Getting familiar with Excel
  • Using the exercise files
  • Introducing Excel
  • Using the Menu System
  • Using the Quick Access Toolbar
  • Understanding Workbooks and Worksheets
  • Using the Formula Bar
  • Using the Status Bar
  • Using Navigation Tools
  • Using Short Cut Menus and the Mini Toolbar
  • Using Excel help
  • Introduction to Excel
Entering Data in Excel
  • Exploring data entry and editing techniques
  • Entering data with AutoFill
  • Working with dates and times
  • Using Undo and Redo
  • Adding Comments
  • Entering data
Creating Formulas and Functions
  • Creating Formulas and Functions
  • Copying a formula into an adjacent cell
  • Calculating Year to date totals
  • Creating a percent change formula
  • Working with absolute and relative references
  • Auto Sum and Auto Average
  • Other popular Excel functions
  • Creating Formulas and Functions
Formatting Excel data
  • Fonts and Styles
  • Adjusting Columns and Rows
  • Align and Merge
  • Designing Borders
  • Exploring Numeric and special formats
  • Using Conditional Formatting
  • Creating and Customizing tables
  • Inserting Shapes
  • Adjusting Columns or Rows
Layout Features
  • Insert and Delete Rows and Columns
  • Hiding and Un-hiding Rows and Columns
  • Moving Copying and Inserting Data
  • Find and Replace
  • Layout Features
Preparing for Printing
  • Page Layout View
  • Page Break Preview
  • Page Setup
Creating Charts
  • Creating Charts
  • Chart Types
  • Format Charts and Elements
  • Sparklines
View Options
  • Freezing and Unfreezing Panes
  • Splitting Screens
  • Outlining
View Multiple Worksheets and Workbooks
  • Viewing Multiple Workbooks and Worksheets
  • Working With Sheets
  • Linking Worksheets and Workbooks with Formulas
IF Functions and VLOOKUP
  • If functions and VLOOKUP
  • VLOOKUP Approximate
  • VLOOKUP Exact with Function Assistance
  • IF Family Functions
Security
  • Securing Worksheets and Hiding Tabs
  • Securing Workbooks
Managing Data
  • Sorting Data
  • Insert Subtotals
  • Using FIlters
  • Splitting Text
  • Using Flash Fill to split and combine data
  • Deleting duplicates
  • Data Validating Tools
Analyzing Data
  • Using Goal Seek
  • Using Solver
  • Using Scenario Manager
  • Creating Data Tables
Pivot Tables and Charts
  • Creating Pivot Tables
  • Manipulating Pivot Tables
  • Group by date
  • Groupings in Pivot tables
  • Pivot Table Slicers
  • Pivot Charts
Macro Basics
  • Macro basics
Tips and Tricks - More coming
  • Problems with spaces