EXCEL for Business and Finance – Batch 2
-
- Course level: All Levels
Description
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. You can watch videos on Mobile App. To download the app from Google Play Store, Click here.
The Course will begin on July 27, 2020.
The Course Ending date (Deadline) will be on September 15, 2020.
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
What Will I Learn?
- You will develop an understanding of Microsoft Excel
- You will learn how to prepare professional Excel sheets and to use Excel functions
- You will learn to use financial tools available in Excel for financial modelling
Topics for this course
Preview
Module 1: Learn to Use Excel Efficiently
Lesson 1: AutoFill
Lesson 2: How to make a selection in Excel
Lesson 3: Functions, Relative Addressing and Absolute Addressing, Formulas
Lesson 4: Naming Cells
Lesson 5:Charts
Quiz on Module 1
Module 2 : IF Functions and Text Manipulation
Lesson 6: IF Functions
Lesson 7 : Text Manipulations
Quiz on Module 2
Module 3: Statistical Tools
Lesson 8: Descriptive Statistics
Lesson 9: Frequency Distributions
Lesson 10: Statistical Regression
Lesson 11: Data Analysis Using Statistics Add – In
Quiz on Module 3
Module 4: What- if Analysis
Lesson 12 : Naming Cells for Decision Making and Modeling
Lesson 13: What – if Analysis – Goal Seek
Lesson 14: What – if Analysis – Data Tables
Lesson 15: What – if Analysis – Scroll Bars
Quiz on Module 4
Module 5: Multipage Systems and Lookups
Lesson 16: Multi-Page Budgets
Lesson 17: Lookup Tables
Quiz on Module 5
Module 6: The Data Menu and Ribbon
Lesson 18: Sorting Data
Lesson 19:Auto Filter
Lesson 20: Data Forms
Lesson 21: Group and Outline Data
Lesson 22: Subtotals
Lesson 23: Pivot Tables
Lesson 24: Data Mining using Pivot Tables
Quiz on Module 6
Module 7: Excel Financial Tools
Lesson 25: NPV and IRR – Evaluating Capital Investment
Lesson 26 : Unconventional Financial Functions – XNPV and XIRR
Lesson 27: Frequently used Financial Functions
Lesson 28: Amortization Tables
Lesson 29: Accounting Depreciation Functions
Quiz on Module 7
Module 8: Using the Solver Add-In
Lesson 30: Using Solver to go beyond Goal Seek
Lesson 31: The Solve Add-In Optimizer
Quiz on Module 8
Final Assessment
Course Evaluation
Certificate
About the instructors
2 Courses
365 students
2 Courses
0 students
2 Courses
0 students
The course is well structured, informative and interesting. The contents and presentation of lesson is very helpful for a commerce student.
Material Includes
- Recorded Video Lectures and Excel worksheets for practice
Requirements
- A system, personal computer or a laptop with Microsoft Excel 2007 and above
Target Audience
- A decision maker; a management executive; an analyst in field of finance, accounting, sales, human resourses, marketing and sales; a student interested in improving technical skills