Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Learn Microsoft Excel 2013 - Advanced to your Wishlist.

Add to Wishlist

Learn Microsoft Excel 2013 - Advanced

Insider Method: Learn Advanced Techniques for Microsoft Excel 2013 Fast - Without Lectures, Books, or Night Classes
4.5 (96 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
6,168 students enrolled
Created by Simon Sez IT
Last updated 1/2017
$10 $100 90% off
4 days left at this price!
30-Day Money-Back Guarantee
  • 9 hours on-demand video
  • 3 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?

Master Excel's Powerful Data Functions in this Information-Packed 9-hour Video Training.

  • Personal and Professional Financial Functions
  • Statistical Functions for Description, Prediction and Interference
  • Connecting to External Data
  • Tables, Charts and Pivots
  • Data Analysis

The Versatility of Excel

If you have already been using Microsoft Excel then you know that the calculation, graphing and tables available help you track, manipulate and report important data. There is more to excel than a few SUMs, though, and this is the training course to get you into the advanced uses of Excel so you can really use the data and numbers you are tracking to your advantage.

This course is designed for students that are already familiar with Excel, but wish to improve their skills and open the possibilities with this versatile spreadsheet program. Bring your basic knowledge of Excel 2013 or previous software versions to this class and learn how to reach the next level of database tracking and reporting.

Contents and Overview

Through 52 lectures and over 12.5 hours of content, this course will take you through learning how to use functions in everyday work environments. Personal and professional financial functions are covered including payments, future value and depreciations. Students will learn statistical functions like averages, percentiles, and regression.

In order to improve efficiency, students will also cover concepts for connecting to external data like other workbooks or web data; tables including style, selection and sizing. Pivot tables and data analysis will be key concepts helpful to the work environment.

For help with reporting, students will learn surface charts, stock charts, radar charts and bubble charts and graphs. Lastly, students will cover important web applications.

Upon completion of this course, students will be able to create colorful charts and databases that communicate data and financial records efficiently and effectively. Students will be able to apply data to various reporting forms like tables, graphs and pivot tables in order to show important analysis like depreciation, percentiles and regression for use with strategizing and planning. Students who finish this course will have an advanced knowledge of the versatility of Excel that is immediately applicable to their work with the database.

Who is the target audience?
  • Users with basic knowledge of Excel 2013 and those upgrading from previous software versions
Students Who Viewed This Course Also Viewed
What Will I Learn?
Working with dates and times
Averages, percentiles, and LINEST functions
Calculating depreciation
Inserting and formatting tables
Sparklines and data bars
Pivot charts
Bonus practice files
View Curriculum
  • Microsoft Excel 2013
Curriculum For This Course
Expand All 53 Lectures Collapse All 53 Lectures 12:41:40
6 Lectures 12:11

Essential Information for a Successful Training Experience

Course exercise files

Microsoft Excel 2013 keyboard shortcuts
7 pages

Course transcripts
206 pages

Downloadable course MP3 audio files
Personal and Professional Financial Functions
4 Lectures 49:32

Future Value

Principle Payment

Date and Time Functions
3 Lectures 32:07
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
5 Lectures 59:56



LINEST Function

Example of Functions for Inferential Statistics
Text Functions
2 Lectures 25:01
Text Function Case Study - 1

Text Function Case Study - 2
Lookup Functions
1 Lecture 15:43
Lookup and Reference Functions
Logical Functions
1 Lecture 16:00
Logical Functions
Connecting to External Data
4 Lectures 41:16
Course Review

Connecting to Other Workbooks

Connecting to Access Data

Connecting to Web Data
5 Lectures 49:25

Inserting Columns and Rows; Resizing Tables

Table Reference

Table Styles

Table Selection
9 More Sections
About the Instructor
4.4 Average rating
8,128 Reviews
276,615 Students
109 Courses
280,000+ Students | Wordwide Use 180 Countries |115 Courses

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 80+ courses and 4,500+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 280,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.

Report Abuse