Microsoft Excel
Filtering data in Excel charts is easy to do. The method you use should be based on the amount of data you have. In this video, I show three methods of filtering chart data. Method 1 is using Chart Filters. This is the easiest method. Method 2 is using Filters
Microsoft Excel
I'm frequently asked how to convert decimal hours to Excel's hour and minute format. A couple of examples: 7.75 need to show as 7:45, and 30.25 needs to show as 30:15. The solution is to divide by 24 hours. The formula is
Microsoft Excel
The Outlook desktop client now allows all meetings to be Teams meetings by default. No longer do you have to remember to click the Teams Meeting add-in icon in the ribbon. Another new feature in Outlook is you can now have a Meet Now meeting in Teams. YouTube Video on
Microsoft Excel
Do you need to add or subtract time in Excel? Some time calculations are easy, but depending on how the time is entered, you may need to use the TIME function or formula to add or subtract time. For example, if you have 9am in B2, and in cell C2,
Microsoft Excel
The TODAY function returns the current date. The TODAY function is updated continuously when a worksheet is opened. For example: if you use the TODAY function in cell B1, it will show today's date. Assume that today is 12/21/2021. Tomorrow, it will have the correct date
Microsoft Excel
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. Tip # 1 - Use Keyboard Shortcuts to create Charts Windows Keyboard shortcuts - **F11** to create
Microsoft Excel
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
Microsoft Excel
In Excel, if you need to calculate the difference between two dates in years, month, or days, the **DATEDIF** function will handle it. **DATEDIF** is "Date & Dif". It is an exciting function since it does not show up in Excel's Date & Time function. So
Microsoft Excel
Zoom Meetings Updates Zoom: PowerPoint / Keynote as Virtual Background Zoom's Virtual Background feature is trendy. It is easy to share a PowerPoint or Keynote presentations in a Zoom meeting, but now you can share your presentation as a Virtual Background and it allows your participants to view your
Microsoft Excel
Posted on: 09/08/2020 Welcome to the third issue of my Training Roundup! Today's issue is packed with updates on multiple fronts. I hope you can benefit from at least a few of them! You're receiving this email because you have subscribed on my website
Microsoft Excel
Posted on: 08/07/2020 Welcome to the second issue of my Training Roundup! You're receiving this email because you have subscribed on my website ChrisMenardTraining.com at some point in the previous weeks. The Training Roundup | Issue #2 1. Microsoft continues to add new Excel templates and
Microsoft Excel
1. Microsoft just added the Zip Code Data Type in Excel. Unlike the Geography Data Type, which only shows data for countries, states and cities, the Zip Code Data Type returns things like household income, latitude, longitude, population by marital status, water and land areas and much more. Watch the