Start Feeling Smarter about your Software

Blog

Zach’s Monday Mac Tips

Welcome to Zach’s Monday Mac Tips! Hello, I’m Zach Stout, MPELLC’s marketing specialist. Melissa mentioned that some of her fans were interested in shortcuts like she posts each week, but for Mac users. Well, here you go. Check back each week for new ones! Frequent user of […]

Read more

3 Cool Things About the New SharePoint

If you’ve recently implemented or are thinking about implementing SharePoint in your new Office 365 environment here are a few things that I think are definite improvements. Click this post for more…

Read more

AutoFill Your Own Custom List

AutoFill Your Own List Just like you AutoFill the days of the week and the months of the year in Excel, you can AutoFill your own list. Set up is easy! Type your list into a range of cells on a worksheet and select it. Or, select […]

Read more

Word Paste Options Explained

In most of Office, the paste options seem very straight forward. You’ve probably seen that little Paste Options box pop up when you do a copy/paste of Ctrl+C/Ctrl+V. In word you have three options. Keep Source Formatting Merge Formatting Keep Text Only The first option makes plenty […]

Read more

Replace VLookUp with Access Query

In some cases opening your Excel workbooks in Access is a better solution than trying to link them through VLookUp formulas. If you have access to Access, try this. What I have:  An Orders workbook that shows company code, product code and quantity purchased  A Company workbook […]

Read more

Pivot Table Values as a Percentage of Total

There are 2 ways to show Pivot Table values as a percentage of the total. The first one which is commonly used isn’t very nimble. When your data changes the formulas may not compute correctly. I always say the worst mistake you can have in Excel doesn’t […]

Read more

The Zip Code Conundrum

In Excel, when you have a 0-first digit zip code, it usually shows up as only the last four digits. So, take a Massachusetts zip code like 02201. If you just type that into an Excel cell it comes up 2201. You could type an apostrophe (‘) […]

Read more

Beyond Filtering: Advanced Filter Techniques

You are trying to filter using multiple AND and OR criteria in Microsoft Excel. — OR — One or more columns in your list have more than 10,000 unique items (think employee numbers, serial numbers, transactions).Learn about advanced filtering in this new post!

Read more

Add page numbers to slides in PowerPoint

Thanks to Marie for this question: Q. How (do I) … format a master slide to number pages, and renumber them if I add a slide to my presentation? A. Start from the Slide Master with the master slide selected. Then from the Insert tab, choose Slide […]

Read more

3 Tips and 3 Tools to Love your Lists

Follow these tips for Excel lists and open the doors to a ton of great tools! The Tips 1. Column Headings are essential to use other tools like Pivot Tables, filters and database functions. Column headings become field names to describe the type of data in each […]

Read more