If you ever created a report using Excel and felt the need to be quicker, then this class is for you.
In this session, we will cover topics that will help you do things on Excel much quicker and save time for other tasks. Join us in this session to gain mastery on using Lookup and reference, dealing with dates, basic Reporting and Automation without the use of VBA. These topics provide exposure to little tips and tricks which will help you improve your Excel skills.
Broad Topics:
Lookup and reference – VLOOKUP, Match, Index, Column, Row
Dealing with Dates – Date, Day, Month, Year, Weekday, Networkdays etc…
Reporting and Automation – Name Manager and Format as Tables
Summary Functions – Sumifs, Countifs etc…
Each topic will have multiple examples for you to solve. We will first teach the concept and ask you to solve a new situation. It will help you retain what you learned better. Should you have any doubts, or want to explore more, we can provide some resources to help you improve better.
During the session, you will need Excel and files to work and practice along. We will provide the data at the start of the session. For each example, you will have a separate sheet to maintain the focus. Please be seated in a conformable place as you will be doing a lot of work during the session. We will have a small break in between for you to grab a coffee or stretch yourself.
During the session, if you have any specific doubts that will help you become quicker at the current work where you use Excel, please let us know so that we can take examples of the same.
About the Host : Kunal Naik is into Data Science by profession, and Excel was the first tool he got introduced that fascinated me. When he started to work, he had other tools as my disposal, but stuck to choose Excel to get things done. It seemed natural at first, but when he started working on specific requests, he realized he took so much time on producing each report. Many people suggested he use other tools, but he had a hunch; there was more to Excel. He knew he had to do something smarter to get things done quicker. Since then, he has always found ways to do things smarter and faster with Excel and save time to do other things or drink a Coffee with all the time remaining. While he mostly used YouTube back then. Today he has his own channel teaching Data Science.