Advanced Excel Skills

Are you ready to take your Excel skills to the next level with our Excel Expert training course?

Do you want to pursue a career in Excel related work?

Are you finding that employers these days want ‘Advanced Excel Skills’?

Or maybe you’ve started a new job that requires more advanced Excel skills.

Our Excel course is designed to take you from zero to hero so you can confidently list ‘Advanced Excel Skills’ on your resume/CV, or quickly get to grips with the requirements of a new job.

Topics Covered

This course will take you from complete beginner to expert, but if you already know a bit of Excel you can skip ahead and just learn what you need to get your skills up to date.

I've included a huge range of advanced formulas as well as PivotTables in depth, Conditional Formatting tricks and much more.

It's perfect if you want to get your skills up to date to get a better job or promotion, or just so you can get your work done quicker.

Once you complete the course you'll be able to confidently list 'Advanced Excel Skills' on your CV/Resume. No more wondering if you have the skills, you will know you do.

Interview with Confidence - I also include practice questions for the key formulas you need to know so you'll be able to go to that interview confident in your abilities and ready to be tested.

Who should attend

The course is for you if you:

Want to change career or apply for a new job;
Already prepare reports of any kind that require updating with new data on a regular basis (weekly, monthly….) and, or;
Work with charts and, or;
Work with large volumes of data and, or;
Import data into Excel from another source e.g. another database, Access, Web, Text files etc. and, or;
Often don’t know the best chart to use to display your data.

Pre-requisites

This course is not for complete beginners but if you’ve put together any type of report in Excel before then you will definitely benefit from the time saving tips and data visualization techniques I share with you.

What you need to bring

Offline - Your Laptop
Online - Your Laptop / High speed Broadband Internet

Key Takeaways

In the course I teach you how to build Excel Dashboard reports from the ground up.

By applying the simple rules I share with you, you will have the skills to be able to create reports that save loads of time (allowing you to go home early :) ) and you’ll quickly become known as a Dashboard Superhero with reports that are:

Quick and easy to update, in fact they can update themselves (imagine being able to confidently say that in an interview) by pulling in data direct from your external database, Microsoft Access, the web etc. at the click of a button if you set them up right (I show you how).

Fully interactive so the reader can change the view themselves; they can filter by product, time period or any parameter you choose, they can show and hide data using check boxes, drop down lists, and option buttons to name a few.

Easy to read and interpret; plus I share with you a heat map of your page that shows you where your most important data should go and where will get the least attention.

Exactly what the reader wants; I teach you the 5 key questions to ask and to who in the planning stage of your report so you get it right first time.

Choose the right chart for your data; I teach you over 20 charts and show you which type of chart will best display your data.