Skip to content
Play overlay
Preview this course

Microsoft Excel from A-Z: Beginner To Expert Course

Master pivot tables, formulas, macros, vba, data analysis and learn how to land your first job as an Excel expert!


Lunes Online Learning

Summary

Price
Save 90%
£10 inc VAT (was £100)
Offer ends 31 December 2021
Study method
Online, On Demand What's this?
Duration
13 hours
Qualification
No formal qualification
Additional info
  • Tutor is available to students
  • Certificate of completion available and is included in the price

2,296 students purchased this course

Add to basket or enquire

Overview

  • Learn to master Excel from A-Z.
  • How to become a professional Data Analyst.

  • How to be a better, faster, stronger Excel user.

  • How to save hours of time and boost your productivity in Excel.

  • How to find a value with VLOOKUP, HLOOKUP, INDEX, MATCH.

  • How to use math, statistical, logic and text functions.

  • How to use VBA and Macros.

  • How to use VLOOKUP/HLOOKUP in formulas.

  • How to create basic and advanced formulas.

  • Mastering Pivot Tables.

  • Creating Charts from your data.

  • How to land your first job as an Excel Expert.

Curriculum

28
sections
154
lectures
13h 3m
total
    • 16: Creating Excel Labels 02:32
    • 17: Entering Numeric Data in Excel 03:25
    • 18: Formatting Date Values in Excel 05:19
    • 19: Building Basic Formulas in Excel 04:44
    • 20: Order of Operation 06:28
    • 21: Relative vs Absolute Cell References 07:23
    • 22: Excel Functions Explained 02:35
    • 23: The SUM Function 07:31
    • 24: The MIN and MAX Function 03:44
    • 25: The AVERAGE Function 02:01
    • 26: COUNT Functions 04:57
    • 27: Moving and Copying Data 06:45
    • 28: Insert and Delete Rows and Columns 05:04
    • 29: Adjusting the Width and Height of Cells 04:34
    • 30: Hiding and Unhiding Excel Rows and Columns 04:28
    • 31: Renaming Moving and Deleting Excel Worksheets 05:27
    • 32: Adding Protection to Specific Cells 04:24
    • 33: Protecting the Structure of a Workbook 02:11
    • 34: Adding a Workbook Password to Open File 02:10
    • 35: Formatting Fonts and Cell Background Color 04:55
    • 36: Adding Cell Borders 04:47
    • 37: Formatting Data Appropriately 05:21
    • 38: The Magic Behind Excel's Format Painter 03:30
    • 39: Creating Styles for Formatting Efficiency 05:56
    • 40: Merging Cells for a Cleaner Look 03:27
    • 41: The Power of Conditional Formatting 06:09
    • 42: Grab User's Attention Using Illustrations 08:39
    • 43: Customizing Icons 04:41
    • 44: Create Compelling Graphics with SmartArt 05:36
    • 45: The Commonly Used Column Chart 02:46
    • 46: Changing the Chart Design 01:58
    • 47: Formatting Elements of a Chart 06:24
    • 48: Modifying the Data Type and Location of a Chart 06:06
    • 49: Little Slice of Pie Charts 05:12
    • 50: Print Preview Options 04:26
    • 51: Excel's Page Layout View 06:36
    • 52: Printing a Specific Range of Cells 02:38
    • 53: Converting Spreadsheets to PDF Files 02:28
    • 54: Why Create an Excel Template 01:23
    • 55: How to Create an Excel Template 05:22
    • 56: How to Prepare Data for Analysis 04:01
    • 57: How to Sort Data in Excel 02:38
    • 58: Multi-Level Sorting 02:34
    • 59: Custom Sorting Datasets in Excel 02:27
    • 60: Applying Filters to Datasets 04:44
    • 61: Creating Subtotals within a Dataset 05:39
    • 62: Converting Datasets into Tables 05:55
    • 63: Finding and Removing Duplicate Values 07:29
    • 64: The SUMIF Function 08:42
    • 65: The DSUM Function 07:47
    • 66: The DSUM Function Continued 07:06
    • 67: The SUBTOTAL Function 06:29
    • 68: What is Excel Data Validation? 01:56
    • 69: Creating a Drop Down List with Data Validation 07:09
    • 70: Different Types of Data Validation 05:39
    • 71: Adding Custom Alerts to Data Validation 06:53
    • 72: Creating a Dynamic Drop Down List 03:09
    • 73: Complex Validation: Dependent Drop Down List! 08:39
    • 74: Creating an Excel Pivot Table 05:31
    • 75: Modifying Excel Pivot Tables 05:39
    • 76: Grouping & Filtering PivotTable Data 06:30
    • 77: Drilling Down into PivotTable Data 02:00
    • 78: Creating PivotCharts and Utilising Slicers 08:00
    • 79: What is PowerPivot? 03:46
    • 80: Activating the Excel PowerPivot Add-In 01:34
    • 81: Creating Relationships between Data Tables 06:22
    • 82: Using Data Models to Create PivotTables 04:31
    • 83: How to Create PowerPivot KPIs 08:26
    • 84: Excel's IF Function 05:17
    • 85: IF() Function with AND() Criteria 05:23
    • 86: IF() Function with OR() Criteria 05:14
    • 87: Nesting Multiple IF() Functions 07:24
    • 88: The COUNTIF() Function 04:06
    • 89: Key Benefits of Using Named Ranges 04:11
    • 90: VLOOKUP() Function 09:00
    • 91: The Beauty of Excel’s IFERROR() Function 03:56
    • 92: HLOOKUP() Function 06:21
    • 93: INDEX() Function 04:43
    • 94: MATCH() Function 04:56
    • 95: INDEX() and MATCH() Combined 05:08
    • 96: Two-Way Lookup with INDEX() and MATCH() 04:10
    • 97: LEFT(), RIGHT() and MID() Function 07:08
    • 98: Extracting Specific Text using LEN() & SEARCH() 12:44
    • 99: Combining Text with CONCATENATE() 06:05
    • 100: Quick Tips and Other Text Based Functions 05:49
    • 101: Tracing Precedents and Dependents in Formulas 04:28
    • 102: Showing Formulas 01:53
    • 103: Grouping Data 02:42
    • 104: 3D Referencing in Formulas 05:04
    • 105: Utilizing the Watch Window in Excel 02:44
    • 106: How to Freeze Panes in Excel 02:56
    • 107: Excel's Scenario Manager Tool 05:55
    • 108: Goal Seek in Excel 06:15
    • 109: Compare Results with Excel Data Tables 04:23
    • 110: Solver Tool 10:59
    • 111: The Power Behind Excel VBA 02:35
    • 112: A Look Inside the Visual Basic Editor (VBE) 03:57
    • 113: Recording a Macro 09:11
    • 114: Saving and Opening a Macro Enabled Workbook 02:14
    • 115: Modules and Procedures 06:34
    • 116: Object, Methods and Properties 05:59
    • 117: Excel VBA Variables 04:39
    • 118: Referencing a Range 13:30
    • 119: InputBox and MsgBox 05:33
    • 120: Using Variables in VBA Code 04:32
    • 121: If Then Else Statement 10:23
    • 122: Worksheet Functions inside VBA 07:32
    • 123: Creating User Defined Functions 09:19
    • 124: User Defined Functions within VBA Scripts 06:09
    • 125: Find Last Row of Data 05:46
    • 126: Find Last Column of Data 03:12
    • 127: With Statement 04:51
    • 128: Debugging and Error Handling 06:36
    • 129: Debugging and Error Handling Continued 06:45
    • 130: For Next Loop 09:12
    • 131: Do Until Loop 06:03
    • 132: For Each Loop 03:36
    • 133: Assigning Macros to Shapes 03:33
    • 134: Form Controls vs Active X Controls 07:50
    • 135: Worksheet Events 03:44
    • 136: Workbook Events 02:54
    • 137: Fun with VBA Events 06:55
    • 138: Creating an Excel UserForm 03:15
    • 139: Adding Controls to UserForms 10:00
    • 140: How to Show an UserForm 03:01
    • 141: Passing TextBox Values to Desired Cells 06:37
    • 142: Passing Option Buttons Values to Desired Cells 06:50
    • 143: UserForm ComboBoxes 08:08
    • 144: Clearing Values from UserForm Controls 03:06
    • 145: How to Close an UserForm 01:34
    • 146: UserForms and Protected Sheets 04:40
    • 147: Creating an Excel Resume 04:51
    • 148: Getting Started with Freelancing 06:16
    • 149: How to Become an Excel Freelancer 05:12
    • 150: Top Freelance Sites 05:12
    • 151: Getting Your First Client 07:45
    • 152: Personal Branding 06:47
    • 153: Networking Do’s and Don’ts 04:22
    • 154: Importance of Website 04:24

Course media

Description

Welcome to the Learn Microsoft Excel from A-Z: Beginner To Expert Course

In this practical, hands-on course our main objective is to give you the education not just to understand the ins and outs of Microsoft Excel, but also to learn exactly how to master pivot tables, formulas, macros, vba, data analysis, and how to land your first job as an Excel expert!

This course will fully prepare you for virtually any Excel related career path, including those that require advanced skills with this software. Once you complete the course, you’ll have access to the full functionality of Excel, and will know how to use all formulas, functions, and capabilities.

You’ll also learn about calculating depreciation, calculating interest, and even calculating EMI for loans, all by using Excel functions. The course also features information on INDEX and MATCH functions as well as using the CHOOSE formula, and how to create special charts.

Whether you are brand new to the world of Excel, or you have training and knowledge of the software and are looking to improve your skills, this masterclass will take you to the next level. By the time you finish the beginner, intermediate and advanced portions, you too will be an expert in Excel.

We understand that theory is important to build a solid foundation, we understand that theory alone isn’t going to get the job done so that’s why this course is packed with practical hands-on examples that you can follow step by step. Even if you already have some experience, or want to learn about the advanced features of Excel, this course is for you!

Together we’re going to give you the foundational education that you need to know not just on how to use Excel at an expert level, but also how to get paid for your newly developed skills.

The course covers 4 main areas:

1: INTRO TO EXCEL

This intro section gives you a full introduction to Microsoft Excel, the data analyst industry and marketplace, job opportunities and salaries, and the various Excel-related job roles.

  • Intro to Microsoft Excel

  • Excel Industry and Marketplace

  • Excel Job Opportunities

  • Getting Started with Excel

  • Excel Functions

2: INTERMEDIATE EXCEL

This section gives you a full introduction to the Intermediate Excel functions with hands-on step by step training.

  • Data Visualization

  • Datasets

  • Databases

  • Data Validation

  • PivotTables

  • Conditional Functions

  • Lookup Functions

  • Formulas, + more!

3: EXCEL MACROS & VBA

This section gives you a full introduction to the Excel Macros and VBA with hands-on step by step training.

  • VBA Language

  • VBA Code

  • VBA Loops

  • Macros

  • User Forms

4: STARTING AN EXCEL CAREER

This section gives you a full introduction to starting a career as an Excel Programmer with hands-on step by step training.

  • Creating a Resume

  • Freelancing + Freelance websites

  • How To Get Your 1st Client

  • Personal Branding

  • Importance of Having a Website

  • Networking

By the end of the course you’ll be a professional Excel programmer and confidently apply for jobs and feel good knowing that you have the skills and knowledge to back it up.

Who is this course for?

  • Students who want to learn and master microsoft excel

Requirements

  • basic computer skills

Questions and answers


No questions or answers found containing ''.


Prince asked:

I accessed the resources from the google link, but could not find and locate the Excel Practice copy datasets to download, so where can you find it?

Answer:

Hi Prince, all the resources have no been added to the lesson for download, thanks.

This was helpful. Thank you for your feedback.

Khalid asked:

Can you download the Excell program for free.

Answer:

Hi Khalid, you'll have lifetime access to the on-demand course through the platform. You will not be able to download, thanks.

This was helpful. Thank you for your feedback.

Hunain asked:

What version of Excel do you need for the course?

Answer:

Any version but best with the latest version.

This was helpful. Thank you for your feedback.

Le-Anne asked:

How long do you get access to this course?

Answer:

Hi Le-Anne, lifetime access, thanks.

This was helpful. Thank you for your feedback.

Khalid asked:

Do you need any software for excel.

Answer:

Hi Khalid, you'll simply need the excel program, thanks.

This was helpful. Thank you for your feedback.

Bulukani Mmongwa asked:

how do i apply for the course

Answer:

Hi Bulukani, just click on the "add to basket" button and go through the process, thanks.

This was helpful. Thank you for your feedback.

Ella asked:

when do you receive the certificate? Who is it awarded by?

Answer:

Hi Ella, the certificate is awarded by Reed. Please contact student support with your queries, thanks.

This was helpful. Thank you for your feedback.

Prince asked:

I went in the "finding and opening excel" lesson that has a google drive link, but still could not view and access, the example Excel Datasets?

Answer:

Hi Prince, resources have been uploaded to the lesson and are now available for download, thanks.

This was helpful. Thank you for your feedback.

John Onoja asked:

How do i pay for the course?

Answer:

Hi John, you add the course to add and checkout your order, thanks.

This was helpful. Thank you for your feedback.

Prince asked:

Where can you find the practice files for the some sections of the course?

Answer:

Hi Prince, you'll find the course files in the "finding and opening excel" lesson that has a google drive link, thanks.

This was helpful. Thank you for your feedback.

Mehret asked:

When is dead line for application

Answer:

Hi Mehret, you can take the course whenever you like. It's pre-recorded course with on-demand videos you can watch at your leisure, thanks.

This was helpful. Thank you for your feedback.

Zafar Khan asked:

Is there age limit fir this course ?

Answer:

Hi Zafar, no age limit required, thanks.

This was helpful. Thank you for your feedback.

Dani asked:

Do we need to be on at certain times or can I work this round my full time job?

Answer:

Hi Dani, you can take the course whenever you like. It's pre-recorded course with on-demand videos you can watch at your leisure, thanks.

This was helpful. Thank you for your feedback.

Ime asked:

Can I have access to the course instructor if I need detailed explanation on some subjects or issues I don’t understand ?

Answer:

Yes, you can ask questions and we'll be sure to provide guidance, thanks.

This was helpful. Thank you for your feedback.

Reviews

5.0
Course rating
100%
Service
100%
Content
100%
Value

FAQs

What does study method mean?

Study method describes the format in which the course will be delivered. At reed.co.uk 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.

What are CPD hours/points?

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.co.uk, many of which can be completed online.

What is a ‘regulated qualification’?

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.

What is an ‘endorsed’ course?

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.