Windows 11 Microsoft 365 / Office 365 Update: Quick Access Toolbar & Menu Tabs, and the Colorful Office Theme

If you upgrade to Windows 11, you will find that your Microsoft 365 / Office 365 will soon change their … More

Excel: Drop-Down Menus, aka, Data Validation

Years ago, I worked at a university, and I was hiring student workers to help with data entry. The highest … More

Excel Absolute and Relative Cell References: Multiplication Table

How to explain the difference between using a relative and absolute cell reference in a basic Excel formula? I know … More

Excel Dates: Birthdays and Ages Spreadsheet

You are rushing to get your niece a birthday card before her birthday, and you cannot remember how old she … More

MS Office / Word / Excel / PowerPoint: Customize Your Quick Access Toolbar

When you first open any document in MS Word, MS Excel, or MS PowerPoint, you should notice there are little … More

Excel Basics

I am a guest blogger on Noobie.com.  They asked me to create some new-to-Excel posts for beginners.  Just click the … More

Windows and Office: Using Shortcut Keys to Select a Range

Microsoft has developed several standard ways to select bits of text, objects, or files in most of their products.  The … More

Setting Excel’s Default Date Format to Two-Digit, aka, mm/dd/yy

I like using two-digit date formats on all my spreadsheets.  This way all the dates in columns will line up, … More

Use Excel and Word’s Mail Merge to Print Mailing Labels

First, create a basic mailing list in Excel of your friends and family.  You must include the headers for each … More

Excel: A Cell Full of Notes

Excel is great for math, but it is also great for organizing lists and making notes.  Let’s compare cats. I’ve … More