Microsoft Excel
I recently spoke at the Administrative Professional Day Conference hosted by the University of Georgia. After reviewing my survey results in Microsoft Forms, I realized I needed to analyze the survey data. Forms results are immediately available in Excel. **Microsoft Forms - Analyze data in Excel** After opening in Excel,
Teams
Updated: December 10, 2022 You can now delete an entire chat for one-on-one chats and group chats. In Teams, it is easy to add files in a chat. In a chat, you click the paperclip for attaching files, select your files, and click Send. The files show up in the
Microsoft OneDrive
OneDrive is Microsoft's Cloud storage. There are three sync icons for files and folders - cloud-only, locally available, and Always keep on this device. OneDrive Questions Answered - Why do folders show the cloud-only icon when it contains multiple sync file types? - When you create a folder
Google Calendar has been around since 2009 for general release. In this short video, I'll show keyboard shortcuts for navigating the Google calendar with different views, and quickly getting around. We will look at various views: day view, week view, month view, schedule view, and year view. **Google
Microsoft Excel
When you have a range of numbers in Excel and want to figure out the AVERAGE but you have some extreme values that can skew your averages, there is a function that helps solve that problem. **Average using Sum with Max, Min, and Count** You can calculate the AVERAGE in
Microsoft Excel
The STOCKS data type in Microsoft Excel required manual refresh until now. A new feature released for Microsoft Excel on Desktop for Windows, Mac as well as Excel on the Web, fixes that problem, by allowing you pull almost live stock data into Excel. **Stock data type Refresh every 5
Microsoft Excel
Which is best in Excel? Classic CHARTS or PIVOTCHARTS? I will show you both ways of creating charts in Excel. I demonstrate step by step what's involved in each method, which one is the most flexible and powerful, and which one I prefer. **Charts vs. PivotCharts** We take
Microsoft Excel
PivotTables in Excel can create a Distinct Count. An example of a distinct count is we had five orders in one day, but three orders were placed by the same customer. I want to know we have five orders from three customers. **PivotTable with a Distinct Count** To create a
Teams
Saving chats and channel conversations in Microsoft Teams helps you reference old discussions, go back to questions or things you want to remember from your conversations with your colleagues. In this video, I provide 5 tips that will help you find your way around the Saved messages functionality in Teams.
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 Word
Inserting videos from the web inside a Word document is easy. You can link to a video from a document, using the Insert Hyperlink function, but you are also able to insert the actual video in Word, so it shows the thumbnail and you can access playback. **Word - Insert
Microsoft OneDrive
OneDrive is Microsoft's cloud storage where you can store, share, and sync your work files. In this short video, I answer five frequently asked questions about OneDrive for Work or School. Q1 - How do I upload a file to OneDrive? **Upload files to OneDrive** To upload a