close
search
search
menu
Topics
close
I want to...
Get started with computers
Learn Microsoft Office
Apply for a job
Improve my work skills
Design nice-looking docs
More...
Microsoft
Office 2019
|
2016
|
2013
Word
Excel
PowerPoint
Access
Excel Formulas
More...
Basic Skills
Computers
Smartphones & Tablets
Typing Tutorial
Windows
More...
Internet Skills
Internet
Online Safety
Social Media
Email
Search Better
More...
Google
Gmail
Google Docs
Google Sheets
More...
Work & Career
Career Planning
Resume Writing
Cover Letters
Job Search and Networking
Business Communication
More...
Skills for Today
Adapting to Change
3D Printing
Wearables
Freelance Work
Personal Finance
Sharing Economy
Decision-Making
More...
Creativity & Design
Graphic Design
Creativity
Photography
Image Editing
Photoshop
More...
Core Skills
Math
Reading
Grammar
Language Learning
More...
For Educators
Translations
Staff Picks
All Topics
English
expand_more
expand_less
English
expand_more
expand_less
Español
Português
search
menu
All Topics
My Account
About Us
FAQ
Contact Us
EN
ES
PT
search
560d88f6369ca18833b60c1d
Excel Quick Tips
1
Add the Current Date to a Cell
arrow_forward_ios
✓
Learn how to add a date or time stamp to any cell with this Excel keyboard shortcut.
2
A Faster Way to Use the Fill Handle
arrow_forward_ios
✓
Learn a faster way to use the fill handle in Excel.
3
Two Ways to Use the Format Painter
arrow_forward_ios
✓
Learn how to use the Format Painter in Excel.
4
A Shortcut to AutoSum
arrow_forward_ios
✓
Learn an Excel keyboard shortcut that makes the AutoSum function even faster.
5
Quick Access Toolbar Shortcuts
arrow_forward_ios
✓
Learn how to add shortcuts to the Quick Access Toolbar in Excel.
6
How to Quickly Duplicate a Sheet
arrow_forward_ios
✓
Learn a shortcut for making an exact copy of an existing worksheet.
7
Jump to Any Sheet with a Shortcut
arrow_forward_ios
✓
Here's a shortcut for quickly jumping to any sheet within a workbook.
8
Select an Entire Row or Column
arrow_forward_ios
✓
Learn these Excel shortcuts for selecting an entire row or column at one time.
9
Find a Sum Without Using a Formula
arrow_forward_ios
✓
Here's how to find a sum without using a formula.
10
Why You Should Avoid Merging Cells
arrow_forward_ios
✓
Use the Center Across Selection feature to easily merge cells in Excel.
11
Using the Quick Analysis Tool
arrow_forward_ios
✓
Learn how to browse through different visualization options with the Quick Analysis tool.
12
How to Make Charts Auto Update
arrow_forward_ios
✓
Learn how to use tables to keep charts up to date using this Excel feature.
13
Use Transpose to Flip Data on its Side
arrow_forward_ios
✓
Here's how to use the Transpose feature to rearrange your data instantly.
14
Absolute References with the F4 Key
arrow_forward_ios
✓
Learn how to convert a cell reference to an absolute reference with the F4 key.
15
Add a New Row with a Shortcut
arrow_forward_ios
✓
Learn a keyboard shortcut that lets you add a row anywhere in your spreadsheet.
16
Use an Entire Column as a Cell Range
arrow_forward_ios
✓
Learn how to use an entire column as a cell range in Excel.
17
What are Named Ranges?
arrow_forward_ios
✓
Learn how to use named ranges to make your formulas easier to write and read.
18
A Trick for Finding Inconsistent Data
arrow_forward_ios
✓
Here's a trick for quickly finding inconsistent data in a large spreadsheet.
Excel Functions
19
How to Use Excel's VLOOKUP Function
arrow_forward_ios
✓
Use VLOOKUP to find specific information in your worksheet.
20
Use SUMPRODUCT to Calculate Weighted Averages
arrow_forward_ios
✓
Use SUMPRODUCT to calculate weighted averages.
21
Use the PROPER Function to Capitalize Names in Excel
arrow_forward_ios
✓
Use the PROPER function to capitalize names in your spreadsheet.
22
How to Count Cells with COUNTA
arrow_forward_ios
✓
Use the COUNTA function for counting cells and for determining how many cells have data in them.
23
CONCATENATE: Excel's Duct Tape
arrow_forward_ios
✓
Use the CONCATENATE function to combine two or more things in one cell.
More Tips
24
5 Tips for Printing Excel Spreadsheets
arrow_forward_ios
✓
Use these tips for printing Excel spreadsheets.
25
How to Use Fractions in Excel
arrow_forward_ios
✓
Learn how to work with fractions in Excel.
26
How to Add Line Breaks in Excel
arrow_forward_ios
✓
Learn how to add line breaks in Excel.
27
Free Resources for Learning Office for Mac
arrow_forward_ios
✓
Use these free resources for learning Office for Mac.
28
Understanding Regional Differences in Excel
arrow_forward_ios
✓
Use regional settings in Excel to use the program in any language.