- Reed courses certificate of completion - Free
Microsoft Excel - Beginner, Intermediate & Advanced- CPD Professional Course
CPD Courses
CPD Certified|70 CPD Points|Beginner,Intermediate & Advanced|FREE PDF Certificate+Courses [70,000+ Enrolled Students]
Summary
Overview
Achievement
Certificates
CPD
Curriculum
Description
Microsoft Excel
Microsoft Excel - 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 Microsoft Excel.
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 2016
- What are Spreadsheets, Worksheets, and Workbooks?
- What are Columns, Rows, Cells, and Ranges?
- The Excel Interface
- Navigation Options
- Creating a New Blank Workbook
- Creating a New Workbook from a Template
TOPIC B: Create a Basic Worksheet
- The Ribbon
- The Backstage View
- Data Types
- Excel 2016 File Formats
- The Save and Save As Commands
- Saving to Microsoft OneDrive
- Compatibility Mode
- The Convert Option
- The Compatibility Checker
- Checking for Accessibility Issues
TOPIC C: Use the Help System
- Using Tell Me
- Accessing Advanced Help Options
Microsoft Excel - Lesson 2: Performing Calculations
TOPIC A: Create Formulas in a Worksheet
- Excel Formulas
- The Formula Bar
- Elements of an Excel Formula
- Common Mathematical Operators
- The Order of Operations
TOPIC B: Insert Functions in a Worksheet
- Functions
- The Function Library
- Common Functions in Excel
- The Formula AutoComplete Feature
TOPIC C: Reuse Formulas
- The Cut, Copy, and Paste Commands
- Paste Special Options
- Relative References
- Absolute References
- Mixed References
Microsoft Excel - Lesson 3: Modifying a Worksheet
TOPIC A: Manipulate Data
- The Undo and Redo Commands
- The AutoFill Feature
- AutoFill Options
- The Transpose Option
- Live Preview
- The Clear Button
- Quick Analysis Features
TOPIC B: Insert, Manipulate, and Delete Cells, Columns, and Rows
- The Insert and Delete Options
- Column Width and Row Height Alternation Methods
- The Hide and Unhide Options
TOPIC C: Search For and Replace Data
- Cell Names and Range Names
- The Find Command
- The Replace Command
- The Go To Command
TOPIC D: Spell Check a Worksheet
- The Spelling Dialog Box
Microsoft Excel - Lesson 4: Formatting a Worksheet
TOPIC A: Modify Fonts
- Fonts
- The Font Group
- The Format Cells Dialog Box
- The Format Painter
- Galleries
- Live Preview and Formatting
- The Mini Toolbar
TOPIC B: Add Borders and Colors to Cells
- Border Options
- Fill Options
- Sheet Backgrounds
- Paste Options
TOPIC C: Apply Number Formats
- Number Formats
- Number Formats in Excel
- Custom Number Formats
TOPIC D: Align Cell Contents
- Alignment Options
- The Indent Commands
- The Wrap Text Command
- Orientation Options
- The Merge & Center Options
TOPIC E: Apply Cell Styles
- Cell Styles
- The Style Dialog Box
Microsoft Excel - Lesson 5: Printing Workbook Contents
TOPIC A: Define the Basic Page Layout for a Workbook
- The Print Options in Backstage View
- The Page Setup Dialog Box
- The Print Preview Option
- Workbook Views
- Headers and Footers
- Header and Footer Settings
- Page Margins
- Margins Tab Options
- Page Orientation
TOPIC B: Refine the Page Layout and Apply Print Options
- Zoom Options
- Page Breaks
- Page Break Options
- The Print Area
- Print Titles
- Scaling Options
Microsoft Excel - Lesson 6: Managing Large Workbooks
TOPIC A: Format Worksheet Tabs
- Renaming Worksheet Tabs
- Changing Tab Color
TOPIC B: Manage Worksheets
- Grouped Worksheets
- Repositioning Worksheets
- Inserting or Deleting Worksheets
- Hiding and Unhiding Worksheets
- Worksheet References in Formulas
TOPIC C: Manage the View of Worksheets and Workbooks
- The Split Command
- The Freeze Panes Options
- The Arrange All Command
- The Arrange Windows Dialog Box
- The View Side by Side Command
- The Switch Windows Command
- The New Window Command
Microsoft Excel - Lesson 7: Customizing the Excel Environment
TOPIC A: Customize General and Language Options
- The Excel Options Dialog Box
- The General Category
- The Language Category
TOPIC B: Customize Formula Options
- The Formulas Category
TOPIC C: Customize Proofing and Save Options
- The Proofing Category
- The Save Category
- Version Control
TOPIC D: Customize the Ribbon and Quick Access Toolbar
- The Customize Ribbon Category
- The Quick Access Toolbar Category
TOPIC E: Customize the Functionality of Excel by Enabling Add-Ins
- What Are Add-ins?
- The Add-Ins Category
- The Developer Tab
TOPIC F: Customize Advanced and Trust Center Options
- The Advanced Category
- The Trust Center Category
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.
Microsoft Excel
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.
Microsoft Excel
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
Reviews
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
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.