Microsoft Excel
Year-Over-Year (YOY) growth compares one period, usually a quarter or a month, against the same period twelve months before. You can compare Q3 of 2022 against Q3 of 2021. Another example is comparing the month of November 2022 to November 2021. You can even compare one day to the same
Microsoft Excel
If you need to find out what day of the week is the most profitable or what day of the week do we receive the most support calls, Excel's PivotTables can handle it. PivotTables will group dates automatically. If you have any date field - invoice dates, order
Zoom
Zoom has a new feature when you share your screen, you get notified over your shared content that 1) you are sharing and 2) participants can see your content. I've been in meetings when someone that is sharing is talking about cell B5 in Excel and no one
Microsoft Outlook
Outlook on the Web keeps rolling out new features. In this video, I cover seven features in Outlook that I love. Quickly view emails and attachments from a person, start a Teams chat, send attachments from OneDrive, save attachments to OneDrive, undo send, suggested replies, and schedule an email to
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
Zoom
Your Personal Meeting Room is a virtual meeting room permanently reserved for you to access with your Personal Meeting ID (PMI). With your PMI, you can start instant meetings or schedule a meeting that uses your PMI. I find myself starting instant meetings with co-workers using the PMI. Your Personal
Microsoft Word
Need to add your electronic signature to a Word document? It is effortless to do. In this video, I'll show three ways to add your electronic signature to a Word Doc, how to correctly resize your signature, and wrap the text shows it shows correctly in the document.
Microsoft Forms
With Microsoft Forms, you can easily create surveys and polls to collect customer feedback, measure employee satisfaction, and organize team events. You can print a blank form, shuffle questions, allow receipt of responses, add a logo to your Form, and use Forms in Teams. YouTube Video Microsoft Forms - 5
Zoom
Zoom has a nifty feature where you can block or allow participants from countries/regions when scheduling your meeting. For example, I'm in the U.S. and schedule a zoom meeting. I can block participants from Ireland, Italy, Spain, and the UK. I can also go the other
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 Forms
Microsoft Forms is an excellent tool for creating surveys, quizzes, and polls. Did you know you can add a progress bar to a Forms survey or quiz? A progress bar makes it easy for users to see how many pages they have left to complete. The key to making the
Zoom
Zoom's polling is a great feature. One tip that most users don't know is that you can view all polls' results during a meeting. By default, as the host, you can easily share one poll's results during the meeting, but you can launch