Skip to content

Microsoft Excel: from ZERO to ADVANCED

Learn Excel from scratch to the point where you'll be able to program your own macros!

LearningWhilePracticing

Summary

Price
Save 76%
£12 inc VAT (was £50)
Offer ends 30 June 2024
Study method
Online, On Demand What's this?
Duration
7.2 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Reed courses certificate of completion - Free
911 students purchased this course

Add to basket or enquire

Overview

Microsoft Excel is one of the most advanced spreadsheet software and one with a high demand on the market. Whether it is for data science, finance and accounting or administration, Microsoft Excel has the tools and libraries that will make your project come to life.

If you have no knowledge whatsoever in this software, this course is for you! You will be gaining all the required skills to be a complete professional in no time.

This course is divided into 6 sections, and made up of 42 chapters. All the exercise files are provided with the videos so you can follow along with the instructor.

Curriculum

6
sections
42
lectures
7h 13m
total

    • 1: Part 1 - Chapter 1 04:17
    • 2: Part 1 - Chapter 2 09:28
    • 3: Part 1 - Chapter 3 08:10
    • 4: Part 1 - Chapter 4 04:09
    • 5: Part 1 - Chapter 5 11:34
    • 6: Part 1 - Chapter 6 03:38
    • 7: Part 1 - Chapter 7 07:14
    • 8: Part 1 - Chapter 8 01:47

    • 9: Part 2 - Chapter 9 05:27
    • 10: Part 2 - Chapter 10 07:42
    • 11: Part 2 - Chapter 11 10:14
    • 12: Part 2 - Chapter 12 06:33
    • 13: Part 2 - Chapter 13 16:59
    • 14: Part 2 - Chapter 14 12:15
    • 15: Part 2 - Chapter 15 11:56
    • 16: Part 2 - Chapter 16 11:44
    • 17: Part 2 - Chapter 17 07:47
    • 18: Part 2 - Chapter 18 08:41

    • 19: Chapter 19 15:27
    • 20: Chapter 20 36:46
    • 21: Chapter 21 05:51
    • 22: Chapter 22 20:03
    • 23: Chapter 23 31:33

    • 24: Chapter 24 - Imporing and Cleaning Data 10:08
    • 25: Chapter 25 - Using Data Validation 09:47
    • 26: Chapter 26 - Worksheet Outlines 03:47
    • 27: Chapter 27 - Linking and Consolidating 05:56
    • 28: Chapter 28 - PivotTables 16:39
    • 29: Chapter 29 - What-If Analysis 15:11
    • 30: Chapter 30 - Goal Seek and Solver 15:11
    • 31: Chapter 31 - ToolPak 06:23
    • 32: Chapter 32 - Protecting Data 03:57

    • 33: Chapter 33 - Introducing Power Pivot 03:43
    • 34: Chapter 34 - Data Model 07:57
    • 35: Chapter 35 - Adding Formulas to Power Pivot 12:42
    • 36: Chapter 36 - Power Query 10:52

    • 37: Chapter 37 - VBA 14:45
    • 38: Chapter 38 - User Defined Functions 06:32
    • 39: Chapter 39 - UserForm 06:12
    • 40: Chapter 40 - UserForm Example 12:19
    • 41: Chapter 41 - Excel Events 04:15
    • 42: Chapter 42 - Add in 06:49

Course media

Description

The course is divided into the following sections and chapters:

  1. Getting Started with Excel

    • Introducing Excel
    • Entering and Editing Worksheet Data
    • Performing Basic Worksheet Operations
    • Working with Excel Ranges and Tables
    • Formatting Worksheets
    • Understanding Excel Files and Templates
    • Printing Your Work
    • Customizing the Excel User Interface

  2. Working with Formulas and Functions

    • Introducing Formulas and Functions
    • Using Formulas for Common Mathematical Operations
    • Using Formulas to Manipulate Text
    • Using Formulas with Dates and Times
    • Using Formulas for Conditional Analysis
    • Using Formulas for Matching and Lookups
    • Using Formulas for Financial Analysis
    • Using Formulas for Statistical Analysis
    • Understanding and Using Array Formulas
    • Making Your Formulas Error-Free
  3. Creating Charts and Other Visualizations

    • Getting Started with Excel Charts
    • Using Advanced Charting Techniques
    • Creating Sparkline Graphics
    • Visualizing with Custom Number Formats and Shapes
    • Implementing Excel Dashboarding Best Practices

  4. Managing and Analyzing Data

    • Importing and Cleaning Data
    • Using Data Validation
    • Creating and Using Worksheet Outlines
    • Linking and Consolidating Worksheets
    • Introduction to PivotTables and Data Analysis
    • Performing Spreadsheet What-If Analysis
    • Analyzing Data Using Goal Seeking and Solver
    • Analyzing Data with the Analysis ToolPak
    • Protecting Your Work

  5. Understanding Power Pivot and Power Query

    • Introducing Power Pivot
    • Working Directly with the Internal Data Model
    • Adding Formulas to Power Pivot
    • Power Query

  6. Automating Excel

    • Introducing Visual Basic for Applications
    • Creating Custom Worksheet Functions
    • Creating UserForms
    • Using UserForm Controls in a Worksheet through an Example
    • Working with Excel Events
    • Creating Custom Excel Add-Ins

Who is this course for?

This course can be enrolled by complete beginners in Excel who would like to achieve a high level of knowledge in the software.

Requirements

None!

Career path

Any career that requires the use of Microsoft Excel.

Questions and answers

No questions or answers found containing ''.

Louise asked:

My laptop and software is old - what are the excel versions/requirements to be able to access the course?

Answer:

Hello, the minimal Excel version should be 2016, ideally 2019 or 365

This was helpful. Thank you for your feedback.
Marcia asked:

Does this course include V-Look ups?

Answer:

Yes it does

This was helpful. Thank you for your feedback.
Uppal asked:

How long is the time frame for one to complete the course? 1 month, 2 months etc...

Answer:

The course is made up of 7.2 hours of video lectures. At an accelerated pace it can be done in a month. But going for 2 to 3 months at a slower pace will certainly be more beneficial to fully grasp all the skills

This was helpful. Thank you for your feedback.
Mahmood hussein asked:

It's seventy two hours or seven hours and twenty minutes.

Answer:

It's seven hours and 13 minutes

This was helpful. Thank you for your feedback.
Yee Chi asked:

In this course, does it provide some excel files for practice?

Answer:

Yes! All Excel files are provided so you can follow along every step like the instructor.

This was helpful. Thank you for your feedback.
Abdul asked:

Could this course be done on office online? Thanks

Answer:

Hello, Office Online might not have all the functionalities of the video. However it does contain a good part of them.

This was helpful. Thank you for your feedback.
peter asked:

is this course time bound or is it train at your own pace, and how long is the material accessible for please

Answer:

Hello Peter, this course is a train at your own pace. The material should in theory be accessible right at all times. Best, LWP

This was helpful. Thank you for your feedback.
Ask a question

Certificates

Reed courses certificate of completion

Digital certificate - Included

Will be downloadable when all lectures have been completed

Reviews

4.8
Course rating
94%
Service
97%
Content
100%
Value

Legal information

This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Related searches: Microsoft 365 courses, Business administration courses, Microsoft courses, Online courses