For five years, I’ve researched and submitted items for the Remember When column that appears in the Shakopee Valley News weekly, on behalf of the Shakopee Heritage Society, Shakopee’s local history organization. With my work schedule varying for many years,
Change Number Formatting in Excel
Recently, I was asked how to change Excel’s default date from the format 3/10/2019 to Sunday, March 10, 2019. There are a few number formatting options that can accomplish this. In Excel, the Number Format options allow you create custom
Auto-Launching Applications
Are there certain applications or web pages that you always open right when you log in to your computer? There’s a way in Windows to set these programs and websites to launch automatically when you log into your computer. Here’s
Fitting Worksheet Content on a Page
There are some instances where you want to fit the contents of a workbook onto a single page (or limit how many pages wide a workbook prints, or pages tall a workbook prints). Rather than adjusting column width to get
Sampling Colors in Office
If you’re like me and you’re developing something such as a newsletter or sign, you want the branding colors based on a logo to match to perfection. There’s a nifty feature built into Microsoft Publisher that can be used to
Adding Web Shortcuts to Mobile Device Home Screens
A couple friends of mine recently got me into Warhammer and recommended I bookmark an army builder on my phone. Another friend of mine is coaching baseball and wants quick access to an online rule book. Both of these commonly-accessed links
Showing and Hiding Data in Excel
Excel has a feature that allows you to hide cells for printing or display purposes, and also allows you to un-hide them. To hide rows or columns in Excel: Highlight the row or column header(s) for those row(s) or column(s)
Moving Cells in Excel
Have you ever wanted to move rows or columns of cells in Excel, but struggled to keep the formulas in place when changing the layout of your workbook? Here’s how to move cells in Excel, while keeping formulas intact: Highlight
Apostrophe Shortcut in Excel
When using Excel, by default, cell contents that look like a number are treated as a number. At times, this can be inconvenient as Excel also truncates leading zeroes on text that is a number, but shouldn’t be calculated on
Scam Busters: Your Mailbox is Not Full!
Every once in a while, an individual may receive an email that looks legitimate, saying that their inbox is full. More often than not, this isn’t true. It’s often an attempted phishing attack, where a user visits a bogus website,