Intermediate Excel Course

About the ‘Intermediate Excel Course’

This is a preview lesson

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

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

Intermediate Excel Course Details

  • 133 lessons
  • 260 video clips
  • 48 example exercises with detailed video solutions explaining exactly how you should have got to the answer.
  • Aimed at Beginner to Intermediate 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
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!

0 of 136 lessons complete (0%)
0
    0
    Your Cart
    Your cart is emptyReturn to Shop