Microsoft Excel Masterclass

This Microsoft Excel Masterclass is specially tailored for those who wish to use Excel in their work regularly and want to enhance their Excel skills. This one-day masterclass will help delegates to learn how to highlight cells containing text and how to create and edit worksheets. 

Along with this, delegates will gain knowledge of how to use formulas and functions as well as sort and filter detail data visually. Delegates will get an understanding of how to present summary information in a consumable and professional format.

They will also learn how to effectively use various excel formulas, tables and charts to manage the business process from small to large.

Course Outline:

• The Excel Tab Interface
• The Tabs
• The Main Components of the Workbook Screen
• The Ribbon
• Name Box
• The Formula Bar
• Worksheet Tab
• Shortcuts
• Showing and Collapsing the Ribbon
• Understanding the Backstage View
• Understanding Dialogue Boxes
• Launching Dialogue Boxes
• Understanding the Quick Access Toolbar
• Changing the Location of the Bar
• Modify Quick Access Commands
• Add a Command
• Remove a Command
• Understanding the Status Bar
• Understanding Filters
• Applying a Filter
• Performing an Alphabetical Sort
• Performing a Numerical Sort
• Creating a Table
• Inserting or Deleting Table Records
• Adding Table Column
• Deleting Table Column
• Deleting Table Record
• Removing Duplicates
• Modifying a Table
• Sorting Data in a Table
• Naming Tables
• Resizing Tables
• Deleting a Table
• Understanding Conditional Formatting
• Highlighting Cells Containing Values and Text
• Highlighting Duplicate Values
• Using Top/Bottom Rules
• Applying Top/Bottom Rules
• Top Bottom Rule Types
• Using Data Bars
• Using Colour Scales
• Using Icon Sets
• Creating Custom Rules
• To Create a Custom Rule
• The Conditional Formatting Rules Manager
• Rules Manager
• Clearing Rules
• Using Sparklines
• Using Formulas in Excel
• Exploring Excel Functions
• Using Functions in Excel
• Insert Function Button
• Working with Names and Ranges
• Creating a Named Reference
• Removing a Named Reference
• IF Formulas
• Common Logical Functions
• Arguments used within IF Functions
• Create a PivotTable from an Excel Data List
• Add/Remove/Reorganise Data Fields
• Changing the Pivot Table Design
• Refresh Data/Change Data Source
• Create and Modify a Pivot Chart
• VLOOKUP