WATPI Prep

XAT/ OMET

Interview Experiences

Admissions

Upskill

Placements

RTI Response

Rankings

Score Vs. %ile

Salaries

Stand Out In Your Career With Domain-Relevant Excel Skills

Sep 26, 2020 | 3 minutes |

Join InsideIIM GOLD

Webinars & Workshops

Compare B-Schools

Free CAT Course

Take Free Mock Tests

Upskill With AltUni

CAT Study Planner

SNAP Mock 10: Based on Slot 1&2 2024

Participants: 932

SNAP Mock 9: Based on Slot 1&2 2024

Participants: 522

SNAP Mock 8: Based on Slot 1&2 2024

Participants: 404

SNAP Mock 7: Based on Slot 1&2 2024

Participants: 343

SNAP Mock 6: Based on Slot 1&2 2024

Participants: 356

SNAP Mock 5: Based on Slot 1&2 2024

Participants: 474

SNAP Mock 4: Based on Slot 1&2 2024

Participants: 557

SNAP Mock 3: Based on Slot 1&2 2024

Participants: 735

SNAP Mock 2: Based on Slot 1&2 2024

Participants: 1034

SNAP Mock 1: Based on Slot 1&2 2024

Participants: 1679

XAT 2018 General Knowledge

Participants: 34

XAT 2019 General Knowledge

Participants: 9

XAT 2024 General Knowledge

Participants: 52

XAT 2018

Participants: 18

XAT 2019

Participants: 5

XAT Decision Making 2018

Participants: 573

XAT 2024 Decision Making

Participants: 53

XAT 2024

Participants: 33

XAT Decision Making 2021

Participants: 603

XAT 2021

Participants: 19

XAT 2021 Decision Making

Participants: 25

XAT 2023 Decision Making

Participants: 40

XAT 2022

Participants: 15

XAT 2022 Decision Making

Participants: 38

XAT 2023

Participants: 27

XAT 2020

Participants: 15

XAT 2020 Decision Making

Participants: 24

XAT 2023 General Knowledge

Participants: 38

XAT 2022 General Knowledge

Participants: 20

XAT 2021 General Knowledge

Participants: 18

There are few products and brands which have stayed relevant over decades like MS Excel. It has grown with us over generations and continues to be indispensable in our professional and even personal armory as a number-crunching powerhouse. Given Excel’s universal reach and widespread applications, you would have almost definitely meddled with it at least once. But what all of us have mostly done is just saw the tip of the iceberg. As data rapidly becomes the new gold, and every decision; from Marketing, to Finance, to Operations, to Strategy and to Human Resources, starts getting driven and backed by data, Excel becomes the trump card. With Excel Explained Masterklass by Srikant Rajan, you’ll be able to quickly start applying these advanced elements of MS Excel to your work, including domain-specific and relevant dashboards and features. You will be able to achieve your professional goals, boost productivity and improve the quality and efficiency of your work. Don't miss out on this session with Srikant, where he explained how once can analyse IPL data using Excel!
  What do you get?
  1. 4 Domain-specific live training sessions: Instructions, interactions and doubt solving in real time with the speaker
  2. Practice worksheets and ready to use templates and dashboards for each session
  3. Recording access to all the participants for the live sessions
  4. Certificate of participation to all attendees for the Live Training Workshop
  5. FREE Access to Recorded Course: “Data Management & Analysis using Excel” on Konversations.com worth INR 3999 before the workshop begins which includes:
    • On-Demand Video Lectures (12 Modules, 53 videos, 3.5 Hours Learning Content)
    • Konversations Certification for “Data Management & Analysis using Excel”
  Now that you know why each one of us requires Excel Explained Masterklass, here is the full schedule,
Date Time Topic
16.10.2020 6 pm - 7.30 pm Session 1: How to use Excel for effective project management?
17.10.2020 6 pm - 7.30 pm Session 2: How to track campaigns and utility in Excel?
18.10.2020 6 pm - 7.30 pm Session 3: How to use Excel for effective recruitment activities?
19.10.2020 6 pm - 7.30 pm Session 4: How to analyse budgets in Excel?
Sessions Price
Full Package 2850
Session 1: Projects and Operations 749
Session 2: Marketing Reporting 749
Session 3: HR Management 749
Session 4: General Management 749
You can choose any one session or the whole package. And here is the program outline,
Session Coverage Template (Post Session)
Session 1:
Projects & Operations
  1. Introduction to projects
  2. Project activities & tasks 
  3. Critical tasks & slack 
  4. Introduction to Gantt chart
    1. Business example
    2. Building a Gantt chart in Excel
    3. Refinements 
  5. Check your understanding 
  6. Final Template for Project Management 
Ready to use Gantt chart
Session 2:
Marketing Reporting  
  1. Introduction to marketing planning
  2. Commonly used terms
    1. Planning Metrics: Reach, visits & leads
    2. Campaign Metrics: Email 
  3. Creating a monthly reporting model
    1. Step wise instruction 
    2. Refinements
  4. Check your understanding 
Ready to use planning and campaign management template
Session 3:
HR Management 
  1. Introduction to HR operations
  2. Commonly used metrics in recruitment 
  3. Building a recruitment tracker
  4. Step wise instruction 
  5. Refinements
  6. Check your understanding 
Ready to use template for recruitment management
Session 4:
General Management
  1. Budgeting in business management
  2. Commonly used business terms
  3. Building a cost sheet
  4. Conducting a sensitivity analysis
  5. Introduction to tables
  6. Business dashboard basics
  7. Check your understanding
Ready to use template for budgeting and reporting

Sign Up Now 


If You Have Any Questions Regarding The Excel Explained Masterklass, Please Take A Look At This