Description

Dive deep into the realm of Excel with our meticulously designed course on 'Excel Pivot Tables, Pivot Charts, Slicers, and Timelines'. Unlock the secrets of powerful data visualisation tools like Dashboards, Slicers, and Timelines, while mastering the art of reporting by varying time intervals. Whether you wish to streamline your reporting tasks or augment your analytical capabilities, this course will provide you with the tools and techniques to extract insights from data seamlessly.

Highlights of the Dynamic Excel Gantt Chart and Timelines :

Discover the secrets of finding the key to doing your best work

Understand how to reach your most productive level based on scientific research and principles

Explore the hidden productivity recipes of professionals and the most successful people in the world

Develop a routine for greater productivity both at home and at work

Understand the time management strategies for managing your time when dealing with multiple urgent tasks

Discover how to achieve higher productivity by making just a few simple changes

Learn simple yet highly effective productivity hacks that you can apply in minutes or less

Explore science-backed advice for developing a 'Productivity Mindset' and beat procrastination

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

Who is this Course for?

Data analysts aiming to bolster their data visualisation techniques.

Professionals in finance, sales, and marketing looking to generate detailed reports.

Researchers keen on presenting data in an insightful manner.

Students aspiring to enhance their data representation and analysis skills.

Project managers wanting to make data-driven decisions

How is the course assessed?

To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.

Will I receive a certificate of completion?

Upon successful completion, you will qualify for the UK and internationally-recognised certification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.

Requirements

The Dynamic Excel Gantt Chart and Timelines is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.

Career Path

Data Analyst: £30,000 - £50,000

Financial Analyst: £35,000 - £55,000

Sales Analyst: £28,000 - £47,000

Market Researcher: £24,000 - £45,000

Data Visualization Specialist: £32,000 - £52,000

Business Intelligence Analyst: £38,000 - £60,000

Course Curriculum

Excel Pivot Tables, Pivot Charts, Slicers, and Timelines
	Getting started with your Pivot Table	00:04:00
	Drill Down	00:01:00
	Managing the Field List	00:02:00
	Changing the Calculation type with Value Field Settings	00:06:00
	Growing your Pivot Table with Multiple Fields	00:04:00
	Formatting the Pivot Table	00:05:00
	Sorting and Filtering the Pivot Table	00:03:00
	Creating a Dashboard with Slicers, Timelines and Pivot Charts	00:09:00
	Reporting by day, month, qtr, or year within the Pivot Table	00:04:00
	Refreshing the Pivot Data with new data	00:03:00
	Adding your own calculations into the Pivot Table	00:03:00
	The power of the Filter Section in the Pivot Table	00:04:00
	PowerQuery	00:12:00
	PowerPivot	00:21:00
Assignment
	Assignment - Excel Pivot Tables, Pivot Charts, Slicers, and Timelines	00:00:00

Course Images

Excel Pivot Tables, Pivot Charts, Slicers, and Timelines

By Studyhub UK

Booking options

Highlights

Description

About The Provider

Tags

Reviews