Competitions

CAT Prep

Upskill

Placements

MBA Co'26

RTI Response

Rankings

Score Vs. %ile

Salaries

Campus Tour

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

Final 19 Days to CAT 2024 Test-26

Participants: 126

Final 20 Days to CAT 2024 Test-26

Participants: 176

Final 21 Days to CAT 2024 Test-25

Participants: 145

Final 22 Days to CAT 2024 Test-24

Participants: 164

Final 23 Days to CAT 2024 Test-23

Participants: 102

Final 24 Days to CAT 2024 Test-22

Participants: 154

Final 25 Days to CAT 2024 Test-21

Participants: 144

Final 26 Days to CAT 2024 Test-20

Participants: 193

Final 27 Days to CAT 2024 Test-19

Participants: 170

Final 28 Days to CAT 2024 Test-18

Participants: 168

Final 29 Days to CAT 2024 Test-17

Participants: 175

Final 30 Days to CAT 2024 Test-16

Participants: 193

Final 31 Days to CAT 2024 Test-15

Participants: 183

Final 32 Days to CAT 2024 Test-14

Participants: 190

Final 33 Days to CAT 2024 Test-13

Participants: 191

Final 34 Days to CAT 2024 Test-12

Participants: 226

CAT 2017 VARC SLOT- 2

Participants: 311

CAT 2017 DILR SLOT- 2

Participants: 155

CAT 2017 VARC SLOT- 1

Participants: 297

CAT 2017 DILR SLOT- 1

Participants: 105

CAT 2017 QUANT SLOT 1

Participants: 151

CAT 2017 QUANT SLOT 2

Participants: 69

CAT 2018 QUANT SLOT 2

Participants: 65

CAT 2018 QUANT SLOT 1

Participants: 106

CAT 2018 DILR SLOT- 2

Participants: 57

CAT 2018 DILR SLOT- 1

Participants: 81

CAT 2018 VARC SLOT- 2

Participants: 202

CAT 2018 VARC SLOT- 1

Participants: 294

Final 35 Days to CAT 2024 Test-11

Participants: 154

Final 36 Days to CAT 2024 Test-10

Participants: 130

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