Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
|Section 1: Introduction and Auxiliary Materials|
In this lecture clip we will provide an introduction to ClipTraining and information on how to best use our training materials.
Download this 2 page guide to help get you and your team up and running fast with Excel 2010!
|Section 2: The Basics of Workbooks and Worksheets|
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.
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.
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.
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.
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!
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.
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.
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.
|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.|
|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.|
|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.|
|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.|
|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.|
|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.|
|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.|
|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!|
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.
The Basics Quiz Part One
The Basics Quiz Part Two
|Section 3: Formatting and Conditional Formatting|
|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.|
|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.|
|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.|
|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.|
|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.|
|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.|
|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.|
|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.|
|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!|
|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.|
|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.|
|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.|
|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.|
|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.|
|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.|
|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.|
|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.|
Groups, Dialog Boxes, Rows and Columns Quiz
Formatting and Conditional Formatting Quiz
|Section 4: Working with Formulas and Functions|
|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.|
|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.|
|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.|
|In this short clip see how to insert commonly used functions into your cells. On display in this lesson are Average and Minimum.|
|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.|
|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.|
|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.|
|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!|
|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!|
|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.|
Working with Formulas and Functions
|Section 5: Sorting and Filtering Data|
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.
|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!|
|With your data prepared you are now ready for a color sort. So…how do we do a color sort? Just watch and learn.|
|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.|
|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|
|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!|
|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.|
|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.|
|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.|
Sorting and Filtering Data
|Section 6: Worksheet Protection and Various View Options|
|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.|
|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.|
|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.|
|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!|
|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.|
|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.|
|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.|
|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!|
|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.|
|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!|
|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.|
Worksheet Protection and Various View Options
|Section 7: Working with Illustrations and Charts|
|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!|
|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.|
|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.|
|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.|
|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.|
|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.|
|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.|
|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.|
|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.|
Working with Illustrations and Charts
|Section 8: Printing, Proofing and More|
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!|
|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.|
|A simple but sometimes overlooked feature is shown in nice detail as both header and footer modification options are discussed and demonstrated.|
|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.|
|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.|
Printing, Proofing and More
|Section 9: Advanced Excel Features|
|See how easy it is to create names for your cells and learn why you might need to do this|
|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.|
|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.|
|This helpful feature will make it easier to deal with situations when AutoFill does not enter the values you anticipated.|
|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.|
|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.|
|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!|
|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!|
|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!|
|You can change the look of your slices with some simple color formatting. Learn how in this sub-minute clip!|
|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.|
|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!|
|Once you have a sparkline included in your worksheet you might want to make some design adjustments. See how in this clip!|
|You can use data ranges to make a sparkline chart. In this quick clip we'll show you how to do it!|
|Need to collaborate on Excel files with others? This clip will show you how to save and send your files through Windows Live SkyDrive.|
|Learn how to locate and log in to Windows Live SkyDrive in this quick clip!|
|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.|
|Need to see the different versions of your documents in Excel WebApp? This clip will quickly show you how to do this!|
|Take a quick tour of the different menu options within Excel WebApp!|
Advanced Excel Features Quiz Part One
Advanced Excel Features Quiz Part Two
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!
30 day money back guarantee
Available on desktop, iOS and Android
Certificate of completion
Hours of video content