|
| 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:
| R4 360.00 |
ex VAT |
| R4 970.40 |
incl VAT |
|
Surcharges:
R50 (incl 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. |
|
|
|
| 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. |
|
|
|
| UNDERSTAND THE STRUCTURE OF FUNCTIONS |
Take Excel to the next level
If you’re interested in seeing Excel as the user-friendly, all-purpose, internationally-acclaimed product offering that it is, our 2-day intensive offering will blow you away.
Maximise potential and streamline spreadsheets
Primarily aimed at those using Excel at the Advanced Level, the course covers advanced functions that maximise potential and minimise hassle. In addition, you will learn to streamline your spreadsheets, looking at categories such as financial, text, date, logical, lookup and database, as well as learn how to create your own functions using VBA. In order to facilitate personalised attention, and maximum lecturer interaction, seats are limited.
Cover previously uncharted territory
Aimed at further enhancing your knowledge of Excel for the purposes of advanced functionality, this intensive 2-day workshop enables you to utilise normally uncharted territory in the one of Microsoft’s most powerful Office Suite offerings.
Aimed at users at the advanced level
Please note: In order to maximise the benefit of this course, delegates are required to already have a good working knowledge of all the basic and advanced functions available on Excel. This course specifically targets specialised and advanced Excel functions. Where delegates do not meet this criterion, Front Foot offers comprehensive Excel training in our popular “Get the Best Out Of Excel” Workshop. |
|
| REGISTER NOW |
|
| All Front Foot Microsoft workshop presenters are Certified Microsoft Application Specialists. |
| WHO SHOULD ATTEND |
|
Any business person using Microsoft Excel, who is competent at the basic Excel Level and would like to get maximum benefit from these special features |
|
|
Executives who work with finance and financial projection
|
|
|
Executive Secretaries and Personal Assistants |
|
| TWO DAY WORKSHOP OUTLINE |
| BODMAS |
|
Lookup and Reference Functions |
|
The Structure of Functions |
|
|
Combining Functions |
|
|
|
|
The VLOOKUP Function |
|
How the VLOOKUP Function Works |
|
The HLOOKUP Function |
|
|
MATCH and INDEX |
|
| Text Functions |
|
Financial Functions |
|
|
CONCATENATE |
|
CLEAN |
|
LEFT and RIGHT |
|
|
MID |
|
LOWER, UPPER and PROPER |
|
EXACT |
|
REPLACE |
|
|
|
|
The PMT Function |
|
The FV Function |
|
| Date and Time Functions |
|
Maths and Trig Functions |
|
|
Using the TODAY Function |
|
Using the NOW Function |
|
|
|
|
The RAND Function |
|
The ROUND Function |
|
ROUNDUP |
|
|
The ROUNDDOWN Function |
|
The SUMIF Function |
|
| Statistical Functions |
|
Database Functions |
|
|
Using the COUNTA Function |
|
Using the COUNT Function |
|
|
|
|
DSUM |
|
DAVERAGE |
|
| Logical Functions |
|
Other Features |
|
|
The IF Function |
|
How the IF Function Works |
|
Nesting IF Functions |
|
|
Using the AND and OR Functions |
|
|
|
|
Goal Seek |
|
Formula Auditing |
|
Validation |
|
|
Subtotals |
|
| Creating Functions |
|
| OTHER WORKSHOPS YOU MIGHT ENJOY |
|
|
|
Recommend this workshop on Facebook
