As a tutor you can connect with more than a million students and grow your network.
Bund Garden Road, Pune
Course ID: 23980
Unleash the power of Excel and become an Excel Pro Microsoft Excel, is the widely used program across the world, which is used for performing numerous computations, manipulations and compilation of data. There are so many useful features that are available on this spreadsheet application, which go unused. Hence Excel4 all has designed a two days’ workshop not only to empower the participants with the unexplored features, tools, hidden functions and tips and tricks in Microsoft Excel but also to save TAT, work smart and fast and also can apprehend the significant growth in their productivity. JOIN the workshop and make the difference at your workplace.
• Excel 2013/2016 Quick Overview with exploration of QAT. • Overlook basics • Fill Series • Absolute Referencing • Define Name • Date Functions, Formatting and customisation • Data Formatting, types, and clean • Text Functions • Condition Formatting with formulas • Data Sorting & Filter along with advanced filter • Data Validation to prevent errors and saving TAT • Vlookup & Hlookup with combination of multiple functions • Pivot Table • If & Nested If • Sumif & Countif • Charts • Advance Filter with Formula. • Advance Sorting with multi level sorting and sorting from left to right • Group & Outline and Auto outlining • Consolidation of multiple workbooks and worksheets • Subtotal for preparing a quick summary out of any data • Custom List to define your own list and work conveniently • Link & Hyperlink to create a link and share information • Sharing & Protection to protect data from UN-authorised access. • Macros ( Basic, Run and Record Macro, Editing a macro, Designing your first macro program, Demonstration of macro tools)
This workshop would be very useful to participants across various industries and functional specializations such as MIS, Finance, Marketing, Operations, Human Relations, Information Technology and Administration
Must Aware of the basic of Excel
Laptop with MS Office 2010 version Installed."""
Soft Copies of the precise and handy reference material. Post Training Support for 90 days.
Message copied
Copy
Not decided yet.
4.8 Avg Rating
20 Reviews
22 Students
6 Courses
BCOM,PGDCA,CA, MBA,SAP(FICO)
4.9
Average Rating
Kishor Sarode
Very useful for our working on excel. Prabhas Panda sir gives very important tips and attaining each and every queries of all participants. Syllabus covers very useful chapter. I thinks Macros also should be added in program with increase in duration of course.
Sneha
The training helped us deal with the problems we usually face with excel. We came to know how much time did we waste earlier when it could have been done in a few minutes. I did not know anything about the functions we learnt but after this training I have got a good hand over excel.
Rashmi joshi
It was explained in a very easy manner so it was very easy to understand. Apart from this, training made us work on techniques to use general Excel functions in a very easy manners.
Arnab sarkar. Posco steel
It was a very good training we have ever atteded. We have our internal trainers but Mr.Prabhas is exceptionally well. The beauty of his training is he makes the problem very simple and the way he explains in so simplified manner.
Dr. Neha
We had a wonderful experience learning from Mr.Prabhas. What we learned is very much useful in our every day functions. Mr.Prabhas has a sound knowledge into almost every function. His methodology of explaining the function/formula followed by exercises to work upon is excellent and highly appreciated. Looking forward for more opportunities to learn from him. His training was very impressive and he planned it very well too with the actual content first and then the practical with examples. From the entire team at Bridgestone, we thank you for the wonderful training.
Ridhima
I had attended two days workshop and I felt it was worth attending and also worth risk taking. I had inquired with multiple service providers and many organisations. Finally I went for the Google reviews about Excel4all. Post training I could believe that Mr. Prabhas is an awesome trainer. All my doubts are clarified and the best part is he does share the tips about best industrial practices and troubleshoot techniques. Out of two days program I loved the techniques and features of pivot table. It was really an eye opening techniques I learnt from him. I must say if someone wants to learn the real advanced excel techniques then he or she should join Excel4all.
Namita
It is my privilege to write a feedback about excel4all. I have attended MS excel training program-advanced level and learnt a lot in the two days which I had never had before. Hats off to the trainer for his unique delivery style .Mr. Prabhas has really done the in-depth analysis in excel and taught me with live examples by which i can make out the things better and quickly. Yes I shall definitely recommend in my office and my colleagues as well.
Ask a Question
Register for Free Master Class
You have successfully registered
Class Scheduled at
hour
Share this Master class
Message copied
For Mobile phone, download the UrbanPro app for Learners
The UrbanPro Learner app is your study app for this course. You can attend the Demo Class on the app and also get access to the course material, course schedule and ability to communicate with the Tutor. To learn more, watch this video.
For Laptop, download the Zoom app
Download the Zoom app for your laptop. The link to join the class will launch the meeting with the tutor on this Zoom app. To learn more, watch this video.
Verify you Mobile Number
Please verify your Mobile Number to continue and book a FREE Demo class.
Please enter 10 digit phone number.
Please enter your phone number.
Please Enter a valid Mobile Number
This number is already in use.
Please enter OTP.
080-66-0844-42