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.
|Title||Contents / 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 Worksheets||Opening workbooks, Saving Workbooks, Closing Workbooks, Opening, Saving and Closing Worksheets|
|Selecting Cells & Range of Cells||Selecting Cells / Range of Cells|
|Data Entry||Entering and Editing Data in Cells|
|Formatting||Formatting Text, Cells, Rows, Columns and Worksheets|
|Sorting & Filtering||Sorting Data in Rows and Columns, Sorting Criteria, Data Filtering|
|Calculations Operators||Arithmetical Operators, Comparison Operators, Reference Operators and Calculation Order in Excel|
|Add & Subtract||Addition of contiguous numbers, Addition of noncontiguous numbers, Add numbers based on Condition, Subtraction of numbers|
|Multiply & Divide||Multiplication of numbers in Cells, Product Function, Divide numbers|
|Average, Count and Round||Calculate Average, Calculate Weighted Average, Rounding Numbers, Rounding up, Rounding down, Counting numbers in a range, Find Smallest and largest number in a range.|
|Conditional Formulas||Use of IF, AND, NOT, OR Functions to create conditional formulas|
|Keyboard Shortcuts||Keyboard 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|
|File Menu||Description and use of commands available in File menu|
New, Open, Close, Save, Save As, Search, Permission, Page Set up, Print Area, Print Preview, Print, Exit.
|Edit Menu||Description and use of commands available in Edit Menu |
viz. Undo, Repeat (last Action), Cut, Copy, Paste, Paste Special, Fill, Clear, Delete, Move or Copy Sheet, Find, Replace, Go To
|View Menu||Description and use of commands available in View menu|
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.
|Insert Menu||Description and use of commands available in Insert menu|
Cells, Rows, Columns, Worksheet, Chart, Symbol, Page Break, Function, Name, Comment, Picture, Diagram, Object, Hyperlink.
|Format Menu||Description and use of commands available in Format menu|
Format Cells, Format Rows, Format Columns, Format Worksheet, Autoformat, Set Style.
|Tools Menu||Description and use of commands available in Tools menu|
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.
|Data Menu||Description and use of Commands available under Data menu|
Sort, Filter, Form, Subtotals, Validation, Tables, Text to Columns, Consolidate, Group and Outline, Pivot Table and Pivot Table Report, import External Data, List, XML
|Window Menu||Description and use of commands under Window Menu|
Arrange Windows, Hide Windows, Unhide Windows, Split Windows, Freeze Windows
|AutoCorrect and Smart Tags||AutoCorrect and Smart Tags|
|Add-Ins||Add-Ins in Excel|
|Collaboration||Online Collaboration and Meetings tools|
|Compare & Merge||Compare workbooks side-by-side, Merge workbooks|
|Customize||Display / Hide Toolbars, Adding / removing icons from toolbars|
|Formula Audit||Various types of formula errors. How to find and remove errors in formulas?|
|Goalseek & Solver||Goalseek and Solver tools and their use|
|Macros||What are macros? How to create, record and edit a macro?|
|Speech||Description and use of Speech tool.|
|Track Changes||Keeping record of changes made in Excel Workbooks and tracking them.|
|Customizing Excel||Customize View, Customize Editing, Customize Column headers, Customize Auto Save / Auto Recover, Create Custom Lists, Customize Spell Check, Customize Security|
|VLOOKUP & HLOOKUP||Description and use of VLOOKUP and HLOOKUP functions for importing and analyzing data.|
|Pivot Tables||What are Pivot tables? Creation and use of Pivot Tables|