Become Quicker at using Excel

Become Quicker at using Excel

Workshops

August 16 | 3PM

Watch us on Google Meet

100

Sorry, this show is already over but head here for other fun events!

Invite your friends

and enjoy a shared experience

INVITE

Invite your friends

and enjoy a shared experience

About the Event

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. 


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

- Get instant feedback

- Limited seats only so everyone gets personal attention from the artist / trainer

- For best experience join the workshop from your laptop / desktop or watch on phone on landscape mode.

- Ensure your internet connectivity is strong.

- Do login 10 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 attend the live session due to technical reasons, please call us (+91-6361358825)

- This is a closed event. Only registered email ids will be allowed to join the session.

Please note that you will receive the link of the session via Google Calendar Invite 1 hour prior to the session. If, for some reason, you fail to receive the email please get in touch with us on team@dialogues.space or call us on +916361358825 and we will send the invite to you again.

Terms & Conditions

100

Sorry, this show is already over but head here for other fun events!

Discover
Digital Events

We bring you online experiences to make sure you've got an exciting plan every day.

Bake a cake, get in some yoga, and stay entertained with digital events on the Paytm Insider app.

  • Unsure if you would be able to go?

    Worried your boss may cancel your holiday or your professor may put up weekend lectures? Dont worry, you can easily transfer your ticket to your friend later!

  • Going out with friends?

    Unlock rewards or cashbacks the next time you are going to an event with your friends. Just use the ‘Buy Together’ option for an event if you see one on its page.

Curated & Handpicked EventsPaytm Insider aims to give you experiences in Online worth your time and money, and hopefully, encourage you to try something new. Be it curing post-work blues or making your weekend (more) awesome, you'll find it here. Explore live events (music, comedy, theatre, art); dining experiences; weekend getaways (treks, adventure, tours, travel, cycling, amusement parks); and live sport (cricket, football, kabaddi, badminton) matches; workshops (photography, marketing, cooking, baking, painting) and more.
Music Events: Gigs & FestivalsCalling all music lovers! Watch your favourite artists, live - at festivals, club shows, gigs or concerts. Paytm Insider has the best curated music events, across genres: rock, metal, EDM, pop, fusion, hip-hop, jazz, classical, Bollywood and world, at some of the best live music venues in the country. Paytm Insider hosts several top properties, including Bacardi NH7 Weekender, Timeout, SulaFest, Mood Indigo, Gaana Crossblade Music Festival, Locals DISTRICT, Lager n Barrel, MPower Fest. Also look forward to superstars like Arijit Singh & AR Rahman hosting their tours here.
Comedy Shows & EventsWho doesn't enjoy a good laugh? You'll find the latest shows by the best Indian comedians - Zakir Khan, Kanan Gill, Biswa Kalyan Rath, Kenny Sebastian, Comicstaan finalists (Nishant Suri, Rahul Dua & others) and more, on Paytm Insider. Catch them doing tours of their specials, trying new material, hosting an open mic, and more. Catch the big names of comedy at Headliners and LOLStars; or shows to see up-and-coming comics enthrall audiences, and open mic events where you'll see and cheer on fresh talent! International legends like Russel Peters, Eddie Izzard & Bill Burr have ticketed here in the past.
Cheer Your Favourite Sports Team On!Paytm Insider is home to world-class sporting experiences across India: Vivo Indian Premier League, Indian Super League (FC Goa, Kerala Blasters, Jamshedpur FC, Mumbai City FC, Delhi Dynamos), Vivo Pro Kabaddi (Tamil Thalaivas, U Mumba, Haryana Steelers, Bengal Warriors, Jaipur Pink Panthers), I-League, Vodafone Premier Badminton League, Premier Futsal, and international cricket matches (Test, T20 and ODI). Can't get to a stadium? You'll find amazing screening experiences too - especially the EPL, Champions League and F1.
Weekend Travel: Trekking, Camping & AdventureAfter a tiring week, one of the best ways to unwind is to head to the great outdoors. You will find excellent options for trekking, camping & adventure activities like white water rafting, waterfall rappelling and paragliding near Online. Paytm Insider teams up with experienced and responsible travel groups and event organizers so you have a memorable and safe experience. These events are for novices as well as experienced folks. You will also find special seasonal experiences like fireflies, camping, rafting and more on Paytm Insider.
Discover your city with Paytm Insider
Paytm Insider

Paytm Insider is a platform that helps you discover and buy the best in events, travel and food in your city. We strive to curate experiences that are worth your time and money, possibly something you have never tried before.

For event organizers

Paytm Insider is built by the same team that created Bacardi NH7 Weekender (us) and we sure know what goes into putting together a great experience. Our technology, marketing and customer support can help you build a community of not just ticket buyers, but also fans.