- Mastering formulae’s and Functions:
- Revising basic Excel functions and formulae’s
- Learning Excel Arithmetic operators
- Understanding intermediate Formulae’s and Functions
- Evaluating and examining the formulae’s
- Shortcuts to write the formulas
- Look up and Reference functions,
- Working with Logical Functions
- Absolute and Relative cell referencing
- IF conditions
- Nested IF conditions
- Date & Time Functions
- Advanced Date And Time Functions
- SUMIF and COUNTIF, SUMIFS and COUNTIFS
- Text functions
- Statistical Functions
- Financial Functions
- Math and Trig functions
- Database and Information Functions
- Multiple exercises to create complex functions
- Hands on challenges to be an expert on Nested formulas and functions
I loved the sessions on formulas, shortcuts and graphs. Given my profile I will be able to apply these to my job immediately
Personal Assistant
Awin Resource
It has been a great experience of getting trained from Divya on the excel tools. The curriculum has been well designed and she is very interactive in the sessions and keeps everyone involved with the practice sessions and throughout otherwise also. Thank you Divya for explaining all the concepts so nicely.
Finance Manager
Asian Pay Television Trust
Very clear explanation on each topic and very approachable. Very handon due to given practice exercise.
Senior Accountant
APTT Management PTE. Limited
key takeaways include use of formulas, charts and shortcuts which I can implement in my day to day work
Senior Banking professional
Deutsche Bank
What I liked about the session is that it was very interactive with lost of hands on exercises.
Senior Management Professional
Schnitz
the sessions on formulas and smart charts were very helpful. These will help me in my regular day to day work.
Regional Finance Officer
Epsun Singapore
The trainer was very approachable. Her hands on approach helped me understand excel in more detail and should help me manage my work efficiently.
Analyst
Cotton on Pte Ltd
This workshop is designed for finance and accounting professionals, who work on humongous raw datasets from various sources and in various formats. This workshop is focused on learning advanced excel formulae’s and functions and learn new excel tips and tricks to use them in their daily routines and solve complex business problems.
Our expert trainer will work with all the participants on various data sets and work on practical examples to help them gain expertise in all the advanced formulae’s and functions and its applicability in real world
Hands on exercises will be given to participants helping them to summarize and organize data for meaningful reporting and help them derive insights.
The participants of this workshop will learn complex calculation through nested functions, dynamic formulas, enhanced features of nested functions to create meaningful and insightful information using excel to perform their daily tasks efficiently
This workshop will also help the participants to learn new excel shortcuts that will help them increase their productivity in their day to day work
All participants should have their laptop with preinstalled MS office 2010 and above
Finance and accounting professionals (such as Accountants, Controllers, Finance managers, Auditors and all accounting professionals) who use excel not only for day to day processing but also for interpretation and data mining to convert raw data to meaningful analysis.
The aim of the course is to make the participants learn advanced excel tips and techniques in a way that helps you enhance your productivity, speed and make your work much easy to interpret.
You can discuss your unique requirements at +65 84831463 or simply fill the required details on Enquiry Now Page and send us at info@outsourcingwise.com
Course Cancellation / Reschedule Policy
OutsourcingWise reserves the right to cancel or reschedule the course due to unforeseen circumstances. If the course is cancelled from our end, management will refund 100% to its participants
Note: the minimal class size to start the class would be 3 pax