Microsoft Excel
PivotTables are one of the best features in Excel. PivotTables allow you to summarize, analyze and chart complex data. There are 3 annoying things in PivotTables that users always ask me about. PivotTable Options - Autofit column widths on update One of them is after changing the width of a
Microsoft Excel
Combine the Geography Data type with a Chart Map. The Geography Data type is located on the Data tab, and Chart Map is on the Insert tab with the other chart types. Geography Data Type in Excel You can use the Geography data type with countries, states, and cities. There
Microsoft Excel
Have you ever copied from a website and tried to paste it into Excel? It isn't a pretty picture. Excel has a new keyboard shortcut coming out soon. Using CTRL + SHIFT + V will paste plain text. Paste with Ctrl + V Paste Values with CTRL + SHIFT + V The current
Microsoft Excel
Updated: November 1, 2022 For potential homeowners, one year makes a HUGE difference. In 2021, we saw some of the lowest mortgage rates in the last 30 years. In July 2021, the average rate on 30-Year Fixed-Rate Mortgages was 2.87% (source FreddieMac). Today, November 1, 2022, we are looking
Microsoft Excel
Excel has two new image-related features coming out. In this video, a preview of my teaching session at the ASAP (American Society of Administrative Professionals) Virtual Event in November, I walk you through these two new Excel functions. IMAGE Function in Excel The IMAGE Function inserts images into cells from
Microsoft Teams
Teams Meetings allows live translated captions in the language you are most comfortable with. By default, live captions are displayed in the language that’s spoken during the meeting, but you can change the language of the captions. Teams change captions to your preferred language. For example, ten people can
Microsoft OneDrive
Microsoft OneDrive for Work or School, formerly known as OneDrive for Business, creates folders for Teams and Outlook files. OneDrive folders created by Teams and Outlook The Teams folders are Microsoft Teams Chat Files and Recording folders. The Microsoft Teams Chat Files shows files you uploaded in chat by clicking
Microsoft Outlook
Dictate in Word, Outlook, OneNote, and PowerPoint allows users to use speech-to-text to author content in files. All that is needed is a microphone and a reliable internet connection. Dictate is easy to use. You can use automatic punctuation, bullets, and numbered lists. You can also format text with the
Microsoft Excel
The new Excel IMAGE function enables you to insert images into cells with a formula. This great function allows you to sort, filter, and rearrange images. Excel IMAGE function IMAGE Function syntax =IMAGE(source, [alt_text], [sizing], [height], [width]) IMAGE Function Arguments * [Required] source is the URL path of the
Microsoft Teams
Teams allows you to "Record a video clip" in Chat. This is possible for one-on-one chats and group chats. Teams Video clip in Chat After sending, users can watch the clip directly in the chat. The icon to Record a video clip is right next to the Send
Microsoft Teams
Using Meeting CO-ORGANIZERS in Microsoft Teams Meetings. You can choose co-organizers when you schedule a meeting so that if you can't attend, the co-organizers will be able to end the meeting and perform other actions you as the organizer would do. Make sure you choose at least one
Microsoft Excel
Conditional Formatting in Excel allows you to highlight every 2nd, 3rd, 4th, or 5th row. Writing a formula using the MOD function and ROW function together allows us to do this. **Excel - Highlight every 3rd row** The MOD Function has two required arguments and shows the remainder after dividing