5.00
(5 Ratings)

23091_EXCEL for Business and Finance

Wishlist Share
Share Course
Page Link
Share On Social Media

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

Show More

What Will You 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

Course Content

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 1 (25 Marks)

Module 2 : IF Functions and Text Manipulation
Learn how to use IF functions, and to import data from other sources.

Lesson 6: IF Functions

Lesson 7 : Text Manipulations
Learn how to separate continuous data into columns.

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 2

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

Student Ratings & Reviews

5.0
Total 5 Ratings
5
5 Ratings
4
0 Rating
3
0 Rating
2
0 Rating
1
0 Rating
NF
2 months ago
The business Excel course provided comprehensive training on essential Excel functions and tools, enhancing efficiency in data analysis and financial modeling. It effectively equipped me with practical skills for real-world business applications.
AN
3 months ago
Good
WJ
4 months ago
Very helpful and knowledgeable
SP
8 months ago
It was very helpful for me i learnt all necessary knowledge required to use excel
KU
10 months ago
One of the best practical course that I have joined. Teaching is very easy and it is very easy for the learner to understand the teaching.