Microsoft Excel

CPD Courses
CPD Courses

Course

Distance

Save 96%

Special Emagister price

£ 26 £ 760 VAT inc.

Description

  • Type

    Course

  • Level

    Advanced

  • Methodology

    Distance Learning

  • Class hours

    70h

  • Duration

    Flexible

  • Start date

    December

  • Online campus

    Yes

Microsoft Excel

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!

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!

Important information

Price for Emagister users: On successful completion of the course you can pay the Endorsed/Accreditation certificate fee in order to claim the certificate.

Facilities

Location

Start date

Distance Learning

Start date

DecemberEnrolment now open

About this course


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

Microsoft Excel

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.

OPTION-II: CPD Certificate

Upon successful completion of the course, a fee is payable for a CPD Accredited Diploma in PDF format or hard copy.

CPD Accredited Diploma (PDF format)=£50

CPD Accredited Diploma (Hardcopy)=£160

Postage Charges:

National £9

International £15

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Options
  • Excel
  • Excel for Accounting
  • Microsoft Excel
  • Spreadsheet
  • Office Assistant
  • Excel Formula
  • Excel Sheet
  • Microsoft excel training
  • MS Excel
  • Microsoft Excel 2016

Teachers and trainers (1)

Cpd Tutor

Cpd Tutor

Tutor

Course programme

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

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

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

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

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

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

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

Additional information

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.

See related categories

Microsoft Excel

Special Emagister price

£ 26 £ 760 VAT inc.