MS Excel Tutorial

MS Excel Tutorial

Microsoft Excel is a commercial spreadsheet application, written and distributed by Microsoft for Microsoft Windows and Mac OS X. At the time of writing this tutorial the Microsoft excel version was 2010 for Microsoft Windows and 2011 for Mac OS X.

Microsoft Excel is a spreadsheet tool capable of performing calculations, analyzing data and integrating information from different programs.

By default, documents saved in Excel 2010 are saved with the .xlsx extension whereas the file extension of the prior Excel versions are .xls.

This tutorial has been designed for computer users who would like to learn Microsoft Excel in easy and simple steps. It will be highly useful for those learners who do not have prior exposure to Microsoft applications.

Before proceeding with this tutorial, you should have a basic understanding of Computer peripherals like mouse, keyboard, monitor, screen etc. and their basic operations. You should also have the basic skills of file management and folder navigations.

Table of Contents 

Getting Started with Excel 2010
Explore Window in Excel 2010
BackStage View in Excel 2010
Entering Values in Excel 2010
Move Around in Excel 2010
Save Workbook in Excel 2010
Create Worksheet in Excel 2010
Copy Worksheet in Excel 2010
Hiding Worksheet in Excel 2010
Delete Worksheet in Excel 2010
Close Workbook in Excel 2010
Open Workbook in Excel 2010
Context Help in Excel 2010
Insert Data in Excel 2010
Select Data in Excel 2010
Delete Data in Excel 2010
Move Data in Excel 2010
Rows & Columns in Excel 2010
Copy & Paste in Excel 2010
Find & Replace in Excel 2010
Spell Check in Excel 2010
Zoom In/Out in Excel 2010
Special Symbols in Excel 2010
Insert Comments in Excel 2010
Add Text Box in Excel 2010
Undo Changes in Excel 2010
Setting Cell Type in Excel 2010
Setting Fonts in Excel 2010
Text Decoration in Excel 2010
Rotate Cells in Excel 2010
Setting Colors in Excel 2010
Text Alignments in Excel 2010
Merge & Wrap in Excel 2010
Borders and Shades in Excel 2010
Apply Formatting in Excel 2010
Sheet Options in Excel 2010
Adjust Margins in Excel 2010
Page Orientation in Excel 2010
Header and Footer in Excel 2010
Insert Page Break in Excel 2010
Set Background in Excel 2010
Freeze Panes in Excel 2010
Conditional Format in Excel 2010
Creating Formulas in Excel 2010
Copying Formulas in Excel 2010
Formula Reference in Excel 2010
Using Functions in Excel 2010
Built-in Functions in Excel 2010
Data Filtering in Excel 2010
Data Sorting in Excel 2010
Using Ranges in Excel 2010
Data Validation in Excel 2010
Using Styles in Excel 2010
Using Themes in Excel 2010
Using Templates in Excel 2010
Using Macros in Excel 2010
Adding Graphics in Excel 2010
Cross Referencing in Excel 2010
Printing Worksheets in Excel 2010
Email Workbooks MS Excel 2010
Translate Worksheet in Excel 2010
Workbook Security in Excel 2010
Data Tables in Excel 2010
Pivot Tables in Excel 2010
Simple Charts in Excel 2010
Pivot Charts Excel 2010
Keyboard Shortcuts in Excel 2010