Learn Microsoft Excel 2010 the Easy Way

Impress your colleagues and wow your boss with our Microsoft Excel 2010 Beginners course.
4.3 (77 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.
2,717 students enrolled
$19
$70
73% off
Take This Course
  • Lectures 73
  • Length 7 hours
  • Skill Level Beginner Level
  • 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 10/2013 English

Course Description

Impress your colleagues and wow your boss by developing your spreadsheet skills with our Microsoft Excel 2010 Beginners course. Microsoft Excel 2010 is still one of the most popular and widespread editions of Microsoft’s famous spreadsheet program, but it can seem very overwhelming to the novice getting to grips with the software.

In this 7 hour Microsoft Excel 2010 Beginners course, you’ll go from shunning sums to cheerily calculating, and by the end of the course you’ll be comfortable with every aspect of the layout and basic functionality of Microsoft Excel 2010.

Our professional instructor will talk you through Excel 2010’s features, starting with the basics, from creating files to editing existing documents. You’ll start with creating a new workbook and entering text and numbers, moving onto saving and printing your documents, and working with larger and more complex workbooks. Next 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 move onto sorting and filtering data, linking multiple files, and, finally, working with some more advanced formulas.

With this informative course, you’ll learn the skills you need to make an impact with attractive, functional spreadsheets that help you do your job better.

Plus, when you sign up for our class, you’ll also get these 3 BONUSES:

  1. Downloadable & printable keyboard shortcuts - to help you save time and get your work done faster.
  2. An online quiz (40 questions) - to test what you've learned.
  3. A certificate of completion - to tell everyone you've aced the course.

What people are saying:

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

Note: All videos are high-definition and are therefore best viewed enlarged and with the HD setting on.

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.

What is the target audience?

  • Anyone new to Microsoft Excel or upgrading from an earlier version.

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 to Excel
Introduction and Overview of Excel 2010 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: Creating a New Workbook
Entering Text and Numbers
05:39
Creating Basic Formulas
06:55
Relative References
01:54
Order of Operations
04:33
Working with 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
05:11
Headers and Footers
07:37
Print Titles
02:29
Comments
Preview
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
Preview
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
Course Review
00:43
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
Preview
11:12
Types of Charts
04:27
Editing Charts
10:20
Using Graphics to Enhance Charts
05:41
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
Preview
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
Section 20: Assessment Test
Excel 2010 Quiz
38 questions

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Simon Sez IT, Over 270,000 Students, Used in 180 Countries, 115 Courses

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