Our Offerings
Duration: 4 hours
Price: $229
This is a combination of two separate lesson video series; Unlock Excel Key Topics and Excel Programming Essentials. It is also our most purchased offering by far!
It comprises a 30-minutes Q&A and three separate 1-hour one-on-one coaching sessions with our Excel experts across three months.
Duration: 2.5 hrs
Price: $149
This helps build a foundation for learners to be more productive at work. Basic, intermediate, and advanced topics are collated into what we feel are core topics for efficiency. And because there is never a perfect fit between the learners' work requirements and what any course provides, we provide a 1-1 Coaching to help the learners bridge this gap. We ensure whatever they learn can be applicable in their work.
What you'll learn
At the end of the lesson videos and 1-1 Coaching, learners will know how to:
• Apply the skills learned and improve the time taken to complete an Excel task at work.
• Differentiate whether the format of dates are recognized in Excel or not and convert them if needed.
• Name the five components in the basic structure of what is needed in a formula and adopt it in the in-house program given.
• Use IF, COUNTIF, SUMIF/AVERAGEIF, VLOOKUP, and INDEX + MATCH formulas successfully.
• List down 3 things to note from the database before creating a PivotTable.
• Create PivotTables, manipulate them, and create an interactive report.
Lesson Video Series Outline
1. Basics such as keyboard shortcuts, double-click tricks, how to reduce file size, store data, filter and basic conditional formatting.
2. How to check if a date is recognized in Excel, why is it important for it to be recognized, and how to convert them if they are not recognized.
3. Advanced conditional formatting using formulas and IF formula.
4. FHT – In-house program to guide them on how to use formulas.
5. Use COUNTIF, SUMIF, AVERAGEIF formulas.
6. VLOOKUP, IFERROR, and INDEX + MATCH formulas.
7. Learn to manipulate PivotTable (Creating, changing the layout, formatting, sorting, refreshing within a click, using slicers, Pivot Charts).
Who is this for
Executives, managers, or anyone who:
- spends more than 1 hour per day using Excel and wishes to improve on their productivity.
- faces constant changes in reporting requirements.
- cannot figure how formula works.
- wants to improve the time taken to complete an Excel task at work.
Duration: 1.5 hrs
Price: $129
This is not a stairway to become an expert in Excel programming (VBA). It is catered for beginners who have never touched VBA or only used recording macros. Due to the dry and heavy content, it is intentionally done in a very short time so that the more essential topics are covered for learners to get started in VBA.
What you'll learn
At the end of the Lesson Video Series and 1-1 Coaching, learners will know how to:
• Apply the skills learned and improve the time taken to complete an Excel task at work.
• Use Record Macro function.
• Use Cells object and Variables to do common tasks.
• Use If statements and For Next loop.
• Troubleshoot a macro.
Lesson Video Series Outline
1) VBA Starter Kit -> How to go inside Visual Basic Editor, enable Project Explorer, Code window, write code, run it, save it, and enabling macro.
2) Simplest Way of Coding -> How to record macro, see what the recording does, playing it through Macros window and button.
3) Manipulating Cells -> Different ways of selecting cells, doing common tasks on cells, storing and declaring Variables.
4) Decision Making and Looping -> If statement, useful text functions, and looping.
5) Troubleshooting -> Debugging and error handling.
Who is this for
Executives, managers, or anyone who:
- wants to speed up repetitive tasks.
Program Enrolment
Please complete the form to apply for enrolment in any of the courses with us.