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 2 Days to CAT 2024 Test-44

Participants: 312

Final 3 Days to CAT 2024 Test-43

Participants: 286

Final 4 Days to CAT 2024 Test-42

Participants: 346

Final 5 Days to CAT 2024 Test-41

Participants: 366

Final 6 Days to CAT 2024 Test-40

Participants: 345

Final 7 Days to CAT 2024 Test-39

Participants: 340

Final 8 Days to CAT 2024 Test-38

Participants: 316

Final 9 Days to CAT 2024 Test-37

Participants: 326

Final 10 Days to CAT 2024 Test-36

Participants: 288

Final 11 Days to CAT 2024 Test-35

Participants: 490

Final 12 Days to CAT 2024 Test-34

Participants: 335

Final 13 Days to CAT 2024 Test-33

Participants: 295

Final 14 Days to CAT 2024 Test-32

Participants: 277

Final 15 Days to CAT 2024 Test-31

Participants: 364

Final 16 Days to CAT 2024 Test-30

Participants: 293

Final 17 Days to CAT 2024 Test-29

Participants: 311

Final 18 Days to CAT 2024 Test-28

Participants: 342

Final 19 Days to CAT 2024 Test-26

Participants: 338

Final 20 Days to CAT 2024 Test-26

Participants: 306

Final 21 Days to CAT 2024 Test-25

Participants: 252

Final 22 Days to CAT 2024 Test-24

Participants: 268

Final 23 Days to CAT 2024 Test-23

Participants: 180

Final 24 Days to CAT 2024 Test-22

Participants: 226

Final 25 Days to CAT 2024 Test-21

Participants: 223

Final 26 Days to CAT 2024 Test-20

Participants: 277

Final 27 Days to CAT 2024 Test-19

Participants: 232

Final 28 Days to CAT 2024 Test-18

Participants: 235

Final 29 Days to CAT 2024 Test-17

Participants: 245

Final 30 Days to CAT 2024 Test-16

Participants: 280

Final 31 Days to CAT 2024 Test-15

Participants: 277

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