Excel Essentials - UA Courses
Forgot your password? Reset It

Excel Essentials

$97.00
$188.00
  • Over 60 Video training modules | 5-10 minutes each
  • Workbooks
  • Practice files
  • 4 Levels

Excel Essentials – Levels 1 – 4 

Learn Microsoft Excel skills with our proven program designed to help busy professionals like YOU- 100% Guaranteed and taught by Rob Hambleton one of the Top Excel Trainers in the Country. Rob makes it Fun to Learn Excel and gives you all the practice files you need to start using Microsoft Excel TODAY!

Excel Essentials Levels 1-4

  • Over 60 Video training modules | 5-10 minutes each
  • Workbooks
  • Practice files
  • Level 1

    • 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

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

  • Level 3

    • 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
    • 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

Lessons

  1. Excel Essentials Level One

    18 Videos
    3 Downloads
  2. Excel Essentials Level Two

    11 Videos
    1 Download
  3. Excel Essentials Level Three

    15 Videos
    1 Download
  4. Excel Essentials Level Four

    11 Videos
    3 Downloads
  5. Bonus: Excel Essentials - LEVEL UP

    6 Videos
  6. Excel Essentials Download File

    1 Download
Tags basic accounting, accounting business, training, virtual bookkeeper, online accountant, profitable business, accountant, accounting
Media Type Online Course

You might also like...

$97.00
$188.00