Microsoft Excel - Pivot Tables and Charts
Accredited by CPD | Complete Video Lessons from Expert Instructor | Tutor Support Included
One Education
Summary
- Exam(s) / assessment(s) is included in price
- Tutor is available to students
Add to basket or enquire
Overview
Join the Microsoft Excel - Pivot Tables and Charts course and develop the ability to condense vast volumes of data into useful information. You will learn all there is to know about the PivotTable and PivotChart in this course, including how they operate.
This course will teach you the essentials of the pivot table and pivot charts and will help you comprehend the content fast. You will learn how to analyse pivot tables and pivot chart data. This course will teach you how to visualise data with charts, modify charts, and many other important topics.
You have come to the correct spot if you are searching for a fast refresher on Excel Pivot Tables, want to diversify your Excel skill set, or want to significantly raise your analytics game. Analytical skills are in high demand and limited supply in today's increasingly data-driven world. Those with specific skills are leading the push. So, don't waste your time. Enrol right away to begin your path to Excel analytics mastery!
Learning Outcomes
Upon successful completion of the Microsoft Excel - Pivot Tables and Charts course, you will be able to,
- Create a pivot table and analyse its data.
- Learn how to present data with pivot charts.
- Determine how to present pivot table data visually.
- Explore the fundamentals of creating charts, modifying, and formatting processes.
- Use advanced chart features.
- Recognise the importance of using lookup functions and formula auditing.
Benefits of studying Pivot Tables and Charts in Excel:
- 24/7 access to the course for 12 months
- Full Tutor support on weekdays (Monday – Friday)
- Efficient exam system, assessment and instant results
- Improve your chance of gaining professional skills and better earning potential.
CPD
Course media
Description
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
Course design
This course is designed with the following modules:
PivotTables and PivotCharts
- Create a PivotTable
- Analyze PivotTable Data
- Present Data with PivotCharts
- Filter Data by Using Timelines and Slicers
- Analyze Data with PivotCharts
- Present PivotTable Data Visually
Visualizing Data with Charts
- Create Charts
- Modify and Format Charts
- Use Advanced Chart Features
- Create a Trendline
- Create Advanced Charts
Using Lookup Functions and Formula Auditing
- Use Lookup Functions
- Trace Cells
- Watch and Evaluate Formulas
How is the course assessed?
This course does not involve any assessment.
Exam & Retakes:
It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable.
Certification
Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery).
Who is this course for?
- Professionals looking to expand their knowledge of Microsoft Excel
- People who are interested in the advanced features of Microsoft Excel.
- Excel users who are skilled with the basics but want to improve their data exploration and analytical skills.
Career path
The Microsoft Excel - Pivot Tables and Charts course will assist you with developing a specific demanding skill that will be useful in the following careers:
- Office Administrator
- Office Manager
- Accountants
In the United Kingdom, the average yearly salary for these vocations is between £22,000 and £28,000.
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Reviews
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.