The Excel 2010 Guru Course (Advanced)
0.0 (0 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.
1 student enrolled
Wishlisted Wishlist

Please confirm that you want to add The Excel 2010 Guru Course (Advanced) to your Wishlist.

Add to Wishlist

The Excel 2010 Guru Course (Advanced)

Advanced Excel, for those who already know basic/intermediate Excel. Tips, tricks, useful formulas, macros and more.
0.0 (0 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.
1 student enrolled
Created by GEM Learning
Last updated 5/2013
English
Price: $30
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
What Will I Learn?
  • Learn how to use and make macros
  • Learn more about functions, important calculations, and formulas
  • Learn about the very useful functions that make life easier that most people don't even know about
  • Also learn about how we are changing how people are learning! Visit www.gemlearning.com
View Curriculum
Requirements
  • Just a desire to make even more use of Excel's full functionality!
Description

This course is about advanced topics in Microsoft Excel 2010. Lecture by lecture, and topic by topic, we will add layers of learning a step at a time. Advanced formulas, functions, calculation methods, macros, and more, will be covered during the course. Many if not most of these functions are not know by most people, and we hope to enable you to make the very most of all of Excel's functionality for advanced use.

Who is the target audience?
  • Those who have taken our basic/intermediate course, or those who already have intermediate expertise in Excel
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 75 Lectures Collapse All 75 Lectures 02:10:26
+
Advanced Section 1/8
16 Lectures 31:34

Hi, and welcome to the course. Please have a look at the attached files to see the list of topics we covered in intermediate and basic Excel training. Also go through the advanced list of topics to see what we will cover in this course, starting with the index-match method, and culminating in our lectures on marcos

Preview 3 pages

In this lecture, learn about the index match method.
Preview 02:51






Indirect Function
02:26

Indirect Function & Lock a Cell Reference
02:26

Create a Reference from a Cell Value
01:13

Create a Reference from a Cell Value and Text
00:53

Reference to Named Range
00:48

Dynamic Named Range
02:58

Compare Two Lists
02:14

How to find the closest number in List
02:32

Using SUMIF to calculate Year-to-Date Sales
02:47
+
Advanced Section 2/8
15 Lectures 19:15
SumIf Function
00:59

Sumproduct Function
01:16

Calculating a Running Balance
01:20

Count Function
00:59

CountA Function
00:34

Countblank Function
00:35

Round, Roundup and Rounddown Functions
02:52

Median Function
00:46

Rand and RandBetween Functions
01:35

Power and SQRT Function
03:41

SIN and ASIN Function
00:42

COS and ACOS Function
00:46

TAN and ATAN Function
00:46

Degrees to Radians and Vice Versa
00:47

Controlling Calculation Options
01:37
+
Advanced Section 3/8
8 Lectures 19:42
Compound Interest Basic
01:58

Compound Interest Calculator
01:23

Investment or Annuity
02:32

IRR and NPV
02:10

Loan Amortization Schedule
06:24

Nper Function
01:14

Numbers as Currency
02:03

Solving for Interest Rate
01:58
+
Advanced Section 4/8
11 Lectures 16:39
Basic Sorting
01:22

Custom Sorting
01:09

Multiple Level Sorting
01:35

Create a Custom List
01:30

Advanced Number Filtering
00:53

Advanced Date Filters
00:47

Advanced Text Filters
01:23

Advanced Filter - Filter Using Search
01:05

Quick Access Toolbar
02:47

Customize Ribbon
03:29

Show the Developer Tab
00:39
+
Advanced Section 5/8
7 Lectures 14:26
Use a Custom View
01:22

Subtotal Function
02:10

Drop Down Menu Using Data Validation
01:40

Removing Duplicate Entries
00:57

Data Validation - Restricting Data
02:03

DGet Function
02:21

Creating a Multi-Tier Cascading List
03:53
+
Advanced Section 6/8
6 Lectures 07:30
Accepting or Rejecting Changes
01:10

Track Changes
02:02

List Changes on a separate Worksheet
00:53

Adding, Editing and Deleting Comments
01:33

Show or Hide Comments
00:28

Protect your Workbook
01:24
+
Advanced Section 7/8
7 Lectures 09:27
Convert Text to Numbers
01:43

Hour, Minute and Second Functions
01:29

How to Print Formulas
01:22

Split an Excel Worksheet
01:30

Text to Columns
01:25

Transpose Function
01:25

Zoom to Selection
00:33
+
Advanced Section 8/8
5 Lectures 08:53
How to Record a Macro
03:32

How to Run a Macro
00:52

How to Save a Macro-Enabled Workbook
01:07

Macro Security Settings
02:24

Add Macro to Quick Access Toolbar
00:58

This quiz will test what you learned in this course. Some questions will of course require knowledge of what was taught in basic and intermediate Excel.

Advanced Learners': Review Quiz
15 questions
About the Instructor
GEM Learning
4.0 Average rating
2 Reviews
34 Students
3 Courses
Educate. Inspire. Enable.

GEM Learning is a learning solutions provider with expertise in corporate and technical training and e-learning. We specialize in e-learning and instructor-led classes for organizations, governments and institutions. 

GEM's IT trainers have developed software training screencasts that have been used by learners in many countries. we are now making them available to a wider audience through Udemy.com.