Get yourself trained on Advanced Excel – with this Online Training Advanced Excel – Beginner to Ninja level (includes Charts).
Online Training Advanced Excel – Beginner to Ninja level (includes Charts)
“Advanced Excel Ninja” is a comprehensive online training program on Microsoft Excel. It is divided in 12 sections and covers exhaustive list of topics. There are 90+ tutorial videos and the duration is 13 hrs. Topics often ignored in other advanced online programs have been included. Demo Preview Lecture 89 and 90 to find the difference. VLOOKUP() with MATCH() HLOOKUP() with MATCH() INDEX() with multiple arrays & two MATCH() Using TRANSPOSE() formula Form Control Buttons for Dashboard SUMIF() vs. SUMIFS() SUM() vs. SUBTOTAL() while using Filter Hidden Text-to-Columns tricks Using IFERROR() vs. IF() + ISERROR() Applications of INDIRECT() and OFFSET() Pivot Table tricks on calculating automatic sum, count, percentage and generating grouped data headings 3-Data Consolidation Power of “GO TO – Special” along with Ctrl+Enter Using “Find and Replace” with wildcard characters Combo techniques for Data cleaning Formula-based Conditional formatting Charts – Thermometer, 2 axis, Trendline, Axis value settings Inserting Picture in Comments… and the list of such tricks is very long So if you intend to take your Excel application skills multiple notches higher, gain from the experience of a training instructor who – Is a qualified Chartered Accountant Has worked with KPMG and J.P. Morgan Has trained 12,500+ professionals (Apr 2010 – June 2016) in face-to-face training programs Has incorporated in this online program 100s of tip-n-tricks, which he has acquired over the years through various forums, experimentation, problem solving challenges and training interaction And by the way he has conducted more than 200 (twohundred) workshops for one of the Big Four firms, where the participants are from numerous departments and domains. The insights acquired have been meticulously incorporated in to the program. Instructor: CA. Rishabh Pugalia, Founder, Excel Next The participants will be provided lifetime access to videos plus downloadable Excel Case Studies and picture-based HandBook (PDF).
Udemy helps organizations of all kinds prepare for the ever-evolving future of work. Our curated collection of top-rated business and technical courses gives companies, governments, and nonprofits the power to develop in-house expertise and satisfy employees’ hunger for learning and development.
Learn on your schedule with Udemy
Investing in yourself through Learning
As a society, we spend hundreds of billions of dollars measuring the return on our financial assets. Yet, at the same time, we still haven’t found convincing ways of measuring the return on our investments in developing people.
And I get it: If my bank account pays me 1% a year, I can measure it to the penny. We’ve been collectively trained to expect neat and precise ROI calculations on everything, so when it’s applied to something as seemingly squishy as how effectively people are learning in the workplace, the natural inclination is to throw up our hands and say it can’t be done. But we need to figure this out. In a world where skills beat capital, the winners and losers of the next 30 years will be determined by their ability to attract and develop great talent.
Fortunately, corporate learning & development (L&D), like most business functions, is evolving quickly. We can embrace some level of ambiguity and have rigor when measuring the ROI of learning. It just might look a little different than an M.B.A. would expect to see in an Excel model.