Create, develop and format basic spreadsheets.
Learn how to apply to simple formulas, calculations, create lists and basic charts.
This professional development program will provide you with the skills required to successfully operate excel spreadsheets.
What will be covered?
– Functions
– Creating lists
– Formatting
– Advanced filtering
– Charts & tables
– Recording and running macros
Saturday Evenings
12th, 19th & 26th August 2017 from 6.30 pm to 9.30 pm
The course is intended for new users of Microsoft Excel 2007, 2010, 2013 or 2016 who want to become productive in the shortest possible time.
Delegates should be proficient in using a PC with the Microsoft Windows operating system, but no prior experience with Excel is required.
| Topics (Session 1) | Date | Time |
| Basic Functions (Sum, Mid, Average) | 12 Aug 2017, Saturday | 6.30 pm – 9.30 pm |
| Data Validation Options (Creating lists) | ||
| Formatting Options and other basics | ||
| Vlookup Function (Level 1) | ||
| Advanced Filtering Options | ||
| IF Funtion (Level 1) | ||
| Creating Charts | ||
| Pivot Tables | ||
| Practical Exercises | ||
| Topics (Session 2) | ||
| SUMIF Function | 19 August 2017,
Saturday |
6.30 pm – 9.30 pm |
| COUNTIF Function | ||
| Formatting Functions & Date Functions | ||
| Hyperlinks & Creating Dynamic User-Friendly Charts | ||
| Index Match | ||
| IF Function (Level 3) | ||
| Practical Exercises | ||
| Topics (Session 3) | ||
| Conditional Formatting | 26 August 2017, Saturday | 6.30 pm – 9.30 pm |
| 1 hour assessment |
Call to book your slot at Malvern International : +65 6268 4515