Become an hero at your office. Become a Ninja level Microsoft Excel User and learn amazing tricks and formulas.
The program lays a solid foundation of why are we using a certain formula or technique in a given situation, and what are the alternatives. Next, we ensure that we cover combo formulas and hidden tricks to truly make you an Excel Ninja. E.g. quite a number of professionals would have used VLookup. By itself, it's a one-dimensional (1-D) lookup. We not only cover the foundation concepts, but we also train you to use 2-D, 3-D and reverse lookup.
My experience in training working professionals day-in & day-out for the last five years allows me to discuss those concepts and case studies which are practical in nature. E.g. how to generate 500+ customer reconciliation worksheets in less than 1 minute without using Macros (VBA coding).
The program will benefit not only in Excel MIS reporting but also in the following areas:
Performing Computer assisted audit techniques (CAAT) in Excel
Forensic Audit techniques
Using ERP downloaded Excel files as base to generate custom MIS reports
Reducing TAT drastically (turn-around time)
Preparing Financial Models with combo-logical statements
Preparing Management Reporting dashboards
Important: The entire program is designed in such a manner that YOU can become an Excel Trainer.
How much time does it take to complete the course?
The course contains video tutorials of approx 11 hours.
What am I going to get from this course?
Video with Trainer's face discussing the tricks
Methodology: Conversation approach and not script reading
Context based Zoom in/out of screen - apt for tablet/smartphone viewing
Picture based eBook (downloadable)
Lecture by Lecture - Excel Case Studies (downloadable)
About the Training Instructor:
Rishabh Pugalia, Founder, Yoda Learning Solutions/Excel Next has trained more than 9,000 professionals on Advanced Excel Ninja across 15+ cities since 2010.
He is a Chartered Accountant and has graduated from St. Xavier's College, Kolkata.
He has worked with KPMG (Assurance), Futures First (Proprietary Trading - Interest Rate Futures & Options) & J.P. Morgan (Debt Capital Markets - Investment Grade). He has 10.0+ yrs. of work experience including 5.5 yrs. in Training.
He has co-authored a Technical Guide on how to use Excel for "Continuous Controls Monitoring" - it was published by the Institute of Chartered Accountants of India (ICAI).
He has conducted 100s of LIVE workshop for corporate clients from diverse industries and vertical - Big Four Accounting firms, Power, Cement, Metals & Mining, FMCG, Telecom, BFSI, Investment Banking, Engineering, Automotive & Ancillaries, Chemical, Real Estate, IT & ITeS etc.
His clientele pool includes prestigious names such as PwC, E&Y, ITC, Tata Sky, Tata Power, Birla Cements, Gulf Oil (Hinduja Group), J.M. Financials.
Program includes topics which are practical and NINJA level:
Handpicked Ninja Shortcuts
Go To - Special "magic wand" with Ctrl + Enter
Sort (Vertical, Horizontal, Custom), Filter & Advanced Filter
Working with Dates (incl. unstructured / unformatted / unclean dates)
Pivot Table - replicating a report format for 100s of criteria in less than 1 minute
Lookups (1D, 2D, 3D, Reverse)
Conditional Calculations (Sum, Average, Count, Special Running Total)
Data Cleaning / "Sanitizing" formulas & techniques
Formula based Conditional Formatting
What-If Analysis - 2 Output and multiple Inputs along with Scroll bar
3-D Data Consolidation
Hiding sheets with "Unhide" option deactivated
Picture in a Comment
How is the course structured?
This course is tailor made for all kinds of Microsoft Excel users. If you are a beginner or an existing user of Excel, you will learn new things with each video and will help you SAVE YEARS. If you are an Experienced Excel user: I will coach you to reach the Ninja level of Excel.
What are the software and other requirements for the course?
A computer with Microsoft Excel 2007 or Microsoft Excel 2010 or Microsoft Excel 2013 or Microsoft 2016 installed.
What are the requirements?
Before starting the course, you should have Microsoft Excel installed on your computer to practice the teachings yourself.
What am I going to get from this course?
Over 167 lectures and 10.5 hours of content!
This course will help you become a Microsoft Excel Ninja User. Your skills at Excel will help you do your work faster and smarter
Become a Hero at your office, do Excel tasks at super speed and get your work done faster
What is the target audience?
Anyone who wishes to learn Excel. This course is suited for Beginners or Advanced User of Excel. You can also become an Excel Trainer
I recommends Buy premimum account for High speed+parallel downloads!