Pivot Tables and Charts in Excel
In day-to-day work, you must know the working with organising and arranging figures and cells within the tables and charts. This Pivot Tables and Charts in Excel course includes several advanced Excel features and skills you need to apply at work for sorting of statistics and counting or deletion of related entries, records, documents. This course covers the introductory use of essential tools such as PivotTable, and charting in an easy to grasp manner, the advanced excel skills of arranging all the functions, and how to create PivotTables from random data sources, combine calculated fields, refine your results, and formatting layouts, useful data visualising tools and more. Benefits of studying Pivot Tables and Charts in Excel: 24/7 access to the course for 12 months No hidden fees or exam charges CPD endorsed certification on successful completion 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.
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
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.
Will I receive a certificate of completion?
Upon successful course completion, you will qualify for a CPD certificate from One Education as proof of your new skills. Certification is available in PDF format, at the cost of £9, or a hard copy can be sent to you via post, at the cost of £15.
|Who is this course for|