Microsoft Excel Masterclass

by Best Practice Training Limited Claim Listing

Microsoft Excel is a spreadsheet application used worldwide for creating, updating and reviewing spreadsheets from anywhere. The Microsoft Excel Masterclass training course is designed to provide essential knowledge and skills required to create, edit, format and share spreadsheets and workbooks

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Best Practice Training Limited Logo

img Duration

Enquire Now

Course Details

Course Introduction

Microsoft Excel is a spreadsheet application used worldwide for creating, updating and reviewing spreadsheets from anywhere. The Microsoft Excel Masterclass training course is designed to provide essential knowledge and skills required to create, edit, format and share spreadsheets and workbooks by effectively using Excel.

The course familiarises the delegates with advanced formulas and different tools used for analysing data in spreadsheets, such as sorting, conditional formatting, filtering, and checking.

 

Overview

Microsoft Excel has become a crucial part of every business, and it is widely used for interpreting and analysing the data and performing formula-based calculations quickly and efficiently.

Microsoft Excel helps the delegates to save their time and make the work more manageable by displaying, manipulating and sharing data.

Learn the basics of Excel including entering data, creating 3-D workbooks, sorting and analysing data and designing custom charts and graphs. The course introduces delegates to the latest features, functions, and tools of MS Excel.

 

Course Content

Introducing 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

The Backstage View (The File Menu)

  • Backstage View - An Overview

  • Opening Workbooks

  • 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

Working with Data

  • 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

Sorting Data

  • How to Perform Alphabetical and Numerical Sort?

  • How to Sort Numbered List?

  • Perform Sorting By Rows

  • An Overview Of Filters, Compound Filters, Multiple Value Filters

  • How To Create Custom Filters?

Manipulating 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

Pivot Tables & Charts

  • 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

Automating Tasks with 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

 

Prerequisites

There are no formal prerequisites for attending the Microsoft Excel Masterclass training course. However, the candidates should be familiar with Windows 10 and Microsoft Office.

 

Target Audience

The Microsoft Excel Masterclass training course is designed for anyone who wants to learn how to create, format, edit, analyse and share Microsoft Excel workbook and spreadsheet. 

 

Delegates Will Learn How To

  • Use Microsoft Excel for creating basic worksheets

  • Modify an Excel worksheet as per specific requirements

  • Work with Backstage views and Quick Access Toolbar

  • Customise a Workbook using tab colours and themes

  • Create pivot tables, pivot charts, and slicers

  • Trace precedents and dependents to identify which cells impact specific cells

  • Restrict type of data entered into a cell using data validation

  • Add and edit macros to the Quick Access Toolbar

  • Collaborate with others by protecting worksheets and workbooks

  • Import and export data to a text file

  • Work with Array and advanced lookup and reference functions

  • Southampton Branch

    Wessex House, Upper Market Street, Southampton

Check out more MS Excel courses in UK

Smartthink Training Ltd Logo

Microsoft Visio 2013 Essentials

Microsoft Visio 2013 Essentials is offered by Smartthink Training Ltd

by Smartthink Training Ltd [Claim Listing ]
PCWorkshops Logo

MS PowerPoint Intermediate/Advanced

MS PowerPoint is really easy, but in this PowerPoint Training Courses, we cover most aspects in a fast-paced day, and attend the to more tricky aspects. This course is one-to-one to attend to specific aspects per delegate. Group training could be organised on request.

by PCWorkshops
AJ Training Logo

Microsoft Office Training Course

Microsoft Office Editions, the easiest way to help more people use information to make a positive impact on business. The Office Editions offer great technologies and features while improving upon existing and familiar tools to facilitate effective and efficient collaboration and information sharin...

by AJ Training [Claim Listing ]
Best Practice Training Limited Logo

Microsoft PowerPoint Masterclass

The Microsoft PowerPoint Masterclass course helps the delegates to learn about tools and techniques to present data effectively to the audience. Microsoft PowerPoint can be used to present the data in text, graphical or animated forms by applying the available effects.

by Best Practice Training Limited [Claim Listing ]
SureSkills Logo

Microsoft PowerPoint Training

This PowerPoint Advanced course is intended to help all users get up to speed on many of the different features found in PowerPoint and to become familiar with its more advanced selection of features.

by SureSkills [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy