Microsoft Excel: Tips and Tricks
VLOOKUPfunction is used to pull a value from a list or table based on a corresponding value. For example, if you have a worksheet with a table showing employee names, hire date, and salary, you could use
VLOOKUPin a separate worksheet to pull the hire date and salary for individual employees from the first worksheet. In this example, the employee name serves as a key, identifying which information from the first worksheet you wish to pull.
It's easy to group and ungroup data in any list in Excel. Just follow these simple steps.
Use the Quick Analysis tool to convert your data quickly and easily into a chart or table.
You can quickly name cells in Microsoft Excel using their row and column headings.
Slicers make it really easy to filter data in a pivot table. Adding a Slicer is similar to adding a second Page field (Report Filter) but is even easier to use. To add a Slicer to a pivot table, follow these four steps.
The following seven steps show how to create a pivot table timeline for filtering your Excel data by time.
Converting a list to a table makes it very easy to format your data and to keep the formatting consistent as you make changes to the data. You can convert a list to a table in three short steps.
RIGHTfunctions are used to return characters from the start or end of a string. The following explains how to select these functions and some possible uses.
Creating a macro and adding it to the Quick Access Toolbar makes it easier to complete a set of operations that you perform regularly. To add a macro to the Quick Access Toolbar, follow these steps.
A large library of Clip Art, including drawings, videos, sounds, and photographs, is available from Office.com. Inserting Clip Art into an Excel worksheet can be done in just a few simple steps.
When working in Excel, it can sometimes be helpful to split the worksheet in two, so that you can compare data within the sheet. To split the window in Excel follow these three easy steps.
Aside from superficial color and labeling, Microsoft Excel 2016 isn't much different from Excel 2013 or 2010. All the menu items and often-used features are the same. There are some new features that you may be interested in. Below is a list of features introduced with the 2013 and 2016 versions. There is also a link to a video that walks you through the Microsoft Excel 2016 interface.
It takes only four simple steps to accept or reject changes in Excel.
The following steps show how to insert a pivot table. A pivot table is an interactive table that can be used to analyze, organize, and summarize large amounts of data. Pivot tables make it easy to rearrange data, quickly displaying it in different ways. Before inserting a pivot table, make sure the data you want to analyze is in an organized table and that your data includes a header row, no empty rows or columns, and no subtotals.
Ink Equations allows you to "write" equations on a tablet device using a stylus or your finger and then converts them to text. If you are not using a touchscreen device, you can do the same using a mouse. To employ Ink Equations just follow these few steps.
Creating a formula that spans multiple Excel worksheets is easy. Just follow these steps.
CONCATENATEfunction is used to join the contents of multiple cells. For example, if you have a worksheet with first names in one column and last names in another column, you can use the
CONCATENATEfunction to join the first and last names into one column. To use this handy function, follow these three steps.
In Excel, you can use the
TEXT()function to output the day name from a date. For example, if cell A1 contains
12/18/2017, you can output "Monday" in another cell using
TEXT(A1,"dddd"). But I needed a way to list 10 day names in a row without any associated dates. And I wanted the list to update based on the value in the first cell. So, how do you do that?
Freezing panes is a way of making one or more rows or columns stay at the top or left of your worksheet as you scroll through the worksheet. A common use of freezing panes is to keep a header row in view as you scroll through a large worksheet. To freeze panes in an Excel worksheet, follow these four steps.