Learn Microsoft Excel 2010
0.0 (0 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.
252 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn Microsoft Excel 2010 to your Wishlist.

Add to Wishlist

Learn Microsoft Excel 2010

Fast moving, easy to follow Microsoft Excel 2010 tutorial from the the e-learning experts!
0.0 (0 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.
252 students enrolled
Created by ClipTraining LLC
Last updated 3/2013
Current price: $15 Original price: $25 Discount: 40% off
1 day left at this price!
30-Day Money-Back Guarantee
  • 4.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • After completing this course you'll have the ability to prove your mastery of Microsoft’s standard spreadsheet application. With the skills learned in these easy to follow videos, any user will be fully competent and capable of working in a variety of business settings.
View Curriculum
  • Microsoft Excel 2010

In this Microsoft Excel 2010 course, ClipTraining provides a comprehensive instruction starting with the basics and on through the advanced features. 

With over 100 Video Tutorials and more then 4 hours of training; ClipTraining helps both the beginner and advanced user visualize what they are learning with step-by-step instruction from a Microsoft Excel Professional. 

Watch as the instructor performs progressive operations in each video starting with the Basics of Worksheets. Then moving onto Formatting, Formulas, Illustrations and Charts, Printing, and finishing off with 20 part sections on Advanced Excel Features. 

Along with the task-based, to-the-point videos, you'll receive an excellent downloadable 'ClipStart' PDF with helpful tips to get you started.

Take this course to learn all about Excel 2010 and be on your way to becoming a Microsoft Office pro.

Who is the target audience?
  • Anyone interested in learning Excel 2010 from beginners to advanced users. This course will help you learn the basics or refresh your knowledge and then provide a deeper understanding of advanced features. These videos are ideal for visual learners.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
103 Lectures
Introduction and Auxiliary Materials
2 Lectures 01:43

In this lecture clip we will provide an introduction to ClipTraining and information on how to best use our training materials.

Preview 01:43

Download this 2 page guide to help get you and your team up and running fast with Excel 2010!

ClipStart Guide for Excel
2 pages
The Basics of Workbooks and Worksheets
17 Lectures 39:57

In this clip, let's take a look around the Excel window, label the  parts, and see how to better navigate the interface.  We'll also see the Backstage view and how to use it.

Preview 02:53

In this clip we will take a close up look at the main tabs and groups on the ribbon.  Group names on the ribbon will cluster similar commands in groups so you can save time looking for a command.  See how screen tips can help you learn about a particular ribbon command.

Preview 03:34

Do you know another name for the File tab?  It's  called Backstage View.  Get a brief overview of the various commands in this clip.

Preview 02:22

In this clip we will see how to navigate through our worksheets. With the ability to create 255 worksheets in an Excel document, it's important to understand how to sort through them and access them.  Find out how in this lesson.

Understanding Worksheet Navigation

In this clip we will discuss how to add, delete or rename worksheets. Be careful when deleting a worksheet.  That data will be permanently gone so make sure you really mean to delete it!

Adding, Deleting and Renaming Worksheets

Don't let sensitive data become visible to others.  See what it takes to hide your worksheets from view and then restore them back when needed.

Hiding and Unhiding Worksheets

What does it take to move around the order of worksheets?  This clip explores how to accomplish this in detail.  We'll also see how useful it is to copy them and how to accomplish the copying of a worksheet.  Another useful thing to know is how to change sheet tab colors and this will be covered toward the conclusion of this clip.

Moving, Copying or Coloring Worksheets

Templates can be a real time saver in setting up your worksheets. The following templates are automatically installed when you start using Excel 2010: Billing Statement, Blood Pressure Tracker, Expense Report, Loan Amortization, Personal Monthly Budget, Sales Report, and Time Card.

Many additional templates are available for downloading from Microsoft Office online. See how to use templates in this clip.
Working with Templates

There are a couple of different ways to close Excel after you've finished working in it.  For example you can close just a spreadsheet and leave the application open or you can close the entire application down. This lesson shows this distinction and how to use these methods to close Excel.
Closing Excel

So how do you build an Excel worksheet from scratch?  This clip is the starting point for that as you learn how to enter data into a worksheet.  Getting started here with the basics will make sure you have the right foundation moving forward.
Entering Data

Learn how to get around worksheets with keyboard commands like Enter, Tab, Arrow Keys, Page Up /Down, Home key and more! You'll also be introduced to a couple of commands on the Home tab in the Editing group on the Find and Select drop down menu.  Discover how Excel pinpoints various aspects of your worksheet for you in this clip, for example cells that contain formulas.
Exploring Navigation Shortcuts

What type of data can be inserted into Excel?  All sorts!  This clip wil show you how to insert different types of data, such as text, numerical and dates.
Inserting Different Data Types

Sometimes when we enter data, we may want to provide an additional explanation in the worksheet to clarify why it is there or clear up some question about it.  Comments are an easy unobtrusive way to accomplish this.  Discover how this can be done in this clip.
Modifying Cell Comments

This clip shows you a quick way to insert data into multiple cells. See the various objects on the clipboard and how to pick which items you want inserted where.  Sounds tricky? It's not, just watch and learn.  Finally, this lesson closes with a nice explanation of the purpose of the shortcut key Ctrl+Enter in relation to Excel.
Using the Clipboard Pane

Ready for a timesaver?  Learn about a key tool in Excel – AutoFill.  Watch and learn in this lesson how to quickly fill cells with data automatically.
Understanding AutoFill

Forget about typing January, February, March, etc.  Learn how AutoFill can create this series and others like the days of the week, number sequences and dates.  Also see how AutoFill can look at a sequential range of numbers and continue building the sequence for you.  This is one clip you won’t want to miss!
Creating Series with AutoFill

By now we are all used to search engines automatically suggesting keywords as we type searches.  Not one to be left behind, Microsoft Excel features this same capability.  Watch this clip to see how to use this feature and also take a trip into advanced options to make sure your system is properly utilizing this feature.

Working with AutoComplete

Think you got it now that you've watched these clips?

Let's find out. 

The Basics Quiz Part One
9 questions

Mastered the second half of the Basics Clips? 

Check your progress here. You can do it!

The Basics Quiz Part Two
8 questions
Formatting and Conditional Formatting
17 Lectures 46:53
No more bland worksheets with default fonts and colors after this clip.  Get the facts on how to quickly customize the look of your worksheet.  You never knew you could be so creative in Excel!  See how to use bold, underline and italics along with a bevy of other font options in this quick clip.
Exploring the Font Group

Don't worry, after watching how to utilize the Font dialog box with its preview feature, you'll have all the confidence you need to get the most out of your fonts.  This short lesson will get you quickly up to speed on this feature.
Using the Font Dialog Box

Explore how to precisely position your text; whether in a cell or a group of cells.  One example provided in this lesson is how to use the Merge and Center command. This joins the selected cells into one larger cell and centers the contents in a new cell.  This feature is practical when you need to use labels that span multiple columns.
Exploring the Alignment Group

Ever wonder how to make your text appear on an angle in your worksheet?  Wonder no more after watching this brief tutorial clip.  See how to align and orient your text, like if you want it to run on an angle or even vertically.
Using the Alignment Dialog Box

On the Home tab on the ribbon is the Number group.  This lesson takes a close look at the specifics regarding the commands located here.  Learn about number styles such as a comma, dollar sign, and other accounting formats along with increase and decrease commands.
Understanding the Number Group

Where is the command to open the number dialog box?  Find out in this clip.  Also learn about different numerical categories you can assign to a cell or range such as currency, accounting, date, percentage, fraction and much more.
Using the Number Dialog Box

Why is it that sometimes Excel puts a lot of ##### in a cell?  Find out what this is and how to get rid of it in this lesson.  Also see how to take advantage of the AutoFit feature when working with data in multiple columns.
Adjusting Rows and Columns

The art of hiding and unhiding is discussed in this clip.  Where did that row go?  Where did that column go?  Did you hide it?  See how to do this and also discover how to unhide them. 
Using Hide and Unhide

What is Conditional Formatting? Conditional formatting allows you to change the appearance of a cell, depending on certain conditions.  Formatting your spreadsheet in this way allows you to see at a glance relevant information quickly through graphics or colors.  This clip looks at using conditional formatting in both ways.  This will be demonstrated through a data bar.  Check it out!
Formatting a Data Bar

This clip focuses on the commands found on the New Formatting Rule dialog box.  This dialog box allows you to configure rule types and then edit the Rule Description.  Sounds hard? – it’s not.  Watch and learn in this clip now.
Configuring Data Bar Rules

Similar to data bars, color scales graphically present you with the result of your data.  Learn how to add these to your data.  Simple and easy to use, color scales are an easy way to see what the numbers are doing.
Formatting with Color Scales

This lesson continues to look at conditional formatting and expands on the previous clips by introducing Icon Sets.  Find out how small graphic icons can tell the story of what is happening with your data.
Formatting with Icon Sets

Learn all about applying pre-configured rules for actions in your cells. Values you can learn in this clip to apply are: Greater Than, Less Than, Between, Equal To, Text that Contains, A Date Occurring and Duplicate values.
Configuring Highlight Cells Rules

Learn how to quickly benefit from pre-configured  rules that will show you the details such as the Top/Bottom 10%, Items or Average in a series of data.  This lesson shows you how to apply these and then locate these values in your cell range.  An invaluable tool, learn how to use it quickly by watching this clip.
Working with Top/Bottom Rules

Why just use one set of rules?  Learn how to benefit from a graphical representation of your selected rules; includes configuring cell data with multiple rules.  Are you making a mess out of it?  No problem, you’ll also see how to clean things up with the 'Clear rules From Selected Cells' command.
Manage Multiple Conditional Formatting Rules

In this lesson we'll see how to create cross sheet references.  What are these you ask?  These are cell references to other worksheets in your workbook.  See how you can graphically represent what is happening across one worksheet in a single cell.
Using Cross Sheet Conditional Formatting

Imagine this situation.  You want to apply conditional formatting but your range of data has errors.  No problem!  Watch how Excel deals with this situation and how you can apply conditional formatting to ranges with errors.
Working with Conditional Formatting in Ranges with Errors

Groups, Dialog Boxes, Rows and Columns; Oh My!

Groups, Dialog Boxes, Rows and Columns Quiz
8 questions

Think you have what it takes to Format? 

Lets see what you're made of!

Formatting and Conditional Formatting Quiz
10 questions
Working with Formulas and Functions
10 Lectures 24:42
What is a Formula? In just a few minutes you’ll learn exactly what they are and when to use them.  We'll also discuss operators and we'll see how to enter and edit those formulas.  Here’s a hint:  Formulas that involve adding, subtracting, multiplying and dividing usually start with an = sign. Watch and learn the rest of the formula in this clip.
Creating Formulas

What is a Function? How does it differ from a formula?  Get the facts quickly in this brief tutorial clip. We'll also show you how to insert a function into your worksheet.
Understanding Functions

Learn about this incredibly useful shortcut tool: AutoSum that takes all the guess work out of getting a quick summary of data. Just take a minute and watch this clip.
Using AutoSum

In this short clip see how to insert commonly used functions into your cells.  On display in this lesson are Average and Minimum.
Exploring Common Functions

This lesson shows off the Status Bar.  From here you can also add features to display like the minimum and maximum values in cells.  Also learn how to see the sum of data through the Status Bar!  Understand how to better utilize this helpful tool by watching this mini lesson.
Understanding Status Bar Results

The Function Library is located on the Formulas Tab and this group is replete with preset functions.  See how screen tips point the way to the function you need.  Gain a better understanding of this topic by viewing this quick clip.
Exploring the Function Library

Discover how to benefit from the Function  Arguments dialog box.  The example provided looks at calculating a loan payment.  See how to do this quick and easy.
Using the Insert Functions Command

See how to use logical functions in the context of calculating a sales commission based on performance.  If you watch this lesson, you can follow the example to mimic the results in your own worksheets!
Inserting Logical Functions

Get ready for a real timesaver as you see  the power of the Proper function located on the Formulas tab.  Forget about messy text throughout your worksheet.  Get it all cleaned up – and fast!
Working with Text Functions

Need a way to insert the date or the exact date and time?  Here’s a quick clip on getting this data painlessly into your cells.
Using Date Functions

We've given you the Formula. 

Now here's an experiment. No Cheating!

Working with Formulas and Functions
10 questions
Sorting and Filtering Data
9 Lectures 23:24
In this clip you will look at two different types of sorting.

(1) Ascending/Descending Sorts - See the right way and the wrong way to sort your data and then head over to the Editing group on the Home  tab to put your knowledge to work. 

(2)Using Table Column Headers - Done through the Sort dialog box, this enables sorting by multiple columns rows, case sensitive sorts and other sort options.
Exploring Sort and Filter Commands

This lesson details what is required to make a custom sort.  Specifically, this is contiguous rows and unique headings.  Want to see it in action?  Watch this short video lesson!
Preparing to Use Custom Sort

With your data prepared you are now ready for a color sort. So…how do we do a color sort?  Just watch and learn.
Performing a Color Custom Sort

See how to get the most out of the Sort and Filter dropdown in the Editing group on the Home tab.  An example in this clip utilizes the Custom Sort dialog box.  See it in action now.
Using Multiple Level Custom Sorts

Learn how to hide records you are not interested in seeing and only showing records you want to see.  The distinction between filtering and sorting is that sorting rearranges your data whereas filtering gives you an opportunity to hide (not delete) what you don't want to see.  This lesson will show you how to do it
Exploring Data Filters

This clip continues with data filters but keys in on filtering multiple columns.  Quick and easy. Watch this lesson and you’ll get the hang of this in a snap!
Filtering Multiple Columns

See how to quickly create subtotals between your groups of data.  Stop doing this manually! This clip will show you how to use automated features on the Data tab to accomplish this. 
Working with Subtotals

Discover how formulas look when used in a table and how to use the Autofilter tool when working in long spreadsheets.  Learn all of this in just a few minutes with this short tutorial lesson.
New Table Features

See how to turn on the AutoFilter, use the Search feature to quickly filter your data, and how to clear filters and turn off the AutoFilter.
Using Search Features

Done Sorting through these clips? 

Now Filter out the answers and get a 100% on this quiz. 

Sorting and Filtering Data
9 questions
Worksheet Protection and Various View Options
11 Lectures 23:57
Discover how to configure your workbook protection settings in this lesson. This is setup initially on the Save As dialog box on the Tools menu.  Watch this clip to see how to password protect your workbook.
Protecting Your Data

In the previous clip it was demonstrated how to password protect your entire workbook.  This lesson takes protection a step further by also showing you how to password protect individual sheets.  This will prevent unwanted changes to the data in a sheet by specifying what information can be changed.  All of this is done on the Review tab in the Changes group.
Modifying Workbook Protection Settings

This clip will teach you how to protect specific cells in your workbook by locking cells.  Attention is given to the Font dialog box and the Protection tab.  The example provided will show you how to lock down a worksheet while leaving open a specific data range for edits.
Protecting Cells in a Workbook

In this lesson you will learn how to prevent changes to the structure of the workbook such as moving, deleting or adding sheets.  Best of all you’ll learn it all in under 2 minutes!
Protecting a Workbook Window

Protected view is all about keeping your system safe from malicious software commands that may be transferred in an Excel file.  Learn about what Protected View is, what the Security Bar does for us, and how to enable a Protected File.
Understanding Protected View

Take a minute and see how to force an Excel file to open in Protected View.  This is useful in instances where you have a questionable document and you want to make sure it opens in a safe protected environment that can do no harm to your computer.
Requiring Protected View

This lesson takes you over to the View tab and examines the Workbook Views group.  Examples of different views include Normal, Page Layout, Page Break Preview and more.  Watch and learn how to switch between them.
Exploring Worksheet Views

In a little over a minute you’ll see how to zoom in, zoom out and how to get the most out of the zoom button and Zoom dialog box.  How do we do all that in so short a time?  Click the clip to find out!
Using Zoom Controls

Here’s a challenge for you: How do you determine the headings of a column in a worksheet with hundreds of rows?  That’s easy... freeze the panes! See how to do exactly that in this video.
Working with Freeze Panes

When it comes to comparing data at the top of a large worksheet with the data at the bottom of the worksheet, splitting the worksheet will make it real easy to see both sets of data.  In this clip you'll learn how to do it!
Splitting the Worksheet Views

The emphasis of this lesson is the Arrange All button located on the View tab.  This will let you tile all open Excel documents on the screen.  Discover how to best use the Arrange Windows dialog box.
Arranging Worksheet Views

Done watching these clips? 

Get it? Got it? Good!

Now take this quiz!

Worksheet Protection and Various View Options
11 questions
Working with Illustrations and Charts
9 Lectures 30:23
Get ready to add some life to your worksheets by adding illustrations to them.  See how to add pictures, resize them and add shapes of all kinds to your worksheet.  Quick and easy – you’ll love it!
Using Illustrations

Take advantage of Excel’s powerful photo editing features made available on the Picture Tools Format contextual tab.  Sure it’s a mouthful, but you’ll be singing its praises once you watch this clip and learn how to get the most of Quick Styles, Line Colors and a ton of preset graphic configurations for your pictures.
Formatting Pictures

Who knew shapes could come in such a variety of... well... shapes and sizes?!  Learn how to customize them and truly make your shapes unique in this video clip. Continuing on from the last clip, this lesson looks at the Drawing Tools Format contextual tab.  See how to modify and graphically enhance your shapes.  From shape fill to outline to 3D effects there are plenty of choices to create fantastic results.
Formatting Shapes

SmartArt graphics add color, shape, and emphasis to your text and data. It's easy to try out SmartArt graphics such as an organization chart, a time line or cycle. You can preview styles before choosing one, so you don't have to apply styles over and over again to find the one you want. And after you apply a style you can customize it with colors, animation, effects such as shadows, bevels, and glows, and more.  This lesson demonstrates how to create and modify an organizational chart through SmartArt.
Adding SmartArt into Worksheets

Here we see how to create a SmartArt diagram, find a style that allows pictures, and how to insert pictures into the SmartArt diagram.  Learn how to do all of this in just a few minutes by watching this video lesson. 
Adding Pictures in SmartArt

Charts are a nice way to express your data results in a visually appealing manner. For example, a pie chart may show the results of data in a simpler form than simply a long row of data.  This clip shows off pie and bar charts and also provides some simple explanations of chart terminology.
Exploring Charts

So what will it be, Line chart or Pie chart? Can’t decide?  No problem!  This short tutorial lesson teaches you in just a couple minutes how to build either one of them.
Create a Simple Chart

Rather than just accept the default text style, this lesson shows you how to completely customize your chart title and labels.  In this lesson, the Font dialog box is demonstrated and explained.
Customizing Text in Charts

Picking up where we left on in the last lesson, this clip explores chart formatting and how to modify chart colors and background.  Also demonstrated and explained is the Format Data Point dialog box and several of its commands.
Formatting Chart Components

Brace up your mind and take this quiz

on illustrations and charts. 

Working with Illustrations and Charts
9 questions
Printing, Proofing and More
6 Lectures 16:15
Customizing Print Options

When preparing for printing, it may be necessary to rescale the document to a specific paper width and height.  This lesson shows you how to do that by using the Page Layout tab on the ribbon.  See it in action now by watching this quick clip!
Scaling Page Dimensions

Learn how to turn off gridlines and headings.  The gridlines are the lines between the rows and columns in the sheet to make editing and reading easier.  Note: These lines will not print unless Print is also checked in the Sheet options dialog box.
Modifying Gridlines and Headlines

A simple but sometimes overlooked feature is shown in nice detail as both header and footer modification options are discussed and demonstrated.
Creating Headers and Footers

This lesson will show you how to add print titles to a spreadsheet so your headings print on every page, without having to create those headings more than once.  See how this can be done by watching this 2 minute clip.
Printing Titles

The proofing tools provided in Excel are Spell Check, Thesaurus and the Translate Tool.  Check out all these tools in action in this quick video lesson.
Using Proofing Tools

Now that you're a Printing and Proofing expert. 

Take this quiz and prove it. We know you can!

Printing, Proofing and More
6 questions
Advanced Excel Features
21 Lectures 45:13
See how easy it is to create names for your cells and learn why you might need to do this
Renaming a Cell

If you want to learn how to select a range of cells and then use the column heading as the name then take a minute to watch this clip.
Renaming Cell Ranges

Once you become adept at working with named cells and ranges, you may want to consider using the Name Manager to tidy up your names.  This short clip will show you how to modify these names using the Name Manager.
Using Name Manager

This helpful feature will make it easier to deal with situations when AutoFill does not enter the values you anticipated.
Working with Absolute References

As simple as can be: Discover how to use named cells in formulas.  This lesson demonstrates how to do this building off a named cell created in a previous lesson.
Using a Named Cell within a Formula

The Pivot Table is powerful and efficient feature of Microsoft Excel 2010.  With it you can summarize a table’s data by its different fields (the table’s columns), and utilize this to generate critical data associated with the table.  It only sounds complicated.  Watch this short lesson to see how it’s done.
Understanding PivotTables

The key to creating a PivotTable is clicking into the data.  That is one of the important steps to creating a simple PivotTable.  This clip will show you the entire process of creating a simple PivotTable.  3 minutes of your time well spent in this one clip!
Create a Simple PivotTable

Once your PivotTable is created, if you have changes or updates to make you don't have to start from the beginning.  You can update and adjust existing tables to create what you need.  This clip will show you how it's done!
Update Your PivotTable

Jumping off of the joy of PivotTables from previous lessons we can look at a new tool in Excel 2010 called Slicer that helps to really enhance the way a PivotTable works for us.  Take a look in this clip!
Understanding the Slicer Tool

You can change the look of your slices with some simple color formatting.  Learn how in this sub-minute clip!
Formatting the Slicer Tool

Learn how to create a PivotChart, how to put it on its own page and how to work with and adjust the chart and play with field buttons.
Customizing PivotCharts

Sparklines are a new feature in Excel 2010 and they help to provide a new visual representation of the data.  You can show a line, column or win/loss type of sparkline chart.  Learn how easy it is to use sparklines in this 2 minute clip!
Creating Sparklines

Once you have a sparkline included in your worksheet you might want to make some design adjustments.  See how in this clip!
Modifying Sparklines

You can use data ranges to make a sparkline chart.  In this quick clip we'll show you how to do it!
Inserting Sparklines from Data Ranges

Need to collaborate on Excel files with others?  This clip will show you how to save and send your files through Windows Live SkyDrive.
Saving to Excel WebApp

Learn how to locate and log in to Windows Live SkyDrive in this quick clip!
Logging in to Excel WebApp

Working with Excel WebApp can be done through SharePoint 2010 or through Windows Live.  In this clip, watch what you can do through Excel WebApp.
Modifying Excel WebApp Documents

Need to see the different versions of your documents in Excel WebApp?  This clip will quickly show you how to do this!
Viewing an Excel WebApp Document Version History

Take a quick tour of the different menu options within Excel WebApp!
Exploring Excel WebApp Menu Features

Need to make your ribbon disappear?  This clip will show you how to make that ribbon go bye-bye until you need it again!
Hiding the Ribbon

Working with the ribbon is not rocket science.  In fact, it takes only 5 minutes to master.  Don't believe us?  Watch this clip and we'll prove it to you!!!
Customizing the Ribbon

Now that you're in the Advanced Features you should 

feel like a pro. Take this quiz to prove it!

Advanced Excel Features Quiz Part One
10 questions

This is it, the last one. 

You can do it!

Advanced Excel Features Quiz Part Two
11 questions
Additional Training Clips
1 Lecture 03:26
In this clip you will learn how to work with VLookup!
About the Instructor
ClipTraining LLC
4.3 Average rating
124 Reviews
1,787 Students
20 Courses
Learn what you need, when you need!

ClipTraining is a leading creator of eLearning for Microsoft Office, Microsoft Windows, and many more business applications. The ClipTraining Library is a continuously growing resource for educating and supporting individuals, K-12 students, and business organizations. Through to-the-point, task-based lessons called Clips, every student is empowered with on-demand knowledge to expand their skills. Having access to our courses is like working with the expert by your side!