Placements

MBA Co'26

CAT Prep

RTI Response

Rankings

Score Vs. %ile

Salaries

Campus Tour

Upskill

Career Show

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

CUET-PG Mini Mock 2 (By TISS Mumbai HRM&LR)

Participants: 443

CUET-PG Mini Mock 3 (By TISS Mumbai HRM&LR)

Participants: 180

CUET-PG Mini Mock 1 (By TISS Mumbai HRM&LR)

Participants: 774

MBA Admissions 2024 - WAT 1

Participants: 273

SNAP Quantitative Skills

Participants: 521

SNAP Quant - 1

Participants: 955

SNAP VARC Mini Mock - 1

Participants: 964

SNAP Quant Mini Mock - 2

Participants: 366

SNAP DILR Mini Mock - 4

Participants: 247

SNAP VARC Mini Mock - 2

Participants: 447

SNAP Quant Mini Mock - 4

Participants: 192

SNAP LR Mini Mock - 3

Participants: 254

SNAP Quant Mini Mock - 3

Participants: 211

SNAP VARC Mini Mock - 3

Participants: 302

SNAP - Quant Mini Mock 5

Participants: 55

XAT Decision Making 2020

Participants: 453

XAT Decision Making 2019

Participants: 351

XAT Decision Making 2018

Participants: 448

XAT Decision Making -10

Participants: 588

XAT Decision Making -11

Participants: 457

XAT Decision Making - 12

Participants: 417

XAT Decision Making - 13

Participants: 353

XAT Decision Making - 14

Participants: 355

XAT Decision Making - 15

Participants: 398

XAT Decision Making - 16

Participants: 469

XAT Decision Making - 17

Participants: 513

XAT Decision Making 2021

Participants: 522

LR Topic Test

Participants: 2783

DI Topic Test

Participants: 1253

ParaSummary Topic Test

Participants: 2147

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