Skip to content
  1. Online
  2. Office skills
  3. Microsoft
  4. Microsoft Excel
Master Microsoft Excel: from Novice to Pro cover image
Play overlay
Preview this course

Master Microsoft Excel: from Novice to Pro
Vnnergy LLC

2023 BLACK FRIDAY OFFER: FREE PDF Certificate | Accredited 25 CPD Hours | Lifetime Access

Summary

Price
£1,900 inc VAT
Or £158.33/mo. for 12 months...
Study method
Online, On Demand 
Course format
Video with subtitles and transcript
Duration
16.9 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Reed courses certificate of completion - Free
Additional info
  • Tutor is available to students

Overview

Are you ready to transform your professional life? Join us on a journey to mastery with our comprehensive Microsoft Excel course. This Black Friday, seize the opportunity to acquire essential skills and gain a competitive edge in your career. With a free PDF certificate upon completion from Vnnergy, you're on the path to success.

Embark on an extraordinary learning experience with our Microsoft Excel course and open doors to countless opportunities for career advancement. At Vnnergy, we empower you to pursue your dreams, equipping you with the skills and knowledge required to excel in your chosen profession.

This self-paced course, accessible through Reed's user-friendly platform, is designed to elevate your CV, impress potential employers, and set you apart from the competition. With our expertly crafted modules, a blend of instructional video lessons and study materials, and dedicated online tutor support, you'll have all the resources you need to succeed.

Upon completing this course, you'll receive a prestigious e-certificate, validating your expertise in Microsoft Excel. Join the ranks of professionals who have enhanced their careers with Vnnergy's world-class training.

Why Choose Vnnergy's Microsoft Excel Course?

  • FREE PDF certificate upon successful completion
  • Lifetime access to course materials
  • Instant assessment results
  • No hidden fees
  • Full tutor support available Monday to Friday
  • Self-paced learning at your convenience
  • Comprehensive understanding of Microsoft Excel
  • Engaging modules taught by industry experts
  • 24/7 support via email, live chat, and WhatsApp
  • Accessible from any device

Invest in your future today and enroll in the Microsoft Excel course. Take the first step towards a brighter tomorrow!

Certificates

Curriculum

This course contains

Format: 107 Videos (with subtitles and transcripts) and 1 Article

Duration: 16h and 55m

    • 3: Launching Excel 08:59
    • 4: Introduction to the Excel Interface 12:22
    • 5: Ribbons and Tabs 11:47
    • 6: The Backstage Area 08:57
    • 7: The Quick Access Toolbar 09:05
    • 8: Useful Keyboard Shortcuts 09:20
    • 9: Getting Help 14:59
    • 10: Contextual Menus and the Mini Toolbar 06:30
    • 11: Status Bar 06:16
    • 12: Section 02 Exercise 03:40

    • 13: Working with Templates 16:11
    • 14: Working with Workbooks and Worksheets 15:44
    • 15: Saving your Excel Spreadsheet 13:32
    • 16: Custom Lists and Series Fill 07:47
    • 17: Entering and Editing Data 11:39
    • 18: Basic Number Formatting 12:37
    • 19: Navigating and Selecting Cells and Ranges 10:05
    • 20: Section 03 Exercise 06:55

    • 21: Introduction to Functions and Formulas 15:03
    • 22: The Order of Calculation 09:57
    • 23: Counting Items in a List 08:50
    • 24: Finding Averages 10:52
    • 25: Finding the Minimum and Maximum Value 07:44
    • 26: Using Multiple Functions in a Formula 11:27
    • 27: Errors in Calculations 11:15
    • 28: Relative, Absolute and Mixed Referencing 14:41
    • 29: Section 04 Exercise 06:05

    • 30: Creating Named Ranges 06:48
    • 31: Managing Named Ranges 05:48
    • 32: Using Named Ranges in Formulas 09:02
    • 33: Named Ranges Tips and Tricks 07:04
    • 34: Section 05 Exercise 06:15

    • 35: Formatting Numbers 13:51
    • 36: Formatting Dates 11:13
    • 37: Applying Formatting to Cells 18:16
    • 38: Formatting Columns and Rows 15:33
    • 39: Alignment 12:42
    • 40: Deleting and Clearing Formatting 08:25
    • 41: Themes and Styles 12:21
    • 42: Using the Format Painter 08:14
    • 43: Section 06 Exercise 08:47

    • 44: How to Structure a List 12:17
    • 45: Sorting a List (Single-level sort) 15:48
    • 46: Sorting a List (Multi-level sort) 11:07
    • 47: Sorting using Custom Lists 04:50
    • 48: Using Auto-Filter to Filter a List 13:15
    • 49: Format As a Table 14:22
    • 50: Creating Subtotals in a List 11:14
    • 51: Flash Fill 08:29
    • 52: Section 07 Exercise 05:41

    • 53: Cut Copy and Paste Basics 07:39
    • 54: Paste Options 10:43
    • 55: Using the Clipboard 07:56
    • 56: Linking to cells in other Worksheets 09:39
    • 57: 3D Referencing 09:17
    • 58: Inserting Hyperlinks to Worksheets 11:19
    • 59: Section 08 Exercise 06:29

    • 60: The VLOOKUP Function (Exact Match) 10:09
    • 61: The VLOOKUP Function (Approx Match) 07:08
    • 62: The HLOOKUP Function 07:42
    • 63: Error Handling in Formulas 12:31
    • 64: Logical Functions - Part 1 08:27
    • 65: Logical Functions - Part 2 12:22
    • 66: COUNTIF and SUMIF 07:11
    • 67: Text Functions 14:20
    • 68: Date and Time Functions 11:55
    • 69: Section 09 Exercise 13:06

    • 70: Creating Charts to Present Data 09:36
    • 71: Formatting a Chart 11:21
    • 72: Other Useful Charts 14:01
    • 73: Updating Charts 04:26
    • 74: Section 10 Exercise 05:21

    • 75: Sorting Data 10:07
    • 76: Filtering Data 10:48
    • 77: Section 11 Exercise 05:20

    • 78: Highlight Cell Rules 10:52
    • 79: Data Bars 06:19
    • 80: Color Scales 06:41
    • 81: Icon Sets 09:19
    • 82: Section 12 Exercise 06:50

    • 83: Inserting Pictures 14:24
    • 84: Inserting Shapes 15:46
    • 85: Inserting Icons and 3D Models 09:48
    • 86: Inserting SmartArt 12:34
    • 87: Inserting Screenshots 07:07
    • 88: Inserting Comments and Notes 10:32
    • 89: Section 13 Exercise 09:24

    • 90: Workbook Views 08:58
    • 91: Zooming in and Out of a Worksheet 06:41
    • 92: Arranging Workbooks and Worksheets 06:13
    • 93: Freezing Panes 06:04
    • 94: Section 14 Exercise 04:29

    • 95: Margins and Orientation 07:20
    • 96: The Print Area 03:08
    • 97: Page Breaks 04:58
    • 98: Print Titles-and-Background 07:59
    • 99: Headers-and-Footers 05:34
    • 100: Printing a Workbook 07:52
    • 101: Section 15 Exercise 05:01

    • 102: Protecting Workbooks and Worksheets 13:09
    • 103: Spell Checking 06:52
    • 104: Inspecting the Workbook 08:59
    • 105: Saving in Different Formats 07:47
    • 106: Sharing a Workbook 07:17
    • 107: Section 16 Exercise 06:33

    • 108: Bonus Lecture 01:33

Course media

Description

Join our seasoned instructor, Deb Ashby, with over 15 years of Excel training experience, on a journey from Excel novice to Excel guru. This course is your gateway to mastering the most popular spreadsheet tool in the market – Microsoft Excel.

By the end of this course, you'll have the confidence to tackle any Excel task efficiently and gracefully. Here are just a few of the topics you'll master:

  • Creating effective spreadsheets
  • Managing large datasets
  • Mastering Excel's popular functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH, and more)
  • Creating dynamic reports with Excel PivotTables
  • Unlocking the power of Microsoft Excel's Add-In, PowerPivot
  • Auditing Excel Worksheet formulas for clean results
  • Automating daily Excel tasks with Macros and VBA

Don't wait any longer – enroll now and elevate your Excel skills from novice to guru!

Method of Assessment: To successfully complete the Microsoft Excel course, you'll take an automated multiple-choice exam, which is available online. Achieve a score of 60% or higher to pass and receive your certificate, validating your Microsoft Excel qualification.

Certification: Upon successful completion of the course, you can instantly download your free e-certificate. Additionally, you have the option to purchase a hard copy of the certificate, delivered by post for £9.99.

Who is this course for?

  • This course is perfect for anyone looking to develop one of today's most crucial digital skills. Whether you need Excel skills for your daily office tasks, want to enhance your CV, or aspire to gain a professional qualification, this course is tailored to meet your needs.

Requirements

  • Internet connection
  • Access to MS Excel on your computer/laptop
  • The Microsoft Excel is open to all students and has no formal entry requirements. To study the Microsoft Excel course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills.

Career path

The Microsoft Excel course is your stepping stone to a dream career in various industries. Acquire the skills necessary to enhance your CV and pursue your ideal job. Excel in your job search with an industry-recognized qualification gained from the Microsoft Excel course. Your future success awaits!

Questions and answers

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: Online courses

Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2026. All rights reserved.