Excel - Data Reporting Tools | Simon Lambourne | Skillshare
Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
11 Videos (1h 50m)
    • Intro to Excel Data Reporting Tools Course Outline

      1:50
    • 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
    • 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

About This Class

This course will showcase some of the most useful tools used for not only bringing data together, but to turn that data into a professional report. You'll learn how to use tools such as Consolidate, Advanced Filtering for extraction and creating Pivot Tables and Charts.

There are no complicated formulas or difficult syntax, just a set of great tools to get Excel to do the hard work for you!

15

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