18 Excel tips that every user must master

Whether you are a Microsoft Excel novice or an advanced user, you will benefit from these step-by-step tutorials.

Image: Bumblee_Dee, iStock / Getty Images

Microsoft Excel was first released in 1985 and the spreadsheet program has remained popular over the years. You can control Excel by reading these tips and tricks about adding a drop-down list in an Excel cell to find duplicates, delete empty rows in Excel and more.

MORE INFORMATION: Office 365 Consumer prices and functions

3 quick and easy ways to summarize Excel data

Summarizing data in Microsoft Excel does not have to be difficult. Put these few techniques to work for almost magical results.

How to use the new Excel Lookup function
A little from column A, a little from column B: XLOOKUP is the new, easier way to retrieve information in Excel spreadsheets.

How to evaluate the last rows in a changing data set in Excel
In Microsoft Excel, changing the evaluated range on site requires a bit of work, but it is certainly possible thanks to the Offset () function.

Quickly change a conditional Excel format
Conditional formatting is a flexible and powerful tool in Microsoft Excel, but you cannot change a condition without changing the underlying rule. Don’t be stopped – use an input cell. Here’s how.

Add a drop-down list to an Excel cell
Drop-down lists can greatly facilitate data entry. Here you can see how you can use the Excel data validation function to create useful lists in your worksheets.

A quick way to delete empty rows in Excel
Deleting empty rows in an Excel data range is easy with this technique, but beware of unintended consequences.

How to password protect an Excel workbook
At file level, you can password protect an Excel workbook in two ways: you can control who has access and who can save changes.

Enter leading zeros in Excel
By default, Microsoft Excel will not display or save any leading zeros. Read this Excel tip to learn three useful ways to work around the problem.

Use Excel to calculate the hours worked for each service
With Microsoft Excel you can create a worksheet that displays the number of hours worked for each service. Follow these step-by-step instructions.

Copy an Excel sheet from one workbook to another
Susan Harkins shows you two quick ways to copy data from one Excel workbook to another.

Use a custom format in Excel to display readable millions more easily
Use a custom format in Microsoft Excel to reduce the number of digits in a large number without losing the scale.

How to transfer data from Word forms to an Excel worksheet
Avoid the hassle of manually importing Word form data into Excel. With the help of an Excel wizard you can quickly step through the process.

How to suppress 0 values ​​in an Excel graph
There is no one-size-fits-all solution for removing 0 values ​​from an Excel chart. Here are some methods.

How to find duplicates in Excel
You need more than one trick to find duplicates in Microsoft Excel.

Two ways to build dynamic charts in Excel
Users will appreciate a graph that is updated just before their eyes. In Microsoft Excel 2007 and Excel 2010, it is as easy as creating a table. In earlier versions you need the formula method.

Use named ranges to quickly navigate through an Excel workbook
Named ranges are not just for formulas. Here are two ways you can use named ranges to create shortcuts for fast navigation in a Microsoft Excel workbook.

How to combine formulas with Excel data validation and a trick for replacing Word

These tutorials based on readers’ questions describe how you can combine formulas with Excel data validation and have a trick for replacing Word.

Use the Excel border options by creating a simple floor plan
Applying borders to your sheets makes them easier to read and easier to use. Learn how to use borders efficiently by creating a simple map.

Weekly newsletter from Microsoft

Be Microsoft’s insider for your business with the help of these Windows and Office tutorials and the analyzes of our experts on Microsoft business products.
Delivered on Monday and Wednesday

Register today

Also see

Disclosure of affiliated parties: TechRepublic can earn a commission with the products and services on this page.

Leave a Reply