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
Example of Functions for Inferential Statistics
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock