|
| Front Foot Strategic Consulting has been awarded accreditation status as a provider of Education and Training in terms of the National Qualifications Framework Act, 2008. |
|
|
| DETAILS |
Date and Venue:
No future dates have been scheduled for this workshop. Please contact us for more information. |
Maps:
Click Here |
Time:
9:00 AM |
Duration:
2 Days |
Cost Per Delegate:
| R3 650.00 |
ex VAT |
| R4 161.00 |
incl VAT |
|
Surcharges:
R50 (Inl VAT) per delegate, per day for Strictly Halaal and Kosher Meals |
Group Bookings:
Bookings of 2 or more delegates qualify for a 10% discount. |
Out-of-town Delegates:
If you are flying in from out-of-town in order to attend, we will give you a 15% discount on the cost of the workshop.
Contact us to find out more. |
Please Note:
This training is conducted on Microsoft version 2003, if you are using version 2007, kindly bring this to our attention. |
|
|
|
INHOUSE
DISCOUNTS |
1. Less 25%
In House at your premises.
You provide the venue and refreshments, Front Foot will supply all the workshop material.
2. Less 15%
In House at a conference venue
Contact us to find out more. |
|
|
| IN HOUSE |
This workshop is also available under Front Foot’s in-house menu.
Front Foot is proud to offer you a comprehensive array of customised in-house training solutions that are focused on your unique business needs. For more information in this regard, please contact us. |
|
|
|
| MASTER THE BASICS OF MICROSOFT EXCEL |
Save time and effort
Get the Best Out of Microsoft Excel is a unique 2-day course that is specifically designed to allow business people to master the time-saving basics built into one of the most powerful packages in the Office Suite.
Master Excel's renowned functionality
This workshop covers functionality such as setting up spreadsheets, data manipulation and printing out of formatted reports and charts.
Practical learning sessions with templates and exercises
As with most Front Foot workshops, delegate numbers are limited to ensure the highest levels of lecturer interaction. In addition, delegates will have ample opportunity to set up and complete a variety of practical exercises to practice and further anchor the techniques learned.
Please note: This course covers the basic functionality of Microsoft Excel, and as such delegates are not required to have any prior working knowledge of the programme. For delegates who have mastered the basics, and wish to advance their understanding, Front Foot offers a 2-day workshop, Get the Best Out of Excel – Advanced. |
|
| REGISTER NOW |
|
| Front Foot courses are compiled and presented by subject matter experts and industry specialists to ensure the highest and most current standard of excellence in all our workshops and training |
| WHO SHOULD ATTEND |
 |
Any decision maker who would like to
get the most out of their software |
|
Financial managers, bookkeepers,
analysts and researchers |
|
Secretaries and personal assistants |
|
| TWO DAY WORKSHOP OUTLINE |
| Introduction to Excel |
|
The Basics of Excel |
 |
The Excel Window Components |
|
Move Around |
|
Enter Data in Cells |
|
Selecting Techniques |
|
|
|
Save a Workbook |
|
Open an existing Workbook |
|
Create a New Workbook |
|
Making a Copy of a Workbook |
|
Help |
|
| Manipulating Cell Data |
|
Printing |
|
Move and Copy |
|
Fill Cells with Series of Data |
|
Insert, Delete Cells, Rows and Columns |
|
Find and Replace |
|
Spell Check |
|
|
|
Page Setup |
|
Insert and Remove Page Breaks |
|
Set a print title |
|
Set print area/ranges |
|
Printing |
|
| Formulas |
|
Working with Data |
|
Create Formulas |
|
Use Excel Functions |
|
Copy Formulas and Functions |
|
Cell References (Absolute, Mixed and Relative) |
|
|
|
Sorting Data |
|
Multiple Level Sorts |
|
Filtering data with auto filter |
|
Subtotals |
|
| Formatting |
|
Import and Export Data |
|
Cell Date |
|
Cell Ranges |
|
|
|
Exporting data from Excel |
|
Importing data into Excel |
|
| Workbook Settings and views |
|
Working with Graphic Objects |
|
Insert, Delete Worksheets |
|
Copy and Move Worksheets |
|
Format Worksheet Tabs |
|
Split a Worksheet |
|
Freeze and Unfreeze |
|
Hide and Unhide |
|
|
|
Adding an Auto Shape |
|
Resizing |
|
Modifying |
|
Order |
|
Grouping |
|
| Named ranges |
|
Creating Charts |
|
Creating a Named Range |
|
Removing a Name from a Cell |
|
Using Named Ranges in a Calculation |
|
|
|
Chart Wizard |
|
Chart Toolbar |
|
Printing Charts |
|
|
| OTHER WORKSHOPS YOU MIGHT ENJOY |
|
|
|
