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

Last Chance to get 20% off Excel Macro Course

Recently, I let you know about Allen Wyatt’s Excel Macros for Beginners course that can help you work faster by automating some of your tasks.

If you’re thinking about signing up, I wanted to remind you that the 20% early bird discount is ending this Thursday, March 10th, at 8:00 pm Pacific time pm.

Continue reading

Posted in Excel training | Leave a comment

AWeber Link Tracking Not Working

As I’ve mentioned before, I use AWeber to manage my mailing list, and I’m generally pleased with the way that it works. Recently though, I discovered a major problem with the AWeber link tracking feature. I’ve lost data, but have learned how to avoid the problem in the future. As is often the case with computer problems, it was user error!

Continue reading

Posted in email list tips | Leave a comment