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)

₹ 5,000

43 Reviews

Date and Time

Not decided yet.

Lokesh Lalwani picture
Lokesh Lalwani

Microsoft Certified Trainer

6 Years of Experience

About Lokesh Lalwani

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.
M

Mallika Mahato

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

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

S

Sumit Rohj

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

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

K

Khushboo Parakh

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

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

G

G N Nikita

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

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

S

Srishti Gautam

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

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

R

Rishikesh

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

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

D

Darpan Singhal

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

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

M

Monica Jujjavarapu

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

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

S

Shikhar Baid

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

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

S

Shubham Rana

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

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

S

Shameek Sharma

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

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

R

Rajat Kumar Saha

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

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.

P

Prakhar Srivastava

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

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.

S

Shubhangi Bahl

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

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.

R

Ruchi Shambhavee

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

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.

R

Ruchi Shambhavee

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

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.

L

Lalit Patel

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

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

R

Rahul Yadav

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

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

G

Gaurav

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

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

P

Pawan Kumar

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

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

R

Ravi Jangra

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

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.

P

Puneet Arora

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

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

H

Himanchal Sahu

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

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.

P

Praroop Bhatt

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

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.

M

Mohit Goyal

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

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.

A

Ankit Katiyar

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

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

J

Joginder

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

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

A

Ashish Kockcha

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

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

A

Arushi Verma

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

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!!!!!

C

Chandra Shekhar Kumar

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

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

S

Shubham Mishra

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

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

A

Arpita Sharma

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

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

D

Deepika

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

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

D

Divakar Uniyal

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

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.

A

Ashish Rawat

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

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

A

Abhishek Anand

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

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..

G

Gourab Roy

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

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.

A

Aditya Soni

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

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

H

Himanshu Gupta

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

Overall very good

H

Himanshu Gupta

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

Overall very good

A

Azim

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

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

R

Ridhi Narula

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

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.

R

Ratandeep Singh

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

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.

View more 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.

Pre-requisites

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)

Reviews (43) See all Reviews

M

Mallika Mahato

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

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

S

Sumit Rohj

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

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

K

Khushboo Parakh

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

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

G

G N Nikita

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

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

S

Srishti Gautam

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

Great learning experience! All the topics were covered well and focus was on making the session more...

R

Rishikesh

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

Interesting training session. Lokesh has good knowledge of the program's working and quickly helped us...

Gallery (11)

Discussions

Students Interested 3 (Seats Left 0)

₹ 5,000

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now
₹ 5,000 Enquire

Enquire

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.

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 support@urbanpro.com 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 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