Learn Excel 2010

Acquire Solid Spreadsheet Skills

Excel is the industry-standard spreadsheet program, and almost all of us find ourselves using it at one point or another. In this workshop veteran author Chris Grover teaches you the fundamental skills you need to work with Excel, starting with basics like entering and formatting numbers and text, then moving on to writing formulas and using Excel’s built-in functions. You’ll learn about sorting, filtering, and lookup, as well as charts, graphs and sparklines, and even advanced tools like pivot tables. Along the way, you’ll become familiar with the new features in Excel 2010 and learn techniques for troubleshooting your spreadsheet when something goes wrong.

Trainer: Chris Grover

January, 2013

Duration: 3 hrs 50 min

Ready for iPad, Android, and HTML5

Powerful, Feature-Rich Interface

HD Video

Excel

Add to Cart Downloads

Similar Courses

Welcome to Learn Excel 2010

In this chapter you'll be introduced to Excel and its interface, including the Backstage view, the Ribbon, the Quick Access Toolbar, and more.

Understanding Excel and Its User Interface
- Wondering how or why you'd use Excel? This lesson shows how Excel helps you keep track of the details for many different types of projects.
  
  Why Use Excel?
  
  03:21
- The File tab takes you to Excel's Backstage view, where you can create, open, and save files. You'll also get an introduction to printing and sharing files in this lesson.
  
  Checking Out Excel's Backstage View with the File Tab
  
  05:54
- In this lesson you'll learn how to examine the details that Excel stores with your files, such as properties, dates, and permissions. You'll also get some tips for sharing your files with others.
  
  Examining Your File's Info
  
  02:55
- This lesson looks at Excel's Ribbon. You'll learn how to choose commands, minimize the Ribbon when you need more room for your workbook, and use the Ribbon's shortcut keys.
  
  Exploring Excel's Ribbon
  
  06:38
- In this lesson you'll learn how to customize Excel's Quick Access Toolbar and Ribbon with the commands you like to use.
  
  Customizing the Ribbon and Quick Access Toolbar
  
  03:41
In this chapter you'll learn how to perform basic tasks like creating a workbook from a template; adding, copying, and removing worksheets; moving around within your workbooks and worksheets; and more.

Getting Started with Basic Tasks in Excel
- Excel gives you access to hundreds of predesigned templates that let you save time and get professional results for all sorts of projects. This lesson will show you how to choose and use templates, as well as how to create your own.
  
  Creating Workbooks from Templates
  
  05:40
- Excel lets you save files in different file formats so that they can be opened with older versions of Excel, used as templates, or viewed as PDF files. This video will show you how it's done.
  
  Saving Workbooks to Different File Formats
  
  05:52
- Excel provides different views of your worksheets for different tasks. This lesson will explore the Normal, Page Layout, and Page Break Preview views. You'll learn when and why you'd choose one view over another and how to add headers and adjust page breaks. We'll also explore different ways to quickly zoom in and out of a worksheet.
  
  Switching Between Views
  
  03:28
- Learning to navigate within your worksheets and workbooks is an important basic skill. This lesson will show you how to move around using both the mouse and the keyboard.
  
  Moving Around Your Worksheets and Workbooks
  
  05:57
- Workbooks can hold multiple worksheets, and in this lesson you'll learn how to add new worksheets to a workbook. You'll also learn how to copy, rename, and delete worksheets.
  
  Adding, Copying, and Removing Worksheets
  
  03:25
This chapter gets into the nitty-gritty of working with content in your spreadsheet. You'll learn how to add and format text and numbers; use AutoSum and references; cut, copy, and paste; and more.

Developing Your Spreadsheet
- A fundamental part of building a worksheet is entering and formatting text and numbers. This lesson provides tips and shortcuts for quickly adding content and formatting it to emphasize parts of your worksheet.
  
  Entering and Formatting Text and Numbers
  
  06:32
- Aligning text and numbers makes it easier to understand their relationship and also makes your spreadsheets look better. This lesson looks at the alignment options in the Alignment group on the Home tab.
  
  Aligning Text and Numbers
  
  03:50
- Your worksheets communicate valuable information through number formatting. In this lesson you'll learn how to change cell formats to indicate whether a number is currency, a percentage, a fraction, or a date.
  
  Choosing Number Formats
  
  04:41
- The AutoSum and Fill tools are among the most powerful in Excel, yet they're very easy to use. You'll learn all about them in this lesson.
  
  Totaling Rows and Columns with AutoSum and Fill
  
  03:41
- Referencing cells and then using those references in formulas is a core function of spreadsheets. In this lesson you'll learn how to reference cells and ranges of cells. You'll also see how those references are used in simple formulas and functions.
  
  Referencing Cells by Row and Column
  
  04:42
- Workbooks often contain more than one worksheet, so in this lesson you'll learn how to reference cells that are in a different worksheet.
  
  Referencing Cells in Another Worksheet
  
  03:22
- In Excel, your editing tools (cut, copy, and paste) are similar to those in a word processor, but there are some significant differences in the way they work. This lesson shows how to cut, copy, and paste words, numbers, and formulas.
  
  Cutting, Copying, and Pasting
  
  07:14
- There's a difference between clearing the contents of a cell and deleting a cell. This lesson illustrates the difference and shows you how to do both.
  
  Clearing Contents and Deleting Cells
  
  02:32
- When you work with large worksheets, it's sometimes hard to see everything you want in one view. This lesson will show you how to view two different parts of a worksheet at once.
  
  Splitting the Worksheet View and Freezing Panes
  
  03:44
- Excel provides some special tools to make it easier to work with multiple workbooks. In this lesson you'll learn how to automatically arrange two windows and how to synchronize the scrolling.
  
  Working with Two Workbooks and Syncing the View
  
  02:51
The real power of Excel comes from what you can do with formulas. This chapter looks at writing, using, formatting, and troubleshooting formulas.

Creating More Complex Formulas
- Formulas are at the heart of Excel. In this lesson you'll learn how to write formulas that include the basic arithmetic operations: addition, subtraction, multiplication, and division.
  
  Writing Your Own Formulas
  
  06:12
- It's important to understand the difference between relative references and absolute references. This lesson illustrates the difference and explains why you might want to use one or the other.
  
  Understanding Relative and Absolute References
  
  04:40
- It's not necessary to write every formula from scratch; you can save time and increase your accuracy by using Excel's predesigned functions. In this lesson you'll see how to use the function builder feature.
  
  Using Functions like ROUNDUP(), AVERAGE(), and IFERROR()
  
  09:52
- Excel stores dates and times as a serial number. In this lesson you'll learn how to use number formatting to display this information in a useful manner.
  
  Formatting Dates and Times
  
  05:46
- There are a number of functions that can help you extract useful information from date and time serial numbers. This lesson will show you how to use that information in a formula.
  
  Using Date and Time Functions
  
  04:14
- You can be more efficient and develop more readable formulas when you apply names to cells and ranges of cells. This lesson shows you how.
  
  Naming Cells and Ranges
  
  05:19
- What do you do when Excel indicates that there's an error in your worksheet? This lesson translates the error messages and shows you how to find a fix.
  
  Using LOOKUP() functions
  
  06:20
- For worksheets where each formula is dependent on the previous one, it can be difficult to zero in on an error. This lesson will show you how to use Excel's "trace" tools to pinpoint the cell with the error.
  
  Fixing Common Errors
  
  05:22
Sooner or later you'll find that you want to make changes to your workbook, and this chapter will show you how. You'll learn how to move, add, remove, and merge cells, rows, and columns, as well as how to add comments to your worksheets.

Making Changes to Your Workbook
- This lesson will show you how to move, insert, and remove columns and rows in your worksheet.
  
  Moving, Inserting, and Removing Cells, Rows, and Columns
  
  03:27
- It's not unusual to want to transpose the rows and columns in a worksheet. This lesson will show you how to do it.
  
  Transposing Rows and Columns
  
  02:29
- Merging cells in your worksheet not only makes them look better, but also makes them better at communicating the underlying data. This lesson will show you how to merge (and unmerge) cells.
  
  Merging and Unmerging Cells
  
  04:20
- Comments let you add text to your worksheet without making it part of a cell. This lesson will show you how to use text boxes and how to create comments.
  
  Adding Comments to Worksheets
  
  04:31
If you'd like to jazz up your worksheets with colors, charts, photos, and graphics, this chapter will show you how.

Visualizing Your Data with Color, Charts, and Graphics
- You don't have to be a graphic artist to use Excel's themes, which provide predesigned combinations of colors, fonts, and effects. When your work looks good, you look good.
  
  Changing Worksheet Colors, Fonts, and Effects
  
  04:26
- The numbers in your worksheets tell a story, and that story becomes crystal clear when you translate the numbers into a chart. This lesson shows how easy it is.
  
  Creating Charts
  
  05:34
- Excel gives you a variety of charts that you can add to your worksheets with a couple mouse clicks. This lesson will show you how to choose the chart that matches your numbers.
  
  Choosing the Right Chart for Your Data
  
  04:60
- You can emphasize the important points in your numbers by customizing the data elements and labels in your chart. This lesson will show you how.
  
  Changing Your Chart's Appearance
  
  04:47
- Sparklines are miniature graphs that you use to visualize trends in rows and columns of numbers. In this lesson you'll learn how to use these single-cell "data words" in your worksheets.
  
  Using Sparklines as Data Words
  
  04:06
- Images can help tell the story behind the numbers. This lesson will show you how to liven up those rows and columns of numbers with photos, graphics, clip art, and SmartArt.
  
  Inserting Photos, Graphics, and Clip Art
  
  07:04
- This lesson will show you how to add artwork, such as a letterhead, to your worksheets.
  
  Using an Image for a Header
  
  04:05
Excel offers some powerful tools for data analysis. In this chapter we'll look at creating a data table or pivot table, sorting and filtering data, importing data from an outside source, and more.

Analyzing Data
- Excel can perform the functions of a "flat file" database. This lesson will show you how to create a database and turn on the database features in a worksheet.
  
  Creating a Data Table
  
  03:57
- In this lesson you'll learn how to add records and modify the structure of an Excel data table.
  
  Adding Records and Modifying a Data Table
  
  02:33
- Excel's sorting and filtering tools make it easy to find records in your database, as you'll see in this lesson.
  
  Sorting and Filtering Data in a Table
  
  05:06
- You may not always want to create a data table from scratch. In this lesson you'll see how to import data from a separate file.
  
  Importing Data from an Outside Source
  
  05:04
- Outlines and grouping provide a convenient way to show or hide rows and columns of data. This lesson will demonstrate.
  
  Grouping Data in Outlines
  
  03:12
- Pivot tables give you a quick way to see your data from a different perspective. This lesson will show you how to create a pivot table from existing data and how to change the data and relationships in a pivot table.
  
  Building a Pivot Table
  
  05:04
- You can make the import numbers in your worksheet pop out using conditional formatting, which can be applied in two ways: You can manually set conditions and formats, or you can use Excel's predesigned formats. This lesson looks at both.
  
  Highlighting Data with Conditional Formatting
  
  04:55
In this chapter you'll learn about Excel's options for printing your worksheets and sharing them with others via email.

Printing and Sharing Your Worksheet
- Printing a worksheet is different from printing text in your word processor. This lesson gives you the lowdown, showing you how to fit your work to a page and place the proper title left and above the numbers.
  
  Printing a Worksheet with Column and Row Headers
  
  05:53
- You may know the best places for page breaks in your worksheet, but you have to let Excel know where they are. This lesson will show you how.
  
  Setting Up Page Breaks
  
  04:14
- Want to share a worksheet so that a colleague can use it or make changes? The quickest and easiest way is to email a copy, as you'll see in this lesson.
  
  Emailing a Workbook
  
  03:23

Welcome to Learn Excel 2010

In this course you’ll learn the fundamentals of Microsoft Excel 2010. The contents of this course include:

Understanding Excel and Its User Interface
In this chapter you’ll be introduced to Excel and its interface, including the Backstage view, the Ribbon, the Quick Access Toolbar, and more.

Getting Started with Basic Tasks in Excel
In this chapter you’ll learn how to perform basic tasks like creating a workbook from a template; adding, copying, and removing worksheets; moving around within your workbooks and worksheets; and more.

Developing Your Spreadsheet
This chapter gets into the nitty-gritty of working with content in your spreadsheet. You'll learn how to add and format text and numbers; use AutoSum and references; cut, copy, and paste; and more.

Creating More Complex Formulas
The real power of Excel comes from what you can do with formulas. This chapter looks at writing, using, formatting, and troubleshooting formulas.

Making Changes to Your Workbook
Sooner or later you’ll find that you want to make changes to your workbook, and this chapter will show you how. You’ll learn how to move, add, remove, and merge cells, rows, and columns, as well as how to add comments to your worksheets.

Visualizing Your Data with Color, Charts, and Graphics
If you’d like to jazz up your worksheets with colors, charts, photos, and graphics, this chapter will show you how.

Analyzing Data
Excel offers some powerful tools for data analysis. In this chapter we’ll look at creating a data table or pivot table, sorting and filtering data, importing data from an outside source, and more.

Printing and Sharing Your Worksheet
In this chapter you’ll learn about Excel’s options for printing your worksheets and sharing them with others via email.

The lessons are wrapped in a feature-rich interface that lets you jump to any topic and bookmark individual sections for later review. Full-Screen mode provides a hi-def, immersive experience, and Watch-and-Work mode shrinks the video into a small window so you can play the videos alongside your application. Also included are exercise files that give you an easy way to try out the techniques you learn.

System Requirements

Broadband internet connection
Up-to-date browser with Flash plug-in
Screen resolution 1024x768 or higher
Sound card with speakers or headphones attached
Pentium 4 2.6 GHz or higher, or Apple Mac G5
512 MB RAM

Ready for iPad, Android, and HTML5

It's easy to watch this course from your Android device, iPad, or iPhone (4 or later). Access videos straight from your browser, or, for Android devices or iPads, use this course in one of our free apps.

Project Files (Downloadable Feature)

Project files are included with this course so you can practice what you learn and work right along with the videos.

Powerful, Feature-Rich Interface

This course features video2brain’s interactive interface. As you navigate the course, rolling over a chapter or video brings up text describing that item.

Full-Screen mode provides a hi-def, immersive experience. And Watch-and-Work mode puts the video into a resizable window that you can shrink so you can watch the lessons on one side of your screen while you’re following along and applying what you’ve learned on the other.

HD Video

This course comes in crisp 1280 x 720 high definition video.

Bookmarks (Downloadable Feature)

Available in the downloadable version of our courses, this feature makes it easy to create a custom bookmark in any lesson to mark where you left off or to make note of something you want to refer back to later. You can even add a name or short note to remind yourself what the bookmark is for.

No comments yet

Recommended Courses

Learn Excel 2010

Acquire Solid Spreadsheet Skills

About this lesson

Welcome to Learn Excel 2010

System Requirements

Welcome to video2brain!

Other sites. Andere Seiten. Otros sitios. Autres sites.