Microsoft Excel
A loan amortization schedule also called a loan amortization table, is a table that illustrates the process of paying off a loan. The amortization table will show every payment and the details for that payment. How much principal and interest are paid in any particular payment. There are usually seven
Microsoft Excel
Overview of COUNTIF The COUNTIF function is used to find cells that meet certain criteria. COUNTIF function works with dates, numbers, and text. The COUNTIF function has two arguments. For example: - =COUNTIF(A2:A11,"Atlanta") Will count the city of Atlanta. - =COUNTIF(A2:A11,"<>Atlanta&
Microsoft Excel
Many Excel files are not set up properly. Data that should be in a flat file is laid out in a crosstab file format, or in this example, the data is missing information and has totals manually applied. The issue with data being set up incorrectly is the following can’
Microsoft Excel
Create a Sunburst Chart in Excel by Chris Menard - YouTube The sunburst chart or multi-level pie chart is ideal for displaying hierarchical data. Each level of the hierarchy is represented by one ring or circle with the innermost circle as the top of the hierarchy. A sunburst chart without
Microsoft Excel
Excel group numbers and IFS and FormulaText functions Two new Excel 2016 Functions **IFS** - The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. IFS can take the place of multiple nested IF statements and is much easier
Microsoft Excel
Excel - use the Median function in a PivotTable by Chris Menard - YouTube PivotTables do not allow median function. We will create a helper column and use an array function to calculate the median in a PivotTable. Also shown are average, median, averageif, if statement with the median function. The median
Microsoft Excel
Bill in Smyrna, GA wants to show percentage in a PivotTable and filter the PT. That is easy. The issue is Bill wants to show the unfiltered percentages, not the filtered percentages. I had to add a helper column to do this. PivotTable Percentages - Show unfiltered percentage when filtering a
Microsoft Excel
What if I told you in Excel 2016 for Office 365, you can click on one cell and with two more clicks, have data analysis you would never dream of having? It’s here! Microsoft has updated Excel 2016 for Office 365 with Insights for Excel. Insight is discussed in
Microsoft Excel
Extracting email address from a text string in Excel can be tricky. I made a video demonstrating three methods of extracting the email addresses. I also showed how to take the email addresses and add a comma between them. This is handy when you need to import the email addresses
Microsoft Excel
You can use Microsoft’s **Map Chart** to compare values and show categories across geographical regions. The map chart works with geographical regions. This means your data should have 1. Countries 2. Regions 3. States 4. Counties 5. Postal codes Note: This feature is only available if you have an
Microsoft Excel
If you see data on a webpage and need to pull it into Microsoft Excel, don’t copy/paste. Excel 2016 has a feature called Get Data / From Other Sources / From Web. In the example below I’m pulling population data for the 50 states from Wikipedia into Excel. If
Microsoft Excel
Microsoft Excel can be used to analyze vast amounts of data, and one of the best features in Excel for this purpose is changing your data range to a table. With tables, you can quickly sort and filter your data, add new records, and see your charts and PivotTables update