Excel Pivot Tables
Excel Pivot Tables
Original price was: £425.£29Current price is: £29. ex Vat
Take This Course OR
1 Year Access 
Intermediate
15 Students -
47 minutes
Overview
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.
Course design
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.
Course Curriculum
| Section 01: Course Introduction | |||
| Excel Pivot Tables | 00:03:00 | ||
| Section 02: Data Insights with Pivot Tables | |||
| Overview about Store Dataset | 00:02:00 | ||
| Data Insights | 00:02:00 | ||
| Sales Profit Summary | 00:03:00 | ||
| Highlight the Data | 00:01:00 | ||
| Unprofitable Products | 00:02:00 | ||
| Create Crosstabs | 00:02: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 | ||
| Finding Trends | 00:02: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 | |||
| Marketing Analytics | 00:02:00 | ||
| Target Your Advertisements | 00:05:00 | ||
| Section 06: Summary | |||
| Become Analyst | 00:01:00 | ||
| Assignment | |||
| Assignment – Excel Pivot Tables | 00:00:00 | ||
Related Courses
Important Links
With a team of industry professionals producing and delivering our course content, you can be sure the skills and knowledge you learn are applicable to your career aspirations, whether that’s in management, administration or beyond.
0
0
Your Cart
Your cart is emptyBrowse Courses
Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year
Claim Offer & UpgradeMembership renews after 12 months. You can cancel anytime from your account.
Other Students Also Buy
-
Get Lifetime Access To Your Course£9.99 Add to basket+Add