BASIC & INTERMEDIATE MICROSOFT EXCEL

Course Content:

Getting Started with Excel 2010
 Starting Excel
 Excel 2010 Working Environment
 Using the Ribbon as the Excel 2010 User Interface
 Navigating within the Worksheet
 Selecting a Cell or Range of Cells
 Entering Data
 Entering Cell Contents
 Cutting, Copying, and Pasting Cell Values
 Copy and Paste Special
 Saving your Workbook
 Opening your Workbook
Managing Rows & Columns
 Inserting, Moving & Deleting Cells
 Managing Columns and Rows
 Hide and Unhide Rows/Columns
 Changing Column Width & Row Height
Managing Worksheets
 Format Worksheet Tabs
 Insert and Delete Worksheet
 Move and Copy Worksheet
 Hide & Unhide Worksheet
Formatting the Cell
 Formatting the Cell
 Number and Date Formatting
 Finding and Replacing Text
 Working with Styles
Working with Formulas and Functions
 Excel Arithmetic Operators & Order of Operations

Organizing Worksheet and Table Data
 Create and Modify Tables
 Sorting and Filtering Data in a Table
 Getting Summary Information in a Table
Working with Chart
 Summarizing Data Visually Using Charts
 Customizing Chart Data
 Format Chart Legend and Titles
 Change the Chart Body
 Saving the Chart as a Template
 Creating a Pie Chart
Working with Graphics
 Adding Pictures into a Worksheet
 Customizing Pictures and Objects
 Adding Drawing Objects into a Worksheet
 Adding SmartArt into a Worksheet
 Adding Clip Art into a Worksheet
Managing Large Workbook
 Managing Large Workbooks
 Printing Worksheets
 Setting Page Setup Options
 Setting Page Breaks
Customizing & Enhancing Workbooks
 Customizing Excel to the Way You Work
 Creating Hyperlinks
 Working with Workbook Themes
 Working with Templates

 Using AutoFill Options
 Using Commonly Used Functions
 Using SUMIF() and COUNTIF(): Adding and Counting only the Cells you Specify

The Excel Environment
Entering and editing data
Entering and editing text and values
Entering text and values
Editing cell contents
Using AutoFill to fill a series
Entering and editing formulas
Creating a basic formula
Entering cell references with the mouse
Editing a formula
Working with the order of operations
Using Multiple Worksheets and Workbooks
Using and Managing large workbooks
Using multiple workbooks
Using multiple worksheets
Linking worksheets with 3-D formulas
Linking workbooks
Managing workbooks
Advanced Formatting
Using special number formats
Using functions to format text
Working with styles
Working with themes
Other advanced formatting
Outlining and Subtotals
Outlining and consolidating data
Creating subtotals
FUNCTIONS AND FORMULAS

Using Functions
Entering functions
Entering a SUM function
Using the mouse to enter a function argument
Entering a function in the formula bar
Inserting a function
AutoSum
Using AutoSum
Other common functions
Using AVERAGE
Using MIN
Using MAX
Using COUNT and COUNTA
Cell and range names
Creating and using names
Managing names
Tables
Sorting and filtering data
Advanced filtering
Working with tables
Using Lookup functions
Web and sharing features
Saving workbooks as Web pages
Using hyperlinks
Sharing workbooks

Getting Help with Functions
Nested Functions
Consolidating Data Using a 3-D Reference Sum Function
Mixed References within Formulas
TIME & DATE FUNCTIONS
Inserting the Current Time and Date
Today
Now
Day
Month
Year
MATHEMATICAL FUNCTIONS
Round
RoundDown
RoundUp
LOGICAL FUNCTIONS IF AND OR
MATHEMATICAL FUNCTIONS SUMIF
STATISTICAL FUNCTIONS

• COUNT
• COUNTA
• COUNTIF
• COUNTBLANK
• RANK