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
Word
Excel
PowerPoint
Access
More...
Computers
Getting Started
Smartphones & Tablets
Typing Tutorial
Windows
Online Learning
More...
The Internet
Basic Internet Skills
Online Safety
Social Media
Zoom Basics
Email
More...
Google
Gmail
Google Docs
Google Sheets
More...
The Job Search
Career Planning
Resume Writing
Cover Letters
Job Search and Networking
Business Communication
Entrepreneurship 101
Careers without College
Job Hunt for Today
More...
Skills for Today
3D Printing
Freelancing 101
Personal Finance
Sharing Economy
Decision-Making
More...
Creativity & Design
Graphic Design
Creativity
Photography
Image Editing
Photoshop
Learning WordPress
More...
Core Skills
Math
Reading
Science
Grammar
Language Learning
Critical Thinking
More...
For Educators
Translations
Staff Picks
All Topics
English
expand_more
expand_less
English
expand_more
expand_less
Español
Português
search
person_outline
arrow_drop_down
menu
All Topics
My Account
About Us
FAQ
Contact Us
EN
ES
PT
Signin
Signup
Dashboard
Profile
Logout
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
Understanding Regional Differences in Excel
arrow_forward_ios
✓
Use regional settings in Excel to use the program in any language.
28
Excel Tips Quiz
arrow_forward_ios
✓
Take the final quiz to see how many tips you've learned about Excel.
These tutorials might interest you
View more
expand_more
View less
expand_less