top of page


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? ...
Oct 29, 20212 min read
6,093 views


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...
Oct 8, 20211 min read
106 views


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...
Jul 29, 20211 min read
25,869 views


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...
Jul 21, 20211 min read
120 views


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...
Jul 15, 20211 min read
88 views


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...
Jun 23, 20211 min read
1,446 views


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...
Jun 15, 20211 min read
113 views


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...
Jun 9, 20213 min read
9,957 views


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...
May 27, 20211 min read
17 views


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...
May 18, 20211 min read
39 views


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...
May 5, 20211 min read
1,744 views


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?...
Apr 29, 20211 min read
36 views


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...
Apr 21, 20211 min read
8,725 views


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...
Apr 15, 20211 min read
19 views


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...
Feb 22, 20211 min read
11 views


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...
Dec 7, 20201 min read
100 views
bottom of page