Microsoft Excel for Business: Basic and Advanced

Indian Institute of Management Indore

How long?

  • 4 days
  • in person

Indian Institute of Management Indore

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Read more about Finance

Finance is an integral and most important component of any business, so everyone needs to improve their competence in this area. Finance courses will ...

Read more about Human Capital Management

In the rapidly changing global marketplace, companies that consider Human Resources as purely business-serving are inevitably falling behind. That is ...

Who should attend

Anyone who wants to learn excel or deals with excel on a regular basis.

About the course

The programme aims to teach the participants how to use Microsoft Excel tool for automation, modelling, reporting and solving several problems related to business. This is a rigorous hands-on course which is appropriate for beginners as well as proficient excel users. The exercises used in this programme are based on some commonly observed problems from different domains in management. The participants will learn not only the commands but also understand an effective approach to model and automate a given problem. We expect a significant reduction in the participants’ routine excel-related work after successful completion of this programme.

Objectives

To make the participants proficient in solving their day to day problems using Microsoft Excel.

Content

The course will cover, in-detail, the following basic and advanced topics:

  • Introduction to excel functionality (Absolute and Relative Referencing)
  • Using basic built-in functions (IF, VLOOKUP, INDEX, MATCH, COUNTIF, Text Functions )
  • Using advanced built-in functions (OFFSET, INDIRECT, Array formulae)
  • Data crunching tools (Data Tables, What-if analysis, Database functions, Pivot tables)
  • More complex excel functionality (Solver, Macros and introductory VBA)

The exercises to cover the above mentioned topics have been mainly chosen from HR, Operations, Legal, Accounting, Finance and Sales.

Experts

Harshal Lowalekar

Harshal Lowalekar is an Associate Professor in the area of Operations Management and Quantitative Techniques at the Indian Institute of Management Indore, India. He is a Fellow of the Indian Institute of Management Ahmedabad, India. He was working at W.P. Carey School of Business at Arizona State...

Microsoft Excel for Business: Basic and Advanced at Indian Institute of Management Indore

From  INR 60 000$837

Something went wrong. We're trying to fix this error.

Thank you for your application

We will contact the provider to ensure that seats are available and, if there is an admissions process, that you satisfy any requirements or prerequisites.

We may ask you for additional information.

To finalize your enrollment we will be in touch shortly.

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Read more about Finance

During Finance courses, you will get acquainted with a huge number of financial analyst tools and learn how to work with them. So, you will learn how to make and analyze financial reporting, calculate the main financial indicators of the company and ...

Read more about Human Capital Management

Basically, HR management can be defined as the effective use of human resources in an organization with the help of various management strategies. Due to the diversity of the courses, you should be aware of your needs while selecting one. Human Capit...

Because of COVID-19, many providers are cancelling or postponing in-person programs or providing online participation options.

We are happy to help you find a suitable online alternative.