Learn Microsoft Excel 2013 - Advanced
4.1 (206 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6,669 students enrolled

Learn Microsoft Excel 2013 - Advanced

Insider Method: Learn Advanced Techniques for Microsoft Excel 2013 Fast - Without Lectures, Books, or Night Classes
4.1 (206 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6,669 students enrolled
Created by Simon Sez IT
Last updated 6/2018
English
English
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 9 hours on-demand video
  • 3 articles
  • 4 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Working with dates and times
  • Averages, percentiles, and LINEST functions
  • Calculating depreciation
  • Payments
  • Inserting and formatting tables
  • Sparklines and data bars
  • Pivot charts
  • Bonus practice files
Requirements
  • Microsoft Excel 2013
Description

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.

** Updated July 2017. English close captions added

What People Are Saying:

★★★★★ “The overall course has a nice progressive layout and the presenter knows what he is teaching.” -Eric Cobb

 ★★★★★ “I have some experience with Excel but this course really helped me know the functions available in it and how to use them. The instructor explains the subject very patiently and clearly so the student can follow along and master the details. Production quality was good.” -Vikram Hegde

★★★★★ “Excellent course. I am about half way so far and I am loving it. The course is really detailed and displays very good examples and methods to use functions in Excel. The course is divided into various sections based on type of functions (Accounting, Date/time, Statistics, etc.). For every section there are examples and exercises and this is what makes this course very useful. You can do the exercises and follow along with what Simon says in the class.-Hari Iyer

★★★★★ “Even if the course is targeted at advanced Excel users, I think that it provides great value even for beginner ones. I believe that the most important part in learning anything and improving a certain skill is to know where to actually search for the information that you need to fulfill your task. That is why I strongly recommend this course to anyone! It starts not by just providing a full list of useful keyboard shortcuts that can save a lot of time, but it also teaches you how to navigate within Excel for invaluable sources of information.” -Vlad Zamfirescu

★★★★★ “This material is very easily laid out and relevant. I have obtained many tips that will help me to become much more productive in my Excel use.” -Mark Carson

Who this course is for:
  • Users with basic knowledge of Excel 2013 and those upgrading from previous software versions
Course content
Expand all 53 lectures 12:41:42
+ Introduction
6 lectures 12:15
Essential Information for a Successful Training Experience
01:34
Course exercise files
00:23
Microsoft Excel 2013 keyboard shortcuts
7 pages
Course transcripts
206 pages
Downloadable course MP3 audio files
00:22
+ Personal and Professional Financial Functions
4 lectures 49:32
Future Value
11:17
Principle Payment
12:02
Depreciations
13:25
+ Date and Time Functions
3 lectures 32:07
How Dates and Times are Stored
11:57
Dates and Times Calculation
12:45
Exercise on Date and Time Functions; Date and Time Settings
07:25
+ Statistical Functions for Description, Prediction and Interference
5 lectures 59:56
Percentile
10:21
Regression
14:02
LINEST Function
09:49
Example of Functions for Inferential Statistics
12:39
+ Text Functions
2 lectures 25:01
Text Function Case Study - 1
14:26
Text Function Case Study - 2
10:35
+ Lookup Functions
1 lecture 15:43
Lookup and Reference Functions
15:43
+ Connecting to External Data
4 lectures 41:16
Course Review
00:43
Connecting to Other Workbooks
16:04
Connecting to Access Data
14:11
Connecting to Web Data
10:18
+ Tables
5 lectures 49:25
Inserting Columns and Rows; Resizing Tables
15:03
Table Reference
09:18
Table Styles
07:07
Table Selection
04:08