Microsoft Excel 2016: Beginner, Intermediate, and Advanced Training
538 minutes of course content
Review course syllabus
100% money-back guarantee | Click here to read more
Course Description
This Microsoft Excel training consists of several major blocks:
- Excel for Beginners
- Excel for Intermediate users: Shortcuts, Navigation, Formatting tools, Functions
- Excel for Advanced users: Sophisticated functions, Financial modeling tools
In addition, we will provide you with two complete Case Studies. Everything that has been taught in the videos will be applied in practice. Step by step. WIth no steps skipped.
Excel is the #1 productivity software in the world. You need it if you want to get a job in Business Development, Corporate Finance, Consulting, Marketing, Data analysis, Accounting, Banking, and pretty much everywhere.
If you want to become…
- a Financial Analyst
- an Accountant
- an Auditor
- a Business Analyst
- a Financial Controller
- a Financial Manager
- a CFO
- a CEO
- an Investment Banker
- an Equity Research Analyst
- an Investor
- an Entrepreneur
- Someone who is involved with a business and would like to be successful
Then you simply have to learn Microsoft Excel. There is no way around it.
But how can you do that if you have no prior experience and you want to do it fast?
Don't worry!
Microsoft Excel 2016: Beginner, Intermediate and Advanced Training is here for you!
The most complete and comprehensive course you will find online.
After taking this course, you will be able to:
- Work comfortably with Microsoft Excel and many of its advanced features
- Be quicker at carrying out regular tasks
- Learn how to build solid financial models
- Be the #1 Excel user in your team
- Create financial models with multiple scenarios
- Use advanced Excel formulas
- Create good-looking Excel charts
This course is for professionals within the following business functions:
- Professionals working in Business and Finance
- Bankers, Financial analysts, Accountants, Financial controllers, Private equity analysts, BI analysts, Marketing analysts
- Anyone who uses Microsoft Excel in their job and would like to improve their skills significantly
-
Course Introduction - 4 Minutes
- What Does the Course Cover?
- Excel's "Tell Me" Search Bar
-
A quick introduction to the basics of Microsoft Excel 2016 - 35 Minutes
- Overview of Excel 2016
- Excel's basic features - Course notes
- The Excel 2016 Ribbon
- Working with Rows & Columns
- Data Entry in Excel
- Data-Entry-Exercise-Text
- Data-Entry-Solved
- Creating Formulas in Excel
- Formulas-Exercise-Text
- Formulas-Solved
- Introduction to Formatting
- Formatting-Exercise-Text
- Formatting-Solved
- Microsoft Excel at Its Best - Functions
- Functions-Exercise-Text
- Functions-Solved
- Work Efficiently By Using Cut, Copy & Paste
- Copy-Cut-Paste-Exercise-Text
- Copy-Cut-Paste-Solved
- Pasting Values, Formulas and Formats with Paste Special
- Copy-Cut-Paste-Exercise-Text
- Copy-Cut-Paste-Solved
-
Professional formatting sets you apart - 14 Minutes
- Let's start from scratch and create a P&L sheet
- Cell styles allows you to be faster…
-
Be 3.0x faster than average users - shortcuts and quick navigation tools - 20 Minutes
- The secret of fast scrolling: navigation and keyboard shortcuts
- Use multiple screens simultaneously
- F1 to F12 - Using Excel's function keys
- How to select visible cells only
- Beginner to Pro in Excel - Shortcuts for PC
- Beginner to Pro in Excel - Shortcuts for MAC
-
Best practices that will help you work in a professional way - 40 Minutes
- This Is How You Can Start Formatting Your Sheets in a Professional Way
- Fast Scrolling That Would Allow You to Be 3x Faster
- Fixing Cell References Properly
- Using the Alt plus Enter combination
- Learn How to Organize Your Excel Data with Text to Columns
- Wrapping Text in Excel
- Create Easily Printable Documents by Using Set Print Area
- Find and Select Special Types of Cells with Select Special (F5)
- Learn How to Assign Dynamic Names within a Model
- Assigning Custom Formats to Specific Cells (Ex. Multiples)
- Excel Formulas that Make Sense - Named Ranges
- Execute 50 Commands with a Single Click - Excel Macros
- Create a Drop-Down List by Using Data Validation
- Using Custom Sort in Order to Sort Multiple Columns within a Table
- Freeze the Title Row of Your Table - Freeze Panes
- Create a Great Index Page at the Beginning of Your Financial Models
- Useful tips & tools - PDF version
-
Key functions in Excel - 42 Minutes
- Key Functions in Excel: Count, Counta, Countif, Countifs
- Key Functions in Excel: Sum, Sumif, Sumifs
- Key Excel Functions: Average & Averageif
- Working with Text in Excel: Left, Right, Mid, Upper, Lower, Proper, Concatenate
- Find the Highest and the Lowest Values in a Range: Max & Min
- Transferring Data Efficiently: Vlookup & Hlookup
- Use Index & Match as a Substitute of Vlookup
- Create Flexible Financial Models with the Choose Function
- Include Round in Your Financial Models
- Iferror Allows You to Deal Easily with Error Mesages
- Excel functions - PDF
-
Building a Profit & Loss Statement from scratch - 60 Minutes
- Introduction to the Case Study
- This Is the data that we will use for our Exercise
- Let's Reorder our Excel sheet and create a clear structure!
- Order-a-worksheet-Unsolved
- Order-a-worksheet-Solved
- Introducing a Code: The best way to work with large amounts of data
- Creating-a-code-Unsolved
- Creating-a-code-Solved
- Finishing Touches of our Database
- Creating-a-database-Unsolved
- Creating-a-database-Solved
- Using Vlookup in Order to Transfer Data
- Vlookup-Unsolved
- Vlookup-Solved
- Applying Sumif in Order to Populate the Database with Numbers
- Sumif-Unsolved
- Sumif-Solved
- Demonstrating How Index & Match Can Successfully Replace Vlookup
- Index-Match-Unsolved
- Index-Match-Solved
- Mapping the Items Within Our Database - A Key Exercise For Financial Analysts
- Mapping-Unsolved
- Mapping-Solved
- Creating the Structure of the P&L Statement
- 11-Building-A-P-L- Unsolved
- Building-a-P-L-Solved
- Time for Some Formatting! The Secret of Creating Awesome Looking Excel Sheets
- Formatting-the-P-L-Unsolved
- Formatting-the-P-L-sheet-Solved
- Populating the P&L sheet with figures
- Populating-the-P-L-sheet-Unsolved
- Populating-the-P-L-sheet-Solved
- How do We Find Mistakes in the easiest way possible?
- Countif-Unsolved
- Countif-Solved
- Finishing Touches: Calculating Year-on-Year Growth and Percentage Incidence
- Adding-variations-Unsolved
- Adding-variations-Solved
-
Invaluable tools that will turn you into a proficient user - 27 Minutes
- Include Sensitivity Analysis In Your Model Through Data Tables
- Find the Result that You Are Looking For with Goal Seek
- Highlight key data with Excel Conditional Formatting
- Recording Macros - The perfect way to avoid repetitions
- Formatting Cells Part I - Working with data in Excel
- Formatting Cells Part II - Customize numbers the way you like
- Filter by color
-
Excel mechanics - A collection of indispensable tools - 28 Minutes
- Grouping Excel rows and columns - The correct way to do it!
- Working on multiple sheets at the same time
- Find & Replace - Our favourite Excel tool
- A great way to apply Find & Replace
- What Are Circular References in Excel?
- Circular References - An example
- Trace precedents - Display the relationship between formulas and cells
-
Advanced Excel functions - Part 1 - 35 Minutes
- What is a nested function?
- Advanced Excel functions: Index, Match, Match
- Advanced Excel functions: Indirect; Vlookup & Indirect
- Advanced Excel functions: Rows; Columns; Vlookup & Columns
- Advanced Excel functions: Vlookup & Match
- Advanced Excel functions: Choose; Vlookup & Choose
- Advanced Excel functions: Offset; Offset & Match
-
Advanced Excel Functions - Part 2 - 30 Minutes
- Financial functions: FV and PV
- Discounting Cash flows and calculating Net Present Value (NPV)
- Financial functions: IRR
- Financial functions: PMT and building a complete loan schedule
- Date functions
-
Excel Tips & Tricks - 27 Minutes
- Excel tips & tricks: Part 1
- Excel tips & tricks: Part 2
- Excel tips & tricks: Part 3
- Excel tips & tricks: Part 4
-
Financial modeling fundamentals - 23 Minutes
- What is a financial model?
- Why use a financial model?
- Financial modeling Don'ts - Worst practices we should avoid
- Financial modeling Do's - This is what solid modelers do
- The different types of models
- What is the right level of detail in a financial model?
-
Forecasting future financials - A cornerstone of financial modeling - 20 Minutes
- Forecasting guidelines: apply these principles when forecasting financials
- How to build a complete model
- Forecasting Income statement financials
- Forecasting Balance sheet financials - Part one
- Forecasting Balance sheet financials - Part two
-
Building a complete 3-statement model - 30 Minutes
- Introduction to the Exercise
- Let's create a mapping of financials
- Building an output P&L sheet
- Filling in the output P&L sheet with historical financials
- Calculating percentage variances and applying conditional formatting
- Building an output Balance sheet
- Adding the forecast period
- Using Index, Match, Match to fill in the output Balance sheet
-
Let's build a flexible model with multiple scenarios - 18 Minutes
- Calculating historical percentage ratios and use Index and Match for scenarios
- Building a flexible model with Choose & Match
- Building a flexible model with Vlookup & Columns
- Calculating historical DSO, DPO, DIO, Other assets %, and Other liabilities %
- Forecasting DSO, DPO, DIO, Other assets and Other liabilities
-
Completing the 3-statement model - 25 Minutes
- Building a Fixed asset roll forward
- Building a Financial liabilities schedule
- Building an Equity schedule
- Preparing a Cash flow structure
- Calculating Cash flows and completing the model & Congratulations
-
Excel's Pivot Tables in depth - 20 Minutes
- Pivot Tables: An Introduction
- Here is how you can create Pivot Tables
- Improving the formatting of Pivot Tables
- Obtaining the desired Pivot Table
- GetPivotData is essential when you work with Pivot Tables
- An Introduction to Slicers - The Moden Day Pivot Table Filters
-
Building an FMCG Model from Scratch - 40 Minutes
- Introduction to the exercise
- Exercise-Build-an-FMCG-Model-before
- Working with an SAP data extraction
- What we will have to do with the data before starting the exercise
- Creating an output sheet
- Exercise-Build-an-FMCG-Model-Structure
- Working on the layout of the FMCG report
- Exercise-Build-an-FMCG-Model-Layout
- Working faster through calculation automations
- Еxercise-Build-an-FMCG-Model-Adding-Calculations
- Here is how we can create a Master Pivot Table
- Exercise-Build-an-FMCG-Model-Creating-a-Pivot-Table
- GetPivotData is awesome! This is how we can extract data from the Master Pivot Table
- Exercise-Build-an-FMCG-Model-GETPIVOTDATA
- The combination of Slicers and GetPivotData - a hidden gem!
- Exercise-Build-an-FMCG-Model-Inserting-Slicers
- Improving the layout of your Pivot Table slicers
- Exercise-Build-an-FMCG-Model-Complete
- Here is how top management will use the report
- Exercise-Build-an-FMCG-Model-Complete
About the Expert

365 Careers