Form Controls in Word
Did you know that Microsoft Word has a variety of automatic form controls that you can insert in your document? What are these exactly? ...
top of page
Oct 8, 20211 min read
Multiple Nested AND / IF Statements
Do you have a spreadsheet that you want to label certain criteria if they have two conditions? In order to do this you can combine...
99 views
Jul 29, 20211 min read
Disable Reply to All or Forward in an Email or Meeting Invite
Have you ever received an email spam from an email that a whole bunch of users were cc'd on. Did you know you can disable this function...
25,243 views
Jul 21, 20211 min read
Add an Existing PowerPoint Presentation and Keep Its Formatting
Did you know you can add an existing PowerPoint presentation to yours and keep its format? This process may not be intuitive for many...
100 views
Jul 15, 20211 min read
Outlook - Desktop Alerts
One thing that drives me crazy when I am sharing my screen during a meeting or watching a meeting is when Outlook pops up a message in...
82 views
Jun 23, 20211 min read
Saving a SharePoint Path as a Favorite
Do you have a SharePoint Library or Folder that you frequently save files to? Did you know there is a way you can quickly pull and save...
1,401 views
Jun 15, 20211 min read
Top 10 Filter in a Pivot Table
Did you know you can automatically filter a Pivot table by the Top or Bottom 10? You can also customize this if you want to just filter...
107 views
Jun 9, 20213 min read
How to Build a Quadrant Chart in Excel
Do you want a chart that will quickly display 3 measures quickly? A Quadrant chart looks like a scatter plot but it is divided into four...
7,376 views
May 27, 20211 min read
Excel - Password Protection in a Worksheet
Do you have a spreadsheet that contains complex formulas that you don't want your users to accidently change? You can protect these...
14 views
May 18, 20211 min read
SUMPRODUCT Formula in Excel
Do you have a spreadsheet where you want to obtain the total of different products by different values? SUMPRODUCT is a very useful...
37 views
May 5, 20211 min read
Insert Last Saved By in the Footer of Your Document
Did you know Microsoft Office has preset fields that you can insert into your document? I typically use the Last Saved By in the footer...
1,565 views
Apr 29, 20211 min read
Excel - Create a Drop-down Selection
Data entry can be the pits. What if you need to send a quick excel template to someone and you want to make it a little easier for them?...
35 views
Apr 21, 20211 min read
Use Dashes Instead of Zeros in a Pivot Table
Do you have a pivot table in your spreadsheet that contains a lot of zeros? There is a way to change the format of the zeros to display...
8,066 views
Apr 15, 20211 min read
Add a Secondary Time Zone to Outlook Calendar
Do you have members of your team that are located in a different time zone than you? Do you want a way to quickly see what the time is...
19 views
Feb 22, 20211 min read
NetworkDays Formula in Excel
Are you in a project and you would like to find the number of work days you have to schedule? Use the NetworkDays formula! You have to...
11 views
Dec 7, 20201 min read
Getting Rid of the #DIV/0! Error in Excel
Do you ever receive the below pesky error when you are creating calculations in Excel? This error occurs when you are trying to divide by...
99 views
bottom of page