Learning new Microsoft Office tricks in "just a minute"
When I go to start a new Word document or Excel file, I nearly always take the default blank template in the upper left corner. However, I recently decided to scroll down and see what Excel file templates were out there. I was amazed at what options I had to create something that was “out of the ordinary”.
One of my colleagues pointed out a really cool trick for quickly adding all the calendars of your team members to your Outlook client without having to look each one up individually.
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…
