Excel Pivot Tables
Master Excel Pivot Tables and take your spreadsheet skills to the next level, with this complete step-by-step training course.
The Excel Pivot Tables course will equip you with the practical skills to analyse large sets of information quickly and easily using Excel Pivot Tables. It will teach you how to perform a diverse range of tasks such as creating Excel Pivot Table reports, using Pivot Table data for market analytics, identifying trends, and calculating profit.
This course is open to learners of all levels and is ideal for financial and market analysts, administrative assistants, project managers, and anyone whose role involves working with data. Gain in-demand analytical skills and learn up-to-date best practices.
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
- Video lessons
- Online study materials
Will I receive a certificate of completion?
Upon successful completion, you will qualify for the UK and internationally-recognised CPD accredited certification. You can choose to make your achievement formal by obtaining your PDF Certificate at the cost of £9 and Hard Copy Certificate for £15.
Why study this course
It doesn’t matter if you are an aspiring professional or absolute beginner; this course will enhance your expertise and boost your CV with critical skills and an accredited certification attesting to your knowledge.
The Excel Pivot Tables is fully available to anyone, and no previous qualifications are needed to enrol. All One Education needs to know is that you are eager to learn and are over 16.
|Section 01: Course Introduction|
|Excel Pivot Tables||00:03:00|
|Section 02: Data Insights with Pivot Tables|
|Overview about Store Dataset||00:02:00|
|Sales Profit Summary||00:03:00|
|Highlight the Data||00:01:00|
|Select Regions for Unprofitable Products||00:04:00|
|Section 03: Real Time Analytics with Pivot Tables|
|Real Time Analytics and Insights||00:02:00|
|Search Data for States with Slicers||00:06:00|
|Find Data for Specific Date||00:04:00|
|Section 04: Reporting with Pivot Tables|
|Reporting Made Easy||00:02:00|
|Generate Reports with Pivot Tables||00:04:00|
|Section 05: Target Your Market with Pivot Tables Analysis|
|Target Your Advertisements||00:05:00|
|Section 06: Summary|