trustpilot

Pivot Tables and Charts in Excel

Introduction In day-to-day work, you must know the working with organising and arranging figures and cells within the tables and …

3.5 3.5 Rating ( 2 Reviews )
42 Students
Bestseller
Great Service
Highly Rated
i Last Updated: 27th October 2022
â—Ž English
Flexible Schedule
thumbnail

Unlock 3,000+ Courses & Unlimited Free Digital Certificates for £99 Only! Grab Now

Introduction

In day-to-day work, you must know the working with organising and arranging figures and cells within the tables and charts. This [course_title] 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.

Course description

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.

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

How is the course assessed?

This course does not involve any assessment.

Will I receive a certificate of completion?

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

Why study this course

Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge.

The [course_title] 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.

Course Curriculum

Visualizing Data with Charts
Create Charts 00:13:00
Modify and Format Charts 00:12:00
Use Advanced Chart Features 00:12:00
Create a Trendline 00:30:00
Create Advanced Charts 00:30:00
Using PivotTables and PivotCharts
Create a PivotTable 00:13:00
Analyze PivotTable Data 00:12:00
Present Data with PivotCharts 00:07:00
Filter Data by Using Timelines and Slicers 00:11:00
Analyze Data with PivotCharts 00:30:00
Present PivotTable Data Visually 01:00:00
Using Lookup Functions and Formula Auditing
Use Lookup Functions 00:12:00
Trace Cells 00:09:00
Watch and Evaluate Formulas 00:08:00
Activities
Activities-Pivot Tables and Charts in Excel 00:00:00

Certificate of Achievement

Upon completion, you will receive a CPD-accredited certificate recognised globally. Choose from:

Pdf Certificate & Transcript  £7.99
Hardcopy Certificate & Transcript  £17.99

This certification validates your knowledge and skills, boosting your employability in healthcare.

Course Reviews

  • 5 stars 0
  • 4 stars 0
  • 3 stars 0
  • 2 stars 0
  • 1 stars 0

3.5

3.5
2 ratings
top