Excel
-
The course is great. It’s a professional site and easy to follow. Staff is very helpful, I must say I'm glad I've chosen this centre.
← | →
-
Currently taking the online Excel course and I’m pleased since it’s easy to understand and very detailed.
← | →
-
I took the excel course and I’m very pleased with it. I can’t wait to take the next level. The course is well structured and there are a lot of exercises to practice what you have learned. Great experience!
← | →
Course
Online
Description
-
Type
Course
-
Methodology
Online
-
Class hours
12h
-
Duration
Flexible
-
Start date
Different dates available
-
Online campus
Yes
-
Support service
Yes
-
Virtual classes
Yes
Unlock the secrets of Excel and learn:
How Excel works, how to navigate and design a spreadsheet.
The most popular formulas including IF, VLOOKUP, COUNT, SUM, SUMIF.
To use PivotTables, Pivot Charts and Basic Macros.
To create beautiful looking graphs and charts.
Formatting, including; conditional, cell and number formatting.
How to print what you want.
The Skillsology Excel course is your one stop shop for Excel knowledge. Covering a range of business essential Excel skills, it is accessible 24/7, as many times as you like.
Facilities
Location
Start date
Start date
About this course
Consists of 38 business focused Excel units from our distilled syllabus
Contains 32 hours of learning materials but can be completed in as little as 12 hours of dedicated study
Provides 24/7 access to all learning materials from the date you register
It is available in all the main versions of Excel (PC: 2003, 2007, 2010, 2013 & 2016 / 365; Mac: 2011)
Generates a Certificate of Attainment and a Test Certificate (useful for CPD fulfilment)
It is taught through a blend of text-based articles, practice spreadsheets, video tutorials, and podcasts
Comes with email support from our experts.
This course is aimed at beginner to intermediate Excel users. If you are brand new to Excel or have a limited knowledge set you want to expand, then this course is for you. The course starts by covering the basics of Excel and then goes into essential formulas and functions. It then takes you through all the tools you will need to perform Data Analysis, including PivotTables and ends by looking at how you present and print your spreadsheets.
Open to all levels of professional and educational experience.
Reviews
-
The course is great. It’s a professional site and easy to follow. Staff is very helpful, I must say I'm glad I've chosen this centre.
← | →
-
Currently taking the online Excel course and I’m pleased since it’s easy to understand and very detailed.
← | →
-
I took the excel course and I’m very pleased with it. I can’t wait to take the next level. The course is well structured and there are a lot of exercises to practice what you have learned. Great experience!
← | →
Course rating
Recommended
Centre rating
Ruth Gaddess
Denise Felder
Patrice Diana
Funmi Elegbe-Odunaike
Susan Dutton
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 6 years
Subjects
- Excel
- Spreadsheet
- Design
- Graphics
- Database
- Data analysis
- IT
- Communication Skills
- Calculus
- Maths
Course programme
Section 1: Foundation
Unit 1.1 - Excel Introduction
Unit 1.2 - The Excel Interface
Unit 1.3 - Basic Navigation and Editing
Unit 1.4 - Getting Going
Takes a quick look at a first ‘real’ spreadsheet, in order to introduce the concept of functions and formulas, and give a feel for how Excel can be useful.
Section 2: Orientation & Efficiency
Unit 2.1 - Editing
Unit 2.2 - Viewing
Unit 2.3 - Spreadsheet Structure
Unit 2.4 - Cell References
Unit 2.5 - Named Ranges
Unit 2.6 - Basic Macros
Unit 2.7 - Design
Section 3: Administration
Unit 3.1 - Customising Excel
Unit 3.2 - Housekeeping
Unit 3.3 - Connecting Workbooks
Unit 3.4 - Documentation
Unit 3.5 - Protecting and Sharing
Unit 3.6 - Excel Troubleshooting
Section 4: Data Handling
Unit 4.1 - Sorting and Filtering
Unit 4.2 - Controlling User Input
Unit 4.3 - Working with Dates & Times
Unit 4.4 - Working with Text
Unit 4.5 - Lookup and Reference
Unit 4.6 - Logical Functions
Section 5: Data Analysis
Unit 5.1 - Working with Numbers
Unit 5.2 - Summarising Data
Unit 5.3 - PivotTables 1 - Simple Summaries
Unit 5.4 - PivotTables 2 - Manipulating Data
Unit 5.5 - PivotTables 3 - Interpreting Data
Unit 5.6 - Formula Auditing
Unit 5.7 - Advanced Macros and VBA
Unit 5.8 - Modelling
Excel