Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Learn Microsoft Excel 2013 - Advanced
Introduction
Prerequisites of Excel 2013 Advanced Course (9:55)
Course Exercise Files
Functions
List of Functions; Common Types of Arguments; Basic Use of Functions (13:38)
Advanced Aspects of Functions; Searching for a Function (11:00)
Autosum (6:18)
Personal and Professional Financial Functions
Payment (12:48)
Future Value (11:17)
Principle Payment (12:01)
Depreciations (13:25)
Date and Time Functions
How Dates and Times are Stored (11:57)
Dates and Times Calculation (12:45)
Exercise on Date and Time Functions; Date and Time Settings (7:25)
Statistical Functions for Description, Prediction and Interference
Average (13:05)
Percentile (10:21)
Regression (14:02)
LINEST Function (9:49)
Example of Functions for Inferential Statistics (12:39)
Text Functions
Text Function Case Study - 1 (14:26)
Text Function Case Study - 2 (10:35)
Lookup Functions
Lookup and Reference Functions (15:43)
Logical Functions
Logical Functions (15:59)
Connecting to External Data
Connecting to Other Workbooks (16:04)
Connecting to Access Data (14:11)
Connecting to Web Data (10:18)
Tables
Creating a Table and Changing Table Name; Filter; Removing Duplicates; Total Row (13:48)
Inserting Columns and Rows; Resizing Tables (15:02)
Table Reference (9:18)
Table Styles (7:07)
Table Selection (4:08)
Pivot Tables
Basic Principles of Pivot Tables (14:58)
Presentational Side of Pivot Tables (15:40)
Filtering in Pivot Tables; Slices (14:06)
Data Analysis
What if (15:32)
Scenario Manager (14:06)
Goal Seek (7:51)
Solver (14:38)
Charts
Area Charts (10:39)
Surface Charts (7:40)
Stock Charts - Part 1 (12:27)
Stock Charts - Part 2 (12:47)
Radar Charts (5:08)
Bubble Charts (10:20)
Graphs
Regression and Scatter Chart (7:00)
Pivot Charts
Creating Pivot Charts (12:32)
Sparklines
Using Sparklines (15:30)
Web App
Creating Workbooks using a Web App (15:15)
Sharing your Workbook (10:00)
Conclusion
Closing (0:19)
Course Quiz and Certificate of Completion
Downloadable course MP3 audio files
MP3 audio files
Course Transcripts
Advanced Aspects of Functions; Searching for a Function
Complete and Continue