Microsoft Excel Advanced

Provided by GoSkills

  • Sector IT
  • Course Type Online
  • Duration 25 online lessons (12 Months)
  • Price £20.00

Enquire about this course

About the course

Have some experience with Excel and want to improve your skills, or taken our Basic Excel course? This online course will help you learn intermediate and advanced Excel techniques.

In 25 engaging lessons you will learn how to find a value with VLOOKUP, create and format Pivot Tables, record basic Macros and more.

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

  • Microsoft Excel 2016, 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:

Essential Formula Knowledge

  • Understanding Dates
  • Understanding Time

Intermediate Formula Knowledge

  • Formula Auditing
  • Temporal Functions
  • VLOOKUP with Approximate Match
  • VLOOKUP with Exact Match
  • Other Lookup Methods

Optimizing 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

  • Outlining
  • Custom Number Formats
  • Conditional Formats with Built-In Rules
  • Conditional Formats with Custom Rules
  • Building Combination Line and Area Charts

Validating and Updating

  • Data Validation
  • Data Validation Lists
  • Styles

Preparing to Deploy

  • Custom Views
  • Page Setup Options
  • Security Considerations

Enquire

Start date Location / delivery
No fixed date Online Book now

Related article

5 Qualities Of Effective Leaders

We have all experienced terrible leaders, just what does it take to be a great leader? Here we give you the five qualities great leaders should have.