0 (0 Ratings)
Excel: Basic Formulas and Pivot Tables
£30.00
£40.00
Enrollment is now paused
-
LevelBeginner
-
Last UpdatedMay 30, 2025
-
CertificateCertificate of completion
Hi, Welcome back!
Description
Unlock the power of data with Excel! This foundational course will equip you with two essential skills: writing basic formulas to perform calculations and using Pivot Tables to summarise and analyse data with ease. Learn how to add, subtract, multiply, divide, and use fundamental functions to gain insights from your spreadsheets. Then, discover the magic of Pivot Tables to transform raw data into meaningful summaries and reports with simple drag-and-drop actions. Whether you’re a student, professional, or anyone looking to work more efficiently with data, this course will provide you with practical, immediately applicable Excel skills.
Course Curriculum
Getting Started with Basic Formulas
-
Introduction to Excel Formulas
-
Performing Basic Arithmetic
-
Introduction to Basic Functions
Unleashing the Power of Pivot Tables
-
What are Pivot Tables?
-
Creating Your First Pivot Table
-
Basic Pivot Table Operations
Analysing Data with Pivot Tables
-
Grouping Data in Pivot Tables
-
Using Filters and Slicers
-
Presenting Insights with Pivot Charts