Category - Excel

22
Mar

Using an Excel IF Statement Combined with a VLOOKUP Function

Did you know that you can use Excel IF statements along with VLOOKUPs? For example, if you wanted to enter a value from a table into a cell, based on what was in another cell, you could start with an IF statement and then enter the VLOOKUP in the “value if true” part of the …

19
Dec

How to Work with Automatic Time Grouping in Excel 2016

Automatic Time Grouping, a new feature in Excel 2016, helps use time-related fields in a PivotTable by auto-detecting and grouping them on your behalf. The automatic grouping creates new Date/Time functionality and automatically populates the PivotTable in one action when you add a field to the ROWS or COLUMNS drop box in the PivotTable Task Pane. …

19
Dec

Using Excel FlashFill

Here’s a nice tip on Excel FlashFill…when you need to combine fields or create a new format (e.g., telephone numbers with hyphens), Flash Fill can do the work for you. Type the first entry into the cell (e.g., telephone number with hyphens). Press Enter to see the completed entry. Begin to type the second entry. The Flash …

19
Dec

How to Filter Excel Data Using Slicers

PivotTables and PivotCharts are fantastic Excel features that allow you to analyze data. Sometimes you need an easy way to manipulate only specific data and view it. This Trainer Tip will show you how to filter data in PivotTables and PivotCharts using Slicers. Though you can filter data in a PivotTable using filters and by using the drop zones …

13
Nov

Create Custom Number Formats in Microsoft Excel

Thousands, Millions, etc. If you use a number format like 0, Excel simply writes the number with no decimal point or decimal digits. To truncate the last three digits of a number in the thousands, append a comma to the number format, like this: 0,. Two commas drop off two sets of three digits, etc. …

13
Nov

What is an Excel PivotTable?

Sharing the Wonder of PivotTables! The PivotTable is a powerful tool for summarizing, analyzing, exploring and presenting data, extracted from larger amounts of data elsewhere in your workbook. It enables you to query the data in user-friendly ways, subtotal and aggregate numeric data, summarize data by categories and subcategories, and create custom calculations and formulas. …

13
Nov

Get a Handle on Excel AutoFill!

Use AutoFill to fill in data…With the AutoFill feature, you can have Excel automatically continue a series of numbers, number and text combinations, dates, or formulas, based on a pattern that you establish. Select the first cell in the range that you want to fill. Type the starting value for the series. Type a value …

13
Nov

Using Excel Data Bars to Show Conditional Formatting

Conditional Formatting helps you explore and analyze data visually, detect critical issues and identify patterns and trends. A conditional format changes the appearance of a cell range based on a condition or criteria. You can use Highlight Cells Rules, Top or Bottom Rules, Data Bars, Color Scales or Icon Sets to visualize data easily, highlight …

gtag('config', 'AW-776341736');