Links in Outlook Email Not Working

You probably get lots of email messages, and a good portion of those have links in them. Maybe a co-worker wants you to look at an online article, or a client sends you a link to check.

I get lots of emails like that, so it was alarming to get this message in Outlook recently, when I clicked a link.

Continue reading

Posted in Microsoft Office Tips | Leave a comment

Name That Office Gadget

In my Excel newsletter last week, I posted the picture below. These are 8 gadgets that I found in the drawers and shelves and other dark corners of my office, while decluttering it.

Do you recognize any or all of them? Some might be easy, but I had to do an online search for office gadget number 5, because I couldn’t remember what it was! And even with Google’s help, it was hard to find.

Continue reading

Posted in office gadgets | 2 Comments

Make It Easy to Read

Happy New Year, and best wishes for a prosperous 2017! And, to get things off to a good start, I’ll post a short, New-Year’s-related rant about accessibility – please make your products/articles easy to read.

Continue reading

Posted in Computer tips | Leave a comment

Reminder Excel Course Closing

Did you watch the 3 free data cleansing videos from John and Oz? If you want to learn more, don’t miss your chance to sign up for their full course — Ultimate Excel Power Query & Data Cleansing Online Course. Registration closes tomorrow, Friday, September 30th, at 6:59 PM (EDT).

To help you decide if the course is right for you, my review, and course details, are below.

Continue reading

Posted in Excel training | Leave a comment

Excel Data Cleansing Videos

If you have to work with messy data in Excel, be sure to watch the third video in the free Excel Data Cleansing series from John and Oz at MyExcelOnline. In this final video, you’ll learn how to consolidate Excel workbooks and worksheets using Power Query. That’s the best tool in the Power BI toolkit, so it’s worthwhile to learn more about it.

Continue reading

Posted in Excel training | Leave a comment

Excel Errors With Access Database

Recently, I’ve heard from a couple of people who were getting strange errors in Excel, when they tried to get data from an Access database. In both cases, things had been going smoothly for a long time, then suddenly stopped working. What was going wrong?

These Excel errors were different from the Read Only database problem that I wrote about before.
Continue reading

Posted in Microsoft Office Tips | Leave a comment

Website Backups

Today I’m making some structural changes to my websites, and the instruction page on Hostgator warns that you should make a full site backup before beginning. That sounded like good advice, so I decided to follow it!

In their support section, I found the instruction page, and followed the steps carefully, to begin the backup. Hostgator promised to send me an email as soon as the backup is ready, and it “could take a few minutes.”

Continue reading

Posted in Computer tips | Leave a comment

Excel Versions Survey Results

Thanks for answering the 3-question survey that I posted last week, about which Excel versions you’re using. I’ve compiled the results, so you can see what people are using. Is it close to what you expected?

Continue reading

Posted in Excel blog | 4 Comments

Installing Excel on New Laptop

Do you like to get a new computer, even though it means a few hours of setting things up? I’m still setting up my new laptop, and experimenting with Excel 2016. There’s lots to do! And there’s a very short survey at the end of this post, so please answer, if you can.

Continue reading

Posted in Excel blog | 18 Comments

New Laptop Setup Steps

On the weekend, I got a new laptop (another ASUS), which is exciting, until you realize all the things that have to be set up. It came with Windows 10 installed, but nothing else, so there were lots of programs to install. On the bright side, it’s a 15″ laptop with a number pad, so that’s a good thing!

Continue reading

Posted in Computer tips | 3 Comments