Microsoft Excel - Basic and Advanced

Provided by

  • Duration 49 online lessons (12 months access)
  • Price £29.00

Enquire about this course

About the course

 

Looking for an Excel course for beginners to experts? This online course has something for everyone, covering beginner, intermediate and advanced lessons in Excel.

In 49 engaging lessons you will learn basic techniques including how to use math, statistical, logic and text functions, organize data by sorting and filtering, effectively present your data in several chart formats and more. You will also learn intermediate and advanced techniques such as how to find a value with VLOOKUP, create and format PivotTables, record basic Macros and more.

Whether you use Excel for work or study, these tutorials will start you on your journey to becoming an Excel Ninja!

  • Microsoft Excel 2013 and 2010 compliant
  • Award winning Microsoft MVP instructor Ken Puls
  • Certificate of training upon completing the course
  • Accredited with CPD UK
  • Bite sized video tutorials, cheat sheets, exercise files and quizzes
  • Unlimited testing
  • Self-paced course can be completed in your own time over 12 months

Syllabus:

Getting to Know Excel

  • The Ribbon
  • The Work Surface
  • Navigation
  • First File
  • Formatting
  • Basic Math

Essential Formula Knowledge

  • Formula Anatomy
  • Cell Referencing
  • Function Anatomy
  • Math Functions
  • Basic Statistics
  • Logic Functions
  • Text Functions
  • Understanding Dates
  • Understanding Time

Intermediate Formula Knowledge

  • Formula Auditing
  • Conditional Math
  • External Links
  • Temporal Functions
  • VLOOKUP with Exact Match
  • VLOOKUP with Exact Match
  • Other Lookup Methods

Optimizing Data

  • Sorting
  • Filtering
  • Contiguous Data
  • Naming Ranges
  • Excel Tables
  • Recording Macros

Data Analysis

  • Creating Pivot Tables
  • Formatting Pivot Tables
  • Calculated Fields in Pivot Tables
  • What-If Analysis

Presenting and Reporting

  • Cell Formatting
  • Outlining
  • Custom Number Formats
  • Conditional Formats with Built-in Rules
  • Conditional Formats with Custom Rules
  • Building Column Charts
  • Building Bar Charts
  • Building Pie Charts
  • Building Line Charts
  • Building Combination Line and Area Charts

Validating and Updating

  • Data Validation
  • Data Validation Lists
  • Comments
  • Styles

Preparing to Deploy

  • Custom Views
  • Page Setup Options
  • Security Considerations

 

Enquire

Start date Location / delivery
No fixed date Online Book now

Related article

Could you be making CV mistakes that are sabotaging your job search? It’s quite possible, and easily fixed, by addressing these common CV mistakes.