Microsoft Excel - Level 3 - Advanced

Master advanced Excel techniques including Pivot Tables, Charts, Macros, and formula tracing to enhance your productivity and data management skills.

  • Overview
  • Curriculum
  • Instructor
  • Review

Brief Summary

This course dives into advanced Excel tools, teaching you how to format cells, use Pivot Tables, record Macros, and manage data like a pro. It's all about making your workflow smoother and saving time!

Key Points

  • Advanced formatting techniques in Excel
  • Working with Pivot Tables and the slicer tool
  • Recording and using Macros
  • Tracing and watching changes in cells and formulas
  • How to manipulate large data sets easily

Learning Outcomes

  • Master custom cell formatting in Excel.
  • Easily create and utilize Pivot Tables to analyze data.
  • Automate repetitive tasks with recorded Macros.
  • Skillfully trace and update changes in spreadsheet formulas.
  • Quickly manipulate large datasets without breaking a sweat.

About This Course

Learn advanced formatting techniques, how to work with Pivot Tables, Charts, record Macros & trace spreadsheet formulae

This course covers the advanced tools in Excel. You’ll learn how to create custom cell formats. You’ll start to learn about Pivot Tables, the slicer tool, Macros and how to record steps to common tasks. You’ll learn how to trace and watch changes with cells and formulae.

  • This course introduces the power of Pivot Tables and Recording Macros. Pivot tables let us report and manipulate huge amounts of data quickly and easily. Learning the foundations of Macros can save you huge amounts of time by automating repetitive tasks.

Instructor

Profile photo of eLearnExcel
eLearnExcel

Our online eLearning courses build on 20 years experience of classroom training. Training is our business. The courses are delivered by our expert tutors and we know where topics become complex and need better explanations because we see it every day in our classrooms. Some of the world’s most prominent businesses choose us to teach their employees Excel – including...

Review
4.9 course rating
4K ratings
ui-avatar of Joan Barnett
Joan B.
4.5
9 months ago

yes, this is good match for me.

  • Helpful
  • Not helpful
ui-avatar of Sunny Ovbiagele James
Sunny O. J.
4.5
5 years ago

Yes, very helpful

  • Helpful
  • Not helpful
Leave A Reply

Your email address will not be published. Required fields are marked *

Ratings

Courses You May Like

Lorem ipsum dolor sit amet elit
Show More Courses