About the course

  • Pre-requisites

    You'll need Excel 2007, 2010, 2013 or 2016 installed. You should have a basic knowledge of Microsoft Excel. From creating SUM formulas and using AutoSum, to data entry.

  • Who will benefit?

    Anyone who wants to enhance their knowledge of Excel. Users who want to learn more advanced formulas, tools and shortcuts.

  • Course Outcomes

    Create Advanced Formulas such as VLookup/HLookup. Apply Conditional Formatting to change cell colour based on High/Low Value. Use IF Statements to perform tests based on a condition. Manipulate Large Worksheets to make viewing large amounts of data easier.

Course curriculum

  • 1
    Welcome to the course!
    • Here's what you'll be learning...
    • Course Exercises
  • 2
    Module 1 - Manipulating Large Worksheets
    • Hiding Rows and Columns
    • Freeze Panes
    • Group and Outline
  • 3
    Module 2 - Working with Multiple Files
    • Using Arrange All
    • Viewing Multiple Sheets
  • 4
    Module 3 - Linking Data
    • Linking
  • 5
    Module 4 - Paste Special
    • Paste Special
  • 6
    Module 5 - VLookup and HLookup
    • Introduction to VLookup and HLookup
    • Range Names
    • VLookup Syntax
    • Using VLookup
    • Using HLookup
  • 7
    Module 6 - IF Statements
    • Introduction to IF Statements
    • Creating IF Statements
    • CountIF
    • SumIF
    • AverageIF
  • 8
    Module 7 - Conditional Formatting
    • Applying Conditional Formatting
    • Top-Bottom Rules
    • Text, Duplicate and Formula Rules
  • 9
    Module 8 - Date and Text Formulas
    • TEXT, LOWER, UPPER, PROPER, TRIM
    • CONCATENATE
    • TODAY, NOW and NETWORKDAYS
    • YEARFRAC
  • 10
    Test your learning
    • End of Course Quiz
  • 11
    Course Survey
    • Before you go, we’d love to hear your feedback on the Excel Advanced course please…

Course Instructor

  • Simon Lambourne-Wills

    Microsoft Office and Office365 Trainer

    Simon Lambourne-Wills

    I’ve been an IT trainer for over 10 years and have acquired many skills in teaching different software packages to students of all abilities. I aim to build confidence in all attendees of the courses that I teach, for both large and small groups. Through my professional conduct and enthusiasm when working with learners of mixed levels, I am able to create good rapport with students, which forms a high-quality learning environment. I believe it’s important to enjoy attending training courses. Therefore, engaging and interacting with students on their own experiences of using the software, enables them to feel more involved in the course.

Other Available Courses

View more courses