This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel 2016: Beginner to intermediate training
Welcome! Course Introduction
What does the course cover ? (1:42)
Introduction to Excel
Overview of Excel 2016 (3:32)
Basic Manipulations with Rows & Columns (1:44)
The Excel Ribbon (2:43)
Data Entry in Excel (3:00)
Introduction to Formatting (5:49)
Introduction to Excel Formulas (2:54)
Introduction to Excel Functions (3:41)
Cut, Copy & Paste (2:10)
Paste Special (1:16)
Basic Operations in Excel
Useful tips and tools for your work in Excel
Excel Best Practices - Welcome Lecture (0:41)
Initial formatting of an Excel sheet in order to render it professional (1:54)
Fast scrolling through Excel sheets (1:36)
Introduction to fixing of cell references (2:20)
Using the Alt plus Enter combination (0:54)
Learn how to organize your data with Text to Columns (1:52)
Learn how to Use the Wrap Text Button (0:43)
Create easily printable documents in Excel by using Set Print Area (1:17)
Find and select types of cells with Select Special (F5) (1:45)
Learn how to assign dynamic names within a Financial Model (1:27)
Define a named range in Excel (1:34)
Assign custom formats to specific cells within a Financial Model (ex. Multiples) (1:34)
Macros are a great timesaver! Here's why! (3:04)
Create a drop=down list by using Data Validation (1:49)
Using Custom-sort in order to sort multiple columns within a table (1:28)
Create a great Index page at the beginning of your models - Hyperlinks (1:16)
Fix the top row of your table with Freeze panes (1:12)
Keyboard shortcuts in Excel
Keyboard Shortcuts Save Lots of time in Excel (4:15)
Keyboard shortcuts in Excel
Excel's key functions and functionalities made easy
Excel's Key Functions - Welcome Lecture (0:45)
Key Functions in Excel
Key Excel Functions: Sum, Sumif and Sumifs (4:24)
Key Excel Functions: Count, Counta, Countif, Countifs (4:06)
Key Excel Functions: Average and Averageif (1:59)
Elaborate text efficiently: Left, Right, Mid, Upper, Lower, Proper, Concatenate (4:29)
Find the minimum or maximum value in a range of cells in Excel (0:52)
Include Round in your Financial Models (1:01)
Learn how to transfer data efficiently in Excel: Vlookup and Hlookup (7:44)
Index, Match and their combination - the perfect substitute of Vlookup (7:27)
Using Excel's Iferror function to trap spreadsheets errors (1:43)
Learn how to render your models flexible with Choose (2:24)
Use Goal Seek in order to find the result that you are looking for (2:17)
Include sensitivity analysis in your models through Data Tables (4:10)
Excel's dynamic and interactive tables: Pivot tables (2:17)
Sumifs Exercises
Exercise - Excel's "Sumifs" function - unsolved
Exercise - Excel's "Sumifs" function - explained & solved (8:36)
Microsoft Excel's Pivot Tables in Depth
Introduction to Pivot Tables & Their Application (1:35)
Creating Pivot Tables is easy! (3:47)
Give Your Excel Pivot tables a Makeover (2:14)
Modifying and Pivoting Fields in Order to Obtain the Pivot Tables that you need (4:33)
Learn More About GetPivotData - A very important Excel Function (3:45)
An Introduction to Slicers - The moden Day Pivot Table Filters (4:20)
Case Study - Building a Complete P&L from scratch in Excel
Case Study - Build a P&L From Scratch - Welcome Lecture (1:02)
Introduction to the Case Study (0:42)
Understand your data source before you start working on it (2:42)
Order the source worksheets
Create a code: the best way to organize your data and work efficiently with it (2:04)
Learn how to create a Database (2:05)
Use Vlookup in order to fill the Database (5:32)
Use Sumif in order to complete the Database (4:22)
Use Inder & Match as substitute of Vlookup (4:14)
Mapping of the rows in the Database (2:22)
Building the structure of the P&L sheet (2:15)
Formatting sets you apart from competition in Excel - A Practical Example (3:31)
Populate the P&L sheet with Sumif (2:54)
Learn how to find mistakes with Countif (2:32)
Calculating year-on-year percentage variations the proper way (3:15)
Create professional and good-looking charts - Introduction (0:20)
Build a column stacked chart with a secondary Line axis in Excel (6:07)
Learn how to build effective Doughnut Charts in Excel (4:21)
Learn how to build an Area Chart in Excel (4:16)
Learn how to create Bridge Charts (10:56)
Course Challenge - Apply Your Skills in Practice!
Case Study - Building an FMCG Model from Scratch
Introduction to the Case Study (2:09)
Preliminary mapping of the data extraction (2:10)
Creating an output structure of the FMCG model (2:29)
Working with an SAP data extraction (3:23)
Improving the layout and appearance of the FMCG report (3:59)
Inserting formulas and automating calculations (2:30)
Creating a Master Pivot Table: The main data source for the FMCG report (1:55)
GetPivotData is great! Extracting data from the Master Pivot Table (5:45)
Combining Slicers and GetPivotData: The key to our success (3:20)
Getting fancy with Excel slicers - Good-looking Excel slicers (3:12)
This is how the report can be used in practice by high-level executives (3:59)
The Excel Ribbon
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock