Skip to content

Microsoft Excel

CPD Certified|70 CPD Points|Beginner,Intermediate & Advanced|FREE PDF Certificate|MS OFFICE& Report Writing Free Courses


CPD Courses

Summary

Price
Save 98%
£10 inc VAT (was £760)
Offer ends 18 June 2021
Study method
Online, self-paced
Duration
450 hours
Qualification
No formal qualification
CPD
70 CPD hours / points
Achievement
Additional info
  • Exam(s) / assessment(s) is included in price
  • Tutor is available to students

1,483 students purchased this course

Add to basket or enquire

Overview

Microsoft Excel

** 4 Courses Bundle**

**FREE MS Office Course****FREE Report Writing Course**FREE Bookkeeping course

Microsoft Excel Course for Beginners, Intermediates & Advanced Users

The course comes with easy to understand e-learning study materials.

Exclusive CPD-Accredited Excel Course for Online Learning

This new and exclusive course replaces our Beginner, Intermediate and Advanced Microsoft Excel Courses with a single unified program, now available exclusively via Reed at an unbeatable price of just £10!

Learning Objectives

This exclusive Microsoft Excel Course has been designed for newcomers to Excel and those with limited experience with the software. Having become an essential component in the everyday operations of millions of businesses worldwide, advanced Excel skills are guaranteed to assist your career development. Even if you do not work directly with Microsoft Excel today, it’s likely your future duties and responsibilities will involve the use of Excel.

Divided over a series of seven fascinating units, this course provides an introduction to the basics of Excel, before progressing to more advanced features and functionalities. Upon completion, learners benefit from the skills, knowledge and confidence needed to leverage the power, versatility and flexibility of the world’s number-one spreadsheet software package. Expert tutor support is available at all times and there are no deadlines to worry about.

What Will I Learn From This Microsoft Excel:

Key skills, knowledge areas and insights covered in this exclusive Microsoft excel course include the following:

  • The primary features and functions of Excel
  • Various key tasks excel can simplify
  • How to calculate sums, totals and averages
  • Inserting and editing data
  • Creating borders and other visual features
  • Automating calculations in Excel
  • Customisation and personalisation
  • Working effectively with larger workbooks
  • Using a variety of formulas
  • Proofing Excel documents for accuracy

Why Students prefer this Microsoft Excel from CPD:

  • Fully Endorsed Microsoft Excel Course
  • Microsoft Excel Specialist Tutors
  • The course does not expire till you successfully complete it
  • The option to take study breaks at any time at no extra cost
  • No deadlines, no time restrictions and no fixed schedules
  • Online assessments to test your new skills and knowledge
  • The opportunity to enhance and improve your CV and career prospects.
  • The opportunity to study from any location in the world.

*** 3 Free Gifts included ***

***FREE MS Office Course***

This Free MS Office course covers the following topics:

  • Identify the components of the Microsoft Word interface
  • Create a basic worksheet
  • Navigate the PowerPoint environment

***FREE Report Writing Course***

This Free Report Writing course covers the following topics:

  • The First Stage–Investigating
  • The Second Stage–Planning
  • The Third Stage–Writing
  • The Fourth Stage–Revising

***FREE Bookkeeping Course***

This Free Bookkeeping course covers the following topics:

  • Workshop Objectives
  • Basic Terminology (I)
  • Balance Sheet
  • Revenue
  • Cost of Goods Sold
  • Basic Terminology (II)
  • Accounts Receivable
  • Accounts Payable
  • Trial Balance

***This offer ends soon***

Take your Microsoft Excel skills and knowledge to the next level, with this exclusive online training program from CPD Courses. Learn how to take full advantage of the most important features and functionalities of Microsoft Excel - the world’s most popular and widely used computer spreadsheet program. Enjoy the freedom to study in your own time at a pace that suits your lifestyle, with no deadlines or time restrictions imposed.

By definition, Microsoft Excel is a computer spreadsheet program designed to simplify the storage and analysis of data in large quantities. From an organisational perspective, Excel is a critical business tool most firms would not be able to operate without.

Bursting with intuitive features and functionalities, Excel makes it quick and easy to organise and work with complex data. From simple mathematical calculations to advanced statistical analysis, Excel has become the spreadsheet software of choice for the 21st century organisation.

Increasingly, basic Microsoft Excel skills are becoming classified as a core competency expected of candidates pursuing employment. Particularly if your goal is to climb the career ladder in a business setting, an in-depth understanding of Excel’s features and functionalities is now mandatory.

Whether new to Excel or looking to take your existing competencies a step further, this exclusive online program from CPD Courses has you and your career covered!

Quality Licence Scheme

This Microsoft Excel course is endorsed by the Quality Licence Scheme. The Quality Licence Scheme, endorses high-quality, non-regulated provision and training programmes.

Achievement

CPD

70 CPD hours / points
Accredited by The CPD Standards Office

Course media

Description

Microsoft Excel

Course Outline

This exclusive Microsoft Excel course is divided into seven detailed units, each covering a different aspect of the software and its core features. Your assigned tutor will provide the on-demand support you need to successfully complete your studies, as you explore the following topics in detail:

Microsoft Excel - Lesson 1: Getting Started with Microsoft Excel 2016

TOPIC A: Identify the Elements of the Excel Interface

  • Microsoft Excel - Microsoft Excel 2016
  • Microsoft Excel - What are Spreadsheets, Worksheets, and Workbooks?
  • Microsoft Excel - What are Columns, Rows, Cells, and Ranges?
  • Microsoft Excel - The Excel Interface
  • Microsoft Excel - Navigation Options
  • Microsoft Excel - Creating a New Blank Workbook
  • Microsoft Excel - Creating a New Workbook from a Template

TOPIC B: Create a Basic Worksheet

  • Microsoft Excel - The Ribbon
  • Microsoft Excel - The Backstage View
  • Microsoft Excel - Data Types
  • Microsoft Excel - Excel 2016 File Formats
  • Microsoft Excel - The Save and Save As Commands
  • Microsoft Excel - Saving to Microsoft OneDrive
  • Microsoft Excel - Compatibility Mode
  • Microsoft Excel - The Convert Option
  • Microsoft Excel - The Compatibility Checker
  • Microsoft Excel - Checking for Accessibility Issues

TOPIC C: Use the Help System

  • Microsoft Excel - Using Tell Me
  • Microsoft Excel - Accessing Advanced Help Options

Microsoft Excel - Lesson 2: Performing Calculations

TOPIC A: Create Formulas in a Worksheet

  • Microsoft Excel - Excel Formulas
  • Microsoft Excel - The Formula Bar
  • Microsoft Excel - Elements of an Excel Formula
  • Microsoft Excel - Common Mathematical Operators
  • Microsoft Excel - The Order of Operations

TOPIC B: Insert Functions in a Worksheet

  • Microsoft Excel - Functions
  • Microsoft Excel - The Function Library
  • Microsoft Excel - Common Functions in Excel
  • Microsoft Excel - The Formula AutoComplete Feature

TOPIC C: Reuse Formulas

  • Microsoft Excel - The Cut, Copy, and Paste Commands
  • Microsoft Excel - Paste Special Options
  • Microsoft Excel - Relative References
  • Microsoft Excel - Absolute References
  • Microsoft Excel - Mixed References

Microsoft Excel - Lesson 3: Modifying a Worksheet

TOPIC A: Manipulate Data

  • Microsoft Excel - The Undo and Redo Commands
  • Microsoft Excel - The AutoFill Feature
  • Microsoft Excel - AutoFill Options
  • Microsoft Excel - The Transpose Option
  • Microsoft Excel - Live Preview
  • Microsoft Excel - The Clear Button
  • Microsoft Excel - Quick Analysis Features

TOPIC B: Insert, Manipulate, and Delete Cells, Columns, and Rows

  • Microsoft Excel - The Insert and Delete Options
  • Microsoft Excel - Column Width and Row Height Alternation Methods
  • Microsoft Excel - The Hide and Unhide Options

TOPIC C: Search For and Replace Data

  • Microsoft Excel - Cell Names and Range Names
  • Microsoft Excel - The Find Command
  • Microsoft Excel - The Replace Command
  • Microsoft Excel - The Go To Command

TOPIC D: Spell Check a Worksheet

  • Microsoft Excel - The Spelling Dialog Box

Microsoft Excel - Lesson 4: Formatting a Worksheet

TOPIC A: Modify Fonts

  • Microsoft Excel - Fonts
  • Microsoft Excel - The Font Group
  • Microsoft Excel - The Format Cells Dialog Box
  • Microsoft Excel - The Format Painter
  • Microsoft Excel - Galleries
  • Microsoft Excel - Live Preview and Formatting
  • Microsoft Excel - The Mini Toolbar

TOPIC B: Add Borders and Colors to Cells

  • Microsoft Excel - Border Options
  • Microsoft Excel - Fill Options
  • Microsoft Excel - Sheet Backgrounds
  • Microsoft Excel - Paste Options

TOPIC C: Apply Number Formats

  • Microsoft Excel - Number Formats
  • Microsoft Excel - Number Formats in Excel
  • Microsoft Excel - Custom Number Formats

TOPIC D: Align Cell Contents

  • Microsoft Excel - Alignment Options
  • Microsoft Excel - The Indent Commands
  • Microsoft Excel - The Wrap Text Command
  • Microsoft Excel - Orientation Options
  • Microsoft Excel - The Merge & Center Options

TOPIC E: Apply Cell Styles

  • Microsoft Excel - Cell Styles
  • Microsoft Excel - The Style Dialog Box

Microsoft Excel - Lesson 5: Printing Workbook Contents

TOPIC A: Define the Basic Page Layout for a Workbook

  • Microsoft Excel - The Print Options in Backstage View
  • Microsoft Excel - The Page Setup Dialog Box
  • Microsoft Excel - The Print Preview Option
  • Microsoft Excel - Workbook Views
  • Microsoft Excel - Headers and Footers
  • Microsoft Excel - Header and Footer Settings
  • Microsoft Excel - Page Margins
  • Microsoft Excel - Margins Tab Options
  • Microsoft Excel - Page Orientation

TOPIC B: Refine the Page Layout and Apply Print Options

  • Microsoft Excel - Zoom Options
  • Microsoft Excel - Page Breaks
  • Microsoft Excel - Page Break Options
  • Microsoft Excel - The Print Area
  • Microsoft Excel - Print Titles
  • Microsoft Excel - Scaling Options

Microsoft Excel - Lesson 6: Managing Large Workbooks

TOPIC A: Format Worksheet Tabs

  • Microsoft Excel - Renaming Worksheet Tabs
  • Microsoft Excel - Changing Tab Color

TOPIC B: Manage Worksheets

  • Microsoft Excel - Grouped Worksheets
  • Microsoft Excel - Repositioning Worksheets
  • Microsoft Excel - Inserting or Deleting Worksheets
  • Microsoft Excel - Hiding and Unhiding Worksheets
  • Microsoft Excel - Worksheet References in Formulas

TOPIC C: Manage the View of Worksheets and Workbooks

  • Microsoft Excel - The Split Command
  • Microsoft Excel - The Freeze Panes Options
  • Microsoft Excel - The Arrange All Command
  • Microsoft Excel - The Arrange Windows Dialog Box
  • Microsoft Excel - The View Side by Side Command
  • Microsoft Excel - The Switch Windows Command
  • Microsoft Excel - The New Window Command

Microsoft Excel - Lesson 7: Customizing the Excel Environment

TOPIC A: Customize General and Language Options

  • Microsoft Excel - The Excel Options Dialog Box
  • Microsoft Excel - The General Category
  • Microsoft Excel - The Language Category

TOPIC B: Customize Formula Options

  • Microsoft Excel - The Formulas Category

TOPIC C: Customize Proofing and Save Options

  • Microsoft Excel - The Proofing Category
  • Microsoft Excel - The Save Category
  • Microsoft Excel - Version Control

TOPIC D: Customize the Ribbon and Quick Access Toolbar

  • Microsoft Excel - The Customize Ribbon Category
  • Microsoft Excel - The Quick Access Toolbar Category

TOPIC E: Customize the Functionality of Excel by Enabling Add-Ins

  • Microsoft Excel - What Are Add-ins?
  • Microsoft Excel - The Add-Ins Category
  • Microsoft Excel - The Developer Tab

TOPIC F: Customize Advanced and Trust Center Options

  • Microsoft Excel - The Advanced Category
  • Microsoft Excel - The Trust Center Category

Microsoft Excel - Course Assessment

When you have worked your way through the course materials and are confident in your understanding of the subject, you may proceed to the course assessment.

Microsoft Excel course assessment is taken online in the form of a multiple choice exam, which will be marked automatically upon completion. If you are unsuccessful, you will be able to retake the test again at no extra cost. Each time you retake the test, you will be presented with the set of questions to assess your knowledge and understanding of the course materials.

Upon passing the final course assessment, you will have the opportunity to claim a certificate of completion as proof of your accomplishment.

Who is this course for?

Microsoft Excel

Microsoft Excel is the most popular and widely used computer spreadsheet program in the world by a significant margin. In almost every organisational setting, a thorough understanding of the features, functions and applications of Microsoft Excel is considered advantageous. From the smallest retailers to the largest international enterprises, Microsoft Excel forms part of a suite of software solutions that powers global business.

As a result, this course is ideal for anyone looking to enhance their CPD profile and their long-term outlook with an invaluable set of skills and competencies. Whether new to Microsoft Excel or looking to brush up your existing skills, you’ll find our flexible programmes suitable for even the busiest lifestyles.

Sign up and start your Microsoft Excel course today, or contact a member of the team at CPD Courses anytime for more information.

Requirements

Microsoft Excel

Option 1

Microsoft Excel Diploma QLS Level 5 endorsed by Quality Licence Scheme

Certificate Fee: £120 + postal charges

Option 2

MS Excel Diploma issued by CPD

PDF Certificate - FREE

Hard copy - £25 + postal charges

Option 3

CPD Accredited Certificate

(PDF format)=£30

(Hard copy)=£95 + postal charges

*Postage Charges: National £9, International £15

Career path

Microsoft Excel

An advanced knowledge and understanding of Microsoft Excel could prove invaluable for your long-term progression in any organisational setting. From accountancy to marketing to retail to data analysis, advanced Excel skills are valued across most industries and sectors.

Questions and answers


No questions or answers found containing ''.


Edward asked:

Will I get a Certificate after I complete this Microsoft Excel Course?

Answer:

Dear Edward Yes,after successful completion of Microsoft Excel course you can claim CPD Accredited certificate by paying £160 accreditation fee + postage charges, which is issued by CPD Standards Office. Their certificates are widely accepted within the UK and abroad. CPD(soft copy of course completion) can be claimed for £15. If you need hard copy of this certificate you will pay £25 + postal charges.

This was helpful. Thank you for your feedback.

Reviews

4.1
Course rating
85%
Service
79%
Content
84%
Value
Leave a review

{{ getTruncatedSinglePointScore(item.OverallCourseRating) }} Star Review by {{ item.ReviewerName }} for {{ item.Title }}


{{ getLongDate(item.CreatedOn) }}
{{ item.Title }}
Reviewed by {{ item.ReviewerName }}
|Purchased {{ getHumanisedPassageOftime(item.PurchasedOn) }}
{{ item.ProviderName }} responded to this review
{{ getLongDate(item.ProviderResponseDate) }}
{{ results.length }} out of {{ totalResultsCount }} reviews

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.