Learn Microsoft Excel 2013 - Advanced

Insider Method: Learn Advanced Techniques for Microsoft Excel 2013 Fast - Without Lectures, Books, or Night Classes
  • Lectures 52
  • 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

Want to create jaw-dropping spreadsheets that get your boss’s attention?

You can!

Colorful charts, sleek graphs, and cutting-edge databases that offer insight into financial information are a breeze when you learn the secrets of creating sophisticated spreadsheets in our Learn Excel 2013 – Advanced course. That’s because you’ll get the tools you need to master Excel’s powerful data functions in this information-packed 9-hour video training class.

Your expert instructor will kick the course off by leading you through graph and chart basics. Then, you’ll explore Excel’s array of detailed formatting tools and discover how to make these work for you when graphing and charting financial information. Next, you’ll explore the roles played by trends, relationships, and differences in charts, and how to work with sparklines for data visualization and data bars. The course will also take you through detailed discussions of pivot tables, bubble charts, radar charts, and more.

Plus, when you sign up for our class, you’ll also get these 6 BONUSES for a limited time in addition to the 40+ online course videos:

  1. Downloadable & printable keyboard shortcuts - to help you save time and get your work done faster.
  2. An online quiz (40 questions) - to test what you've learned.
  3. Exercise files – to help you become proficient with the material.
  4. Downloadable & printable transcripts – to give you another learning option, if you prefer reading but don’t have time to take notes.
  5. 9 hours of downloadable MP3s to play on your favorite audio device - to help you learn in the car, while you walk, or in the gym.
  6. A certificate of completion to tell everyone you've aced the course.

Where else can you find so many extra tools to help you gain advanced skills in Excel 2013?!?!

So start learning today.

What people are saying:

"Simon Sez IT is one of the best resources if you are looking for Microsoft Office tutorials."
- TopTenReviews.com

Note: All videos are high-definition and are therefore best viewed enlarged and with the HD setting on.

What are the requirements?

  • Microsoft Excel 2013

What am I going to get from this course?

  • Over 52 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

Curriculum

Section 1: Introduction
Prerequisites of Excel 2013 Advanced Course
09:55
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
Section 19: Downloadable course MP3 audio files

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 60+ 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 185,000 students, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.

Reviews

Average Rating
4.9
Details
  1. 5 Stars
    23
  2. 4 Stars
    4
  3. 3 Stars
    0
  4. 2 Stars
    0
  5. 1 Stars
    0
    • 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.

    • L Whiting

    Great to learn at ones own pace at any time and in any place. Thanks.

Show more reviews

What you get with this course

30 day money back guarantee

Lifetime access

Available on desktop, iOS and Android

Certificate of completion

Join the biggest student community

5,200,000

Hours of video content

19,000,000

Course enrollment

5,800,000

Students

Ready to start learning?
Preview this course