Fast Excel for MBA's, Working Professionals, Business Owners
3.0 (15 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,128 students enrolled

Fast Excel for MBA's, Working Professionals, Business Owners

Excel for Students, Professionals and Entrepreneurs in less than 45 minutes
3.0 (15 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,128 students enrolled
Created by Jeep Finance
Last updated 1/2019
English
Price: Free
This course includes
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What you'll learn
  • Learn the most common and basic Excel functions used in the Office
  • Build a base understanding on the Basics of Microsoft Excel

  • Access to a MBA with many years of experience in Excel

  • Creating effective worksheets for your small businesses
  • Presented with high-quality video lectures, this Excel course will visually show you how to start working in Excel.
Requirements
  • This course was created with Microsoft Excel for Office 365. But all features will work in Excel 2010, 2013, 2016 and most will work in 2007.
  • All you need is a PC/MAC, a copy of Excel 2007, 2010, 2013 or 2016, and a willingness to learn! No other knowledge is required, as each step is explained fully in the course.
Description

This course is aimed for working professionals and entrepreneurs who would like to strengthen their spreadsheet skills. We will cover various types of functions, shortcuts and hotkeys, and also present different business situations where Microsoft Excel can be applied. Advanced topics include: Common-Size Income Statements, Currency Exchange Rates with Absolute Cell Referencing, and Sensitivity Analysis for Compensation Packages.

We want to give you the tools to build your confidence and start your own business and give you the skills required to succeed at any desk job. We aspire to use an integrated learning to advance finance education and we have over +10 years of experience in Finance, Excel, Banking and come from top business schools in the world.

Who this course is for:
  • Working Professionals
  • Business Entrepreneurs
  • This course is aimed at complete beginners, or those who want to get a base knowledge of Excel and ways to apply this to Business
Course content
Expand all 25 lectures 57:19
+ Introductory Excel
1 lecture 03:44

Graphical User Interface when using Microsoft Excel.

Introduction to Excel and the Excel Layout
03:44
+ Financial Statement Analysis
4 lectures 04:14

This video will teach you how to project revenue increases that a business can generate over time.

Financial Statement Analysis: Projecting Revenue Increases
00:55

This video will teach you how to calculate percentage change for a growing business.

Financial Statement Analysis: Calculating Percentage Change
01:07

This video teaches you how to calculate the Gross Profit of a business.

Financial Statement Analysis: Calculating Gross Profit
00:46

This business teaches you how to calculate the Gross Margins of a business.

Financial Statement Analysis: Calculating Gross Margin
01:26
+ Hotkeys
5 lectures 06:03

This video teaches you how to use the excel shortcuts and hotkeys to create a new workbook on a MAC.

Hotkeys - Creating a New Workbook
00:47

This video teaches you how to use the excel shortcuts and hotkeys to toggle worksheets in a workbook on a MAC.

Hotkeys - Toggling Worksheets in a Workbook
01:43

This video teaches you how to use the excel shortcuts and hotkeys to send print instructions on a MAC.

Hotkeys - Sending Print Instructions
01:04

This video teaches you how to use the Copy and Paste Formatting shortcuts/hotkeys.

Hotkeys - Using the COPY and PASTE Formatting Shortcuts on Excel
01:25

This video teaches you how to use the excel shortcuts and hotkeys to cut and paste on a MAC.

Hotkeys - Using the CUT and PASTE Formatting Shortcuts on Excel
01:04
+ Functions
9 lectures 15:50

This video will teach you about the structure of a function in Microsoft Excel.

Understanding the Structure of a Function
03:25

This video teaches you how to use the AVERAGE function for analyzing the revenue of a business.

Function: Using the AVERAGE function to Calculate Average Revenue
00:52

This video teaches you how to use the SUM function to add revenue in the business.

Function: Using the SUM Function to Add Revenues
00:43
Quick Quiz #2
1 question

This video teaches you how to use the MEDIAN function in excel when looking at Revenue statistics.

Function: Using the MEDIAN Function in Excel
01:38

This video teaches you how to use the MIN and MAX functions to calculate revenue ranges of a business.

Function: Using the MIN and MAX functions to calculate ranges
00:56

Using the ABS Function in Microsoft Excel.

Function: Using the ABSOLUTE VALUE Function in Excel
01:33
Quick Quiz #3
1 question

Using the RANDOM Function in Microsoft Excel.

Function: Using the RANDOM Function in Excel
03:27

This video teaches you how to use the COUNT function in Excel.

Function: Using the COUNT Function in Excel
00:51

Please select the correct answer choice.

Quick Quiz #1
1 question

This video teaches you how to use the COUNT function in Excel.

Function: Using IF and THEN on Microsoft Excel
02:25
+ Excel Application into Advanced Business Situations
6 lectures 27:28

Using Cell References for Currency Exchange Rate Fluctuations.

Advanced - Currency Exchange Rate Calculations: Using Absolute Cell Referencing
06:13
Advanced - Compensation Structure: Using Data to Create Sensitivity Analysis
05:16

Creating Common-Size Income Statements in Excel.

Advanced - Analyzing Cost Drivers via Common-Size Income Statements in Excel
07:15

Using Goal Seek when assessing the profitability targets.

Advanced - Goal Seek in Basic Business Case Scenario
02:06

Using Goal Seek when Structuring the Coupon Payments for your Loan.

Advanced - Goal Seek in Advanced Business Case Scenario
06:10

Please see link: https://www.udemy.com/principles-of-stock-trading/?couponCode=NINETY-OFF

Bonus Lecture - Coupon Codes
00:28