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.
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.
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.
Think you got it now that you've watched these clips?
Let's find out.
Mastered the second half of the Basics Clips?
Check your progress here. You can do it!
Groups, Dialog Boxes, Rows and Columns; Oh My!
Lets see what you're made of!
Now here's an experiment. No Cheating!
Done Sorting through these clips?
Now Filter out the answers and get a 100% on this quiz.
Get it? Got it? Good!
Now take this quiz!
Brace up your mind and take this quiz
on illustrations and charts.
Take this quiz and prove it. We know you can!
feel like a pro. Take this quiz to prove it!
You can do it!
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!