Excel - Advanced Training | Simon Lambourne | Skillshare
Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
23 Videos (3h 15m)
    • Introdution to Excel Advanced

      1:59
    • Goal Seek

      7:16
    • Scenarios

      14:31
    • Consolidate Part 1

      7:25
    • Consolidate Part 2

      8:19
    • Advanced Filtering

      14:08
    • Working with Tables Part 1

      15:26
    • Working with Tables Part 2

      7:30
    • Working with Tables Bonus Tip

      3:47
    • Validation Drop Down Lists

      9:17
    • Validation Date Ranges

      7:22
    • Protection Protect Sheet

      7:18
    • Protection Protect Workbook Bonus Tip

      4:07
    • Protection Protect File

      5:05
    • Introduction to Pivot Tables

      21:37
    • Pivot Tables Analysing Data

      14:56
    • Pivot Tables Grouping

      5:50
    • Pivot Tables Slicers

      8:31
    • Pivot Tables Pivot Charts

      4:15
    • Introduction to Macros

      3:17
    • Recording Macros

      7:02
    • Recording Global Macros

      7:47
    • Assigning Macros

      8:05

About This Class

This course combines all the tools you needs to become the Advanced user of Excel. If you're great with formulas and setting up sheets but want to enhance your knowledge of what else Excel can do, this course will help you no end!

You'll learn useful techniques to apply to any sort of data, from crunching large sets using Pivot Tables, to analysing and forecasting figures with Goal Seek.

You'll also learn how to automate procedures and actions with the use of Macros. Record what you do in Excel and watch as the Macro does the rest!

11

Students

--

Projects

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Simon Lambourne

Microsoft Certified Trainer

I have been an IT trainer for over 9 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 is important to enjoy attending each t...

See full profile

Report class