loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

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 email

Please enter valid 10 digit Phone Number

Note: Please enter the phone number that you want to receive a call on.

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

Share

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

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

Patel Nagar, Delhi

5,000

43 Reviews
3 Interested

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)
Gallery
Reviews

Mallika Mahato

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

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


Sumit Rohj

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

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


Khushboo Parakh

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

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


Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


Recommendations & reviews from previous Customers:

Mallika Mahato

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

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


Sumit Rohj

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

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


Khushboo Parakh

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

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


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

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


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

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


Rishikesh

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

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


Darpan Singhal

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

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


Monica Jujjavarapu

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

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


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

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


Shubham Rana

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

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


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

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


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

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


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

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


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

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


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

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


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

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


Lalit Patel

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

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


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 "

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


Gaurav

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

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


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

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


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

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


Puneet Arora

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

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


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

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


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

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


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

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


Ankit Katiyar

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

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


Joginder

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

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


Ashish Kockcha

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

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


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

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


Chandra Shekhar Kumar

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

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


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 "

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


Arpita Sharma

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

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


Deepika

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

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


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

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


Ashish Rawat

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

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


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

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


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

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


Aditya Soni

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

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


Himanshu Gupta

"Overall very good "

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


Himanshu Gupta

"Overall very good "

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


Azim

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

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


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

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


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

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


Date and Time

Not decided yet.

About the Trainer

Lokesh Lalwani picture

Lokesh Lalwani

Microsoft Certified Trainer


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

Students Interested 3

Course Id: 21128