Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2010: Advanced Training to your Wishlist.

Add to Wishlist

Microsoft Excel 2010: Advanced Training

Master Advanced Excel 2010 Features. Become A Expert And Learn To Use Excel Like A Pro With This Advanced Excel Training
4.5 (1,346 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.
72,928 students enrolled
Published 9/2011
English English
$10 $50 80% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 8.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
Description

A Verifiable Certificate of Completion is presented to all students who undertake this Excel course.

This Excel 2010 advanced training course, follows up from the Beginners Excel 2010 course by delving even deeper into the features and functions of this powerful spreadsheet software.

Microsoft Excel 2010 is much more than a quick way to add up numbers. In this online course, you will learn advanced features such as nesting IF statements, how to calculate the Mean of a group of numbers using AVERAGEIF, SUMIF and more. You will learn about performing lookups with HLOOKUP and VLOOKUP. This tutorial also covers Sparklines, and goes in-depth with Pivot Tables and Charts. Finally, you will learn how to create and record your own Macros.

This advanced Excel video course is not for beginners. You should have a firm grasp of the basics before taking this Advanced Excel training course. By the conclusion of this advanced computer software tutorial for Microsoft Excel 2010, you will have mastered the advanced features and functions of this software. Working files are included to allow you to follow along with the same Excel files the author trains you with.

Students Who Viewed This Course Also Viewed
What Will I Learn?
Learn Advanced Microsoft Excel 2010 from a professional trainer from your own desk.
136 lectures (8.5 hours of content) teaching you lookups, advanced IF statements, Macros, Sparklines, and much more!
Suitable advanced Excel users. ideal for users who learn faster when shown.
Visual training method, offering users increased retention and accelerated learning.
Breaks even the most complex applications down into simplistic steps.
View Curriculum
Curriculum For This Course
Expand All 135 Lectures Collapse All 135 Lectures 08:18:08
+
Getting Started With This Excel Course
4 Lectures 10:15
+
Excel Data Functions
4 Lectures 18:38
The MATCH Function Explained
08:14

The INDEX Function Syntax
05:06

How To Stop Nonexistent Row Or Column Lookups In INDEX
02:41

The CHOOSE Lookup Function
02:37
+
Excel Math Functions
9 Lectures 32:39
Working With TIME
05:55

Rounding To Fractional Values
03:35

MOD For Working Out Remainders
02:18

Generating A Random Number
02:33

Pick A List Item At Random
03:05

Calculating Loan Repayments Using PMT
02:55

Excel - Investment Calculations Using PMT
02:59

Working Out Depreciation
04:21

Working Out Different Parts Of A Loan Calculation
04:58
+
Arrays In Excel
4 Lectures 13:43
What Is An Array And An Array Formula
03:00

Creating And Using An Array Formula
03:29

Conditional Evaluation In An Array Formula
03:42

The Very Clever TRANSPOSE Array Function
03:32
+
Excel Functions For Working With Text
8 Lectures 30:50
LEN And TRIM Two Very Useful Text Functions
02:44

Using LEFT And RIGHT For String Extraction
03:36

FIND And MID Working Together To Extract Parts Of Strings
04:15

Build Strings From Multiple Cells
03:58

Excel - Changing The Case Of Text In Cells
02:56

REPLACE And SUBSTITUTE In Action
05:12

Formatting Numeric Values With A Text String Using TEXT
05:09

Extracting The Values From The Text Functions We Have Used
03:00
+
Other Useful Excel Functions
7 Lectures 33:24
Welcome To IS Functions
02:45

Error Checking With ISERR ISERROR ISNA And IFERROR
08:06

The OFFSET Formula Explained
03:17

Dynamic Named Ranges Using The OFFSET Function
05:48

Use The INDIRECT Function To Build Dynamic Formulas
05:59

Dealing With INDIRECT Errors
01:46

Use Formulas To Determine An Excel Filename And Or Sheet Name
05:43
+
Sparklines
5 Lectures 13:13
Creating A Sparkline In Excel
03:06

Change The Design Of Sparklines
03:38

Dealing with Empty Cells
01:57

Comparing One Sparkline To Another by Altering Vertical Scale
02:57

Removing Sparklines From A Sheet
01:35
+
Outlining
6 Lectures 16:21
Outlining Explained
02:35

Creating An Outline Automatically
02:34

Creating An Outline Manually
02:58

Manually Removing Data From An Outline
03:25

Removing The Outlining From A Worksheet
00:55

Adjusting A Grouping Created By Automatic Outlining
03:54
7 More Sections
About the Instructor
4.4 Average rating
33,854 Reviews
665,451 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.

Report Abuse