Microsoft Excel Masterclass
Throughout this course you will learn important concepts such as converting a selection to a data table, applying a filter, performing an alphabetical sort, doing a numerical sort, and so forth. Making a table, Creating a data table from a selection.
Overview
Microsoft Excel is a spreadsheet tool that is part of the Microsoft Office Suite. Its online and desktop versions allow users to exchange and work on files in real-time with others. Microsoft Excel is a spreadsheet tool that is part of the Microsoft Office suite of programmes. Because of its ease of use for analysing, sorting, reporting, and storing data, businesses rely on MS Excel as a spreadsheet solution. Excel is utilised for financial analysis and accounting duties by organisations of various sizes all around the world. Individuals who possess the information and abilities necessary for utilising Microsoft Excel will gain in terms of enhancing their worth, career chances, and success in their professions. Our teachers have established a distinctive teaching method to assist prospective Excel learners in mastering the skill of utilising Excel as a spreadsheet tool. Our Excel Masterclass Training Course Trainers will walk you through the process of successfully using the Excel spreadsheet application.
Modern and career-focused, our programme exposes you to the vital activities of different job roles within Marketing, such as brand managers, researchers, and consultants. With our foundation year programme, you can dive straight into your higher studies after your school and catalyse your progress towards becoming a certified professional.
Why should I complete the Microsoft Excel Masterclass ?
Delegates will be able to develop equations after completing this training session, allowing them to provide extra data on essential corporate functions. They'll be able to design spreadsheets that organise data better and provide a clearer view of what's being entered. They will also be able to understand data at a higher level to give answers and solutions to business-related difficulties. Delegates can also select other popular courses from our Microsoft Office Training department, such as Microsoft Access Masterclass, Microsoft Outlook Masterclass, Microsoft Word Masterclass, and others, to learn adequate abilities to use Office technologies to improve organisational efficiency.
Modules
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
Foundation Year Modules
- Preparing for Success: Knowledge and Creativity
- Preparing for Success: Self Development and Responsibility
- Inquiry Based Learning
- Introduction to Business Studies
What's included ?
Our Microsoft Excel Masterclass includes: The Knowledge Academy Microsoft Excel Masterclass Manual- Experienced Microsoft Excel Trainer- Certificate of Completion- Refreshments-
How to Apply
Each of our courses has different entry requirements and a different admission process. We encourage you to look at our course pages and the How to apply section for detailed information.
This course is currently only available online in instructor-led format. Classes will take place via GoTo Webinar and Microsoft Teams. For more information please contact us.
FEE
For information regarding fees please scroll down to the pricing section.
Please consider that we are currently not offering in-class lessons due to Covid restrictions.
TIMETABLE
For information regarding the timetable for this course, please scroll down to review the full dates and availability
DURATION
1-5 days
WHATS INCLUDED
Course Material
Case Study
Experienced Lecturer
Refreshments
Certificate
Package Deals
For package deals please enquire now and speak to a member of our team.
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
DELIVERY METHOD
- More events & information
- More events & information
Enter your requirements below :
Submit your onsite requirements and a member of our team will be in contact with you to discuss them further.
There are no official requirements for this Microsoft Excel Masterclass
training. However, you should be conversant with computers and Windows
10. The Microsoft Excel Masterclass programme is great for anybody who
wants to learn how to use Microsoft Excel more successfully.
Course Material
Case Study
Experienced Lecturer
Refreshments
Certificate