# Learn ExcelFree Online Excel Tutorial

This Free online tutorial has been designed with a view to help and guide a novice and also a regular user to use Microsoft Office Excel. The tutorial contains commands used in Microsoft Office Excel 2003, which more often than not can be used in other versions as well.

We shall be glad to receive you feedback and suggestions on this tutorial to make it more useful. Please Click Here to send you feedback and suggestions. The tutorial will be updated on an ongoing basis, so keep visiting for new additions.

## Contents :

TitleContents / Description
Introduction Introduction to Excel Screen Elements viz. Title bar, Menu bar, Standard Toolbar, Format Toolbar, Formula bar, Status bar, Worksheet, Workbook, Rows and Cells
Workbooks and WorksheetsOpening workbooks, Saving Workbooks, Closing Workbooks, Opening, Saving and Closing Worksheets
Selecting Cells & Range of CellsSelecting Cells / Range of Cells
Data EntryEntering and Editing Data in Cells
FormattingFormatting Text, Cells, Rows, Columns and Worksheets
Sorting & FilteringSorting Data in Rows and Columns, Sorting Criteria, Data Filtering
Calculations OperatorsArithmetical Operators, Comparison Operators, Reference Operators and Calculation Order in Excel
Multiply & DivideMultiplication of numbers in Cells, Product Function, Divide numbers
Average, Count and RoundCalculate Average, Calculate Weighted Average, Rounding Numbers, Rounding up, Rounding down, Counting numbers in a range, Find Smallest and largest number in a range.
Conditional FormulasUse of IF, AND, NOT, OR Functions to create conditional formulas
Keyboard ShortcutsKeyboard Shortcuts for Display and Use Windows, Scrolling in a worksheet, selecting data and cells, extend selection, entering data, editing data, insert, delete and copy cells, formatting data, print and print preview
New, Open, Close, Save, Save As, Search, Permission, Page Set up, Print Area, Print Preview, Print, Exit.
viz. Undo, Repeat (last Action), Cut, Copy, Paste, Paste Special, Fill, Clear, Delete, Move or Copy Sheet, Find, Replace, Go To
Normal View, Page Break View, View Task Pane, Add / Remove Toolbars, Enable / Disable Formula bar, Enable / Disable Status bar, Custom View, Enable / Disable Full Screen View, Set Header & Footer, Enable / Disable Comments View, Set Zoom level.
Cells, Rows, Columns, Worksheet, Chart, Symbol, Page Break, Function, Name, Comment, Picture, Diagram, Object, Hyperlink.
Format Cells, Format Rows, Format Columns, Format Worksheet, Autoformat, Set Style.
Check Spelling, Check Formula Errors, Speech, Share Workbooks, Track Changes, Compare and Merge Workbooks, Protection, Online Collaboration, Goal Seek & Solver, Formula Auditing, Macros, Add-Ins, Auto Correct, Customize, Lookup, Options.
Sort, Filter, Form, Subtotals, Validation, Tables, Text to Columns, Consolidate, Group and Outline, Pivot Table and Pivot Table Report, import External Data, List, XML
Arrange Windows, Hide Windows, Unhide Windows, Split Windows, Freeze Windows
AutoCorrect and Smart TagsAutoCorrect and Smart Tags