Microsoft Excel Course

Microsoft Excel 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 Dialog Boxes 

• Launching Dialog Boxes 

• Understanding Quick Access Toolbar 

• Changing the Location of the Bar 

• Understanding the Status Bar 
   

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 
   

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 Color Scales 

• Using Icon Sets 

• Creating Custom Rules 

• Conditional Formatting Rules Manager 

• Clearing Rules 
   

Module 4: Using Formulas and Creating Pivot Tables 

• Using Sparklines 

• Using Formulas in Excel 

• Exploring Excel Functions 

• Insert Function Button 

• Working with Names and Ranges 

• AVERAGE Function 

• COUNT Function 

• Common Logical Functions 

• Using Formulas in Excel 

• IF Formulas 

• IFS Formulas 
   

Module 5: Visualising Your Data 

• Creating and Formatting Charts 

• Create a PivotTable from an Excel Data List 

• Refresh Data/Change Data Source 

• Changing the Pivot Table Design 

• Creating and Modifying a Pivot Chart 

• VLOOKUP 

• HLOOKUP 

• XLOOKUP 

• Creating and Managing Drop-down Lists 

• Undo, Redo, and Repeat with Keystrokes 
   

Module 6: Paste Special Techniques 

• Basic Use Cases for Paste Special 

• Transposing Data Using Paste Special 

• Applying Paste Special Operations to Improve Data Accuracy 

What You’ll Learn in this Course

This course takes you from understanding basic Excel functions to applying advanced tools for efficient data handling and analysis. Each stage builds the confidence needed to work professionally with spreadsheets. 
 

• Learn the fundamentals of Excel navigation and worksheet formatting 

• Learn how to use formulas and functions for data calculation 

• Learn to manage and organise data using sorting and filtering tools 

• Learn how to create charts and visual reports for better presentation 

• Learn to apply data validation and conditional formatting techniques 

• Learn how to enhance productivity using shortcuts and automation tools