Online Corporate Financial Modelling Course

Intermediate MS Excel

This is a preview lesson

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

The Intermediate Excel portion 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.┬áIf you buy this product bundle, it will open the MS Excel Intermediate Online Course.

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 by going back to the Course Bundle Home Page

    Your Cart
    Your cart is emptyReturn to Shop