Microsoft Excel 2010 Training - Beginner to Advanced Lessons

This course will teach you Excel 2010 from the absolute basics through to the most advanced topics. Start today!
4.7 (22 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,902 students enrolled
$19
$25
24% off
Take This Course
  • Lectures 158
  • Length 12 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 6/2013 English

Course Description

Microsoft Excel is the most used computer application in the world. Because of this, Excel skills are in high demand by businesses of all sizes.

This structured training course will teach you how to use Microsoft Excel 2010 from the most basic of concepts through to the most advanced features.

Each topic in this course is presented in a separate video lesson, allowing you to learn as much or as little as you like at a time. You are also able to watch videos as many times as you like if you need to.

Regardless of your current skill level, this course will teach you how to save time and also get the most from Excel 2010.

Watch your productivity and creativity go through the roof!

Enjoy.

What are the requirements?

  • Basic computing skills

What am I going to get from this course?

  • By the end of this course you will be very comfortable with all aspects of Microsoft Excel 2010

What is the target audience?

  • All skill levels

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: Introducing Excel 2010
01:25
Welcome to Excel 2010! The journey begins here.
02:55
Starting with the absolute basics, we look at how to start the application and also how to add shortcuts to the desktop and Task Bar for fast and easy access.
08:54
Excel 2010 Screen Layout - There have been a number of changes in this release, so let's take a look at some of them.
14:47
Introducing the File Tab and the new Backstage View
Section 2: Excel 2010 Basics
Article
Excel 2010 work file to be downloaded and used for practice during the training course.
04:49
Introducing the new Office 2010 file format - Learn why the new file format is much better than the old format.
04:39
Creating and saving a new workbook
01:35
How to open an existing workbook
05:01
Creating a new workbook from a template
03:41
Saving a workbook as a template
05:25
Opening a workbook using different options - Learn some of the more advanced and useful options when opening files.
01:30
Using SAVE AS to create a new workbook
02:28
Saving a Excel 2010 workbook in Excel 2003 format
02:33
Saving a workbook as a PDF file
03:50
Saving a workbook in web page format (HTML)
04:30
Printing workbooks - Printing is so much more straight forward in Excel 2010. A welcome addition.
05:40
Understanding text versus numeric cell entries
06:43
Introducing the Quick Access Toolbar
02:40
How to minimize the Office Ribbon - Useful to know if you would like to use more of the screen for your work.
03:45
Navigating the Office Ribbon using the keyboard
05:18
Navigating worksheets using the keyboard
04:17
Managing worksheets
03:37
Introducing the Mini Toolbar
05:35
Getting to know the Formula Bar
04:49
How to select cells in different ways
02:13
Resizing rows and columns
02:52
Using AutoCorrect
02:24
Using AutoComplete
06:50
Using AutoFill - Your new best friend.
03:25
Inserting and deleting cells, rows and columns
07:34
A closer look at Cut, Copy and Paste
05:46
Understanding Excel Operators
04:46
A refresher course in the Order of Operations
03:50
Multi-user editing using the new Office Web Apps
Section 3: Controlling Worksheets and Information
07:43
Getting the most from the Office Clipboard
03:14
Saving time with the Format Painter
05:03
Understanding the Font Group commands
02:43
Understanding the Alignment Group commands
04:56
Merging cells and wrapping text
06:32
Understanding the Number Group commands
09:08
Introducing Conditional Formatting
05:14
Working with Table Styles
05:22
Table formatting options
05:16
Working with Cell Styles
08:49
Introducing Sparklines
04:36
Adjusting rows and columns using the Office Ribbon
03:25
How to hide and un-hide rows, columns and worksheets
01:38
Managing worksheets using the Office Ribbon
03:24
Clearing cell contents and formatting
06:01
Sorting and filtering information
07:57
Using the Find and Replace tools
02:50
Using the Select Objects tool
04:08
Working with the Selection Pane
Section 4: Inserting Objects Into Worksheets
13:46
Inserting pictures into worksheets
04:19
Understanding the new picture editing tools
05:54
Inserting and working with Clipart
06:50
Inserting and working with Shapes
06:20
Introducing SmartArt graphics
04:31
Introducing the new Screenshot tool
07:27
Using different types of Hyperlinks
05:05
Working with Text Boxes
05:42
Inserting Headers and Footers into worksheets
05:52
Working with WordArt
03:43
Inserting Equations and Symbols
Section 5: Organizing Worksheets and Workbooks
03:37

Using Office Themes

04:32
Adjusting Page Margins and Orientation
05:05
Changing the Page Size and Print Area
03:50
Working with Page Breaks
01:19
Adding a worksheet background image
02:46
Adding column and row headings to reports
02:23
Using Gridline and Heading options
05:27
Working with different Excel Views
02:17
Working with the Show and Zoom commands
04:40
Managing multiple workbook windows
06:11
Freezing rows and columns
02:57
Comparing workbooks side by side
08:36
Using the Spelling Checker and other proofing tools
04:10
Working with Comments
Section 6: Excel Security
03:40
Protecting worksheets
03:37
Protecting workbooks
10:20

Allowing multi-user editing of workbooks

02:47

Using Mark As Final

02:59
Password protecting your workbooks
01:50
Other ways to protect your work
02:17
IRM, DRM and Digital Signatures
03:09
The Document Inspector
02:53
Using the Accessibility Checker
03:11
Working with Protected View
Section 7: Working with Charts
04:13
How to insert a chart
03:20
Chart Basics
06:32
Modifying the chart design
09:41
Modifying the chart layout
06:35
Chart formatting options

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

VideoTraining Online, Comprehensive Training

VideoTraining and has been designing and building video based training materials for over 5 years.

Our courses are thorough and to the point. Each topic is explained clearly with examples of how and why the different features work within applications.

We look forward to helping you reach your productivity goals.

VideoTraining - Comprehensive training without the waffle

Ready to start learning?
Take This Course