Course Introduction

MS Excel is a widely used spreadsheet application that allows the users to organise and manipulate data effectively. The Microsoft Excel Masterclass course provides essential knowledge and skills necessary to create, format and print workbooks and worksheets in a fraction of the time.The one day course enables the delegates to create a basic worksheet, use formulas and functions, audit and analyse worksheet data, create and manage macros, set up printing options and manage worksheets and workbooks. The Masterclass course teaches delegates how to combine the tools, features and functions of Excel together and manipulate huge amounts of data, automate tasks and present complex information.

In today’s highly competitive world, everyone needs to have knowledge of how to use Excel as it is considered as one of the foremost skill. The Microsoft Excel Masterclass course is designed to help delegates to create and manage spreadsheets and share information to make more informed decisions using this powerful tool. The course helps the delegates to enhance their use of Excel for work-related and personal tasks. Boost your productivity and skills for work by learning the ins and outs of Excel.  

More

What's Included

Find out what's included in the training programme.

Course Content

Create a Workbook in Microsoft Excel

  • Start a Microsoft Excel
  • Create a Workbook
  • Save a Workbook
  • Describe the Status Bar
  • Add and Delete Worksheets
  • Copy and Move Worksheets
  • Transform the Order of Worksheets
  • Split the Worksheet Window
  • Close a Workbook

Work with the Backstage View (The File Menu)

  • Overview of the Backstage View
  • Open a Workbook
  • Select, Open and Save a Template
  • Explore new Workbooks and Excel Templates
  • Print Worksheets
  • Add your Name to Microsoft Excel
  • Personalize your Copy
  • Manage Workbook Versions

Enter Data in Microsoft Excel Worksheets

  • Enter Text
  • Expand Data across Columns
  • Add and Delete Cells in Worksheets
  • Enter Numbers and Dates
  • Add a Hyperlink
  • Add an Outline
  • Add WordArt to a Worksheet
  • Use AutoComplete
  • Use the Fill Handle

Work with Rows and Columns

  • Insert lesson titles in a bulleted list
  • Add Rows and Columns
  • Delete Rows and Columns
  • Change Row Height and Column Width
  • Transpose Rows and Columns
  • Hide and Unhide Rows and Columns
  • Freeze Panes

Format Microsoft Excel Worksheets

  • Hide Worksheets
  • Add Color to Worksheet Tabs
  • Add a Watermark
  • Add Themes to Workbooks
  • Add Borders to Cells
  • The Font Group
  • Change Font and Font Size
  • The Alignment Group
  • Wrap and Indent Text
  • Merge and Center Text
  • The Number Group
  • Change Date Formats
  • Change Number Formats

Create Pivot Tables

  • Create Pivot Tables
  • Amend the Fields in a PivotTable
  • Work with Pivot Tables
  • Format Pivot Tables
  • Add Calculations to a PivotTable
  • Create Pivot Charts
  • Add Grouping to a PivotTable
  • Insert Slicers
  • PivotTable Timelines
  • More Pivot Table Functionality
  • Create PivotTables from Tables and Related Tables

Create Macros

  • Create a Macro
  • Compare Relative and Absolute Macros
  • Assign Shortcuts to Macros
  • Macro Security
  • Enable Macros in the Backstage View
  • Copy a Macro between Workbooks
  • Describe Document Properties and the Document Inspector

Advanced Lookup and Reference Functions

  • GETPIVOTDATA
  • MATCH
  • INDIRECT
  • ROW / COLUMN
  • INDEX
  • VLOOKUP
  • OFFSET
  • LOOKUP (Array format)
  • LOOKUP (Vector format)

Array Functions

  • Define an Array Formula
  • Understand Array Functions
  • FREQUENCY
  • Define Single Cell or Multiple Cell Arrays
  • Single Cell Array Functions
  • Multiple Cell Array Functions TRANSPOSE
More

Delivery Methods

Course Schedule

Select Your Location

Northampton from £3294
Virtual from £984
Leeds from £3294
Chorley from £3294
London from £3294
Manchester from £3294
Crewe from £3294
Preston from £3294
Liverpool from £3294
Newcastle from £3294

FAQs

What will you learn during Microsoft Excel Masterclass Training course?

  • Learn how Excel works, how to navigate and design a spreadsheet
  • Create pivot tables and charts
  • Convert text and validate and consolidate data
  • Create, use, edit, and manage macros
  • Collaborate with others by protecting worksheets and workbooks

What are the prerequisites for attending the Microsoft Excel Masterclass course?

The Microsoft Excel Masterclass course has no official prerequisites. Hence, anyone can attend the course. However, the experience of using the Windows Operating System and computers would be beneficial.

Who should attend the MS Excel training course?

The Microsoft Excel Masterclass course is intended for individuals who want to gain knowledge to create, edit and print Microsoft Excel worksheets.

What time shall I arrive at the venue?

Please arrive the venue at 8:45 am as our training sessions are from 9:00 am to 5:00 pm.

How can I get more information about Microsoft Excel Masterclass?

Please send us an e-mail on info@datrixtraining.com or contact us on 0800 781 0626 for more information.