reed.co.uk Courses

Header

Check out our Christmas deals

Microsoft Excel Complete Course 2019 - Beginner, Intermediate & Advanced - CPD Accredited

Updated with MS Excel 2019 New Features . Exam Included . Accredited Qualification . Lifetime access . Instant Result


Course Gate

Summary

Price
Save 89%
£19 inc VAT (was £175)
Offer ends 14 December 2019
Study method
Online, self-paced
Access to content
Lifetime access
Qualification
40 CPD points / hours
Additional info
  • Exam(s) / assessment(s) is included in price
  • Tutor is available to students

326 students purchased this course

Add to basket or enquire

Overview

Updated with the Microsoft Excel 2019 New Features.

Microsoft Excel – Complete Course - Beginners, Intermediate & Advanced - CPD Accredited

We have carefully combined our three best courses in one bundle- Microsoft Excel Beginners, Intermediate and Advanced to make it easy for you to learn Excel. You won’t find a great deal like this anywhere else at this price.

Microsoft Excel is one of the most widely used programs in the world for visualising and analysing data. This useful software is used for personal use in households as well as in almost every industry these days. Whether you are a beginner, an expert or haven't used Excel in years and require a significant refresher, this Microsoft Excel Complete Course will be hugely beneficial. You will be an expert user in Excel in just 10 hours.

Our easy-to-grasp tutorials will provide the knowledge you need in an easy format, and you’re free to study at your own pace, whenever you want, so there will be no rush. You will feel more confident in working with Excel upon completion of the Microsoft Excel Complete course.

Learning Objectives:

The primary learning objectives of the Microsoft Excel Complete Course - Beginner, Intermediate & Advanced are to:

  • Develop a range of basic to advanced Microsoft Excel skills and techniques that will become a standard component of your everyday use of Excel.
  • Help you design sophisticated spreadsheets, including modifying and formatting worksheets.
  • Assist you in performing complex calculations using advanced Excel features and techniques.
  • Get you acquainted with the skills to manage large datasets efficiently and extract meaningful information from datasets.
  • Teach you how to analyse data, extract information effectively and present the results in a user-friendly way.
  • Help you familiarise with the methods of working with multiple worksheets and workbooks.
  • Develop your knowledge of creating easy to use spreadsheets.
  • Explain how to automate choices and data lookups using functions.
  • Teach you how to generate pivot tables from a range with rows and columns in Excel and represent data visually using pivot charts.
  • Train you to manage large datasets and create meaningful reports.
  • Provide guidance to confidently utilise Excel and add highly valuable skills to your CV.
  • Provide expert training to help you earn your Microsoft Excel certification that will lead to better employment opportunities.

Course Gate gift cards make the perfect Christmas presents for friends, leaving gifts for colleagues or little treats to lavish on loved ones. Buy this course as the best Christmas gift and send the gift card to anyone you want.

Course media

Description

Updated with the Microsoft Excel 2019 New Features.

MS Excel Beginners Course

The Microsoft Excel beginner’s course will provide you with a comprehensive overview of all of the most well-known features of Excel and the methods to successfully use them.

The highlights of this course cover:

  • A broad overview of MS Excel
  • Calculating sums, averages, and totals
  • Summing columns or rows of numbers
  • Including cells
  • Learning formulas including IF, COUNTIF, SUMIF, VLOOKUP, HLOOKUP, and AVERAGEIF
  • Pivot tables
  • Inserting, editing, and deleting comments
  • Wrapping text
  • Creating borders
  • Merging cells
  • Pasting, ordering, and converting columns to rows
  • Designing graphs, diagrams and charts
  • Using hyperlinks

This beginner's level Microsoft Excel Complete course highly recommended if you want to use Excel at home or work for tracking simple expenses or calculating sums or totals, adding column headings, and so on.

MS Excel Intermediate Course

The MS Excel Intermediate Course focuses on teaching you more advanced concepts of Excel in an accessible and more comprehensive guide to the mind.

The highlights of the intermediate Excel course include the following:

  • Grasp advanced Excel functions such as ABS, SUMIF, HLOOKUP, VLOOKUP, COUNTIF, AVERAGEIF, and AVERAGEIFS
  • Data validation with date, list, time, and numbers
  • Other functions such as RANK, MIN, MAX, CHAR, MODE, MEDIAN, CODE, CLEAN, and EXACT
  • Techniques to eliminate duplicates in Excel
  • Creating random numbers
  • Changing text case
  • Adding passwords
  • Sending emails from Excel
  • Adding custom backgrounds
  • How to auto-fill data
  • Adding special data and characters
  • Changing border colour and theme

With having a firm basic knowledge of the beginner Excel functions, you can effortlessly get into the MS Excel Intermediate course.

The Microsoft Excel Complete course curriculum intended for making it much easier to work with Excel in the workplace, and it is perfect for individuals who desire to enhance their skills in Excel.

MS Excel Advanced Course

After completing the beginner and intermediate courses successfully, you will move onto the MS Excel Advanced Course where you will introduce with the curriculums that well laid out with just the most essentials in Excel.

The highlights of MS Excel Advance Course cover:

  • VLOOKUP Advanced formula options and manipulations
  • Other advanced functions such as OR, AND, CHOOSE, INDIRECT, REPLACE, LEN, LEFT, FIND
  • Functions including CEILING, CORREL, DATEDIF, DATEVALUE, DAVERAGE and EDATE
  • Highlighting a cell with a formula
  • Functions including ISODD, ISNUMBER, ISTEXT, ISLOGICAL, ISNONTEXT, ISERR and ISBLANK
  • Functions including DGET, DMAX, PRODUCT, DCOUNTA, DCOUNT and DSUM
  • Calculating loan IPMT and EMI
  • Functions including DATEDIF, DATEVALUE, EDATE, EOMONTH, MATCH and INDEX
  • A detail interpretation of the INDEX and MATCH functions
  • How to look up data
  • Colouring a column and row with a formula
  • How to select only cells carrying remarks
  • Hiding formulas

The MS Excel Advanced Course will thoroughly prepare you for job positions that require excellent command over Excel. Upon successful completion of the course, you will gain the knowledge and skills and feel more confident that will be ideal for your career success.

**** **** **** **** **** **** **** **** ****

Microsoft Excel 2019 New Features

  • Introduction to Microsoft Excel 2019 New Features
  • CONCAT
  • IFS
  • MAXIFS
  • MINIFS
  • SWITCH
  • TEXTJOIN
  • Map Chart
  • Funnel Chart
  • Better Visuals
  • Pivot Table Enhancements
  • Power Pivot Updates

Beginners Course Modules:

  • Module 1: Navigate the Excel User Interface
  • Module 2: Use Excel Commands
  • Module 3: Create and Save a Basic Workbook
  • Module 4: Enter Cell Data
  • Module 5: Use Excel Help
  • Module 6: Create Worksheet Formulas
  • Module 7: Insert Functions
  • Module 8: Reuse Formulas and Functions
  • Module 9: Insert, Delete, and Adjust Cells, Columns, and Rows
  • Module 10: Search for and Replace Data
  • Module 11: Use Proofing and Research Tools
  • Module 12: Apply Text Formats
  • Module 13: Apply Number Format
  • Module 14: Align Cell Contents
  • Module 15: Apply Styles and Themes
  • Module 16: Apply Basic Conditional Formatting
  • Module 17: Create and Use Templates
  • Module 18: Preview and Print a Workbook
  • Module 19: Set Up the Page Layout
  • Module 20: Configure Headers and Footers
  • Module 21: Manage Worksheets
  • Module 22: Manage Workbook and Worksheet Views
  • Module 23: Manage Workbook Properties

Intermediate Course Modules:

  • Module 1: Work with Ranges
  • Module 2: Use Specialized Functions
  • Module 3: Work with Logical Functions
  • Module 4: Work with Date & Time Functions
  • Module 5: Work with Text Functions
  • Module 6: Sort Data
  • Module 7: Filter Data
  • Module 8: Query Data with Database Functions
  • Module 9: Outline and Subtotal Data
  • Module 10: Create and Modify Tables
  • Module 11: Apply Intermediate Conditional Formatting
  • Module 12: Apply Advanced Conditional Formatting
  • Module 13: Create Charts
  • Module 14: Modify and Format Charts
  • Module 15: Use Advanced Chart Features
  • Module 16: Create a PivotTable
  • Module 17: Analyze PivotTable Data
  • Module 18: Present Data with PivotCharts
  • Module 19: Filter Data by Using Timelines and Slicers

Advanced Course Modules:

  • Module 1: Use Links and External References
  • Module 2: Use 3-D References
  • Module 3: Consolidate Data
  • Module 4: Use Lookup Functions
  • Module 5: Trace Cells
  • Module 6: Watch and Evaluate Formulas
  • Module 7: Collaborate on a Workbook
  • Module 8: Protect Worksheets and Workbooks
  • Module 9: Apply Data Validation
  • Module 10: Search for Invalid Data and Formulas with Errors
  • Module 11: Work with Macros
  • Module 12: Create Sparklines
  • Module 13: MapData
  • Module 14: Determine Potential Outcomes Using Data Tables
  • Module 15: Determine Potential Outcomes Using Scenarios
  • Module 16: Use the Goal Seek Feature
  • Module 17: Forecasting Data Trends

Method of Assessment:

Upon completion of the course, you will be required to sit for an online multiple-choice quiz based assessment, which will determine whether you have passed the course (60% pass mark). The test will be marked immediately and results will be published instantly.

Certification

After successfully completing the course, you will be able to obtain the certificates. You can claim a PDF certificate by paying a little processing fee of £2. There is an additional fee to obtain a hardcopy certificate which is £9.

Who is this course for?

Getting enrolled in this Microsoft Excel Complete course requires no prior experience or qualifications. It is easily accessible for learners of all academic credentials.

Success stories:

William Hargreaves

"I am always eager to learn something new, but am busy working during the day and unable to make many evening classes on certain days. So to get the opportunity to advance my knowledge of Microsoft Excel from the comfort of my own home, following a curriculum devised by a professional with years of experience using Excel, was a dream come true. I couldn’t be happier with this course and have told everyone I know to have a look at it. Thank you!"

Jude Hunter

"This bundle course gives you three lots of courses for the price of a few lessons at a traditional educational centre. Although many people have concerns over the quality of online learning, I have to say that I was blown away by what was offered in this course. Everything from basic spreadsheet skills to statistical functions is covered, meaning you can go from a complete novice to a bit of an expert in almost no time at all, fitting the learning in around your busy schedule. This won't be the last online course I purchase, but I doubt it will be bettered."

Requirements

Our Microsoft Excel Complete course instructions are simple and understandable, as well as step by step organised. You can easily access with PC’s, Mac’s, Laptop, Tablet and Smartphones on Wi-Fi, 3G or 4G.

All tests will be taken either during or, after completion of the Microsoft Excel Complete course, these are included in the price, so no extra charges added.

Career path

Gaining Excel qualifications will provide you with the opportunities to work successfully in various fields including Business & Management, Administration, Accountancy & Finance, Secretarial & PA.

Questions and answers


No questions or answers found containing ''.


Maxine asked:

I have only got access to an iPad and iphone. Can I do this course on my ipad, or will I need a laptop or computer?

Answer:

Hi Maxine, Thanks for your query. Yes, you can do the course from an iPad. Many thanks.

This was helpful. Thank you for your feedback.

Jay asked:

is the course just slides or is there a talking tutor?

Answer:

Hi Jay, Thanks for your query. This is a video course and there is a talking tutor. Many thanks.

This was helpful. Thank you for your feedback.

Ewan asked:

How many hours I will have for per module?

Answer:

Hi Ewan, Thanks for your query. The estimated course duration is 11 hours, however, you will get one year access to the course to complete. Many thanks.

This was helpful. Thank you for your feedback.

Saz asked:

Hello, once purchased do you have access to this course for life or is there a time limit? Do you get the certificate included in the price? Thanks

Answer:

Dear Saz, Good morning. You will get lifetime access to the course after purchasing. The exams and the PDF Certificate are included in the course price. Thanks

This was helpful. Thank you for your feedback.

Christopher asked:

Is there any additional fees I need to pay to attend the exam?

Answer:

Hi Christopher, Thanks for your query. The course fee is included exam. You do not need to pay any additional fee for the exam. If you failed id final exam then you can retake for an additional fee. Many thanks.

This was helpful. Thank you for your feedback.

Sam asked:

At which position I will get an advantage to apply with this course certificate?

Answer:

Hi Sam, Thanks for your query. This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Many thanks.

This was helpful. Thank you for your feedback.

Rating and reviews

There haven't been any reviews for this course yet.

Leave a review

Modals

Mobile Navigation