1. Online learning

Discover what you can learn.

With video courses for work, study and leisure.

Microsoft Excel 2016 (EN)

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

Microsoft Excel: Basics (EN)

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

Microsoft Excel: Best Practices and Tools (EN)

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

Microsoft Excel: Functions (EN)

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

Microsoft Excel: Professional Charts (EN)

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

Microsoft Excel: Profit and Loss Calculations (EN)

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

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


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

© 2024 Lecturio GmbH. All rights reserved.

Direct contact to top experts
Mobile availability
100% Money-Back Guarantee