Advanced Spreadsheets Using Excel

(3 hours)

“Countif and Vlookups were new to me but easy to grasp thanks to the course and very helpful, hopefully, I will use them in work” Mr X

We will build on your knowledge of Microsoft Excel and teach you how to construct a clear, concise, and informative expert spreadsheet that can be used in any business, club, or personal use situation. You will be introduced to some of the more complex operations within the program. Follow our step-by-step instructions as we produce a multi-sheet workbook that will be used to record a real-life activity before we look at performing a range of complex analysis actions on the results.

Course Contents

  • Lesson 1: Spreadsheets Recap
  • Lesson 2: Advanced Formulas and Functions
  • Lesson 3: Vlookup
  • Lesson 4: Pivot Tables
  • Lesson 5: Multiple Worksheets and Graphs
  • Lesson 6: Final Task

The final task of this course is the ability to use a pre-configured spreadsheet to set up formulas and retrieve data. The task is based on the features you have learned through the lessons and a recommendation is to complete each function in the spreadsheet in order, so the task flows correctly.

In the task, you will be asked to carry out calculations using functions like COUNTIF, VLOOKUP, and Pivot tables combined with Conditional Formatting and the creation of graphs using the data provided.

Learning the skills of using these functions and tables will allow you to make the tasks generally quicker and potentially more accurate.

Our Method

We use the online learning suite Moodle to enable you to learn both from the comfort of your own home or any other location.

24 hours a day, 7 days a week, and 365 days a year!

HELP WHEN YOU NEED IT

Free tutor support 6 days a week online, by phone, email, or live chat.

SHOW YOUR ACHIEVEMENT

Gain a certificate for each course you complete to demonstrate your new skills; for a new employer, to evidence your professional development, or for personal interest.

LEARN BY DOING

Practical tasks in each course to aid your understanding.

To Enrol

If you are interested in the course above or want to find out more about our exciting range of courses please fill in the form below.

Our Delivery Partners

Skills 365 – part of The Thrive Tribe group

*terms and conditions apply

Skills 365