Search the site for help on a problem you have right now or browse the lessons below to improve your skills. We're adding new lessons all the time, so check back often.
Using the SUBTOTAL() function with the Autofilter feature
If you’re using the Autofilter feature, you’re probably wondering how to perform calculations on only those values that are being displayed by the filter. The SUBTOTAL() function is the answer.
Absolute and relative references in Excel
When you create a formula in Excel that refers to other cells in the worksheet, Excel will store the information about those cells as relative references. Relative references and their counterpart, absolute references, are one of the things that make spreadsheets such a powerful tool.
Copying formatting from one cell to another using Format Painter
If you have formatted a cell and want to use the same formatting for another cell or cells, you can easily copy the formatting from that cell to as many additional cells as you like.
Create a PDF from Word, Excel, PowerPoint or any Microsoft Office document
If you need a free option to create a PDF of a Microsoft Office document, your options will depend on which version of Microsoft Office you are using.
Adding up numbers in Microsoft Word
If you’re using Word to present a table of data that includes numbers, you can use Word’s built in formulas to add up those numbers rather than manually calculate them each time they change. This can also eliminate the possibility of error – particularly important if you’re producing a sales proposal or an important report.
Set banding colors in Word 2010 table styles
Word 2010 offers Table Styles to allow you to apply a style to a table in your document.
One of the challenges that can stump you the first time around is setting the color styles for odd/even banding of tables or columns. This lesson describes how to set these on an existing or custom table style.
Print an Excel 2010 spreadsheet with page numbers
In this lesson, we cover how to print an Excel spreadsheet with page numbers on each page. Excel has changed a lot over the years, but one thing that hasn’t changed is the way that you insert page numbers into a spreadsheet. Unfortunately, Excel 2010 does not make it easy to find the options for doing this. This lesson covers the basics of inserting page numbers as well as providing an overview of some more advanced options.
Extract text from a cell in Excel
This lesson shows you now to extract text from a cell in Excel. This is useful when you have a cell containing combining numbers and text, such as a part number, or several text values separated by commas. It introduces the RIGHT() and LEFT() functions, which are essential text manipulation functions in Excel.
Count the number of characters in a cell in Excel
This lesson introduces the LEN() function, which allows you to calculate the number of characters in a cell. This formula is useful on its own, or can be combined with other text functions such as RIGHT(), LEFT(), MID() and FIND().
Working with data ranges in Excel
Excel is a powerful tool for manipulating large amounts of data. Make sure you know the rules Excel uses when setting up a data spreadsheet.
Additional Info
Join our mailing list
