sampleqa.in tutorials, excel 365 tutorial

Microsoft Excel Tutorial

Microsoft Excel is a Spreadsheet software allows the user to combine data,mathematical formulas,text,graphics together in a single report or workbook. Excel allows business to manage their data, create useful analyses and visualizations, and discover insights into their operations by using rich business intelligence analysis tools. Excel is so flexible, you can use Excel to enter data, analyze the data with basic stastistical tests and charts, and then create reports summerizing your findings.

Every Excel file has a Workbook , Workbook contains group of Worksheets, each work sheet is a set of rows, each row contains set of cells. Each cell can be formatted according to your needs. for example: Numeric cell, text cell, date cell etc., by default all cells are string formatted. Rows are auto numbered 1 ,2, 3 etc., so Columns also automatted A B C etc.,

Excel workbook can be created using blank template,or customized template. In blank template cells can be formatted accoring to your needs. Where as customized templates has pre-formatted cells.

Every Excel file has a workbook or excel file is nothing but a workbook

Ribbon Frequently Used commands displayed in Ribbon User Interface and each command sequence seperated by vertical bar, Ribbon tabs include Fonts,Number,Cells etc.,
excel ribbon

Worksheet Worksheet is a area where data entered into Spreadsheet. Worksheet is a actual work area, allows users to input data,or import data from other datasources, displays tables,graphs etc., Worksheet has rows and columns and cells. Each row numbered from 1 ...N columns start from A .... , Cells are core part of Spreadsheet where data can be inputted. it is a intersection of row and column, for ex: cell "A1" means Column A and Row 1 , C10 means Column C and Row 10 etc.,
excel ribbon

Formula Bar:
excel ribbon
Calculations can be done in Formula Bar. By Default formula bar displays cell content, if cell is associated with formula or function call , that will be displayed. In Excel there are 2 types of functions

  • built-in functions (that comes with excel)
  • User defined functions using Macros(Programmers choice)
for ex: Adding two cells A1 and A2 result is in A3. formula in Cell A3 will be "=A1+A3", formuals or functional calls should start with equal '='
Summing range of values "=SUM(A1:A10)"

Named Box: Range of cells can be given a Name. which can be entered in "Named Box", By default it displays Cell Name,where cursor is pointing to.