The Ultimate Microsoft Excel 2010 Training Course - 14 Hours

Have all the numbers, charts and graphs got you down? Demystify Excel forever with this effective course.
4.2 (14 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,232 students enrolled
$125
Take This Course
  • Lectures 103
  • Contents Video: 14 hours
    Other: 0 mins
  • 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 5/2014 English

Course Description

Just about everyone will find him or herself having to use Microsoft Excel at work at one point or another, and Excel 2010 is one of the most popular and powerful versions around. That means that everyone could benefit from devoting some time to mastering the program. Excel mastery will not only have a huge impact on your own productivity, but also it can look hugely impressive to your boss.

With our Ultimate Microsoft Excel 2010 Training Course, you’ll find basic and advanced courses for Microsoft Excel 2010.

This bundle includes:

  • Beginner and advanced courses for mastering Excel 2010
  • 14 hours of video tutorials
  • Over 100 individual video lectures
  • Optional quizzes to test what you’ve learned
  • Certificate of Completion

Courses included with this bundle:

Learn Microsoft Excel 2010 for Beginners

Our professional instructor will talk you through Excel 2010’s features, starting with the basics like creating files to editing existing documents. Secondly, you’ll move onto moving and managing data across rows and columns, as well as different sheets, in addition to introducing your first formulas. Formatting workbooks comes next, in addition to adding attractive charts and graphs to display your work. You’ll then progress to sorting and filtering data, linking multiple files and, finally, working with some more advanced formulas.

Learn Microsoft Excel 2010 - Advanced

Discover methods to make your exceptions stand out so you can attack the anomalies and use the data to make your operations better. During this Advanced level course, Excel’s tools are covered in depth and include discussions on setting up live charts, Sparklines, color scales, and icon sets. Your data will become alive as you identify key action items and understand the meaning behind the numbers. Learn how to use Pivot Tables combined with Pivot Charts in powerful ways. By the end of this course, you will be able to move columns and rows to understand more easily than ever before how the numbers relate.

Where else can you find so many extra tools to help you gain advanced skills in Excel?

What people are saying:

“This would have to be the most enjoyable on-line course I have ever done. The material is nicely laid out, the presenter talks at a nice pace and explains things clearly. I highly recommend this course to those seeking Excel tuition.”
- Paul Schrooder

“Cindy is very clear and has organized the course brilliantly. Her explanation and covering of topics is granular enough to pick up once the course if over. Even though I am quite used to using most of what is covered, it was always interesting to hear her describe the features and was not bored!”
- Sam Malone

"Simon Sez IT is one of the best resources if you are looking for Microsoft Office tutorials."
- TopTenReviews.com

“Truly outstanding course. I have been in accounting/controllership for over 40 years. I decided to review the basics of Excel just to make sure I knew it all. I didn't know it all and this highly detailed, cover everything course did show me new stuff. Cindy's teaching style is the way it should be done. For someone starting out, very highly recommended.”
- Pierre Nantais

“Very clear easy to follow instructions and extremely well presented. Love the layout and how easy it is to navigate to the section you want. Very quick response to any queries you may have. Some companies wanted to charge over £200 for 4 hours! This is great, you work at your own pace, fit it in around your "hectic" lifestyle and you don't feel overwhelmed or afraid to look at a spreadsheet. I've gone from novice to understanding quite a lot from what I've learned so far and I'm not even half way through the course.”
- Debbie Lee

What are the requirements?

  • Microsoft Excel 2010

What am I going to get from this course?

  • Discover how to create and edit spreadsheets.
  • Learn how to organize your data with rows, columns, and multiple sheets.
  • Master both simple and more complex formulas.
  • Sort and filter your data.
  • Four basic steps to consider when creating charts and graphs.
  • How to better format your charts and graphs like professionals do.
  • Discover how to deal with complex trends in your charts and graphs.
  • Learn how to use a bar chart and a pie chart to accentuate the differences in a data set.
  • Discover the tools and options for exporting your charts and graphs.
  • Discover the limitations of pie charts and the best way to correct them.
  • Learn how to use Pivot Tables and Pivot Charts.
  • Learn how to integrate graphics into your spreadsheets.

What is the target audience?

  • Anyone new to Microsoft Excel or upgrading from an earlier version.
  • Those seeking advanced Excel training.

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: Intro to Excel 2010
Introduction and Overview of Excel Course
Preview
00:57
IMPORTANT - Read this to ensure the best video quality!
Article
Overview of the Excel Window
Preview
11:52
Working with the Mouse
04:05
Excel Options
02:44
Section 2: Getting Started Creating a New Workbook
Entering Text and Numbers
Preview
05:39
Creating Basic Formulas
06:55
Relative References
01:54
Order of Operations
04:33
Working withe Ranges
05:03
Section 3: Saving Workbooks
Working with Save and Save As Commands
05:22
File Extensions
03:48
Section 4: Navigating Workbooks
Opening a File
04:37
Working with Larger Files
06:27
Freeze Panes Options
02:20
Split Screen Option
03:43
Section 5: Printing
Page Setup Options
Preview
05:11
Headers and Footers
07:37
Print Titles
02:29
Comments
04:22
Fit to print on one page
05:11
Printing Workbooks
02:21
Section 6: Working with Rows, Columns, and Cells
Adding and Deleting Rows, Columns, and Cells
05:41
Changing Column and Row Widths
04:40
Section 7: Moving Data
Cut, Copy and Paste
06:22
Copying Formulas
04:13
Section 8: Formulas and Functions
Overview of Formulas
03:01
Create Formulas using Functions - Part 1
10:21
Create Formulas using Functions - Part 2
06:55
Absolute Values
05:44
Section 9: Working with Worksheets
Adding, Deleting and Renaming Sheets
06:25
Additional Sheet Tab Options
05:09
3-D Formulas
07:13
Section 10: Formatting Worksheets
Cell Formatting
Preview
12:17
Number Formatting
10:00
Borders and Shading
09:32
Format as Table
06:56
Using Styles
09:14
Using Format Painter
04:40
Protecting Sheets
11:27
Fill Handle and Custom Lists
07:11
Section 11: Charts
Creating Charts
11:12
Types of Charts
04:27
Editing Charts
10:20
Using Graphics to Enhance Charts
05:41
Course Review
00:43
Section 12: Working with Names
Creating Range Names
10:21
Managing Names
02:36
Using Names in Formulas
05:29
Section 13: Sorting and Filtering
Removing Duplicates
08:56
Sort Data
11:11
Filter Data
11:31
Advanced Filters
04:00
Section 14: Outlining and Subtotaling
Creating an Outline - Part 1
08:11
Creating an Outline - Part 2
05:09
Subtotals
09:41
Section 15: Working with Views
New Window Option
03:08
Arrange File Options
02:40
Creating a Workspace
04:16
Custom Views
06:10
Scenarios
06:32
Section 16: Linking Files
Creating Formulas between Files
07:59
Working with Links
04:36
Section 17: Advanced Formula Creation
IF Statement
09:23
VLookups
07:05
Consolidating Data
04:39
Data Validation
09:39
Formula Auditing
04:01
Section 18: Additional Excel Features
Comments
06:08
Goal Seeker
02:05
Text to Columns Option
02:28
Watch Window
02:58
Section 19: Conclusion
Closing Video
00:28
Assessment Test
38 questions
Section 20: Intro to Excel 2010 Advanced - Basic Steps for Charts & Graphs
Introduction to Advanced Excel 2010
Preview
03:10
Four Basic Steps When Creating Charts/Graphs
Preview
10:58
Additional Features to Help Create Charts/Graphs
14:56
Additional Features to Help Create Charts/Graphs Part 2
14:28
Section 21: Layout Tab
Detailed Formatting for Charts/Graphs
Preview
13:03

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Simon Sez IT, Software training to help you succeed

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 80+ courses and 4,000+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 250,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.

Ready to start learning?
Take This Course