Microsoft Excel 2013 Advanced. Online Excel Training Course
4.6 (1,962 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.
40,633 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2013 Advanced. Online Excel Training Course to your Wishlist.

Add to Wishlist

Microsoft Excel 2013 Advanced. Online Excel Training Course

Master Advanced Excel 2013 Features. Become A Expert And Learn To Use Excel Like A Pro With This Advanced Excel Training
4.6 (1,962 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.
40,633 students enrolled
Created by Infinite Skills
Last updated 1/2017
English
Price: $50
30-Day Money-Back Guarantee
Includes:
  • 10 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • To take your basic Excel skills to the next level
  • To gain a solid understanding of the more powerful features and functions in Excel
  • To be able to use Microsoft Excel in a commercial environment
View Curriculum
Requirements
  • Microsoft Excel 2013, Windows 8, 7, Vista or XP
Description

Learn the expert features and functions in Microsoft Excel 2013, alongside our expert author, to help you get you beyond the basics and have advanced-level proficiency within the Excel 2013 suite

Whilst in this course we’ll cover the basics of Excel, including SUM, MIN, MAX and other conditional statements, we’ll quickly move onto more advanced-level topics including:

  • IF statements
  • VLOOKUP and HLOOKUP
  • Sparklines
  • Pivot Tables and Charts
  • Macro Operations

The Ability to Master Excel

By the completion of this computer based advanced Excel training video for Microsoft Excel 2013, you will be comfortable with many of the advanced features and functions that this powerful spreadsheet software from Microsoft has to offer.

With the ability to handle advanced tasks in Excel, you’ll be able to get more power out of your worksheets and be able to dramatically shorten your task times and increase your efficiency in the process.

Content and Overview

Suitable for beginners with Microsoft Excel (as we’ll cover the basics early on) but also for those who wish to cover the advanced topics in Excel. Through the course of 128 lectures and 10+ hours of content, you’ll learn all of the basic and advanced items of Excel, which will enable you to use Excel expertly within in a personal or commercial environment.

Complete with working files and code samples, you’ll be able to follow along with the author throughout the lessons, and will receive a verifiable certificate of completion upon finishing the course.

Who is the target audience?
  • Users with a basic knowledge of Excel
  • Users who have completed our Beginners / Intermediate Excel title
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 128 Lectures Collapse All 128 Lectures 09:52:39
+
Getting Started
5 Lectures 13:31
Working Files - Download These First
00:01


0102 Using The Included Files
01:17

0103 New For 2013: Its All In The Cloud
04:03

+
Using Mathematical Functions
7 Lectures 32:15

0202 AVERAGE, MODE, MEAN, And MEDIAN
04:04


0204 COUNTIF For Selective Counting
03:18

0205 AVERAGEIF For The Mean Of Selected Cells
03:29

0206 Multiple Criteria Within SUMIF, COUNTIF, And AVERAGEIF
07:06

0207 Area And Volume Calculations
04:09
+
IF Functionality
6 Lectures 34:32
0301 IF Syntax And Uses
07:55


0303 Use Of The AND Operator Within An IF
06:29

0304 Use Of The OR Operator Within An IF
04:03


0306 Display Cell Formulas In Another Cell
04:11
+
Performing Data Lookups
7 Lectures 36:37

0402 VLOOKUP In Live Action
06:53

0403 HLOOKUP: Variation On A Theme
04:42

0404 Using A Near Match In The Lookup
03:44


0406 Managing The Lookup Table
05:03

0407 Lookups Nested Within Lookups
06:29
+
Sparklines
5 Lectures 18:20
0501 Creating A Sparkline
04:58

0502 Altering The Design Of Sparklines
04:26

0503 Dealing With Empty Cells
02:24

0504 Comparing Sparklines Within A Sparkline Group
04:18

0505 Removing Sparklines From A Worksheet
02:14
+
Further Mathematical Functions
8 Lectures 43:55
0601 Working With Time In Excel
10:20

0602 Calculations Using Time
03:58

0603 Useful Time And Date Functions
04:45

0604 Rounding Decimal Places
04:32

0605 MOD And INT Functions And Uses
04:42

0606 Generate And Use A Random Number
05:36

0607 Loan And Investment Calculations
05:58

0608 Loan Calculation Elements And Functions
04:04
+
Outlining
3 Lectures 13:48
0701 Create An Outline Automatically
03:47

0702 Adding An Outline Manually
03:22

0703 Editing And Removing Outlining
06:39
+
Scenarios
5 Lectures 21:50
0801 Setting Up A Set Of Scenarios
06:59

0802 Displaying And Editing The Different Scenarios
03:12

0803 How To Work Out Which Scenario You Are Displaying
04:06

0804 Merging And Deleting Scenarios
03:41

0805 Producing A Summary Of Scenarios
03:52
+
Custom Views
4 Lectures 14:54
0901 Custom Views Explained
03:03

0902 Use Of Outlining To Help Setup Custom Views
03:56

0903 Editing And Deleting Custom Views
04:25

0904 Add Quick Access To Custom Views
03:30
+
Functions For Manipulating Text
9 Lectures 46:37
1001 LEFT And RIGHT: Text Manipulation
04:28

1002 LEN And TRIM: String Extractions
06:34

1003 FIND And MID: Text Functions Working Together
06:53

1004 CONCATENATE: Building Strings From Multiple Cells
05:23

1005 Changing Case Functions
04:03

1006 REPLACE And SUBSTITUTE: Two More String Manipulation Functions
04:42

1007 Use Of CHAR Function For More Obscure Characters
06:12

1008 Formatting Numeric And Date Values Using TEXT
05:01

1009 Keeping The Values Created By String Manipulation
03:21
9 More Sections
About the Instructor
Infinite Skills
4.4 Average rating
40,452 Reviews
704,107 Students
331 Courses
High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.