Excel 2010

Visit Tutorial Page ( Report)

Excel 2010 is the spreadsheet application in the Microsoft Office 2010 suite. Get help organizing and calculating data in this Excel 2010 tutorial.

  • Excel Formulas: Solving Real-Life Problems in Excel

    Solving math problems in Excel can be tricky, but it's simple if you know how to break them down into one or more formulas. Watch this video to learn some strategies for writing formulas that work!

  • Excel 2010: Intro to Worksheets

    Every Excel workbook contains at least one or more worksheets. If you are working with a large amount of related data, you can use worksheets to help organize your data and make it easier to work with. In this lesson, you will learn how to name and add color to worksheet tabs, and how to add, delete, copy, and move worksheets. Additionally, you will learn how to group and ungroup worksheets, and freeze columns and rows in worksheets so that they remain visible even when you are scrolling. When you open an Excel workbook, there are three worksheets by default. The default names on the worksheet tabs are Sheet1, Sheet2 and Sheet3. To organize your workbook and make it easier to navigate, you can rename and even color-code the worksheet tabs. Additionally, you can insert, delete, move, and copy worksheets. Watch the video to learn about worksheets.

  • Excel 2010: Grouping Worksheets

    Edit multiple worksheets at a time by learning how to use the group feature in Excel 2010. You can work with each worksheet in a workbook individually, or you can work with multiple worksheets at the same time. Worksheets can be combined together into a group. Any changes made to one worksheet in a group will be made to every worksheet in the group. Watch the video to learn about grouping and ungrouping worksheets.

  • Excel 2010: Freeze Panes

    Find out how to freeze worksheet panes to make your data easier to read when scrolling in Excel 2010. The ability to freeze specific rows or columns in your worksheet can be a very useful feature in Excel. It is called freezing panes. When you freeze panes, you select rows or columns that will remain visible all the time, even as you are scrolling. This is particularly helpful when working with large spreadsheets. Watch the video to learn about freezing worksheet panes.

  • Excel 2010: Printing

    There are many choices you can make when printing an Excel workbook. You can choose what parts of a workbook to print and how the data fits on the page. In this lesson, you will learn how to print worksheets, workbooks, and selections of cells. You will also learn how to prepare for printing by modifying page orientation, scale, margins, Print Titles, and page breaks. In previous versions of Excel, there was a Print Preview option that allowed you to preview and modify the workbook before printing. You may have noticed that this feature seems to be gone in Excel 2010. It actually has not disappeared; it has just been combined with the Print window to create the Print pane, which is located in Backstage view. Watch the video to learn about printing in Excel 2010.

  • Excel 2010: Complex Formulas

    Excel is a spreadsheet application that can help you calculate and analyze numerical information for household budgets, company finances, inventory, and more. To do this, you need to understand complex formulas. In this lesson, you will learn how to write complex formulas in Excel following the order of operations. You will also learn about relative and absolute cell references and how to copy and fill formulas containing cell references. Simple formulas have one mathematical operation, such as 5+5. Complex formulas have more than one mathematical operation, such as 5+5-2. When there is more than one operation in a formula, the order of operations tells us which operation to calculate first. In order to use Excel to calculate complex formulas, you will need to understand the order of operations. Watch the video to learn about the order of operations in complex formulas.

  • Excel 2010: Cell References

    In order to maintain accurate formulas, it is necessary to understand how cell references respond when you copy or fill them to new cells in the worksheet. Excel will interpret cell references as either relative or absolute. By default, cell references are relative references. When copied or filled, they change based on the relative position of rows and columns. If you copy formula (=A1+B1) into row 2, the formula will change to become (=A2+B2). Absolute references, on the other hand, do not change when they are copied or filled and are used when you want the values to stay the same. Watch the video to learn how to copy and fill relative and absolute references.

  • Excel 2010: Basic Functions

    Figuring out formulas for calculations you want to make in Excel can be tedious and complicated. Fortunately, Excel has an entire library of functions or predefined formulas that you can take advantage of. You may be familiar with common functions like sum, average, product or count, but there are hundreds of functions in Excel, even for things like formatting text, referencing cells, calculating financial rates, analyzing statistics, and more. In this lesson, you will learn the basics of inserting common functions into your worksheet by utilizing the AutoSum and Insert Functions commands. You will also become familiar with how to search and find various functions, including exploring Excel's Functions Library. A function is a predefined formula that performs calculations using specific values in a particular order. One of the key benefits of functions is that they can save you time since you do not have to write the formula yourself. Excel has hundreds of different functions to assi

  • Excel 2010: Sorting

    ‪With over 17 billion cells in a single worksheet, Excel 2010 gives you the ability to work with an enormous amount of data. Arranging your data alphabetically, from smallest to largest, or other criteria, can help you find the information you're looking for more quickly. In this lesson, you will learn how to sort data to better view and organize the contents of your spreadsheet. Sorting is a common task that allows you to change or customize the order of your spreadsheet data. For example, you could organize an office birthday list by employee, birthdate, or department, making it easier to find what you're looking for. Custom sorting takes it a step further, giving you the ability to sort multiple levels (such as department first, then birthdate, to group birthdates by department), and more.

  • Excel 2010: Outlining

    ‪If the amount of data in your worksheet becomes overwhelming, creating an outline can help. Not only does this allow you to organize your data into groups, and then show or hide them from view; you can also summarize data for quick analysis using the Subtotal command (for example, subtotaling the cost of office supplies depending on the type of product). In this lesson, you will learn how to outline your worksheet in order to summarize and control how your data is displayed. Outlines give you the ability to group data that you may want to show or hide from view, and create a quick summary using the Subtotal command. Because outlines rely on grouping data that is related, you must sort before you can outline. For more information, you may want to review the Sorting Data lesson.

  • Excel 2010: Filtering Data

    Filters can be used to narrow down the data in your worksheet and hide parts of it from view. While it may sound a little like grouping, filtering is different in the way that it allows you to qualify and display only the data that interests you. For example, you could filter a list of survey participants to view only those who are between the ages of 25-34. You could also filter an inventory of paint colors to view anything that contains the word "blue," such as "bluebell" or "robin's egg blue."

  • Excel 2010: Formatting Tables

    Once you have entered information into a spreadsheet, you may want to format it. Formatting your spreadsheet can not only improve the look and feel, but also make it easier to use. In a previous lesson, we discussed many manual formatting options such as bold and italics. In this lesson, you will learn how to format as a table, to take advantage of the tools and predefined table styles available in Excel 2010.

  • Excel 2010: Reviewing Workbooks

    Suppose someone asked you to proofread or collaborate on a worksheet they put together. If you had a hard copy, you might use a red pen to cross out cell data, mark misspellings, or add comments in the margins. However, you could also do all of these things in Excel using the Track Changes and Comments features. When you've finished reviewing the worksheet, the other person can choose to automatically Accept all of your changes, or decide whether to Accept or Reject each change one-by-one. In this lesson, you will learn how to track changes, add comments, and compare two versions of a worksheet. You will also learn how to prepare a final version for sharing, including how to check spelling. Watch the video to learn about tracking changes and adding comments to worksheets.

  • Excel 2010: Finalizing Workbooks

    Before you send your workbook out, take a minute to prepare a final copy. Excel has tools that might save you from sharing a workbook that contains spelling errors, or information about the workbook itself that you do not want the recipient to see. Use the Spelling command to find and edit any misspelled words; use the Document Inspector to find and delete any hidden data or personal information that is stored in the workbook, such as hidden comments, invisible objects, and file paths; and consider your Protect Workbook options, designed to keep other users from making unwanted changes to your workbook.

  • Excel 2010: Templates

    In Excel 2010, you have many templates that can save you a lot of time. A template is a pre-designed spreadsheet that you can use to create new spreadsheets with the same formatting and predefined formulas. With templates, you don't need to know how to do the math, or even how to write formulas - these are already integrated into the spreadsheet. In this lesson, you will learn how to create a new workbook with a template, as well as basic information about how templates work in Excel 2010.

  • Excel 2010: Charts

    A chart is a tool you can use in Excel to communicate your data graphically. Charts allow your audience to see the meaning behind the numbers, and they make showing comparisons and trends a lot easier. In this lesson, you will learn how to insert charts and modify them so that they communicate information effectively. Excel workbooks can contain a lot of data, and that data can often be difficult to interpret. For example, where are the highest and lowest values? Are the numbers increasing or decreasing? The answers to questions like these can become much clearer when the data is represented as a chart. Excel has many different types of charts, so you can choose one that most effectively represents the data.

  • Excel 2010: Sparklines

    Sparklines are miniature charts that fit into a single cell. Because they're so compact, you can place a large number of them in your worksheets. For example, you could place one sparkline on each row to show trends within that row. In this lesson, you will learn how to insert sparklines and change their type and appearance. Sparklines were introduced in Excel 2010 to be a convenient alternative to charts. Unlike a traditional chart, a sparkline is placed inside a cell, allowing you to easily create a large number of sparklines (for example, one on each row). Watch the video to learn about creating and modifying sparklines. There are three different types of sparklines: Line, Column, and Win/Loss. Line and Column work the same as line and column charts. Win/Loss is similar to Column, except it only shows whether each value is positive or negative, instead of how high or low the values are. All three types can display markers at important points, such as the highest and lowest points

  • Excel 2010: Conditional Formatting

    Imagine you have a spreadsheet with thousands of rows of data. It would be extremely difficult to see patterns and trends just from examining the raw data. Excel gives us several tools that will make this task easier. One of these tools is called conditional formatting. With conditional formatting, you can apply formatting to one or more cells based on the value of the cell. You can highlight interesting or unusual cell values, and visualize the data using formatting such as colors, icons, and data bars. In this lesson, you will learn how to apply, modify, and remove conditional formatting rules. Conditional formatting applies one or more rules to any cells that you want. An example of a rule might be "If the value is greater than 5,000, color the cell yellow." By applying this rule to the cells in a worksheet, you'll be able to see at a glance which cells are over 5,000. There are also rules that can mark the top 10 items, all cells that are below the average, cells that are within

  • Excel 2010: Pivot Tables Part 1

    PivotTables - Part 1: Learn to view, manage and summarize your Excel data with PivotTables.

Write Your Review