Learn Microsoft Excel 2013 - Advanced

Insider Method: Learn Advanced Techniques for Microsoft Excel 2013 Fast - Without Lectures, Books, or Night Classes
  • Lectures 53
  • Video 13 Hours
  • Skill level intermediate level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

Course 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.

What are the requirements?

  • Microsoft Excel 2013

What am I going to get from this course?

  • Over 53 lectures and 12.5 hours of content!
  • 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

What is the target audience?

  • Users with basic knowledge of Excel 2013 and those upgrading from previous software versions

What you get with this course?

Not for you? No problem.
30 day money back guarantee

Forever yours.
Lifetime access

Learn on the go.
Desktop, iOS and Android

Get rewarded.
Certificate of completion

Curriculum

Section 1: Introduction
Prerequisites of Excel 2013 Advanced Course
09:55
IMPORTANT - Read this to ensure the best video quality!!!!
Preview
Text
Course exercise files
Text
Microsoft Excel 2013 keyboard shortcuts
7 pages
Course transcripts
206 pages
Downloadable course MP3 audio files
Text
Section 2: 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
06:18
Section 3: Personal and Professional Financial Functions
Payment
12:48
Future Value
11:17
Principle Payment
12:02
Depreciations
13:25
Section 4: 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
07:25
Section 5: Statistical Functions for Description, Prediction and Interference
Average
13:05
Percentile
10:21
Regression
14:02
LINEST Function
09:49
Example of Functions for Inferential Statistics
12:39
Section 6: Text Functions
Text Function Case Study - 1
14:26
Text Function Case Study - 2
10:35
Section 7: Lookup Functions
Lookup and Reference Functions
15:43
Section 8: Logical Functions
Logical Functions
16:00
Section 9: Connecting to External Data
Course Review
00:43
Connecting to Other Workbooks
16:04
Connecting to Access Data
14:11
Connecting to Web Data
10:18
Section 10: Tables
Creating a Table and Changing Table Name; Filter; Removing Duplicates; Total Row
13:49
Inserting Columns and Rows; Resizing Tables
15:03
Table Reference
09:18
Table Styles
07:07
Table Selection
04:08
Section 11: Pivot Tables
Basic Principles of Pivot Tables
14:58
Presentational Side of Pivot Tables
15:40
Filtering in Pivot Tables; Slices
14:06
Section 12: Data Analysis
What if
15:32
Scenario Manager
14:07
Goal Seek
07:51
Solver
14:38
Section 13: Charts
Area Charts
10:39
Surface Charts
07:40
Stock Charts - Part 1
12:27
Stock Charts - Part 2
12:48
Radar Charts
05:08
Bubble Charts
10:21
Section 14: Graphs
Regression and Scatter Chart
07:00
Section 15: Pivot Charts
Creating Pivot Charts
12:32
Section 16: Sparklines
Using Sparklines
15:30
Section 17: Web App
Creating Workbooks using a Web App
15:15
Sharing your Workbook
10:00
Section 18: Conclusion
Closing
00:19
Assessment Test
45 questions

Instructor Biography

Simon Sez IT , Software training to help you succeed

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 70+ courses and 3,000+ 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 200,000 Udemy students, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.

Join the biggest student community

6,400,000

Hours of video content

28,000,000

Course Enrollments

7,500,000

Students

Reviews

Average Rating
4.6
Details
  1. 5 Stars
    23
  2. 4 Stars
    4
  3. 3 Stars
    0
  4. 2 Stars
    0
  5. 1 Stars
    2
    • Patricia Richardson

    Teacher boring

    He takes way too long to explain. It is very boring. Too much irrelevant information.

    • Emmanuel Nartey-Tokoli

    excel Advanced

    A very good course

    • Vikram Hegde

    Excellent Course

    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.

    • Nuno Araújo

    Very good

    A very good course, well explained, although I think it could provide a little more advanced training.

    • Ernestos Anastassiadis

    A very instructive course

    It has always been a drag for me to try and understand using office applications. It is not that i cannot do what i need to do, but i never had an eye opening experience about the true potencial of these applications. This course, along with the rest of the office courses from this instructor, helped me realise how useful office applications can be. Thank u.

Show more reviews
Ready to start learning?
Preview this course