Learning new Microsoft Office tricks in "just a minute"
It’s a pretty safe bet these days that we’re all swamped with meetings on our calendars, and we need a reminder when the next meeting is due to start. Here’s how to set up Reminders on your calendar entries (both for yourself and for others you invite to the meeting), as well as how to hit the Snooze button on the alarm.
I received a great tip from Tamara Bredemus yesterday when it came to searching for mail in Outlook. She needed to narrow down her inbox to only show items for a two week period. By using the received keyword in the search bar, she easily made that happen. Here’s how…
In Outlook, you can send an email with simple voting options to get quick feedback from people.
When you’re working in SharePoint and you have to fill in someone’s name, you’re seeing what is commonly called a People Picker field. It’s a field that’s set up to allow for names, and it has two icons to check the name format as well as to look up a name in the Select People and Groups dialog box.
However, I often see people clicking on the Address Book icon even if they know the name of the person they want to add to the field. Following are some various ways to add a person’s name into the field and maybe save yourself some clicking around to do so.
Sometimes when working with Excel, you may end up with a spreadsheet that has an excessive amount of formatting. That formatting can come with a cost, such as large file sizes and long wait times to launch the spreadsheet.
I had a question yesterday from someone asking if there was a way to password protect an Excel file. I just assumed that everyone knew that was possible, but I didn’t have a direct answer that said “click here, here, and here” to help her. Thus, today’s tip on how to password protect files in Excel, Word, and PowerPoint.
Sandra showed me a cool trick last week that I was unaware of. She likes to keep her Outlook Folder Pane minimized down the left side of the screen, but I’ve always disliked it because it didn’t list the folders I cared about. She fixed that problem by showing me how to add Favorites there! Here’s how you do it…
A customer asked us a question a while back related to Auto Sum on a column with hidden rows. Not being an Excel wizard, I left the question in my inbox to investigate later. Fortunately, the answer arrived in an Efficiency 365 email!
Over time, Outlook builds up quite a collection of email addresses that it “helpfully” assists you with when you start to type a name in the To field. However, people move on, change email addresses, or no longer qualify as someone you want or need to email. Here’s how you can get rid of those names that just clutter things up.
