Course / Course Details
Access to Computer with MS EXCEL
Welcome to the Certificate Course on Excel for Business and Finance offered by M.Com (Finance and Analytics), St Aloysius, 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. 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
Please Use the Excel Sheet named "AutoFill" for practicing during the video.
Please Use the Excel Sheet named "AutoFill" for practicing during the video.
Please Use the Excel Sheet named "AutoFill" for practicing during the video.
Please Use the Excel Sheet named "AutoFill" for practicing during the video.
Please use your solved Excel sheet named "Autofill" for practicing this lesson. Efficient Way of Selecting the entire sheet: Click on the intersection point of Column A & Row 1. (The intersection point is called "Select All" button)
Please use your solved Excel sheet named "Autofill" for practicing this lesson.
Please use your solved Excel sheet named "Autofill" for practicing this lesson.
Please use your solved Excel sheet named "Autofill" for practicing this lesson.
Please download the worksheet provided in the attachment named "Formulas, Functions and Relative and Absolute Addressing" for practice while watching the video.
Please use the attachment provided "Formulas, Functions, and Relative and Absolute Addressing" to work while watching videos
Please use the Excel attachment provided named "Formulas, Functions, and Relative and Absolute Addressing" for practice throughout this Lesson.
Please use the Excel attachment provided in Lesson 3 for practice throughout this Lesson.
Please use the Excel attachment provided named "Formulas, Functions, and Relative and Absolute Addressing" for practice throughout this Lesson.
Please use the Excel attachment provided named "Formulas, Functions, and Relative and Absolute Addressing" for practice throughout this Lesson.
Please download the Excel Attachment named "Creation of Charts" for practicing throughout the lesson.
Please use the Excel Attachment named "Creation of Charts" for practice. Please Note: For Excel 2007 and 2010 users To format chart, click or select the chart, then go to chart tool ribbon, select layout ribbon and modify chart title, gridlines, and legends as required.
Please use the Excel Attachment named "Creation of Charts" for practice.
Please download the worksheet named "IF Functions" in the attachment for practice while watching the video.
Please download the attachments named "Text Manipulation" and "Opening Text Files" for practice during the lesson.
Please use the attachments named "Text Manipulation" and "Opening Text Files" for practice during the lesson.
Please use the attachments named "Text Manipulation" and "Opening Text Files" for practice during the lesson.
Please download the Excel attachment named "Calculating Descriptive Statistics" to practice while watching.
Please use the Excel Sheet named "Calculating Descriptive Statistics" for practice
Please use the Excel Sheet named "Calculating Descriptive Statistics" for practice
Please use the Excel sheet "Statistical Regression" provided in this lesson for practice
Please use the Excel attachment "Statistical Regression" provided for practice throughout this video.
Please download the Excel attachment named "Descriptive Statistics" for practicing throughout the lesson.
Please use the Excel attachment named "Descriptive Statistics" for practicing throughout the lesson.
Please download the Excel attachment "Naming Cells" to practice while watching.
Please use the attachement named "Naming Cells" for practice.
Please use the attachement named "Naming Cells" for practice
Please use the attachment "Naming Cells" for practice.
Please use the attachment "Naming Cells" for practice.
Please use the attachment "Naming Cells" for practice.
Please use the attachment "Naming Cells" Sheet 2 for practice. How to enable “Developer Tab” for MS Excel 2007: Step 1: Click Windows Icon and then Click Excel Options Step 2: Select “Show Developer Tab in the ribbon” and Click OK. Developer Tab will appear on the toolbar.
Please use "Multi Page Budgets" Document during the lesson.
Please use attachement "Lookup" duing the lesson.
Download attachment named "Sorting Data" for practice.
Download attachment named "Sorting Data" for practice.
Use attachment named "Auto Filter" for practice.
Use attachment named "Data forms" for practice.
Use attachment named "Group and Outline Data" for practice.
Use attachment named "Subtotals" for practice.
Use attachment named "Pivot Tables" for practice.
Use attachment named "Data Mining using Pivot Tables" for practice.
Use attachment named "Data Mining using Pivot Tables" for practice.
Use attachment named "NPV-IRR" for practice.
Use attachment named "NPV-IRR" for practice.
Download attachement "XNPV" for practice.
Download attachement "XIRR" for practice.
Download attachement "Frequently used financial functions" for practice.
Download attachement "Frequently used financial functions" for practice.
Download attachement "Frequently used financial functions" for practice.
Download attachement "Frequently used financial functions" for practice.
Download attachment "Amortization Tables" for practice. Question : Consider a home loan/mortgage of Rs.600,000 to be paid off in monthly installments over a periods of 25 years, applying an interest rate of 6.00 percent. You have to create a loan amortization table for the 300 monthly payments (25 years X 12 months/years).In addition,you ,may want to calculate the cumulative interest in certain years.
Download attachment "Amortization Tables" for practice.
Download attachment "Depreciation" for practice.
Use "Naming Cells" attachement for practice.
Download attachment "Solver Add-In Optimizer" for practice.