Session 1: Introduction
Interface
Tabs and Ribbons
Document Windows
Navigation Tips
Navigation Tips
Session 2: Entering, Editing and Formatting Data
Entering Data
Fonts, Fills, and Alignment
Cut, Copy, and Paste
Paste Special
Undo and Redo
Moving, Finding, and Replacing a Value
Cell Styles
Comments
Session 3: Formatting Numbers
Currency Format
Format Painter
Formatting Dates
Custom and Special Formats
Copying Worksheets
Adding, Deleting and Hiding Worksheets
Grouping Worksheets
Moving, Copying, Deleting and Hiding
Grouped Worksheets
Session 4: Modifying Rows and Columns
Inserting and Deleting Columns and Rows
Inserting Multiple Columns & Rows
Modifying Cell Width and Height
Hiding and Unhiding Rows and Columns
Session 5: Understanding Formulas
Using Operations
Creating Formulas
AutoSum
Common Formulas
Searching for Formulas
Copying Formulas
Using Relative and Absolute References
Session 6: Changing Views
Workbook Views
Show/Hide
Zoom Features
Freeze Panes
Split Windows
Viewing Multiple Windows
Minimize The Ribbon
Worksheet Backgrounds
Watermarks
Session 7: AutoFill and Custom Lists
AutoFill a Series
AutoFill Non-Adjacent Cells
AutoFill on Multiple Sheets
Creating Custom Lists
Series Formatting
Session 8: Conditional Formatting
Highlight Cells Rules
Top/Bottom Rules
Data Bars
Color Scales
Custom Formatting Rule
Session 9: Tables
Add Rows and Columns
Perform a Function in a Table
Summarise With Pivot Table
Insert a Table and Style Options
Session 10: Data Tools
Data Validation
Drop-Down Lists
Removing Duplicates
Text To Columns
Goal Seek
Scenario Manager
Session 11: Referencing Formulas
Multiple Sheet References
Consolidating Data – With or Without Links
Trace the Precedents and Dependents
Using the Watch Window
Session 12: Ranges and Dates
Cell Names
Named Ranges
Formulas with Cell Names
Date Formulas
Session 13: Lookups , Creation and use data validation rules
VLOOKUP
VLOOKUP Exact Match
HLOOKUP
HLOOKUP Exact Match
Session 14: Conditional Logic
IF Statement
Nested IF
AND
OR
NOT
IFERROR
SUMIF
AVERAGEIF
COUNTIF & COUNTIFS
SUMIFS
AVERAGEIFS
Session 15: Text Formulas
Case Formulas
Fix Number Fields
Trim Spaces
Substitute Text
Session 16: Introduction to Charts
Chart Types
Instant Chart
Update Chart
Column Chart
Picture Fill
Adjust Chart Size
Line Chart
Scatter Chart
Session 17: Formatting Charts
Chart Styles
Chart Layouts
Add Labels
Axis Options
Chart Title
Session 18: Adding Graphics to Spreadsheets
Insert Pictures
Modifying Pictures
Insert Shapes
Insert SmartArt
Session 19: Outline, Sort, Filter, and Subtotal
Group and Ungroup
Sort Data
Sort Multiple Levels
Conditional Sorting and Filtering
Session 20: PivotTables
Creating PivotTables
Modifying PivotTable Data
Session 21: Protecting Data
Workbook Passwords
Unlocking Cells
Session 22 : How to work with functions to manipulate strings of text and data
Session 23 : Use of queries to import external data
Session 24 : Troubleshoot errors
