This MS Excel course was developed to master the basic functions and featers of MS Excel Versions 2003, 2007, 2010 or 2013. In order to successfully master Word Excel, Windows Beginners must have been completed.
COURSE REQUIREMENTS - THE USER MUST BE CONFIDENT WITH AT LEAST 80% OF THE COURSE MATERIAL FROM THE WINDOWS BEGINNERS COURSE.
VERSIONS: 2007-2010-2013
Exploring the Excel Window
Using Toolbars and Menus
Selecting & Navigating Cells
Get Help
Deleting Both Cell Contents and Cell Formats
Editing Text, Numbers and Formulas
Paste Special
Inserting Cells, Rows and Columns
Deleting Cells, Rows and Columns
Hide and Unhide Rows and Columns
Create a Workbook
Text, Numbers and Dates
Save a Workbook
Opening Files
Creating Folders while Saving Files
Undo & Redo
Edit Cell Data
Cut, Copy and Paste
AutoComplete
Use AutoFill
Find and Replace
Rename Sheets
Insert & Delete Sheets
Move Sheets
Copy Sheets
Hide and Unhide Sheets
Create Basic Formulas
Method for Entering a Formula
AutoSum
Arithmetic Operators
Using Worksheet Functions
Create Absolute Referencing
Spell Check
Preview Worksheets
Set Page Orientation
Set Margins
Headers and Footers
Page Breaks
Page Break Preview
Print Options
Format Cell Contents
Apply Number Formats
Set Row and Column widths
Change Cell Alignments
Add Borders and Shading
Cell Alignment
Merge Cells
Rotate Text
Format Painter
AutoFormat
ACCREDITED