Excel level one - Office 2010 and 2013
Our Excel level one workshop takes you on an easy-to-follow overview of the basic Excel functions, via an intensive one-day course. This is your opportunity to learn how to make the most of everything Excel has to offer, everyday.
What will be covered on this one-day workshop?
Introduction to Excel
The Excel Window components
What is a spreadsheet?
Customise Quick Access toolbar
Adjust the zoom
Workbook Views
Navigation
Enter data
Selecting data
Save a workbook
Open an existing workbook
Create a new workbook
Help
Formatting
Format fonts
Format borders, fills, heights and widths
Merge cells
Number formats
Styles - find and replacing formats
AutoFormat
Styles
Cell ranges
Data manipulation
Move and copy
Filling cells
Editing cells
Insert and delete columns, rows and cells
Find, replace, go to
Spell check a worksheet
shadow
Workbook manipulation
Insert and delete worksheets
Format worksheet tabs
Insert, delete copy and move sheets
Copy workbooks
Split, freeze and unfreeze panes
Arrange worksheets
Hide and unhide worksheets
Formulas and functions
Create formulas
Use Excel functions
Insert function
Copy formulas and functions
Create an absolute reference
Printing
Page setup
Insert and remove page breaks
Set a print title
Set print ranges
Printing
Time: 08:30 - 16:30
Venue: Birchwood Hotel & OR Tambo Conference Centre, Boksburg
Cost: R2,350 excl. VAT
Date: 09 February 2016
Time: 08:30 - 16:30
Venue: Benvenuto Conference Centre, Johannesburg
Cost: R2,350 excl. VAT
Date: 01 March 2016
Time: 08:30 - 16:30
Venue: Birchwood Hotel & OR Tambo Conference Centre, Boksburg
Cost: R2,350 excl. VAT
Date: 08 March 2016
Time: 08:30 - 16:30
Venue: Benvenuto Conference Centre, Randburg
Cost: R2,350 excl. VAT