23091_EXCEL for Business and Finance
About Course
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