Our Workshops

Description

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

SAQA US ID 116937- NQF Level 2 credits 4

ONE DAY WORKSHOP

Simple Excel
Our Excel Level 1 workshop aims to take you on an easy to follow guide to the basic Excel functions.  This is your opportunity to learn how to make the most of everything Excel has to offer – everyday.

Discover the full potential of this powerful workshop
Covering the toolkit such as the window components, data manipulation, formatting, formulas and functions, workbook manipulation and printing, this course allows you to confidently and efficiently maximise your use – and the full potential - of Microsoft Excel.

Introduction to Excel    

• The Excel Window Components               
• What is a Spreadsheet?               
• Customize Quick Access Toolbar              
• Adjust the Zoom             
• Workbook Views            
• Move Around in Excel   
• Enter Data in Cells           
• Select Data in Cells         
• Save a Workbook            
• Open an Existing Workbook       
• Create a New Workbook             
• Help      

Manipulating Cell Data

• Move and Copy Data     
• Fill Cells with Series of Data        
• Insert and Delete Cells, Columns, and Rows       
• Find, Replace Cell Data 
• Spell Check a Worksheet             

Formulas            

• Create Formulas              
• Use Excel Functions       
• Insert Function
• Copy Formulas and Functions    
• Create an Absolute Reference  
• Formatting        
• Format Fonts
• Format Borders, Fills, Heights and Widths
• Merge Cells
• Number Formats - Styles
• Find and Replacing Formats
• AutoFormat
• Cell Data             
• Cell Ranges        

Workbook Settings and Views 

• Insert and Delete Worksheets  
• Copy and Move Worksheets     
• Format Worksheet Tabs              
• Split a Worksheet           
• Freeze and Unfreeze Panes       
• Hide and Unhide Worksheets   
• Copy a Workbook           

Printing     

• Set Pring Ranges
• Printing        

Page Setup        

• Insert and Remove Page Breaks               
• Set a Print Title          

______________________________________________________________________________________________________________________________________________________________

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

_______________________________________________________________________________________________________________________________________________________________