Advanced Excel -1 (Working with data)

COURSE DETAILS

Course Name : Advanced Excel -1 (Working with data)

Data cleaning technique arranging and analyzing data. Learn advanced formulas and functions to save time and improve efficiency.



Total Students

76

Course Duration

12 Hours

Valid Upto

4 Months

Course Starts

Self paced (recorded)

Course Contents


sumithra@riassociates.co.in

Its very nice to attend the excel session. Its not so easy for an expert in excel to take session very slow - Its very nice to see the the speaker takes the session according to the participants. Its like bullet rain running slow passenger train. Both will reach the end point with difference in days to reach the destination. Ageing Formula - I am yet to explore others - as i missed important sessions

amar.kakaria@gmail.com

You are doing a fantastic job by spreading knowledge. Please keep up the good work Control C Since it is easiest shortcut

ajay.kampali@gmail.com

Solver Best Function : Advance filter and solver

joanita.fernandes@indianagroup.com

Good Best Function : Nested V Lookup

mittalkrishna53@gmail.com

It is helps me a lot in day to day working Best Function index, match and if and nested v lookup

ca.rangarao@gmail.com

The sessions are wonderful and very useful for the professionals to learn in a chronological order. Thanks Best Function: Merging different excel shhets

pooja.agarwaal@gmail.com

It was a great Learning Experience Best Function: XLookup

pratapkshitishraj@gmail.com

Best Best Function : Sumif

vijay.parab@indianagroup.com

Well covered with intrinsic details Best Function : Vlookup , Index and Match

casanitmutha@gmail.com

Understanding and Implementing The Functions and Formulas in Excel was never this easy but after this sessions and the was the sessions were conducted Excel has become a lot easy Best Function : Clipboard, Index Match

mahanth.ca@gmail.com

Excellent Best Function: TABLE, SLICER, INDEX&MATCH, INDIRECT, SOLVER, ADVANCED PIVOT TABLE FUNCTIONS

zarinamathew0209@gmail.com

Loved the pace of speed by Piyush. Unfortunately I couldn't attend most of the live sessions. So I went through the youtube links. Hope to utilise these concepts in the near future. Kudos! Best Function : Insert Slicer

kaustubh07@gmail.com

Best Function : Solver, index match

kaustubh07@gmail.com

Best Function : Solver, index match

vijay.parab@indianagroup.com

Nice way of teaching and responding queries raised by participants

sapatil27@gmail.com

Good session

iaggarwalpiyush@gmail.com

Great opportunity to brush up the basics of excel and also to learn many new things. Beginning of the course has been great. Seeking forward to learn advanced tools of excel also. Hoping as the course will move forward, speed will be increased little bit.

munoyat@gmail.com

Exceedingly Excellent

gopalrathi490@gmail.com

Well,the journey was started from the basics and helped to learn new tricks even who are not working on excel frequently.Now it has become a routine part,awesome learning. User friendly

info.cabhavesh@gmail.com

Very Good. knowledgeable and interesting. Overall Improvement in our existing skill set.

prasad@caprasad.com

Great experience. Mindblowing

vijay.parab@indianagroup.com

Gives total insight of Excel World

parasdharod@gmail.com

very useful. Learned new formulas. One Word : Chief

casanitmutha@gmail.com

IT WAS AN EYE OPENER. WAS TOTALLY OF SOME EXCEPTIONAL FEATURES AND USE EXCEL. VERY WELL CONDUCTED AND EXPLAINED. DEFINITELY WORTH EVERY PENNY. BUT JUST ONE SUGGESTION THAT PLEASE TRY TO RELATE IT WITH MORE PRACTICAL EXAMPLE ,FOR EXAMPLE HOW A FUNCTION CAN BE USED BY A CHARTERED ACCOUNTANT IN HIS OFFICE WORK. One Word : Amazing

pratapkshitishraj@gmail.com

Good

ajay.kampali@gmail.com

Happyful One Word : Great

gopalrathi490@gmail.com

Well,we have a wonderful learning during this timeline ,learnt many functions which increase the efficiency of our work and shared experiences of one another during presentations.Overall it is an awesome learning we have rightly selected the ANKR for the course.User friendly

guptadiksha944@gmail.com

Excellent .Basic conceptual clarity with practice keeping in mind every layer of student. Overall worth the investment.

mahanth.ca@gmail.com

Have learnt a lot during the sessions. Not only just knowing the formula or functions, but practical aspect of it is very important. During these sessions live presentations helped a lot in thinking of the possible practical angle for excel. one word: Excellent

rajesh.dolas@indianagroup.com

Amazing. All the information & detection was helpful

singhal.dipti196@gmail.com

Excellent teaching method. Complicated stuff also explained very nicely. Great work ANKKR Global and a big thanks to Piyush for his amazing teaching style.

naveenjain@ankrglobal.com

It is good learning for all

Training Videos

User Feedbacks

Niladry Kar

Have attended the Sessions on IND AS and upskilling courses such as Advanced Excel and Business Presentation.Each one of the topics were exhaustively covered, the explanation was very elaborate, ample examples and scenarios of practical applications were clearly given. And the best part is a relatively simple and highly effective mode of examination being conducted. You Guys are the best !! Keep up the Good Work !!! 

Niladry Kar
Arrow Image
Niladry Kar
People Image