Microsoft Excel Masterclass
REASONS TO CHOOSE
- Learn Top 10 Excel Shortcuts with our Excel Masterclass Training. Happy Learners: 275,441+
- Gain Knowledge of highlighting Excel data cells containing Values, Text, and Duplicate values.
- Develop your Skillset using Formulas, VLOOKUP, and Pivot Tables. Rated Outstanding!
Microsoft Excel Masterclass
Become the master of Microsoft Excel
Microsoft Excel Masterclass
Microsoft Excel Masterclass Course Outline
Module 1: Navigation of the Excel Interface
- Understanding the Excel Start Screen
- Excel Tab Interface
- Introduction to Microsoft Excel
- Excel Workbook Screen
- Ribbon
- Name Box
- Formula Bar
- Worksheet Tab
- Understanding the Backstage View
- Accessing the Backstage View
- Understanding Dialogue Boxes
- Launching Dialogue Boxes
- Understanding the Quick Access Toolbar
- Changing the Location of the Bar
- Understanding the Status Bar
- Exercise
Module 2: Use of Lists and Tables
- Understanding Lists
- Applying a Filter
- Clearing a Filter
- Performing an Alphabetical Sort
- Performing a Numerical Sort
- Creating a Table
- Inserting or Deleting Table Records
- Removing Duplicates
- Modifying a Table
- Sorting Data in a Table
- Naming Tables
- Resizing Tables
- Converting a Table to a Range
- Deleting a Table
- Exercise
Module 3: Conditional Formatting
- Understanding Conditional Formatting
- Highlighting Cells Containing Values
- Highlighting Cells Containing Text
- Highlighting Duplicate Values
- Using Top and Bottom Rules
- Using Data Bars
- Using Colour Scales
- Using Icon Sets
- Creating Custom Rules
- Conditional Formatting Rules Manager
- Clearing Rules
- Exercise
Module 4: Using Formulas and Creating Pivot Tables
- Using Sparklines
- Using Formulas in Excel
- Exploring Excel Functions
- Using Functions in Excel
- Insert Function Button
- Working with Names and Ranges
- IF Formulas
- AVERAGE Function
- COUNT Function
- Common Logical Functions
- Create a PivotTable from an Excel Data List
- Add/Remove/Reorganise Data Fields
- Refresh Data/Change Data Source
- Changing the PivotTable Design
- Creating and Modifying a Pivot Chart
- VLOOKUP
- Undo, Redo, and Repeat with Keystrokes
- Exercise
Price – From £795
Contact us for pricing information and receive upto 20% discount.
Prerequisites
In this Microsoft Excel Masterclass training, there are no formal prerequisites. But, you should have some familiarity with computers and Windows 10.
Audience
This Microsoft Excel Masterclass training provided by The Knowledge Academy is ideal for anyone who wants to learn how to use Microsoft Excel more effectively.
Microsoft Excel Masterclass Course Overview
The TrainingXperts is Globally Recognised as the Global Market Leader in Excel Training Courses. Our ‘Microsoft Excel Team’ comprises over 35 leading Microsoft Office Experts with more than 21 years of industry recognised teaching experience. Our instructors have developed a unique teaching style to help aspiring Excel learners to master the art of successfully using Excel as a spreadsheet tool. Our Award-Winning Excel Masterclass Training Course Trainers will guide you step by step on how to use the Excel spreadsheet tool successfully.
Microsoft Excel is a spreadsheet program that is part of the Microsoft Office Suite, and its online and desktop versions allow users to share and collaborate on their files with others in real-time. Microsoft Excel is a spreadsheet program, which is included in the Microsoft Office suite of applications. Enterprises use MS Excel as a spreadsheet solution because of its simplicity for analysing, sorting, reporting and storing data. Excel is used for analysis by businesses of all sizes worldwide to perform financial analysis and accounting tasks. Holding the knowledge and skills required for using Microsoft Excel will benefit individuals in increasing their value, job prospects and becoming successful in their professions.
In this 1-Day Microsoft Excel Masterclass training, delegates will learn about different vital skills required to use Excel to create and edit workbooks and spreadsheets effectively. This training course will show how to fully unlock Excel’s powerful capabilities for sorting and manipulating data. Further, delegates will acquire in-depth knowledge about the uses of Excel’s tab interface and file tab. They will gain an understanding of various steps to add the command to the quick access toolbar. Our highly skilled and expert trainer will conduct this training who have years of experience in teaching Microsoft Office Suite courses.
This training course will cover various essential concepts, such as:
- Navigation of the Excel interface
- Excel workbook screen
- Use of lists and tables
- Performing an alphabetical sort
- Conditional formatting
- Using formulas and creating pivot tables
- Working with names and ranges
After attending this training course, delegates will be able to generate equations allowing them to give additional data on critical company functions. They’ll be able to create spreadsheets that better organise data and give a clearer picture of what’s being input. They’ll also be able to interpret data at a more advanced level to provide answers and solutions to problems affecting the business.