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

WAT 2025- Should OTT and YT be censored?

Participants: 31

WAT 2025: Mahakumbh

Participants: 43

WAT 2025: ChatGPT vs. DeepSeek

Participants: 44

NMIMS Competency Test 10 (Updated)

Participants: 391

NMIMS Competency Test 9 (Updated)

Participants: 282

NMIMS Competency Test 8 (Updated)

Participants: 250

NMIMS Competency Test 7 (Updated)

Participants: 240

NMIMS Competency Test 6 (Updated)

Participants: 257

NMIMS Competency Test 5 (Updated)

Participants: 322

NMIMS Competency Test 4 (Updated)

Participants: 364

NMIMS Competency Test 3 (Updated)

Participants: 456

NMIMS Competency Test 2 (Updated)

Participants: 704

NMIMS Competency Test 1 (Updated)

Participants: 1037

DILR 2022 - Test 19

Participants: 7

QA 2022 - Test 19

Participants: 9

VARC 2022 - Test 20

Participants: 20

VARC 2022 - Test 21

Participants: 16

QA 2022 - Test 20

Participants: 8

DILR - Trail

Participants: 0

CMAT 2022

Participants: 23

CMAT 2018 SLOT 2

Participants: 2

CMAT 2018 SLOT 1

Participants: 8

CMAT 2019 SLOT 1

Participants: 10

CMAT 2020 SLOT 1

Participants: 1

CMAT 2021 SLOT 2

Participants: 14

CMAT 2021 SLOT 1

Participants: 21

CMAT 2023 SLOT 2

Participants: 28

CMAT 2023 SLOT 1

Participants: 47

CMAT 2024 SLOT 2

Participants: 55

CMAT 2024 SLOT 1

Participants: 59

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