Microsoft Excel
Excel PivotTables have calculated fields and calculated items. In this video, I will take a field called Year, which has 2022 and 2021 in it and create a calculated item. In case you are wondering, what is the difference between a calculated field and a calculated item? That is easy
Microsoft Excel
Conditional Formatting is one of Excel's best features. I use it daily. In this short video, I'll get you started using Conditional Formatting. We will look at using five easy Conditional Formatting features. We will use Conditional Formatting with text, numbers, above average, top 10 and
Microsoft Excel
Filtering data is one of the most popular Excel features. Here are five great filtering tips for Excel. 1. Filter by selected cells value 2. Copy and paste filtered data 3. Delete filtered data 4. Auto-calculate filtered data 5. Search for filtered data **Excel - Filter data tips** Tip #1
Microsoft Excel
Excel makes it easy to sort using built-in custom lists, you can sort data—either by days of the week or months of the year. I'll demonstrate how to create your own custom lists to sort by any other characteristic that doesn’t sort well alphabetically—such
Microsoft Excel
Use Excel to calculate your tax liability using VLOOKUP. The Excel file is in the blog post. Tax brackets show you the tax rate you will pay on each portion of your income. For example, if you are single in 2021 and make $86,375, you are in the 22%
Microsoft Excel
With a stacked column chart in Excel, you can view partial numbers, but what do you do when you want to show percentages? Excel's pie charts show percentages, but stacked column charts do not. We are going to use a mixed reference to create a column chart with
Microsoft Excel
The Subtotals Command will automatically calculate subtotals and grand totals in a list for a column. Subtotals come with an automatic outline in Excel. The outline will show 1, 2, and 3 to the left of column A. I follow three rules before I use Subtotals - 1) Save, 2) Sort,
Microsoft Excel
The Navigation pane in Excel is an easy way to understand a workbook's layout. With the Navigation pane, you can see charts, tables, images, and PivotTables. The Navigation Pane even shows you the elements by worksheet. Navigation Pane in Excel - Worksheets show and elements on the worksheet Clicking
Microsoft Excel
The **NOW** function in Excel returns the current date and time. The NOW function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time, and have that value updated each time you open the
Microsoft Excel
We love to use Filters in Excel. When filtering data, the filtered rows turn blue. To get the SUM, AVERAGE, MAX, MIN, or COUNT of the filtered data, use the SUBTOTAL function. Subtotal Function in Excel If you use one of the functions with one argument - SUM, AVERAGE, MAX, MIN,
Microsoft Excel
The SORT function in Excel sorts the contents of a range or array. Example, =SORT(B2:B20). You can also sort in ascending or descending order with the SORT function. =SORT(B2:B20,,-1) would sort descending or highest to lowest. The number 1 would sort ascending, which is the
Microsoft Excel
The SORTBY function in Excel sorts the contents of a range or array based on the values in a corresponding range or array. Use SORTBY to see a list of employees sorted by highest paid, but you don't show their salaries. USE SORTBY to sort a customer list