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
Â


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
Â


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
Â


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
Â


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
Â


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
Â


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
Â


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
Â


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
Â


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
Â


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
Â


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
Â


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
Â


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
Â


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
Â


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
Â
bottom of page