Mastering MS Excel: A Complete Course Syllabus for Beginners

 Microsoft Office Excel 2010 Introduction Microsoft Excel 2010

Microsoft Office Excel 2010 Introduction Ribbon, Tabs, Contextual Tab, Group and Commands

Microsoft Office Excel 2010 Change Page Orientation, Paper Size and Set Page Margins

Microsoft Office Excel 2010 Change Font Style, Size, Color and Add border, Fill Color

Microsoft Office Excel 2010 Aligning Values and Rotate text

Microsoft Office Excel 2010 AutoFill

Microsoft Office Excel 2010 Reposition WorkSheets in a WorkBook

Microsoft Office Excel 2010 Rename WorkSheet

Microsoft Office Excel 2010 Preview before Printing

Microsoft Office Excel 2010 Moving around the worksheet

Microsoft Office Excel 2010 Modify Column Width and Row Height

Microsoft Office Excel 2010 Print the Document

Microsoft Office Excel 2010 Merge and Unmerge Cells

Microsoft Office Excel 2010 Linking Worksheet

Microsoft Office Excel 2010 Insert or Delete Cell, Row, Column and Sheet

Microsoft Office Excel 2010 Insert a New Worksheet

Microsoft Office Excel 2010 Hide or Unhine WorkSheet

Microsoft Office Excel 2010 Hide or Unhide Row, Column and Sheet

Microsoft Office Excel 2010 Group or Ungroup Worksheet

Microsoft Office Excel 2010 Functions, Function Library, Insert a Function

Microsoft Office Excel 2010 Format Number, Date and Time

Microsoft Office Excel 2010 Expand or Collapse Formula Bar

Microsoft Office Excel 2010 Entering Data

Microsoft Office Excel 2010 Editing Data

Microsoft Office Excel 2010 Drag and Drop

Microsoft Office Excel 2010 Deleting Data

Microsoft Office Excel 2010 Delete a WorkSheet

Microsoft Office Excel 2010 Define a Print Area

Microsoft Office Excel 2010 Customizing the environment using excel options

Microsoft Office Excel 2010 Customize the Status Bar

Microsoft Office Excel 2010 Create New Workbook

Microsoft Office Excel 2010 Create a Simple Formula

Microsoft Office Excel 2010 Create a Simple Formula using Point and Click Method

Microsoft Office Excel 2010 Change Page View

Microsoft Office Excel 2010 Sort, Filter and String Function Concatenate

Microsoft Office Excel 2010 Hide Column, Rename Worksheet, Delete Worksheet, Add Borders

Microsoft Office Excel 2010 String Function Proper Case

Microsoft Office Excel 2010 using Excel Option Customize Excel

Microsoft Office Excel 2010 Lock or Unlock Cells and Protect Worksheet and Workbook

Microsoft Office Excel 2010 Conditional Formatting

Microsoft Office Excel 2010 Add Comment

Microsoft Office Excel 2010 Find and Replace

Microsoft Office Excel 2010 Table, Create Table, Convert to Range

Microsoft Office Excel 2010 Switch Data in Chart

Microsoft Office Excel 2010 Sort Data

Microsoft Office Excel 2010 Move the Chart to a Different Worksheet

Microsoft Office Excel 2010 Freeze Row and Columns

Microsoft Office Excel 2010 Filter Data

Microsoft Office Excel 2010 Create Chart

Microsoft Office Excel 2010 Change Chart Type, Chart Style or Data Range in a Chart

Microsoft Office Excel 2010 Apply Layout in a Chart

Microsoft Office Excel 2010 Add Labels in a Chart

Microsoft Office Excel 2010 Print Titles on Each Page

Microsoft Office Excel 2010 Zoom In and Zoom Out

Microsoft Office Excel 2010 Wrap Text

Microsoft Office Excel 2010 Using Cell Reference

Microsoft Office Excel 2010 Use Scale to Fit

Microsoft Office Excel 2010 Type of Data and Identify Current Cell

Microsoft Office Excel 2010 Show or Hide Formula bar, Gridlines, Heading

Microsoft Office Excel 2010 Set Headers and Footers

Microsoft Office Excel 2010 Selecting Cell

Microsoft Office Excel 2010 Add and Multiply across the sheet

Microsoft Office Excel 2010 Create Pie Chart

Microsoft Office Excel 2010 Convert Text to Columns