Introduction

Prerequisites of Excel 2013 Advanced Course
WATCH ME: Essential Information for a Successful Training Experience
Course exercise files
Microsoft Excel 2013 keyboard shortcuts
Course transcripts
Downloadable course MP3 audio files

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
Radar Charts
Bubble Charts

Graphs

Regression and Scatter Chart

Pivot Charts

Creating Pivot Charts

Sparklines

Using Sparklines

Web App

Creating Workbooks using a Web App
Sharing your Workbook

Conclusion

Closing
Assessment Test

Popular Searches

Learn Microsoft Excel 2013 - Advanced

Expert

Online

₹ 399 3299

Quick Facts

Course and certificate fees

Fees information

certificate availability

certificate providing authority

The syllabus

Introduction

Functions

Personal and Professional Financial Functions

Date and Time Functions

Statistical Functions for Description, Prediction and Interference

Text Functions

Lookup Functions

Logical Functions

Connecting to External Data

Tables

Pivot Tables

Data Analysis

Charts

Graphs

Pivot Charts

Sparklines

Web App

Conclusion

Instructors

Articles

Popular Articles

Latest Articles

Similar Courses

Courses of your Interest

More Courses by Udemy

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Thank You!

Download Careers360 App

All this at the convenience of your phone