Advanced Excel Workshop Training Course
This is an instructor-led training course
Course Mentor: Jeff Robson
| Date | Location | Venue | Investment | Register |
|---|---|---|---|---|
| 27 Jul - 27 Jul, 2009 | HK, Hong Kong | Marco Polo Prince Hotel | US$1798 |  |
| 3 Nov - 3 Nov, 2009 | SG, Singapore | Marina Mandarin Hotel | US$1798 | |
*18 seats only for each public session
Can't find a session in a city near you? Consider organising this course in-house in the city of your choice.
Have a question? Email us at:
![support [at] ethanhathaway [dot] com](/images/support-email.gif){kind=small}
or call us at: (+852) 2273-4393 or request an in-house training quotationBookmark and/or share this page with your friends and colleagues:
Advanced Excel Workshop Overview
This optional pre-course Excel refresher workshop will help you benefit fully from the 3-day Financial Modelling in Excel course. This pre-course workshop will familiarise you with various necessary excel tools, functions and features that are frequently used in financial modelling.
Have a question? Email us at:
or call us at: (+852) 2273-4393 or request an in-house training quotationBookmark and/or share this page with your friends and colleagues:
Workshop overview
Areas Covered:- Advanced range names, including formulas and naming conventions
- Advanced conditional formatting, including formula-driven formatting
- Aggregation functions
- Financial functions: IRR, NPV, PV, FV, PMT
- Goal seek and Solver
- Pivot Tables
- Scenarios
- Data tables
- Lookup functions: VLOOKUP, HLOOKUP, INDEX, MATCH
- Advanced data validation techniques and forms controls
- Introduction to macros and user-defined functions
Attend both modules and save
Attend both the Advanced Excel Workshop and the Financial Modelling course and save US$798Who should attend?
For delegates who are not too familiar with Excel functions or you want to refresh your skills using Excel in financial modelling.This workshop should be taken if you plan on attending the 3-day Financial Modelling in Excel course and you do not have the experience and/or knowledge in Excel required.
Can't find a session in a city near you? Consider organising this course in-house in the city of your choice.
Have a question? Email us at:
or call us at: (+852) 2273-4393 or request an in-house training quotationBookmark and/or share this page with your friends and colleagues:
Run this course in-house
Consider running this course as an in-house course where you want, when you want and tailor the course to how you want it.
You can gather a group of your colleagues and/or invite your clients.
Find out more about running this course or any other one of our courses in-house.
What do you get from Ethan Hathaway courses?
- Practical. Learn from experienced and active industry practitioners and what's being practiced by your peers.
- Applicable. Apply what you learn in your job and your career
- Specially designed courses by industry active experts for industry practitioners
- Valuable. Earn more revenue or save your organisation from monetary loss. You and your organisation will quickly earn back your investment on the course fee and more
- Enjoyable. Speakers who have a passion for their topic
- Clear. Turning complex concepts into easy to understand concepts
- You gain knowledge and skills that make you valuable to your company and your career
Learn more about this course
Inside the course information booklet you'll find:
- Detailed course agenda of what you'll learn
- Eligible discounts
- Our course quality guarantee
- Course expert biography
- Course venue details
- Cancellation & refund policies
- Course registration form
- Printer-friendly PDF
- Small file size for fast & easy download
- Easy to share with colleagues & friends
Complete the details to the right and click on "Send me the booklet" to have the course booklet emailed to you immediately.
We will never sell, rent or exchange your details to any 3rd parties. We value your privacy.
We will never bombard you with emails and/or pushy sales calls.
Register for the course
You may book your place on the course by any of these methods:
- Online booking - simply click on the "Register Me" button next to the course date you wish to register and it will take you through our quick online registration procedure.
- Email us at: - please include your full contact details.
- Fax us the booking form (included in the brochure) to: UK: +44 87 1715 0414 / Hong Kong: +852 3014-0721
- Or call: +852 2273-4393 during normal office hours
Advanced Excel Workshop Training Course
| Date | Location | Venue | Investment | Register |
|---|---|---|---|---|
| 27 Jul - 27 Jul, 2009 | HK, Hong Kong | Marco Polo Prince Hotel | US$1798 | |
| 3 Nov - 3 Nov, 2009 | SG, Singapore | Marina Mandarin Hotel | US$1798 | |