Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Basic & Advanced Excel, MIS, Macros Training by Certified Trainer

43 Reviews

Patel Nagar, Delhi

Course ID: 21128

Patel Nagar, Delhi

Students Interested 3 (Seats Left 0)

43 Reviews

About the Course

Its a 5 Sunday's workshop, 4 hrs each Sunday. This workshop will be conducted at a Microsoft Authorized Centre. The fee of the course includes a Microsoft Excel Specialist Exam voucher cost Rs. 1500.

This course is structured and comprehensive training program for learning Microsoft Excel in depth. It is full of real world examples. This is 100% PRACTICAL TRAINING PROGRAM, where Mr. Lokesh Lalwani (a Microsoft Certified trainer with 6+ years or training experience) will share a practical excel spreadsheet with you and you will learn all the excel formulas and advanced functions by doing it in your system.

The aim of this course is to make the participants become productive in Excel.

Topics Covered

A broad outline of the topics which will be covered are as follows:

- Excel Basics with Formula writing
(Excel Interface, File conversion, Customizing Ribbon, Name Box etc.)

- Using Text Functions
(Left, Right, Mid, Concatenate, Upper, Lower, Proper, Len, Rept, Find, Search, Substitute, Replace, Trim and Text to Column)

- Date & Time functions
(Today, Now, Day, Month, Year, Workday and Networkdays)

- Logical Functions
(If, And, Or, Not and performing multiple conditions with Nested If)

- Mathematical Functions
(ABS, Rand, Randbetween, Round, Roundup, Rounddown, Sum, Sumif and Sumifs)

- Statistical Functions
(Count, Counta, Countblank, Countif, Countifs, Average, Averageifs, Max, Min, Small and Large)

- Lookup functionality
(Lookup, Vlookup, Hlookup, Match and Index. Searching values on the basis of Exact and Appropriate relationship. Performing multiple Lookup value, Performing lookup in multiple fields, and many more)

- Financial Functions
(PV, FV, Rate, NPV, PPMT and IPMT)

- Naming Conventions
(Applying a Name to a cell or range of cells, Modifying, Deleting and Modifying the names)

- Array Formulas
(Introducing Array Formulas, Using Array Formulas in different situations)

- Playing with Data
(• Using Inbuilt Lists and creating custom lists
• Using Sort to Arrange data alphabetically or through customized order
• Using Sort to Arrange data either vertically or horizontally
• Extracting data by using Custom Filters
• Adding Multiple conditions to extract data using Advance Filters
• Performing calculations on one field depending upon the value of the second field of the database using Subtotals
• Importing the data from different application to Excel
• Removing duplicate records from the database
• Linking the sheets and workbook through Hyperlinks
• Representing the Data graphically using through various Chart Types such as Column Chart, Bar chart, Line Chart, Pie chart and Scatter chart.
• Using Keyboard Shortcuts)

- Advance Data Handling
(• Designing the Forms for the user using Data Validations
• Preparing dropdown lists to fill up a form
• Protecting and Sharing the Worksheets & Workbooks
• Consolidating the Data from different sheets using Data Consolidation)

- Analyzing Data by Data Analytical Tools
(• Performing What If Analysis by using Data tables and Scenarios Manager
• Using Pivot Tables & Pivot Charts- Creating and Modifying a Pivot Table Layout, Creating Groups, Inserting a Calculated Field and Representing data through Pivot Charts
• Using Goal Seek and Solver)

- Introduction to Macros
(• What is a Macro?
• Displaying the Developer Tab
• About Macro Security
• Saving Workbooks that contain macros
• Understanding different types of macros)

- Recording, Editing & Deleting of Macros
(• Understanding how to record VBA Macros
• Examples of recording macros
• Examining, Testing and Editing macros
• Absolute versus Relative referencing while recording macros
• Assigning macro to a keyboard shortcut or a button
• Macros In Depth
• Inset Form controls (Button, combo box, spin button, option button etc.)
• Insert ActiveX controls (Labels, Pictures, Toggle buttons, scroll bars etc.)

- Introduction to VBA Programming
(• Understanding VBA
• Know how of VBA coding
• Basics of writing VBA Code
• Debugging errors)

Who should attend

Any Working Professionals & Students who wants to improve their Excel Skills or anyone who has a passion towards Excel.


Microsoft Excel 2007/2010/2013

What you need to bring

Laptop (If you don't have one, we will provide you the same.)"

Key Takeaways

- An In-depth excel functionality
- From basics of writing a formula to complex functions
- Functions explained in most logical and simplest manner
- Suitable for beginners to advanced users. ideal for users who learn faster when shown.
- Learn different Functions from Microsoft Certified trainer from your own desk.
- You can post any question or query on the trainer's blog.
- Post training support (Trainer will share his ph. number, email id and his blog details so that during or after the training if you find any issue, you can just reach the trainer and he will solve your concern)

Date and Time

Not decided yet.

Gallery (11)

About the Trainer

Lokesh Lalwani picture

4.84 Avg Rating

527 Reviews

790 Students

5 Courses

Lokesh Lalwani

Microsoft Certified Trainer

6 Years of Experience

I have been taking Core & Advanced Excel and VBA classes for more then 6 years. I also provide corporate training. Few of the companies i have given training in are Fortis (Gurgaon), Fortis (Amritsar), Ingersoll (Gurgaon), Ceragon (Delhi), Greaves Cotton (Delhi) etc.

Student Feedback


Average Rating




Mallika Mahato

Has very nice communication skills. Makes the session very lively and interactive.


Sumit Rohj

Very interactive session where i learnt the concepts of VBA and applied them on the problems.


Khushboo Parakh

The session on macro and VBA was very interesting and learning it through examples was best part. It was good learninmg experience.


G N Nikita

He is a good trainer who makes the class lively and interesting by making us indulge in practical sessions of the topic.


Srishti Gautam

Great learning experience! All the topics were covered well and focus was on making the session more interactive with sufficient time for practice.



Interesting training session. Lokesh has good knowledge of the program's working and quickly helped us out when we were stuck. Great learning experience.


Darpan Singhal

Sessions were interactive and consisted of a lot of practice questions as well which was very helpful in learning the concepts.


Monica Jujjavarapu

He carried the session in an eloquent manner. His way of teaching increased our interest in the subject.


Shikhar Baid

Thoroughly enjoyable sessions. A very knowledgeable trainer who puts his ideas very clearly. Very helpful and great way of presenting all the study material.


Shubham Rana

Excellent communication skills, friendly behavior, in-depth knowledge of the subject, really keen to help out with problems, dedicated to clear doubts.


Shameek Sharma

Excellent training of excel, earlier we are using long commands for the small works. The training helps a lot to reduce the time.


Rajat Kumar Saha

It Is really nice & good exp. I request every company should go and have this training it will help to grow self as well as company's growth.


Prakhar Srivastava

The training was very interactive, had good content. I learnt a number of new tricks formulas which would definitely help reducing the labor that I had been putting in which could have been done in those simple tricks and formulas that I learnt during the training. The entire training was excellent.


Shubhangi Bahl

Excel is one thing which I feared before attending the classes by Lokesh. He is a doting professor who makes sure that each student understands everything. The course was deigned systematically taking care of the basics as well as advanced levels. Way to go sir, I recommend all of you out there to attend his classes.


Ruchi Shambhavee

Excel training given by Mr.Lokesh is very informative and a key to understand very useful and complicated formulas in a very easy manner. Would like to attend his trainings on other topics of excel also and would refer my colleagues for training from Mr. Lokesh.


Ruchi Shambhavee

Excel training given by Mr.Lokesh is very informative and a key to understand very useful and complicated formulas in a very easy manner. Would like to attend his trainings on other topics of excel also and would refer my colleagues for training from Mr. Lokesh.


Lalit Patel

He is having good excel knowledge nd demonstrated all excel functionality well. It was a very good learning experienced with him.


Rahul Yadav

Training Session was really good and full of knowledge. The way he delivered the training was too good. He explain each and every section with good examples & answer each doubt/ question clearly. Exercise created by him cleared all doubts about these commands. Overall experience was great



He is very good trainer. training method is very simple but very effective. it will help in my professional growth.


Pawan Kumar

Good knowledge & way of explaination is also good. Advanced Excel formulas & Function teach very easy way .I.e. easily understand & memorable long time.


Ravi Jangra

Training is very pretty much effective, earlier I know about basic excel, but after attending 2 days workshop for advanced excel, it is going to help me a lot in the future.Thanks to Lokesh lalwani Sir and HMSI for this great training.


Puneet Arora

Thanks Lokesh for teaching us tricks and shortcuts in MS Excel! Training session was interesting learnt a lot from it .


Himanchal Sahu

Had a good experience learning some new features in Excel. Surely it will help in our daily works and will be more faster and benifitial ofcourse.


Praroop Bhatt

Lokesh approach to teach is very practical. He believe in practical work around rather than theoretical explanation. By this approach you can actually feel what you are learning and developing.


Mohit Goyal

Mr Lokesh is good in describing excel formulas . He made the training attractive with his good communication skills so that each member was attentive in listening all topics. Overall nice experience.


Ankit Katiyar

Given training in very Good manner and Very easy to understand all functions. Excellent performance.....All the best.... Regards Ankit Katiyar



If I say in one word, Awesome....... Good communication skill with lots of knowledge of all excel formulas.


Ashish Kockcha

It was wonderful. Shri Lokesh has vast knowledge on the topic and can clear every query of yours.


Arushi Verma

The experience was great. It was very helpful very interactive. Learned most of the new things about Excel. He made learning Excel very interesting and easy. It was nice and useful. Looking forward to learning more things in excel. He was very interactive and helpful all throughout the session. He made it easier for us to ask queries. The session was GREAT. Thumbs UP!!!!!


Chandra Shekhar Kumar

It was a good training session. I enjoyed a lot. Knowledge is good and training was full of excercise and interaction.


Shubham Mishra

It was great learning experience, Lokesh is very experienced trainer. He has helped me in understanding basic and advanced excel concepts I would highly recommend him for excel training


Arpita Sharma

Overall excellent experience. Very good and meaningful training & interactive session.



Lokesh makes this session really interesting. i enjoyed each & every bit of it. He was very helpful throughout the session.


Divakar Uniyal

I have learn lots of things from Lokesh, some are refreshing with new concept and most of the area like, nested formulas, index, power pivot, VBA are new for me. I love these and surely will use in my work.


Ashish Rawat

It was a great session. Learned so many new things which will help me in my daily work.


Abhishek Anand

Very good and meaningful training session. Great learning experience i can see the change in my excel knowledge post training. Very good and easy examples to make understand the formulas.. Worth Training... :) :) Thanks Lokesh..


Gourab Roy

It was really great to attend Lokesh's session on Advance excel really learnt a lot about the basics which cleared my foundation. This interactive and learning session is much more helpful for me in my Professional Life. Appreciate Lokesh for his efforts on making this program a very fruitful and learning experience.


Aditya Soni

Training was elaborate and quite interesting. good presentation as well.


Himanshu Gupta

Overall very good


Himanshu Gupta

Overall very good



He has a brilliant way to describet the topics about excel.


Ridhi Narula

I had a one day training session on advanced excel conducted by Mr. Lokesh himself. The training was really beneficial and is helping me in my day to day job requirements. There is no end to learning on this topic. He made us learn each and everything in a very practical way.


Ratandeep Singh

Really a great inovative trainner , try to be give his best in even 2 days training seccion. Good job lokesh . Keep doing good work. Thanks to support in teaching me excel.


Students Interested 3 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now


Submit your enquiry for Basic & Advanced Excel, MIS, Macros Training by Certified Trainer

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Lokesh

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more