Sign In
0

Course / Course Details

EXCEL for Business and Finance

  • Mr Joyan Dsouza image

    By - Mr Joyan Dsouza

  • 80 students
  • 30 Hours
  • (0)

Course Requirements

Access to Computer with MS EXCEL

Course Description

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

Course Outcomes

  • 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 Curriculum

  • 2 chapters
  • 58 lectures
  • 0 quizzes
  • 30 Hours total length
Toggle all chapters
1 Formulas, Relative and Absolute Addressing
18 Min

Please download the worksheet provided in the attachment for practice while watching the video.

2 Working with 3D Charts
6 Min

Please use the Excel Attachment provided in "Creation of Charts" Video for practice.

3 Formatting of Charts
4 Min

Please use the Excel Attachment provided in "Creation of Charts" Video 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.

4 Creation of Charts
9 Min

Please download the Excel Attachment provided in this video for practicing throughout the lesson.

5 Name Menu and Name Manager
13 Min

Please use the Excel attachment provided in Lesson 3 for practice throughout this Lesson.

6 Naming a Range of Cells - Example
8 Min

Please use the Excel attachment provided in Lesson 3 for practice throughout this Lesson.

7 Naming a Range of Cells
8 Min

Please use the Excel attachment provided in Lesson 3 for practice throughout this Lesson.

8 Naming a Single Cell
7 Min

Please use the Excel attachment provided in Lesson 3 for practice throughout this Lesson.

9 Other Functions
9 Min

Please use the attachment provided for the lesson to work while watching videos

10 Introduction to AutoFill and Customs List
6 Min

Please Use the Excel Sheet named "AutoFill" for practicing during the video.

11 Extend and Add Mode
11 Min

Please use your solved Excel sheet of Lesson 1 for practicing this lesson.

12 Selection Shortcuts
10 Min

Please use your solved Excel sheet of Lesson 1 for practicing this lesson.

13 Selecting a Section
2 Min

Please use your solved Excel sheet of Lesson 1 for practicing this lesson.

14 Selecting an Entire Sheet
6 Min

Please use your solved Excel sheet of Lesson 1 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)

15 AutoFill Options and Right Drag AutoFill
9 Min

Please Use the Excel Sheet named "AutoFill" for practicing during the video.

16 Create Customs List
6 Min

Please Use the Excel Sheet named "AutoFill" for practicing during the video.

17 Illustration For AutoFill
7 Min

Please Use the Excel Sheet named "AutoFill" for practicing during the video.

18 Approximate Match Lookup
5 Min

19 Exact Match Lookup
5 Min

20 Multi-Page Budgets Summary sheet
4 Min

21 Multidimensional Excel Workbook
7 Min

22 Scroll Bars (Continuation)
3 Min

23 Scroll Bars
17 Min

24 What-if Analysis example
7 Min

25 Two way Data Table
4 Min

26 One way Data Table
11 Min

27 Goal Seek - Example
18 Min

28 Goal Seek
18 Min

29 Naming Cells - for Decision Making and Modeling
13 Min

Please download the Excel attachment provided with this video below to practice while watching.

30 Frequency Distribution using Histogram
4 Min

Please use the Excel attachment provided in Lesson for practice

31 Descriptive Statistics
9 Min

Please download the Excel attachment provided in this video for practicing throughout the lesson.

32 Linear Regression using Excel Functions
8 Min

Please use the Excel attachment provided in Lesson 10 for practice throughout this video.

33 Regression Using Scatter Chart
5 Min

Please use the Excel sheet provided in this lesson for practice

34 Frequency Distribution Charts
6 Min

Please use the Excel Sheet provided in Lesson 8 for practice

35 Frequency Distribution Tables
9 Min

Please use the Excel sheet provided in Lesson 8 for practice.

36 Calculating Descriptive Statistics
15 Min

Please download the Excel attachment provided with this video below to practice while watching.

37 Example
6 Min

Please use the Excel attachment provided in Video "Text to Column Wizard" for practice during this video.

38 Opening Text Files
6 Min

Please  download the attachments provided in the first video. The text file attached in the previous video will be used during this video.

39 Text to Column Wizard
7 Min

Please download both the attachments for practice during Lesson 7.

40 Nested IF Function Example
9 Min

41 Nested IF Functions
8 Min

42 Simple IF Functions
15 Min

Please download the worksheet provided in the attachment for practice while watching the video.

43 Simple IF Function Example
13 Min

1 IRR
5 Min

2 NPV
10 Min

3 Grouping Data
7 Min

4 3D Column Chart in Pivot Table
7 Min

5 Pivot Tables
7 Min

6 Copying Grouped Data
7 Min

7 Applying Subtotal to Multiple Categories
7 Min

8 Applying Subtotal to Single Data
7 Min

9 Clearing Outline
2 Min

10 Grouping and Outlining Data
7 Min

11 Working with Data Forms
4 Min

12 Data Form Activation
4 Min

13 Auto Filter
11 Min

14 Custom List for Sorting Data
4 Min

15 Sorting Data
11 Min

Instructor

Mr Joyan Dsouza

0 Rating
0 Reviews
85 Students
2 Courses

Course Full Rating

0

Course Rating
(0)
(0)
(0)
(0)
(0)

No Review found

Sign In or Sign Up as student to post a review

Student Feedback

Course you might like

Beginner
STOCK MARKET OPERATIONS
0 (0 Rating)
85 Students
This Stock market course provide essential knowledge for anyone looking to invest or pursue a career in finance. Introdu...
₹500.00
cart
Beginner
Tourism Operations
0 (0 Rating)
60 Students
Module -1: Introduction to Tourism & Different types and forms of tourism (15 hours)Tourism- Meaning and Definition; Sig...
₹500.00
cart

You must be enrolled to ask a question

Students also bought

Comprehensive Investment Strategies
Beginner
  • 0 Lectures
  • 30 Hours
  • 0 (0 Rating)
  • 84 Students
  • ₹500.00
cart
INTEGRATED ADVERTISING AND DIGITAL MARKETING
Beginner
  • 13 Lectures
  • 30 Hours
  • 0 (0 Rating)
  • 80 Students
  • ₹500.00
cart
STOCK MARKET OPERATIONS
Beginner
  • 0 Lectures
  • 30 Hours
  • 0 (0 Rating)
  • 85 Students
  • ₹500.00
cart
TRAVEL AND TOURISM MANAGEMENT
Beginner
  • 13 Lectures
  • 30 Hours
  • 0 (0 Rating)
  • 80 Students
  • ₹500.00
cart
PERSONAL INVESTMENT AND TAX PLANNING
Intermediate
  • 14 Lectures
  • 30 Hours
  • 5 (1 Rating)
  • 80 Students
  • ₹500.00
cart
A SIMPLE GUIDE TO STOCK MARKET FOR BEGINNERS
Beginner
  • 28 Lectures
  • 30 Hours
  • 0 (0 Rating)
  • 88 Students
  • ₹500.00
cart
All Slots Filled

  • Duration 30 Hours

  • Lectures 58 lessons

  • Enrolled 80 students

  • Category: School of Commerce, Finance and Accountancy

  • 0 Quizzes

  • Language: English

  • Skill Level Beginner

  • Certificate of Completion

  • Full lifetime access

Remove Coupon
Coupon Applied!

More Courses by Author

Discover Additional Learning Opportunities

View All
Static
EXCEL for Business and Finance
0 (0 Ratings)
80 Students
Welcome to the Certificate Course on Excel for Business and Finance offered by M.Com (Finance and An...
₹500.00 ₹1,000.00
cart
Static
Diploma Course in Investment Management
0 (0 Ratings)
5 Students
Are you ready to take control of your financial future and make informed investment decisions? Enrol...
₹3,000.00 ₹6,000.00
cart

Shopping Cart

Loading...