I want to...
Get started with computers
Learn Microsoft Office
Apply for a job
Improve my work skills
Design nice-looking docs
Smartphones & Tablets
Work & Career
Job Search and Networking
Skills for Today
Adapting to Change
Creativity & Design
Learn these Excel tips and tricks so you can do more with this popular spreadsheet program.
Go to YouTube Playlist
Excel Quick Tips
Add the Current Date to a Cell
Learn how to add a date or time stamp to any cell with this Excel keyboard shortcut.
A Faster Way to Use the Fill Handle
Learn a faster way to use the fill handle in Excel.
Two Ways to Use the Format Painter
Learn how to use the Format Painter in Excel.
A Shortcut to AutoSum
Learn an Excel keyboard shortcut that makes the AutoSum function even faster.
Quick Access Toolbar Shortcuts
Learn how to add shortcuts to the Quick Access Toolbar in Excel.
How to Quickly Duplicate a Sheet
Learn a shortcut for making an exact copy of an existing worksheet.
Jump to Any Sheet with a Shortcut
Here's a shortcut for quickly jumping to any sheet within a workbook.
Select an Entire Row or Column
Learn these Excel shortcuts for selecting an entire row or column at one time.
Find a Sum Without Using a Formula
Here's how to find a sum without using a formula.
Why You Should Avoid Merging Cells
Use the Center Across Selection feature to easily merge cells in Excel.
Using the Quick Analysis Tool
Learn how to browse through different visualization options with the Quick Analysis tool.
How to Make Charts Auto Update
Learn how to use tables to keep charts up to date using this Excel feature.
Use Transpose to Flip Data on its Side
Here's how to use the Transpose feature to rearrange your data instantly.
Absolute References with the F4 Key
Learn how to convert a cell reference to an absolute reference with the F4 key.
Add a New Row with a Shortcut
Learn a keyboard shortcut that lets you add a row anywhere in your spreadsheet.
Use an Entire Column as a Cell Range
Learn how to use an entire column as a cell range in Excel.
What are Named Ranges?
Learn how to use named ranges to make your formulas easier to write and read.
A Trick for Finding Inconsistent Data
Here's a trick for quickly finding inconsistent data in a large spreadsheet.
How to Use Excel's VLOOKUP Function
Use VLOOKUP to find specific information in your worksheet.
Use SUMPRODUCT to Calculate Weighted Averages
Use SUMPRODUCT to calculate weighted averages.
Use the PROPER Function to Capitalize Names in Excel
Use the PROPER function to capitalize names in your spreadsheet.
How to Count Cells with COUNTA
Use the COUNTA function for counting cells and for determining how many cells have data in them.
CONCATENATE: Excel's Duct Tape
Use the CONCATENATE function to combine two or more things in one cell.
5 Tips for Printing Excel Spreadsheets
Use these tips for printing Excel spreadsheets.
How to Use Fractions in Excel
Learn how to work with fractions in Excel.
How to Add Line Breaks in Excel
Learn how to add line breaks in Excel.
Free Resources for Learning Office for Mac
Use these free resources for learning Office for Mac.
Understanding Regional Differences in Excel
Use regional settings in Excel to use the program in any language.