About the course

  • Pre-requisites

    You'll need Excel 2007, 2010, 2013 or 2016 installed. No prior knowledge of Excel is required.

  • Who will benefit?

    From brand new users of Excel to anyone who wants to brush up on the basics.

  • Course Outcomes

    You'll be able to create and setup spreadsheets from scratch. Produce calculations with formulas and illustrate data with Charts. Also pick up plenty of shortcuts to get things done quicker!

Course curriculum

  • 1
    Welcome to the course!
    • Here's what you'll be learning...
    • Course Exercises
  • 2
    Module 1 - Excel Environment
    • Exploring Excel
  • 3
    Module 2 - Navigating
    • Navigating
    • Highlighting
    • Freeze Panes
  • 4
    Module 3 - Autofiller
    • Using Autofiller
    • Autofiller Options
    • Custom Autofiller List
  • 5
    Module 4 - Creating Formulas
    • Introduction to Formulas
    • Creating Formulas
    • Introduction to Functions
    • AutoSum
  • 6
    Module 5 - Absolute References
    • Absolute References
  • 7
    Module 6 - Sorting and Filtering
    • Sorting
    • Custom Sort
    • Filtering
    • Custom Filtering
  • 8
    Module 7 - Formatting
    • Cell Formatting
  • 9
    Module 8 - Printing
    • Print Area
    • Print Area Scaling
    • Print Titles
  • 10
    Module 9 - Charts
    • Creating a Chart
    • Chart Types
    • Sparklines
  • 11
    Test your learning
    • End of Course Quiz
  • 12
    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

  • Full Courses

    Excel Intermediate

    This course is ideal for those who already use Excel at Introduction level and want to build on the knowledge you already know. You will be introduced to a whole range of useful tools, shortcuts and formulas and functions.

    28 Lessons £59.00
    Excel Intermediate
View more courses