Post covering sorting, filters, getting started with Excel, Excel functions, subtotals, PivotTables, and other Excel features.
Three tips for getting started with Excel Charts
Posted by Chris Menard on 01/08/2021
Charts in Microsoft Excel are easy. This short video shows three tips for creating charts. I'll cover two keyboard shortcuts for making charts, using Recommend Charts, and creating charts using Quick Analysis.
Tax Brackets Explained using Excel's XLOOKUP function
Posted by Chris Menard on 01/06/2021
Tax brackets show you the tax rate you will pay on each portion of your income. There are seven tax brackets. The United States has a progressive tax system based on your Taxable income, not Gross income or Net Income. Your income is taxed at different rates with a progressive tax system.
Email mail merge: personalized emails using Excel - Word & Outlook
Posted by Chris Menard on 12/03/2020
Need to send personalized emails to individuals all at one time? That is called an "Email Mail Merge." I'm going to use Excel, Word, and Outlook - part of Microsoft 365 - to create and send bulk emails out. The order these apps are used would be Excel, then Word, and finally, Outlook.
Excel: College Decision Helper Template
Posted by Chris Menard on 08/13/2020
Whether you want to attend a large public university or a small private college, knowing all about the schools you're considering is essential to making a good decision.
Zip Code data type in Excel
Posted on 07/10/2020
To use the Zip Code data type, select your zip codes, and Excel will return important information. Data includes the median household income, latitude, longitude, population by marital status
Average Function in Excel
Posted on 06/07/2020
The AVERAGE function is one of the most popular functions in Excel. This video shows how to use the Average function, handles zero values when using the Average function. Zero values vs. blank cells will give different results with Average. As a bonus, using the AverageIF function with zero values.
Workbook Statistics in Excel for Microsoft 365
Posted by Chris Menard on 05/09/2020
Excel for Microsoft 365 subscribers now have Workbook Statistics. Workbook Statistics is a window that shows a summary of the workbook statistics including the number of sheets, tables, formulas, charts, and pivottables.
Future Value Function in Excel
Posted by Chris Menard on 02/10/2020
The Future Value Function will give you the answer to the future value on investment. Compound interest is interest on interest vs. simple interest that interest only on the principal.
Annual Percentage Yield (APY) vs. Interest Rate
Posted by Chris Menard on 01/17/2020
The annual percentage yield takes the interest rate and compounding periods to show what your money could earn in a year. The Future Value (FV) and EFFECT functions are shown.