Discover what you can learn.

With video courses for work, study and leisure.

Microsoft Excel 2016 (EN)

By 365 Careers

Do you want to learn how to use Excel in a real working environment?

Are you about to graduate from university and start looking for your first job?
Are you a young professional looking to establish yourself in your new position?
Would you like to become your team's go-to person when it comes to Financial Modeling in Excel? 
If you answered yes to any of these, then this is the right course for you!

A comprehensive guide to Financial Modeling in Excel: 

  • Become an Excel expert
  • Learn how to build sound Financial Models and stand out among your colleagues
  • Gain an in-depth understanding of the mechanics of Company Valuation
  • Build your files professionally
  • Demonstrate superior Excel skills at work
  • Be prepared from day one for your Investment Banking, Financial Advisory or Consulting career

By completing this course, you will:

  • Be able to work comfortably with Microsoft Excel and many of its advanced features
  • Become one of the top Excel users in your team
  • Be much quicker at carrying out regular tasks
  • Be able to build a P&L statement from a raw data extraction
  • Be able to build a cash flow statement
  • Know how to value a company
  • Be able to build a valuation model from scratch
  • Know how to create a model with multiple scenarios
  • Know how to create professional and good-looking advanced charts

Content

play symbol Microsoft Excel: Introduction
01:39
lecture locked Microsoft Excel: Course Overview
01:08
lecture locked Overview of Excel 2016
03:32
lecture locked Introduction to the Excel Ribbon
02:43
lecture locked Working with Rows and Columns
01:44
lecture locked Data Entry in Excel
03:00
lecture locked Introduction to Formatting
05:49
lecture locked Creating Formulas in Excel
02:54
lecture locked Microsoft Excel Functions
03:41
lecture locked Working with Cut, Copy and Paste
02:10
lecture locked Pasting Values, Formulas and Formats with Paste Special
01:16
play symbol Introduction to Formatting a Sheet
01:54
play symbol Tips for Faster Scrolling
01:36
lecture locked Fixing Cell References Properly
02:20
lecture locked Using the Alt plus Enter Combination
00:54
lecture locked How to Organize Excel Data
01:52
lecture locked Wrapping Text in Excel
00:43
lecture locked Using Set Print
01:17
lecture locked Find and Select Special Types of Cells
01:30
lecture locked How to Assign Dynamic Names within a Model
01:27
lecture locked Named Ranges
01:34
lecture locked Assigning Custom Formats to Specific Cells
01:34
lecture locked Excel Macros
03:04
lecture locked Create a Drop-Down List
01:49
lecture locked Sorting Multiple Columns
01:28
lecture locked Creating a Index Page
01:16
lecture locked Freeze Panes
01:12
lecture locked Keyboard Shortcuts
04:15
lecture locked Key Functions in Excel: COUNT, COUNTA, COUNTIF
04:06
lecture locked Key Functions in Excel: SUM, SUMIF, SUMIFS
04:24
lecture locked Key Functions in Excel: AVERAGE and AVERAGEIF
01:59
lecture locked Working with Text in Excel: LEFT, RIGHT, MID, UPPER
02:40
lecture locked Find the Highest and the Lowest Values in a Range
00:52
lecture locked Include ROUND in Financial Models
01:01
lecture locked Transferring Data Efficiently VLOOKUP and HLOOKUP
07:47
lecture locked Use INDEX and MATCH as a Substitute of VLOOKUP
07:27
lecture locked IFERROR to Deal Easily with Error Messages
01:43
lecture locked Excel's Dynamic and Interactive Tables Pivot Tables
02:17
lecture locked Create Flexible Financial Models: CHOOSE
02:24
lecture locked Goal Seek
02:17
lecture locked Include Sensitivity Analysis Through Data
04:10
play symbol Introduction to Charts in Excel
01:11
lecture locked Inserting Charts
02:10
lecture locked Formatting a Chart (Part 1)
02:29
lecture locked Formatting a Chart (Part 2)
03:09
lecture locked Creating a Bridge Chart
06:51
lecture locked Creating a Treemap
01:31
lecture locked Show Data Trends by Using Sparklines
03:52
lecture locked Introduction to the Profit and Loss Calculation
00:51
lecture locked Profit and Loss Calculation: Case Study
01:06
lecture locked Profit and Loss Calculation: Data of the Case Study
02:42
lecture locked Profit and Loss Calculation: Create a Clear Structure for the Case Study
02:16
lecture locked Profit and Loss Calculation: Codes for the Case Study
01:59
lecture locked Profit and Loss Calculation: Databases for the Case Study
01:58
lecture locked Using Vlookup in Order to Transfer Data
05:29
lecture locked Applying SUMIF in Order to Populate the Database with Numbers
04:06
lecture locked Demonstrating How Index and Match Can Successfully Replace VLOOKUP
03:51
lecture locked Mapping the Items Within a Database
02:16
lecture locked Mapping Exercise in the Data Sheet
01:41
lecture locked Creating the Structure of the Profit and Loss Statement
02:21
lecture locked Formatting Excel Sheets
03:17
lecture locked Populating the Profit and Loss Sheet with Figures
02:47
lecture locked Finding Mistakes
02:14
lecture locked Calculating Year on Year Growth and Percentage Incidence
03:08

Details

  • Included lectures: 64
  • Duration: 2:45 h
  • Available documents: 170

These courses may be of interest to you

Authors of course Microsoft Excel 2016 (EN)

 365 Careers

365 Careers

365 Careers specializes in online courses in Finance, Management, Data Science and other fields. The company's courses produced have been taken by more than 400,000 students across 210 countries.

Customer reviews

(1)
5,0 of 5 stars
5 Stars
5
4 Stars
0
3 Stars
0
2 Stars
0
1  Star
0