Skip to content
Play overlay
Preview this course

Microsoft Excel - Excel from Beginner to Advanced 2024

The complete 10-hour Excel course compatible with MS Office 365, or ANY version of Excel. Zero to HERO!

Warrick Klimaytys

Summary

Price
£19.95 inc VAT
Study method
Online, On Demand What's this?
Duration
13.1 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Reed courses certificate of completion - Free
Additional info
  • Tutor is available to students
42 students purchased this course

Add to basket or enquire

Overview

In this ‘No experience needed’ course you’ll go from complete beginner to a proficient Excel user within 10 hours of high-quality Excel tutorials, with some of the most critical Excel knowledge being taught within the first 3 hours of lessons.

Hosted by Reed Courses and taught by a top Excel instructor, you’ll be able to schedule your own learning, as you learn how to create spreadsheets and workbooks everyone will be jealous of.

Used by more than 1 billion people worldwide, Microsoft Excel is one of the top ten programs on the planet. But most users don’t know how to unlock its full potential. This is where “Microsoft Excel: Excel from Beginner to Advanced 2022” comes into play. It is designed to break the trend and make Excel accessible to anyone. Even someone who is not a “natural” Excel type of person.

Certificates

Reed courses certificate of completion

Digital certificate - Included

Will be downloadable when all lectures have been completed

Curriculum

14
sections
168
lectures
13h 4m
total

    • 1: Welcome to the course! Preview 02:52
    • 2: A brief introduction to Excel Preview 05:33
    • 3: The components that make up a spreadsheet, and more (INTRO) 01:46
    • 4: The components of a spreadsheet and more 09:47
    • 5: Open this website for the next tutorial 01:00
    • 6: Basic text/data management 08:30
    • 7: Autofill/Flashfill 06:12
    • 8: Autofill/Flashfill. Part 2 05:10
    • 9: Autofill/Flashfill. Part 3 05:39
    • 10: Exercise Instructions 01:44
    • 11: Solution video 06:33
    • 12: Course notebook preview Preview 00:52
    • 13: Downloading your notebook templates 01:00
    • 14: Must know keyboard shortcuts when doing an online course 06:03
    • 15: List of keyboard shortcuts 01:00
    • 16: A general overview and brief introduction (MUST WATCH) 01:46

    • 17: The main workbook download and instructions 02:00
    • 18: The three different types of references. Part 1 06:45
    • 19: The three different types of references. Part 2 03:41
    • 20: References exercise. A quick note 01:00
    • 21: References exercise 04:12
    • 22: Your 3-page instruction manual on references 01:00
    • 23: Test your knowledge on references 02:00
    • 24: Formulas and functions. What's the difference? 02:30
    • 25: Introduction to formulas 01:27
    • 26: Formula writing basics 05:05
    • 27: Test your knowledge on formula writing 01:00
    • 28: How to write formulas using BODMAS 05:19
    • 29: Test you knowledge on the BODMAS rule 01:00
    • 30: How to write formulas 09:28
    • 31: Methods for creating using functions 01:14
    • 32: Basic function variations you must know. Part 1 12:27
    • 33: Basic function variations you must know. Part 2 11:05
    • 34: Functions exercise. SumIfs, AverageIfs, & CountIfs 01:39
    • 35: Welcome to the Concatenate function 06:41
    • 36: Concatenate exercise 01:00
    • 37: Test your knowledge on the concatenate function. 01:00
    • 38: The IF Function Preview 11:44
    • 39: Test your knowledge on the IF function 01:00
    • 40: Introduction to charts 01:46
    • 41: Inserting a chart 06:04
    • 42: Test your knowledge of charts 01:00
    • 43: Chart exercise instructions 01:11
    • 44: Charts solution video and more! 05:09
    • 45: Formatting data into a table 07:02
    • 46: Formatting data into a table. Part 2 05:20
    • 47: The If/And/Or functions. Part 1 07:07
    • 48: Test you knowledge on the "If/And" function 01:00
    • 49: The If/And/Or functions. Part 2 06:04
    • 50: Test your knowledge on the "If/Or" function 01:00
    • 51: Introduction to printing 00:51
    • 52: Printing your first spreadsheet 10:27
    • 53: Test your knowledge on printing in Excel 02:00
    • 54: Printer settings 01:35
    • 55: Printing the second spreadsheet. Solution/exercise 04:23
    • 56: Building a navigation pane. A few things to note 00:57
    • 57: HEX to RGB converter link. 01:00
    • 58: Building a Navigation Pane. Part 1 08:19
    • 59: Building a Navigation Pane. Part 2 07:32
    • 60: Test your knowledge on navigation panes and hidden links. 03:00
    • 61: Vlookup 09:38
    • 62: Note about next tutorial 01:00
    • 63: Student request (Conditional formatting) 03:55
    • 64: Subtotalling data. Part 1 09:41
    • 65: Subtotalling data. Part 2 06:51
    • 66: 'Goals' exercise instructions 02:56
    • 67: 'Goals' solution video 11:33

    • 68: Advanced printing 08:36
    • 69: Collation and more 06:20
    • 70: Advanced printing. Part 2 09:22
    • 71: Advanced printing. Part 3 09:20
    • 72: Your 6-page printing instruction manual 01:00

    • 73: Introduction to macros Preview 02:00
    • 74: Saving as an Excel Macro-Enabled Document 02:32
    • 75: How to create a macro Preview 07:36
    • 76: Test your knowledge on Macros 03:00
    • 77: How to create macros (Use Relative Referencing) 06:46
    • 78: Test your knowledge on Macros 01:00
    • 79: Macros exercise instructions 04:58
    • 80: Macros exercise solution 07:14
    • 81: How to work with macros conveniently 05:19
    • 82: Test your knowledge on Macros 01:00
    • 83: Final thoughts on macros 01:38
    • 84: Your 8-page instruction manual on Macros 01:00

    • 85: A quick introduction to this section 01:20
    • 86: How to workout monthly payments with the PMT function 05:19
    • 87: How to work out monthly payments with the IPMT function 02:29
    • 88: How to work out yearly payments with the PMT & IPMT 10:05
    • 89: Exercise instructions and solution (PMT, IPMT, and more) 05:55
    • 90: Working out variable rate payments with the PMT 06:26
    • 91: The interest only and weekly payment example spreadsheets 04:12
    • 92: Your 4-page instruction manual on the PMT and IPMT 01:00

    • 93: What if analysis. Data table 10:14
    • 94: What if analysis. Goal seek 06:49
    • 95: What if analysis. Goal seek formulas 04:35

    • 100: Must know functions. Part 1 08:28
    • 101: Test your knowledge on functions 03:00
    • 102: Must know functions. Part 2 08:41
    • 103: Test your knowledge on functions 02:00
    • 104: Must know functions. Part 3 05:53
    • 105: Your 4-page manual on must know functions 01:00
    • 106: Splitting names with the 'Find', 'Left', 'Right' and 'Len' Function. Part 1 07:18
    • 107: Splitting names with the 'Find', 'Left', 'Right' and 'Len' Function. Part 2 06:01
    • 108: Missing 'Draw' tab 00:29
    • 109: Excels drawing tools and more 06:14

    • 110: Introduction to AI in Excel Preview 01:35
    • 111: Install this Add-in for the next 2 tutorials 01:00
    • 112: The 'Data Analyse' feature in Excel. Part 1 06:33
    • 113: The 'Data Analyse' feature in Excel. Part 2 06:25
    • 114: ChatGPT in Excel (Add-in) Preview 08:20
    • 115: ChatGPT for Excel (Add-in) parameters 06:09
    • 116: ChatGPT for Excel (Add-in). Final part 11:31
    • 117: Note about the next few tutorials 01:00
    • 118: How to use ChatGPT and Microsoft Copilot with Excel 07:50
    • 119: How to use Perplexity AI with Excel 02:40
    • 120: Update: Analytical Capabilities of ChatGPT-4 01:40

    • 121: Introduction to Charts in Excel 01:18
    • 122: Introduction to Chart formatting 08:29
    • 123: Test your knowledge on charts 03:00
    • 124: Charts in Excel. The Chart Design Tab 07:58
    • 125: Test your knowledge on charts 02:00
    • 126: Charts in Excel. Advanced Formatting Tools 09:33
    • 127: Inserting and managing Sparklines 06:43
    • 128: Test your knowledge on Sparklines 01:00
    • 129: Pictures in Charts and exercise instructions 05:13
    • 130: Test your knowledge on pictures in Excel 01:00
    • 131: Chart and Table Exercise Solution 09:14
    • 132: Common Charts. Part 1 07:18
    • 133: Common Charts. Part 2 08:47

    • 134: Introduction to this section 01:01
    • 135: Where to Get Free HIGH-QUALITY Datasets for Excel 01:00
    • 136: Collaborating/Sharing in Excel 02:33
    • 137: Test your knowledge on data analysis and management 01:00
    • 138: Data validation. Part 1 02:27
    • 139: Data validation. Part 2 08:25
    • 140: Test your knowledge on data validation 03:00
    • 141: Data validation solution video 01:32
    • 142: Locating and deleting duplicate data 06:57
    • 143: Test your knowledge on removing duplicate data 02:00
    • 144: Advanced filtering 10:42
    • 145: Test your knowledge on advanced filtering 02:00
    • 146: Advanced filtering solution video 04:04

    • 147: How to instal the Data Analysis Toolpak 02:33
    • 148: Test your knowledge on the Data Analysis Toolpak 01:00
    • 149: Data Analysis Tool. Part 1 07:07
    • 150: Data Analysis Tools. Part 2 08:25
    • 151: Test your knowledge on the Data Analysis Toolpak 02:00

    • 152: Calculating the payment with the PMT Function 05:45
    • 153: Exploring true cost 04:26
    • 154: Calculating total cost 06:12
    • 155: Using the 'IPMT' function to work out interest 07:59
    • 156: Inserting a chart for reference (Car Finance) 05:19

    • 157: The 4-point source data checklist Preview 06:29
    • 158: Test your knowledge on Pivot tables and Pivot charts 04:00
    • 159: Creating a pivot table. Part 1 07:34
    • 160: Test your knowledge on pivot tables and charts 04:00
    • 161: Creating a Pivot Table. Part 2 04:28
    • 162: Test your knowledge on slicers 01:00
    • 163: Pivot Tables. A little extra information 02:46
    • 164: Pivot Table and Chart. Scenario 1 08:19
    • 165: Test your knowledge on Pivot Charts 02:00
    • 166: Pivot Table and Chart. Scenario 2 05:51
    • 167: Pivot Table and Chart. Scenario 3 05:23
    • 168: Building a Pivot Dashboard 04:55

Course media

Description

Embark on a journey through Microsoft Excel with the course, 'Microsoft Excel - Excel from Beginner to Advanced 2024'. This course is designed to strip away any uncertainty you might feel and make Excel as intuitive as your morning routine!

How do I achieve this transformation?

  • Clear and Simple Explanations: I demystify Excel’s concepts in a way that’s easy to understand.

  • Detailed Breakdowns: Every tool, feature, and function of Excel is dissected for thorough comprehension, ensuring you grasp the finer points of the application.

  • Continuous Reinforcement: To cement your knowledge, I periodically review previously covered topics, reinforcing your learning and boosting confidence.

  • Designed for All Levels: Whether you're a novice or looking to sharpen your skills, this course catars to all proficiency levels.

To accelerate your proficiency, I've crafted a special workbook, "main-workbook-section2", to guide you through the initial stages of the course after the introductory materials. This workbook covers essential features and functionalities, setting a solid foundation as you advance. As the course progresses, you'll have access to various spreadsheets and workbooks to enhance your learning experience.

What’s next after enrolling?

We kick off with introductory tutorials to ensure you're well-prepared, followed by a thorough overview of Excel basics. Dive into section two with enthusiasm—where I'm confident you’ll not only succeed but also enjoy the learning process! From there, we’ll delve deeper into Excel, refining your skills and introducing new techniques to elevate your expertise.

Join us, and transform your Excel skills from foundational to phenomenal!

What do you get when you enroll:

- A 14-day money-back guarantee, so you can enroll risk-free.

- A lifetime access guarantee so you can re-visit the course whenever you want.

- Access to the Q and A section so you can get help at any point during the course.

- A certificate of completion to add to your resume/CV.

- Regular updates to the course content.

Who is this course for?

With more than six years of experience teaching Excel online, I've designed this dynamic course to meet the needs of nearly every student who joins. The skills you'll learn here are not only practical but also highly applicable to numerous real-world situations. Microsoft Excel is an immensely important tool, essential across every continent. Mastery of Excel can significantly enhance your career opportunities, boosting your current job prospects and playing a vital role in self-employment and everyday home use. Discover how Excel can open doors to new possibilities and transform your professional life!

Is this course right for you? In most cases, yes. Once enrolled, you’ll have a 14-day money-back guarantee. So, if you find the course isn’t a good fit, you can request a refund, no questions asked.

Requirements

This course is designed to be compatible with any version of Excel, thanks to the program's nearly timeless nature. While you may notice some variations between your version and the one used in the course, these differences are typically minor and will not significantly impact your learning experience.

Career path

After completing this course, you'll be able to add a highly relevant skill to your CV/resume. But what job roles can you expect, and what salary ranges do they offer? Here is a list:

Management (Varying industries/roles) – £33,873 – £98,995

Financial analyst – £42,784

Business analyst – £50,384

Accountant - £39,000

Data journalist - £37,124

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Ask a question

Reviews

5.0
Course rating
100%
Service
100%
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