Entdecken Sie, was Sie lernen können.

Mit Videokursen für Beruf, Studium und Freizeit.

Microsoft Excel 2016 (EN)

Von 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

Inhalte

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 Workig 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

  • Enthaltene Vorträge: 64
  • Laufzeit: 2:45 h
  • Enthaltene Lernmaterialien: 170

Dozenten des Kurses Microsoft Excel 2016 (EN)

 365 Careers

365 Careers

365 Careers specializes in on-line 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.

Rezensionen

(1)
5,0 von 5 Sternen
5 Sterne
5
4 Sterne
0
3 Sterne
0
2 Sterne
0
1  Stern
0