Learn these Excel tips and tricks so you can do more with this popular spreadsheet program.
Find tips for using Microsoft Excel.
Learn how to add a date stamp or timestamp to any cell in Excel with this Excel keyboard shortcut.
Watch this video to learn a faster way to use the fill handle in Excel.
The Format Painter offers a quick way to copy formatting from one cell to another. Learn about two to use it.
AutoSum is a fast, easy way to add up multiple values in Excel. Learn an Excel keyboard shortcut that makes AutoSum even faster.
Watch this video to learn how to add shortcuts to the Quick Access Toolbar in Excel.
Learn a shortcut for making an exact copy of an existing worksheet.
When your workbook has a lot of sheets, it can be awkward to switch between them. This shortcut makes it easier.
Watch this video to see how you can use shortcuts in Excel to select an entire row or column at one time.
Excel automatically calculates the sum, average, and count of any cell range you select. You just have to know where to look.
Use the Center Across Selection feature to easily merge cells in Excel.
Use this lesson to learn how to use tables to keep charts up to date using an auto update feature in Excel.
The Transpose feature allows you to rearrange your data instantly, which is much faster than moving it by hand.
Learn how to convert a cell reference to an absolute reference with the F4 key.
Learn a keyboard shortcut that lets you add a row anywhere in your spreadsheet.
Watch this video to learn how to use an entire column as a cell range in Excel.
Finding inconsistent data in a large spreadsheet can be time consuming. This Excel trick can make it much easier.
VLOOKUP in Excel is useful for looking for specific information in your worksheet. Learn all about it in this Excel VLOOKUP tutorial.
Use SUMPRODUCT in Excel and other spreadsheet programs to calculate weighted averages. Learn all about the Excel SUMPRODUCT function here.
You can use the Excel PROPER function to capitalize names in Excel. Learn all about using the PROPER function in Excel in this free lesson.
The Excel COUNTA function is useful for counting cells. Also use the COUNTA Excel function to learn how many cells have data in them.
Use the Excel CONCATENATE function to combine two or more thing in one cell. Learn how to use the CONCATENATE Excel function here.
Printing in Excel can sometimes be tricky. Understand how best to do it in this free lesson offering Excel printing tips.
Learn how to work with fractions in Excel using this free Excel fractions lesson.
Adding line breaks in Excel is easier than you think. Use this helpful keyboard shortcut to create an Excel line break in cell or cells.
This article covers useful free resources for learning Office for Mac.
In Excel regional settings help people from all corners of the world use the program more easily.