Our Workshops

Excel Level 2

Excel Level 2


Front Foot Microsoft workshop presenters are Microsoft Certified Trainers as well as Microsoft Certified Technology Specialists

SAQA US ID 116940 - NQF Level 3, credits 6


Advanced Excel Functions Are Now Simple

Your current knowledge of Excel will grow exponentially. The easy to follow training will enable you to utilise the full potential of one of Microsoft’s most powerful Office Suite offerings.

Go further with Excel by learning to create charts and tables as well as learning time saving formatting and validation features.

In this course, you will create charts and tables;

Learn handy formatting and tools for error checking;

Create formulas to that use built-in functions to do advanced analysis;

Create shared workbooks and track changes in shared workbooks


  • Opening a Template  
  • Creating a Template  
  • Modifying a Template           

 Creating Charts         

  • Insert a Chart 
  • Modifying Charts       
  • Printing Charts           


  • The IF Function           
  • How the IF Function works     
  • Lookup Functions       
  • How the VLOOKUP Function Works   
  • The HLOOKUP Function         
  • PMT    
  • FV       
  • Date and Time functions       
  • DSUM function           
  • Linking cells   

Named Ranges          

  • Creating a named range       
  • Removing a name from a cell           
  • Using named ranges in a calculation

 Working with Data   

  • Sorting Data   
  • Multiple Level Sorts   
  • Filtering Data with the Filter 
  • Subtotals        
  • Import and Export Data         
  • Exporting data from Excel     
  • Importing data into Excel      

 Working with Graphic Objects        

  • Adding a Shape          
  • Resizing an AutoShape           
  • Modifying an AutoShape       
  • Changing the order of object
  • Grouping objects        

Comments and Web Features         

  • Comments      
  • Using Hyperlinks        
  • Publish a worksheet to the web


On-Site Workshops

  • All workshops are offered in-house at your offices to a minimum of 5 delegates
  • You provide the venue and refreshments, Front Foot supply all the workshop material – including laptops for computer-based training sessions


Remote Workshops

  • All workshops are offered remotely to a minimum of 5 delegates
  • Front Foot supply all the electronic workshop material


Workshop Dates