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

Fast Excel for MBA's, Working Professionals, Business Owners, available at Free, has an average rating of 4.2, with 25 lectures, 3 quizzes, based on 184 reviews, and has 9871 subscribers.

You will learn about 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. This course is ideal for individuals who are Working Professionals or Business Entrepreneurs or 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 It is particularly useful for Working Professionals or Business Entrepreneurs or 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.

Enroll now: Fast Excel for MBA's, Working Professionals, Business Owners

Summary

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

Price: Free

Average Rating: 4.2

Number of Lectures: 25

Number of Quizzes: 3

Number of Published Lectures: 25

Number of Published Quizzes: 3

Number of Curriculum Items: 28

Number of Published Curriculum Objects: 28

Original Price: Free

Quality Status: approved

Status: Live

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

Who Should Attend

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

Target Audiences

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

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.

Course Curriculum

Chapter 1: Introductory Excel

Lecture 1: Introduction to Excel and the Excel Layout

Chapter 2: Financial Statement Analysis

Lecture 1: Financial Statement Analysis: Projecting Revenue Increases

Lecture 2: Financial Statement Analysis: Calculating Percentage Change

Lecture 3: Financial Statement Analysis: Calculating Gross Profit

Lecture 4: Financial Statement Analysis: Calculating Gross Margin

Chapter 3: Hotkeys

Lecture 1: Hotkeys – Creating a New Workbook

Lecture 2: Hotkeys – Toggling Worksheets in a Workbook

Lecture 3: Hotkeys – Sending Print Instructions

Lecture 4: Hotkeys – Using the COPY and PASTE Formatting Shortcuts on Excel

Lecture 5: Hotkeys – Using the CUT and PASTE Formatting Shortcuts on Excel

Chapter 4: Functions

Lecture 1: Understanding the Structure of a Function

Lecture 2: Function: Using the AVERAGE function to Calculate Average Revenue

Lecture 3: Function: Using the SUM Function to Add Revenues

Lecture 4: Function: Using the MEDIAN Function in Excel

Lecture 5: Function: Using the MIN and MAX functions to calculate ranges

Lecture 6: Function: Using the ABSOLUTE VALUE Function in Excel

Lecture 7: Function: Using the RANDOM Function in Excel

Lecture 8: Function: Using the COUNT Function in Excel

Lecture 9: Function: Using IF and THEN on Microsoft Excel

Chapter 5: Excel Application into Advanced Business Situations

Lecture 1: Advanced – Currency Exchange Rate Calculations: Using Absolute Cell Referencing

Lecture 2: Advanced – Compensation Structure: Using Data to Create Sensitivity Analysis

Lecture 3: Advanced – Analyzing Cost Drivers via Common-Size Income Statements in Excel

Lecture 4: Advanced – Goal Seek in Basic Business Case Scenario

Lecture 5: Advanced – Goal Seek in Advanced Business Case Scenario

Lecture 6: Bonus Lecture – Coupon Codes

Instructors

Jeep Finance
Finance & Investments

Rating Distribution

1 stars: 16 votes
2 stars: 10 votes
3 stars: 50 votes
4 stars: 59 votes
5 stars: 49 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu