Categories

Our Workshops

Excel Level 2

Microsoft Office Suite

Excel Level 2

Description

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

ONE DAY WORKSHOP

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

Templates

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

 Creating Charts         

  • Insert a Chart 
  • Modifying Charts       
  • Printing Charts           

Functions       

  • 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