Duo Tree
Developing people | Driving Productivity
Courses
Increase Your
Market Value
Register TODAY!
Learn the right tools and skills to...
-
A bigger paycheck
-
Impress others with your analysis
-
Increase your productivity
Earn a bigger paycheck Make 13% more than peers without digital skills
Perform complex analysis Impress others with your insights on data
Go home on time Spend more time with family than in office
Earn a bigger paycheck Make 13% more than peers without digital skills
Structured courses
Upcoming events
Excel 201
Dynamic Dashboards
Dashboard development, one of the most sought after skill; leveraging on Microsoft Excel 2010, the most common and powerful tool. Look like an Excel expert with dashboards in just 2 days!
In this course, you will learn the fundamental building blocks for developing dynamic dashboards. Sharing of tricks and tips to make your work-life simpler and easier!
Content coverage
-
Formulas and nesting
-
Data validation
-
Charts and sparklines
-
Mapping tables
-
Define names
-
Filtering
-
Database
-
Color discipline
-
Hotkeys
Event's Details
Course date: To be confirmed (9am to 5pm)
Closing date: To be confirmed (registration & payment)
Min size: 5 participants
Max size: 20 participants
Lead Trainer: Lester Hui
Location: Park Mall, 9 Penang Road, #11-14/13-14 S238459 (beside Dhoby Ghaut MRT - CC1, NE6, NS24)
Tea breaks will be provided.
Course fees: S$499 nett
Payment mode: Bank transfer or cheque to Duo Tree Pte Ltd
*bring your laptop equipped with Microsoft Excel 2010 or rent a laptop from us at just S$50/pax
Call us at +65 9655 5710 or 9173 6611 to find out more.
Register now and learn it from industry's experts today! While slots last!
**Note that location might be subjected to change without prior notice; participants will be inform should there be amendments to above.
Location map
Excel 101 - Basic
Excel in Fundamentals
Microsoft Excel, the most commonly used program by Finance and Accounting professionals for numbers crunching and reporting purposes. Gain confidence and comfort with navigation and data management in just 2 days!
In this course, you will learn the user interface and frequently used functions necessary for searching, modifying, organising and presenting datasets. Sharing of why and how to make Excel work like you intend it to.
Content coverage
-
Navigation within user interface
-
Input data and formatting
-
Ribbons and commonly used functions
-
Formulas and error reading
-
Auto filters
-
Charts
-
Pivot tables
-
Data protection
-
Hotkeys
Event's Details
Course date: To be confirmed (9am to 5pm)
Closing date: To be confirmed (registration & payment)
Min size: 5 participants
Max size: 20 participants
Lead Trainer: Larry Hui
Location: Park Mall, 9 Penang Road, #11-14/13-14 S238459 (beside Dhoby Ghaut MRT - CC1, NE6, NS24)
Tea breaks will be provided.
Course fees: S$399 nett
Payment mode: Bank transfer or cheque to Duo Tree Pte Ltd
*bring your laptop equipped with Microsoft Excel 2010 or rent a laptop from us at just S$50/pax
Call us at +65 9655 5710 or 9173 6611 to find out more.
Register now and learn it from industry's experts today! While slots last!
**Note that location might be subjected to change without prior notice; participants will be inform should there be amendments to above.
Location map
Structured courses
Excel 101 | Basic
Course objective: Participants should be able to navigate freely within MS Excel and execute basic function for analysis.
Course fees: S$399 nett
Duration: 2 days
Orientation
-
Ribbons and build in functions
-
Cell formatting
-
Modification of tables and layout
Formulas
-
Intro to fomulas
-
Basic nesting
-
Evaluating formula
*Tea breaks will be provided.
Pivot table
-
Creating pivot table
-
Formatting pivot tables
-
Modification of source information
Charting
-
Creating basic charts
-
Building templates
-
Dynamic pivot charts
Excel 102 | Advance
Course objective: Participants should be able to perform advance functions like nesting and conditional formatting. In addition, execution of complex analysis using data tables and pivot tables.
Course fees: S$499 nett
Duration: 2 days
Data analytics
-
Pivot table
-
Data table
-
Various What-if analysis
Charting
-
Creating basic charts
-
Building templates
-
Dynamic pivot charts
VBA
-
Intro to VBA
-
Recording a macro
-
Understanding the codes
Orientation
-
Conditional formatting
-
Data validation
-
Advance filtering
Formulas
-
Refresher on fomulas
-
Complex nesting
-
Evaluating formula
*Tea breaks will be provided.
Excel 103 | Expert
Course objective: Participants should be able to confidently perform complex functions such as nesting formulas and leveraging on charting tools to identify trends within datasets. In addition, participants will learn to develop basic dashboards using a database.
Course fees: S$649 nett
Duration: 3 days
Orientation
-
Customized formatting
-
Data validation
-
Advance filtering
Formulas
-
Refresher on fomulas
-
Complex nesting
-
Evaluating formula and troubleshooting
Data analytics
-
Pivot table
-
Data table
-
What-if analysis
-
Basic dashboards
*Tea breaks will be provided.
Charting and modelling
-
Creating charts
-
Building templates
-
Dynamic pivot charts
-
Sparklines
-
Monte Carlo simulation
VBA
-
Intro to VBA
-
Recording a macro
-
Understanding the codes
-
Editing the codes
Excel XYZ | Customized
We want to be a business partner to your organisation and help develop the talent pool within. As every organisation is unqiue in itself, we understand the need to have a program tailored to your needs. Therefore, we are always ready to work with your Learning and Development group to develop:
-
Fundamental training within induction program
-
New hire orientation for Fresh Graduate
-
Customised training for management trainee program... and more
Please contact us via email at duotreeco@gmail.com to enquire and arrangement for further discussion.
© 2014 Duo Tree Pte. Ltd. UEN: 201425639Z. Created with Wix.com