About the ‘Excel for Data Analysis and Visualization’

Purchase this course, or sign in if you’re already enrolled, to take this lesson.

Purchase course

The Excel for Data Analysis and Visualization course covers the various tools and formula you should know in your daily Excel work. The focus of the course is more on the use of Excel’s tools and wizards to achieve your goals.

Excel for Data Analysis and Visualization Course Details

138 lessons
264 video clips
50 example exercises with detailed video solutions explaining exactly how you should have got to the answer.
Aimed at Intermediate to Advanced Excel users, based on our free Excel skills assessments
Equivalent of attending a 2 day live course
Lifetime access
Start/ stop as required and repeat when necessary

Examples of what you will be able to do

After the lessons and exercises you will be able to:

Find errors in your formulas

Improve the visuals on your spreadsheets

Sort out problemsome Excel dates

Split key text into their own columns

Neaten up your spreadsheets

Create a dashboard type feel for your spreadsheets

Move columns around or sort based on the colour of a cell

Insert mini charts to show the trend of data

Create ‘Word’ like reports in Excel

Merge databases together

Put imported data into its own Excel columns

Easily delete unwanted rows

Turn data into reports (in seconds)

Fit pivot tables into the columns

Normalise data

Group dates into weeks, months, quarters, years with no effort

How many working days between 2 dates (taking holidays into account)

Remove errors from Formulas

Identify above and below average results

Fill in Gaps (easily)

Fix messy system dates

Join cells together

Create a 2 way lookup. Find the exact matching numbers in a matrix

Create intelligent dropdown lists that check whether the user is sure about their entry

Show big and small numbers on the same chart

Fix date issues on charts

Add more information directly to your chart

Differentiate between the main key chart information and the ‘Other’ information

and much, much more!

For the full list of contents go back to the Intermediate Excel Course contents main page.

Buy the course now to get immediate access!