Microsoft Excel 2010 Training - Beginner to Advanced Lessons
4.5 (26 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,909 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2010 Training - Beginner to Advanced Lessons to your Wishlist.

Add to Wishlist

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.5 (26 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,909 students enrolled
Last updated 6/2013
English
Current price: $10 Original price: $25 Discount: 60% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 12 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • By the end of this course you will be very comfortable with all aspects of Microsoft Excel 2010
View Curriculum
Requirements
  • Basic computing skills
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.

Who is the target audience?
  • All skill levels
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 158 Lectures Collapse All 158 Lectures 11:44:46
+
Introducing Excel 2010
4 Lectures 28:01
Welcome to Excel 2010! The journey begins here.
Preview 01:25

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.
Preview 02:55

Excel 2010 Screen Layout - There have been a number of changes in this release, so let's take a look at some of them.
Preview 08:54

Introducing the File Tab and the new Backstage View
Introducing the new File Tab and Backstage View
14:47
+
Excel 2010 Basics
30 Lectures 02:02:09
Excel 2010 work file to be downloaded and used for practice during the training course.
Excel 2010 work file to be downloaded and used throughout this course.
00:04

Introducing the new Office 2010 file format - Learn why the new file format is much better than the old format.
Introducing the new Office 2010 file format
04:49

Creating and saving a new workbook
Creating and saving a new workbook
04:39

How to open an existing workbook
Opening an existing workbook
01:35

Creating a new workbook from a template
Creating a new workbook from a template
05:01

Saving a workbook as a template
Saving a workbook as a template
03:41

Opening a workbook using different options - Learn some of the more advanced and useful options when opening files.
Opening a workbook using different options
05:25

Using SAVE AS to create a new workbook
Using SAVE AS to create a new workbook
01:30

Saving a Excel 2010 workbook in Excel 2003 format
Saving a Excel 2010 workbook in Excel 2003 format
02:28

Saving a workbook as a PDF file
Saving a workbook as a PDF file
02:33

Saving a workbook in web page format (HTML)
Saving a workbook in web page format (HTML)
03:50

Printing workbooks - Printing is so much more straight forward in Excel 2010. A welcome addition.
Printing workbooks
04:30

Understanding text versus numeric cell entries
Understanding text versus numeric cell entries
05:40

Introducing the Quick Access Toolbar
Introducing the Quick Access Toolbar
06:43

How to minimize the Office Ribbon - Useful to know if you would like to use more of the screen for your work.
How to minimize the Office Ribbon
02:40

Navigating the Office Ribbon using the keyboard
Navigating the Office Ribbon using the keyboard
03:45

Navigating worksheets using the keyboard
Navigating around worksheets using the keyboard
05:18

Managing worksheets
Managing worksheets
04:17

Introducing the Mini Toolbar
Introducing the Mini Toolbar
03:37

Getting to know the Formula Bar
Getting to know the Formula Bar
05:35

How to select cells in different ways
How to select cells in different ways
04:49

Resizing rows and columns
Resizing rows and columns
02:13

Using AutoCorrect
Using AutoCorrect
02:52

Using AutoComplete
Using AutoComplete
02:24

Using AutoFill - Your new best friend.
Using AutoFill
06:50

Inserting and deleting cells, rows and columns
Inserting and deleting cells, rows and columns
03:25

A closer look at Cut, Copy and Paste
A closer look at Cut, Copy and Paste
07:34

Understanding Excel Operators
Understanding Excel Operators
05:46

A refresher course in the Order of Operations
A refresher course in the Order of Operations
04:46

Multi-user editing using the new Office Web Apps
Multi-User editing using the new Office Web Apps
03:50
+
Controlling Worksheets and Information
19 Lectures 01:37:59
Getting the most from the Office Clipboard
Getting the most from the Office Clipboard
07:43

Saving time with the Format Painter
Working with the Format Painter
03:14

Understanding the Font Group commands
Understanding the Font Group commands
05:03

Understanding the Alignment Group commands
Understanding the Alignment Group commands
02:43

Merging cells and wrapping text
Merging cells and wrapping text entries
04:56

Understanding the Number Group commands
Understanding the Number Group commands
06:32

Introducing Conditional Formatting
Introducing Conditional Formatting
09:08

Working with Table Styles
Working with Table Styles
05:14

Table formatting options
Table Style formatting options
05:22

Working with Cell Styles
Working with Cell Styles
05:16

Introducing Sparklines
Introducing Sparklines
08:49

Adjusting rows and columns using the Office Ribbon
Adjusting rows and columns using the Office Ribbon
04:36

How to hide and un-hide rows, columns and worksheets
How to hide and un-hide rows, columns and worksheets
03:25

Managing worksheets using the Office Ribbon
Managing worksheets using the Office Ribbon
01:38

Clearing cell contents and formatting
Clearing cell content and formatting
03:24

Sorting and filtering information
Sorting and filtering information
06:01

Using the Find and Replace tools
Using the Find and Replace tools
07:57

Using the Select Objects tool
Using the Select Objects tool
02:50

Working with the Selection Pane
Working with the Selection Pane
04:08
+
Inserting Objects Into Worksheets
11 Lectures 01:09:29
Inserting pictures into worksheets
Inserting a picture into a worksheet
13:46

Understanding the new picture editing tools
Understanding the new picture editing tools
04:19

Inserting and working with Clipart
Inserting and working with ClipArt
05:54

Inserting and working with Shapes
Inserting and working with Shapes
06:50

Introducing SmartArt graphics
Introducing SmartArt graphics
06:20

Introducing the new Screenshot tool
Introducing the new Screenshot tool
04:31

Using different types of Hyperlinks
Using different types of Hyperlinks
07:27

Working with Text Boxes
Working with Text Boxes
05:05

Inserting Headers and Footers into worksheets
Inserting Headers and Footers into worksheets
05:42

Working with WordArt
Working with WordArt
05:52

Inserting Equations and Symbols
Inserting Equations and Symbols
03:43
+
Organizing Worksheets and Workbooks
14 Lectures 57:50

Using Office Themes

Utilising Office Themes
03:37

Adjusting Page Margins and Orientation
Adjusting Page Margins and Orientation
04:32

Changing the Page Size and Print Area
Changing the Page Size and Print Area
05:05

Working with Page Breaks
Working with Page Breaks
03:50

Adding a worksheet background image
Adding a worksheet background image
01:19

Adding column and row headings to reports
Adding column and row headings to reports
02:46

Using Gridline and Heading options
Using Gridline and Heading options
02:23

Working with different Excel Views
Working with different Excel Views
05:27

Working with the Show and Zoom commands
Working with the Show and Zoom commands
02:17

Managing multiple workbook windows
Managing multiple workbook windows
04:40

Freezing rows and columns
Freezing rows and columns
06:11

Comparing workbooks side by side
Comparing workbooks side by side
02:57

Using the Spelling Checker and other proofing tools
Using the Spelling Checker and other proofing tools
08:36

Working with Comments
Inserting and managing worksheet Comments
04:10
+
Excel Security
10 Lectures 36:43
Protecting worksheets
Protecting worksheets
03:40

Protecting workbooks
Protecting workbooks
03:37

Allowing multi-user editing of workbooks

Sharing workbooks to allow multi-user editing
10:20

Using Mark As Final

Using Mark As Final
02:47

Password protecting your workbooks
Password protecting your workbooks
02:59

Other ways to protect your work
Other ways to protect worksheets and workbooks
01:50

IRM, DRM and Digital Signatures
Information Rights Management and Digital Signatures
02:17

The Document Inspector
Using the Document Inspector
03:09

Using the Accessibility Checker
Using the Accessibility Checker
02:53

Working with Protected View
Working with the Protected View feature
03:11
+
Working with Charts
10 Lectures 41:51
How to insert a chart
How to insert a Chart
04:13

Chart Basics
Chart Basics
03:20

Modifying the chart design
Modifying the chart design
06:32

Modifying the chart layout
Modifying the chart layout
09:41

Chart formatting options
Chart formatting options
06:35

Chart formatting tips
Chart formatting tips and techniques
02:19

Changing the default chart type
Changing the default chart type
01:30

The fastest way to insert a chart
The fastest way to insert a chart
02:09

Creating and using chart templates
Creating and using chart templates
03:06

Advanced data selection techniques
Advanced data selection techniques
02:26
+
Macros
9 Lectures 42:17
Recording a basic macro
Recording a basic macro
08:46

Saving a macro enabled workbook
Saving a macro enabled workbook
02:00

Macro Security Settings
Macro security settings
04:01

Absolute versus Relative cell referencing
Absolute versus Relative cell referencing
03:50

Assigning a macro to a button
Assigning a macro to a button
04:41

Adding a macro to the Quick Access Toolbar
Adding a macro to the Quick Access Toolbar
02:22

Editing a macro
Editing a macro
08:53

Troubleshooting a macro
Troubleshooting a macro
05:36

Enabling the Developer Tab
Enabling the Developer Tab
02:08
+
Mastering Pivot Tables
22 Lectures 01:43:27
Introducing Pivot Tables - They aren't so scary after all!
Introducing Pivot Tables
05:05

A quick look around Pivot Tables

A quick look around a Pivot Table
01:30

Adding data to Pivot Tables
Adding data to Pivot Tables
04:59

Customizing Report Data
Removing and customizing report data
02:17

Formatting Pivot Table Information
Formatting Pivot Table information
03:51

Sorting and filtering data
Sorting and filtering data
06:28

Working with Report Filters
Working with Report Filters
04:08

Customizing the Pivot Table screen layout
Customizing the Pivot Table screen layout
04:25

Basic Pivot Table options
Basic Pivot Table options
03:45

Working with Report Filter page options
Working with Report Filter page options
04:25

Pivot Table configuration options
Pivot Table configuration options
11:26

Drilling down into Pivot Table data
Drilling down into Pivot Table data
01:32

Data calculation options
Data calculation options
03:32

Grouping Pivot Table data
Grouping Pivot Table data
05:30

Grouping options relating to date information
Grouping options relating to Date information
05:16

Refreshing and modifying source data
Refreshing and modifying source data
05:08

Moving a Pivot Table
How to move a Pivot Table
06:50

Inserting a Pivot Chart
Inserting a Pivot Chart
04:12

How to create a Calculated Field
How to create a Calculated Field
04:05

Working with Pivot Table Styles
Working with Pivot Table Styles
02:19

Introducing the Slicer tool
Introducing the new Slicer tool
06:05

Inserting a Pivot Chart using the Office Ribbon
How to insert a Pivot Chart using the Office Ribbon
06:39
+
Formulas and Functions
15 Lectures 57:31
Introducing Formulas and Functions
Introducing Formulas and Functions
07:37

Formula and Function Basics
Formula and function basics
05:28

How to use the SUM function
How to use the SUM function
04:59

Understanding Absolute and Relative cell referencing
Understanding Absolute and Relative cell referencing
03:15

How to use the CONCATENATE function
How to use the CONCATENATE function
02:19

How to use the SUMIF function
How to use the SUMIF function
04:49

How to use the VLOOKUP function
How to use the VLOOKUP function
04:45

How to use the TRIM function
How to use the TRIM function
03:47

How to use the RANDBETWEEN function
How to use the RANDBETWEEN function
03:03

How to use the COUNTIF function
How to use the COUNTIF function
06:12

How to use the PMT function
How to use the PMT function
03:06

Formula auditing tools
Formula auditing tools
03:43

Error Checking formulas
Error checking tools for formulas
01:06

Evaluating formulas
Evaluating Formulas
01:16

Using the Watch Window
Using the Watch Window
02:06
2 More Sections
About the Instructor
VideoTraining Online
4.5 Average rating
26 Reviews
1,931 Students
2 Courses
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