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.
9 students enrolled
$20
Take This Course
  • Lectures 128
  • Contents Video: 9 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

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.

About This Course

Published 1/2013 English

Course 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.

What are the requirements?

  • Windows or Mac Computer
  • Microsoft Excel 2007 or 2010

What am I going to get from this course?

  • 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!

What is the target audience?

  • Students (Especially Business Students)
  • Professionals
  • Beginners
  • Intermediate Users
  • Advanced Users

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Introduction to ExcelNow!
Preview
04:43
Section 2: Changes in Excel 2007 and 2010
Changes in Excel 2007 and 2010 Intro
Preview
02:43
Tabs and Ribbons
Preview
04:06
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
Section 3: Intro to Basics
Intro to Excel Basics
00:51
Section 4: Moving and Selecting
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
Section 5: Copying, Cutting, Pasting
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
Section 6: Other Basic Tools
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
Section 7: Formulas
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
Section 8: Charts
Intro to Charts
01:56
Creating a Chart
09:16
Modifying a Chart
10:23
Locating a Chart
03:29
Section 9: Intro to Functions
Intro to Functions
01:32
Function Help
03:21
Section 10: Two Essential Functions
Intro to Two Essential Functions
00:56
IF Function
09:50
VLOOKUP Function
12:12
Section 11: Basic Summarizing Function
Basic Summarizing Functions
00:40
SUM, AVERAGE, PRODUCT
04:25
COUNT, COUNTA, COUNTBLANK
03:16
COUNTIF, SUMIF, AVERAGEIF
06:56
COUNTIFS, SUMIFS, AVERAGEIFS
06:42
SUMPRODUCT
03:09
Section 12: Math Functions
Intro to Math Functions
01:02
INT, ROUND, CEILING, FLOOR
03:11
ABS, SQRT, SUMSQ
02:04
LN, EXP
03:34
RAND, RANDBETWEEN
03:29
Section 13: Text Functions
Intro to Text Functions
01:14
LOWER, UPPER, PROPER
01:18
TRIM, VALUE
04:48
Concatenating
02:54
Parsing with Text to Columns
03:55
Parsing with Text Functions
10:47
Section 14: Date and Time Functions
Intro to Date and Time Functions
05:37
Y2K
02:13
TODAY, NOW
02:16
YEAR, MONTH, DAY, WEEKDAY
03:01
DATEDIF
03:12
DATE, DATEVALUE
06:10

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Chris Albright, 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>

Ready to start learning?
Take This Course