Menu
Cart 0
Excel Essentials - Rob Hambleton

Excel Essentials - Rob Hambleton

Soul Canyon Training and Development

  • $ 97.00


Excel Essentials

Practical and Powerful Microsoft Excel Techniques, Tips, Tricks, and Tools - Basic to Advanced

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

Program Contents/Module Titles

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