MS Excel 2010 Course Details

Microsoft Excel is a spreadsheet developed by Microsoft forWindows, Mac OS X, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of Microsoft Office.

Syllabus:

  INTRODUCTION TO MS EXCEL
 What’s New In Microsoft Excel 2010
 Navigating MS Excel 2010
 Cells, Rows, and Columns
 Formulas
 Sheet Tabs
 WORKSHEETS AND WORKBOOKS

 The Definition of Worksheets and Workbooks
 Opening Worksheets and Workbooks
 Labeling and Naming Worksheets
 Adding and Deleting Worksheets
 Deleting Worksheets
 Hiding/ Unhiding Worksheets
 Hiding Columns and Rows
 Hiding Adjacent Columns
 Hiding Separated Columns
 Hiding Rows
 Saving Workbooks
 Headers and Footers
 Saving an Existing File
 Customize Headers and Footers
 About Printing Worksheets and Workbooks
 Set Margins for Headers and Footers
 Select Print Area
 Print a Range of Pages
 Printing

 ENTERING INFORMATION INTO MS EXCEL

 About Entering Information into Excel
 Entering Data
 Entering Labels and Values
 Entering Values
 Multiple Entries
 Copying Cells, Rows, and Columns
 Pasting Cells, Rows, and Columns
 To Paste an Item from the Clipboard
 Inserting and Deleting Rows and Columns
 To Insert a Column
 To Insert a Row
 To Insert Cells


 ENTERING INFORMATION PART 2
 Adding Images
 Modifying Images
 Removing a Background
 Cropping an Image
 Rotating an Image
 Compressing a Picture
 Adding  Word art
 Inserting AutoShapes
 Adding ClipArt
 Adding a Hyperlink
 Embedding an Object

 CHARTS
 Types of Charts
 Chart Tools
 Modifying and Moving a Chart
 Organizational Charts
 Changing an Organizational Chart
 Other Changes to Charts
 Sparkline

 FORMULAS AND CALCULATIONS
 Definition and Explanation of Formulas and Calculations
 Mathematical operators
 Creating a Formula
 The Role of Functions
 Creating Functions
 References
 Using Labels
 Using Names
 Name Manager
 Absolute, Relative and Mixed Cell References

 EXCEL FORMS
 Adding the Form Button to the Quick Access Toolbar
 Using Data Forms
 Entering Data Using a Data Form

 TABLES
 Creating a Table
 Inserting Rows and Columns into a Table
 Adding Up Values
 Entering Data into a Table
 Using Filters to Sort Tables
 Using Table Border to Expand a Table
 Data Validation
 Finding Invalid Entries
 Auditing
 Trace Precedents and Dependents
 Checking Formulas For Errors
 Using the Watch Window

 DEVELOPING A WORKBOOK
 Format Worksheet Tabs
 Reposition Sheets
 Inserting, Deleting, and Renaming Worksheets
 Copy Worksheets
 Printing a Workbook
 Set Print Titles
 Headers/Footers
 Page Margins
 Page Orientation
 Page Breaks
 Print a Range of Pages

 Sharing Worksheets and Workbooks
 Using Online Collaboration
 Protecting a Workbook
 Change Versions of a Workbook
 Set Up a Shared Version of a Workbook
 Merging Versions of the Same Workbook
 Adding, Editing, and Deleting Comments
 Creating and Sharing Workbook Templates
 Creating a Template

 Advanced Skills
 XML
 Security
 Importing and Exporting Data
 Importing Data

Last modified: Friday, 29 July 2016, 1:32 AM