Excel at Excel with KunalStorytelling

Sept. 6, 2020, 4 p.m.
This event will be held online.

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: 

  1. Lookup and reference - VLOOKUP, Match, Index, Column, Row
  2. Dealing with Dates - Date, Day, Month, Year, Weekday, Networkdays etc...
  3. Reporting and Automation - Name Manager and Format as Tables
  4. 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. 

When: 6 Sep 2020 (4 p.m. to 6 p.m.)
Where: Google Meet

About the Host : Kunal Naik
I am into Data Science by profession, and Excel was the first tool I got introduced that fascinated me. 

When I started to work, I had other tools as my disposal, but I stuck to choose Excel to get things done. It seemed natural at first, but when I started working on specific requests, I realized I took so much time on producing each report. Many people suggested I use other tools, but I had a hunch; there was more to Excel. I knew I had to do something smarter to get things done quicker. Since then, I have 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. I mostly used YouTube back then. Today I have my channel teaching Data Science.

IMPORTANT:
- This is a LIVE session, not a pre-recorded tutorial
- For the best experience, join the workshop from your laptop/desktop
- Ensure that your internet connectivity is strong
- Log in 15 minutes prior to the workshop. This would help us work out any technical difficulties so we can start the session on time.
- If you are unable to join the session due to technical reasons, please call us on (+91-6363556436)
- This is a closed event. Only registered email ids will be allowed to join the session.

Please note that you will receive the invoice and the link of the session on your registered email id. If you fail to receive the email, you can reach out to us on [email protected] or call us on +91-6363556436 and we will send the invite to you again.

Event Location - Dialogues Live

Color Switcher

Sign In