4.00(1)

EXCEL for Business and Finance – Batch 2

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

84 Lessons30h

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?

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.

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

Mr Joyan Dsouza Assistant Professor and Head - M.Com (Finance and Analytics) Department of Post Graduate Studies and Research in Commerce St Aloysius College (Autonomous) Kodialbail, Mangalore - 575 003, Karnataka, India. Ph: 8903838343 joyandsouza@staloysius.edu.in dsouzajoyan@gmail.com
4.96 (24 ratings)

2 Courses

365 students

4.96 (24 ratings)

2 Courses

0 students

4.96 (24 ratings)

2 Courses

0 students

Student Feedback

4.0

Total 1 Ratings

5
0 rating
4
1 rating
3
0 rating
2
0 rating
1
0 rating

The course is well structured, informative and interesting. The contents and presentation of lesson is very helpful for a commerce student.

500.00

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