Description

Unlock the full potential of Excel with this comprehensive course on Pivot Tables, Pivot Charts, Slicers, and Timelines. With easy-to-follow tutorials and step-by-step guidance, you'll learn how to organise and analyse data more efficiently than ever before. From creating customised dashboards to slicing and dicing data to get the insights you need, this course will help you master Excel's most powerful data analysis tools.

Whether you're a business owner, data analyst, or simply looking to upskill in Excel, this course is perfect for you. With hands-on training and real-world examples, you'll learn how to create professional-looking reports and visualisations that will impress your colleagues and clients. Sign up today and start taking your Excel skills to the next level.

Learning Outcomes:

Understand how to create and manage Pivot Tables in Excel

Analyse data using Pivot Charts and Slicers

Learn how to customise the Pivot Table fields and calculations

Create reports by day, month, quarter, or year using Pivot Tables

Understand how to use PowerQuery and PowerPivot to enhance your analysis

Learn how to refresh Pivot Table data with new data sets

Excel Pivot Tables, Pivot Charts, Slicers, and Timelines

Getting started with your Pivot Table

Drill Down

Managing the Field List

Changing the Calculation type with Value Field Settings

Growing your Pivot Table with Multiple Fields

Formatting the Pivot Table

Sorting and Filtering the Pivot Table

Creating a Dashboard with Slicers, Timelines and Pivot Charts

Reporting by day, month, qtr, or year within the Pivot Table

Refreshing the Pivot Data with new data

Adding your own calculations into the Pivot Table

The power of the Filter Section in the Pivot Table

PowerQuery

PowerPivot

How is the course assessed?

Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%.

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 __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery).

CPD

10 CPD hours / points Accredited by CPD Quality Standards

Who is this course for?

The course is ideal for highly motivated individuals or teams who want to enhance their professional skills and efficiently skilled employees.

Requirements

There are no formal entry requirements for the course, with enrollment open to anyone!

Career path

Data Analyst (average salary £30,000-£45,000)

Business Intelligence Analyst (average salary £30,000-£50,000)

Financial Analyst (average salary £25,000-£45,000)

Marketing Analyst (average salary £25,000-£40,000)

Sales Analyst (average salary £25,000-£40,000)

Operations Analyst (average salary £25,000-£45,000)

Certificates

Certificate of completion

Digital certificate - £9

You can apply for a CPD Accredited PDF Certificate at the cost of £9.

Certificate of completion

Hard copy certificate - £15

Hard copy can be sent to you via post at the expense of £15.

Course Images

Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Course

By One Education

Booking options

Highlights

Description

About The Provider

Tags

Reviews