The Essential Microsoft Excel Bundle
Course
Online
Description
-
Type
Course
-
Level
Intermediate
-
Methodology
Online
-
Class hours
9h
-
Duration
Flexible
-
Online campus
Yes
-
Delivery of study materials
Yes
-
Support service
Yes
-
Virtual classes
Yes
In a world where we are constantly bombarded with information, making sense of it all can sometimes be difficult and time-consuming. This is particularly true of Excel. Analysing large amounts of data and presenting information that makes sense to your audience is an essential skill for many people.
Facilities
Location
Start date
Start date
About this course
We all know Excel is essential for any business. When efficiently applied it is a powerful tool, allowing you to manipulate vast amounts of data, automate tasks and present complex information however you see fit.
We also know how difficult it is to find quality instruction that is:
Easy to follow
Gets you the results you want
Teaches you advanced methods that you can quickly put into practice
That’s why we developed our online Excel course.
CPD UK
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 4 years
Subjects
- Excel
- Microsoft Excel
- Microsoft excel training
- MS Excel
- Analysis
- Data analysis
- PivotCharts
- PivotTables
- Vlookup
- HLOOKUP
- Index-match
Course programme
Data Analysis in Excel:
- Clean up data ready for analysis
- Create PivotTables and PivotCharts
- Lookup information using VLOOKUP, HLOOKUP and INDEX-MATCH
- Make decisions using IF Statements
- Highlight information using Conditional Formatting and Rules
- Build a basic Interactive Dashboard
Basic Microsoft Excel:
- Data entry
- Text and number formats
- Basic mathematical functions (SUM, AVERAGE)
- Editing skills, including Flash Fill
- Basic data analysis skills through sorting and filtering.
- Printing spreadsheets
Microsoft PivotTables:
- The primary uses of pivot tables
- How to identify the best and worst data sets
- To filter, sort and group PivotTable™ data to maximise its usefulness
- How to present your data clearly using PivotCharts and Conditional Formatting
The Essential Microsoft Excel Bundle