toolboolzx.blogg.se

He is a Chartered Accountant and has graduated from St.So, do not spend so much time thinking, go ahead and enroll for this course! We atĬaclubindia are very much concerned about your future. Anyone who wants to use the tool to master organisational skills at work.

Become an Excel Expert: Consultant, Freelancers.Work faster & Automate reports: Accountants.He creates courses with a very strong emphasis on two things: (a) Logics, including why and what not to do, and (b) Case Studies that reflect use cases.Įvery professional who uses Excel has a different career goal. He's not just a “YouTuber” who records courses. His video courses are used in top blue-chip companies. Now he's training the Trainers to train on his behalf. He has trained professionals from 50+ companies such as PwC, EY, Flipkart, ITC, etc. He is a Chartered Accountant and has worked with companies such as KPMG (Audit) and J.P. TRIM formula to remove excess spaces in a sentenceĭetailed Content List : Click here to downlaod Why is this course different? What separates this course from the rest?ĬA Rishabh Pugalia's education, job experience, training experience, and his passion will make this course different and separate from the rest.Rectify dates format using Text to Columns.Why does a Date in Excel look like a random number?.Hide a sheet so that no one can unhide easily?.A hidden trick of Consolidation using SUM for multiple sheets.A hidden trick of COUNTIFS to do VLOOKUP for duplicate values.Using SUMIFS to find the sum of values between two dates.Fill intermittent black cells using Go To special.Use of Cell Referencing ($) in formulas.Hidden Tricks & Settings – Compare 2 Excel files, Split Text to Rows, Unpivot Columns.Uses of complex Lookup Formulas such as OFFSET, INDIRECT in a simplified fashion with multiple application.

You will learn those topics and methods which others don’t teach.