Welcome to the Certificate Course on Excel for Business and Finance offered by the Department of M.Com (Finance and Analytics), St Aloysius College (Autonomous), Mangaluru. In this course, we will take you through a journey from basics to best practices in analytics using Microsoft Excel.

Excel for Business and Finance enables you to utilize Microsoft Excel for the business environment. You will learn how to use Microsoft Excel efficiently using functions, shortcuts, decision making tools, What-If analysis, statistical tools, multi-page systems and look ups, data menu and ribbon, financial tools, and solver add-in, in over 8 Modules consisting of 31 Lessons. This course will cover lessons of the book “Next Generation Excel: Modeling in Excel for Analysts and MBA’s” by Isaac Gottlieb.

We have refined the course content to suit learners from diverse backgrounds to help you enhance your practical and analytical skills. We hope you find this course both useful and engaging. The course will be self-paced. You can watch videos anytime. However, it is necessary to complete the Module Quizzes and Final Assessment before the course deadline. A preview of the course videos is provided to you below under “Topics for this course” section. For further clarification, contact +91 89038 38343.

The Course Content is as follows:

Module 1: How to Use Excel Efficiently

Lesson 1: AutoFill

Lesson 2: Selection

Lesson 3: Formulas, Functions, Relative and Absolute Addressing

Lesson 4: Naming Cells and Ranges

Lesson 5: Excel Charts

Module 2: If Functions and Text Manipulations

Lesson 6: IF Functions

Lesson 7: Text Manipulation

Module 3: Statistical Tools

Lesson 8: Descriptive Statistics

Lesson 9: Frequency Distribution

Lesson 10: Statistical Regression

Lesson 11: Data Analysis – Statistics Add-in

Module 4: What-if Analysis

Lesson 12: Naming Cells for Decision Making

Lesson 13: What-if Analysis and Goal Seek

Lesson 14: Sensitivity Analysis – One-Way and Two-Way Data tables

Lesson 15: Scroll Bars

Module 5: Multi-Page Systems and Lookups

Lesson 16: Multiple Budgets

Lesson 17: Lookup Tables

Module 6: Data Menu and Ribbon

Lesson 18: Sorting Data

Lesson 19: AutoFiller

Lesson 20: Data forms and features eliminated in Excel 2007

Lesson 21: Group and Outline Data

Lesson 22: Subtotals

Lesson 23: Pivot Tables

Lesson 24: Data Mining using Pivot Tables

Module 7: Excel Financial Tools

Lesson 25: NPV and IRR

Lesson 26: XNPV and XIRR

Lesson 27: Frequently used Financial Functions

Lesson 28: Amortization Tables

Lesson 29: Accounting Depreciation Functions

Module 8: Using the Solver Add-In

Lesson 30: Beyond Goal Seek

Lesson 31: The Solver Add-In Optimizer