Data Analysis In Excel
Course
Online
Description
-
Type
Course
-
Level
Intermediate
-
Methodology
Online
-
Class hours
3h
-
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.
In this short, ten module course we aim to teach you the basic skills you need to analyse data effectively and efficiently. From Pivot Tables and Conditional Formatting to Lookup Formulas and beyond, ‘Excel Data Analysis’ will set you up with a great foundation upon which to build further skills.
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
Facilities
Location
Start date
Start date
About this course
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
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 5 years
Subjects
- Excel
- Data analysis
- Basic Skills
- MS Excel
- Excel Introduction
- Excel Interface
- Saving Files
- Enter Data
- Efficiency
- Editing
- Sorting and Filtering
Course programme
Section 1: Basic Skills
- Unit 1.1 - Excel Introduction
- Unit 1.2 - The Excel Interface
- Unit 1.3 - Accessing and Saving Files
- Unit 1.4 - Read and Enter Data
- Unit 2.1 - Keyboard Shortcuts
- Unit 2.2 - Editing
- Unit 3.1 - Basic Arithmetic
- Unit 3.2 - Sorting and Filtering
- Unit 4.1 - Setup and Printing
Data Analysis In Excel