MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

# Learn Microsoft Excel 2013 - Advanced

### Course Summary

Insider Method: Learn Advanced Techniques for Microsoft Excel 2013 Fast - Without Lectures, Books, or Night Classes

• +

### Course Syllabus

• Introduction
• Prerequisites of Excel 2013 Advanced Course
• Course exercise files
• Microsoft Excel 2013 keyboard shortcuts
• Course transcripts
• Functions
• List of Functions; Common Types of Arguments; Basic Use of Functions
• Advanced Aspects of Functions; Searching for a Function
• Autosum
• Personal and Professional Financial Functions
• Payment
• Future Value
• Principle Payment
• Depreciations
• Date and Time Functions
• How Dates and Times are Stored
• Dates and Times Calculation
• Exercise on Date and Time Functions; Date and Time Settings
• Statistical Functions for Description, Prediction and Interference
• Average
• Percentile
• Regression
• LINEST Function
• Example of Functions for Inferential Statistics
• Text Functions
• Text Function Case Study - 1
• Text Function Case Study - 2
• Lookup Functions
• Lookup and Reference Functions
• Logical Functions
• Logical Functions
• Connecting to External Data
• Course Review
• Connecting to Other Workbooks
• Connecting to Access Data
• Connecting to Web Data
• Tables
• Creating a Table and Changing Table Name; Filter; Removing Duplicates; Total Row
• Inserting Columns and Rows; Resizing Tables
• Table Reference
• Table Styles
• Table Selection
• Pivot Tables
• Basic Principles of Pivot Tables
• Presentational Side of Pivot Tables
• Filtering in Pivot Tables; Slices
• Data Analysis
• What if
• Scenario Manager
• Goal Seek
• Solver
• Charts
• Area Charts
• Surface Charts
• Stock Charts - Part 1
• Stock Charts - Part 2
• Bubble Charts
• Graphs
• Regression and Scatter Chart
• Pivot Charts
• Creating Pivot Charts
• Sparklines
• Using Sparklines
• Web App
• Creating Workbooks using a Web App
• Conclusion
• Closing
• Assessment Test

Course Fee:
USD 97

Self-Study

### Course Status:

Active

1 - 4 hours / week

Related Posts: