Microsoft Excel 2010 Training Course - Online/Offline Access
4.0 (1 rating)
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.
13 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2010 Training Course - Online/Offline Access to your Wishlist.

Add to Wishlist

Microsoft Excel 2010 Training Course - Online/Offline Access

Top Universities Require Our Microsoft Excel Training Course for their Business Students.Learn Excel 2010 from Experts.
4.0 (1 rating)
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.
13 students enrolled
Created by Chris Albright
Published 1/2013
English
Curiosity Sale
Current price: $10 Original price: $20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
  • 9 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Over 8 hours of videos covering 125 topics
  • Reading and Practice material for all topics
  • New Excel tab with all the material in this course
  • All material created by Dr. Chris Albright from Indiana University
  • Learn to use Excel efficiently and effectively
  • Apply Excel skills to real world applications
  • See the power of Excel
  • Be successful at School and Work
  • Have fun!
View Curriculum
Requirements
  • Windows or Mac Computer
  • Microsoft Excel 2007 or 2010
Description

What is the “Microsoft Excel Training: Learn Excel 2010” course about?

In this Excel training course, you will learn efficient and effective ways to work in Excel environment from Dr. Chris Albright from Indiana University (you should Google him!). This comprehensive Microsoft Excel training course covers all the topics from beginners to advanced level. Instead of focusing on the length of the course, we focus on how effective the course can be; we value your time. We will teach you everything you need to know, all the way up to passing the Microsoft Excel exam, in little more than 8 hours videos.  These videos are broken down into 125 topics. All of these topics also come with Read and Practice workbook where you will be able to apply what you learned.

When we created this course, we had five things in mind.

  1. This Excel training course needs to be fun!
  2. It has to show the power of Excel.
  3. It has to show the real world applications of Excel.
  4. It has to raise your curiosity as you go from beginners to advanced topics.
  5. It has to remind you about what you have already learned.

Since you will spend most of the time in this course within Excel, you will love your new Excel tab, “Excel Now!”. You will be able to read, practice and watch videos, all inside your own MS Excel under this tab. As you learn new topics, you will find yourself looking forward to seeing how the future topics work. And as you go forward, we will also remind you about what you have already learned. You will get plenty of opportunity to apply your new Excel skills and see the power of Excel along the way. Trust me, it will be fun!

What kind of materials are included?

Reading Workbooks, Practice workbooks, Videos, Tip Files and an add-in that will allow you to access any part of this course from within your Excel Application.

How long will the “Microsoft Excel Training: Learn Excel 2010”course take to complete?

The course is only 8 hours long, but give yourself about 15 hours to master Excel.

How is the course structured?

For windows with Excel 2007 or 2010, you will get a tab in Excel called Excel Now!. This tab will have 125 topics with reading, practice and videos material built in. See the screenshots. 

For Mac users, you will find all of the material here on Udemy page.

Why take this Microsoft Excel training course?

This course is created by experts with you in mind.

Many universities require our course for their students.

Our Excel training course will make you efficient and effective in Excel in less than 15 hours.

You will be a rock star of Excel at School and Work.

And above all, you want to!

Sign up for this Microsoft Excel Training course now and learn Excel 2010 from expert.

Who is the target audience?
  • Students (Especially Business Students)
  • Professionals
  • Beginners
  • Intermediate Users
  • Advanced Users
Students Who Viewed This Course Also Viewed
Curriculum For This Course
128 Lectures
08:54:51
+
Introduction
1 Lecture 04:43
+
Changes in Excel 2007 and 2010
15 Lectures 37:33


Modifying Ribbons in 2010
05:15

File and Office Buttons
01:41

Quick Access Toolbar
01:41

Excel Options
03:49

Developer Ribbon
01:18

File Extentions
03:23

Opening Recent Files in 2010
03:16

Selected Range Coloring in 2010
00:51

New Functions in 2010
01:31

Add-Ins Buttons in 2010
01:37

Slicer in 2010
02:19

Sparklines in 2010
02:08

New Solver in 2010
01:55
+
Intro to Basics
1 Lecture 00:51
Intro to Excel Basics
00:51
+
Moving and Selecting
7 Lectures 13:14
Intro to Moving and Selecting
01:26

Going Home to Cell A1
00:49

Splitting the Screen
01:46

Selecting a Range with Keys
03:32

Selecting a Range by Pointing
02:04

Selecting Multiple Ranges
00:56

Go to Options
02:41
+
Copying, Cutting, Pasting
6 Lectures 22:07
Intro to Copying, Cutting & Pasting
00:46

Copying and Pasting
05:21

Cutting and Pasting
01:38

Paste Special Options
07:25

Transposing a Range
02:52

Office Clipboard
04:05
+
Other Basic Tools
13 Lectures 50:54
Intro to Other Basic Tools
00:38

Undoing Actions
02:18

Right-Clicking
02:24

Shortcut Keys
00:48

Number Formats
09:59

Cell Borders
03:50

Manipulating Rows & Columns
02:54

Manipulating Worksheets
04:24

Filling a Series
01:26

Sorting and Custom Lists
09:46

Adding Hyperlinks
05:10

Printing
03:33

Templates
03:44
+
Formulas
11 Lectures 01:10:36
Intro to Formulas
00:51

Relative, Absolute Addresses
10:33

R1C1 Notation
03:49

Range Names
14:43

Calculation Options
03:31

AutoSum Button
02:48

Auditing Formulas
06:35

Evaluating a Formula
05:40

External Formula References
05:20

Error Codes & IS Functions
07:56

Array Formulas
08:50
+
Charts
4 Lectures 25:04
Intro to Charts
01:56

Creating a Chart
09:16

Modifying a Chart
10:23

Locating a Chart
03:29
+
Intro to Functions
2 Lectures 04:53
Intro to Functions
01:32

Function Help
03:21
+
Two Essential Functions
3 Lectures 22:58
Intro to Two Essential Functions
00:56

IF Function
09:50

VLOOKUP Function
12:12
11 More Sections
About the Instructor
Chris Albright
4.0 Average rating
1 Review
13 Students
1 Course
Head Developer at ExcelNow! LLC

Dr. Christian S. Albright is the renowned author of several books on spreadsheet modeling, data analysis, decision making, statistics, and Visual Basic for Applications, all of them based on the extensive use of Excel. You can check out his books at Amazon.com. He has spent most of his life teaching at Kelly School of Business in Indiana University. He recently retired from the University. He spends a lot of his time developing ExcelNow! and making changes to his books for Excel 2013. He has been engaged by Microsoft to teach many of their professionals about VBA and Excel modeling. 

</p></p>