fbpx

Basic to Advanced

Program Contents/Module Titles

A series of 50 downloadable tutorials, with workbooks, program guides, keyboard shortcuts and practice file.

You can work through each Level and Module according to the sequence below, or just run the module for a particular topic you would like to learn about.

Level 1 Modules:

  • Terminology & Navigation
  • The File Tab
  • The QAT
  • Right Click Formatting
  • Entering & Editing Data
  • Autofill
  • Selecting Multiple Cells
  • Core Keyboard Shortcuts
  • Working with Rows and Columns
  • Working with Worksheets
  • Saving Files
  • Formatting Basics
  • Formula Basics
  • Function Basics
  • Database Basics

Level 2 Modules

  • Charts & Graphs
  • Conditional Formatting
  • Custom Autofill Lists
  • Formula Auditing
  • Insert Function
  • Printing
  • Text Functions
  • Paste Special
  • Range Names
  • Subtotals

Level 3 Modules:

  • Options
  • Worksheet Grouping
  • Dates & Times
  • Linking in Excel
  • Linking to PowerPoint/Word
  • Data Validation
  • Functions – IF and DATES
  • Functions – IF, AND, Nesting
  • Functions – VLOOKUP
  • Protection & Security
  • Pivot Tables – Introduction
  • What If – Scenario Manager
  • What If – Goal Seek
  • Macros — Introduction

Level 4 Modules:

  • Pivot Table Basics
  • Pivot Table Layout Options
  • Pivot Table Summary Functions
  • Pivot Table Report/Page Filters
  • Pivot Table Slicers
  • Updating Pivot Table Data
  • Pivot Charts
  • Macro Recording
  • Macro Editing
  • Macro Buttons
Log in or Register to save this content for later.
Leave A Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.