One advantage of working from home is that there aren’t too many interruptions. Just turn off the phone, shut down the email, and focus on getting things done. Last week though, while I was working on an Excel file, a large message popped up on the other monitor. “Bored with your background? Update your desktop background, or create a whole slideshow of pics.”
Better Microsoft Outlook Searches
Is it easy for you to find an old email in Microsoft Outlook? I always click in the Instant Search box, type a word or two, and hope for the best. That doesn’t always work too well Fortunately, Alex B showed me a few tricks for better Microsoft Outlook searches, and they might help you too. There’s also a big problem with one of these tricks, and Microsoft won’t be fixing it.
YouTube Not Eligible for Monetization Problem
On my Contextures YouTube channel, I’ve posted almost 500 Excel videos, since starting way back in 2008. There’s a bit of advertising revenue from the videos, and I usually just check the grand total each month, and put that amount into my records. Today I took a closer look at the revenue for each video, and was surprised to find that one was flagged as “not eligible for monetization”. After some troubleshooting, I think that I’ve figured out what the YouTube “not eligible for monetization” problem was – see if you can spot it.
Continue reading “YouTube Not Eligible for Monetization Problem”
Access Query Date Criteria Examples
On my Contextures website, the focus in on Excel tips and tutorials. Behind the scenes, I use Microsoft Access too, for time tracking, website statistics and a few other key tasks. This week, I wanted to find files that hadn’t been updated for a long time, so I created a query that selects records older than X – Access asks what X is each time the query runs. Here’s what I built, and a few other Access query date criteria examples.
SamCart or E-junkie for Digital Product Sales
Last week I signed up for a trial subscription to SamCart, to see how it worked for digital product sales. I’ve been happy with E-junkie, but SamCart had a few shiny features that looked appealing. Things got off to a great start, but one key feature is missing, so I’ll be staying with E-junkie. Should you choose SamCart or E-junkie?
Continue reading “SamCart or E-junkie for Digital Product Sales”
Can You Give Yourself a Vacation?
When you work for somebody else, you get vacation time every year. It’s nice to have lazy time away from the office, and think about something other than work for a while. But, when you work for yourself, do you remember to go on vacation? Or do you just take a long weekend now and then, and then get right back to work?
Missing Months in Access Report Headings
Today I made a simple report in my Access database, with a list of articles that I’ve written in the past 60 days. I tried to group the articles by month, and that’s when the trouble started. My Access report headings didn’t show all the months, and it took me a while to solve the problem. Maybe this fix will help you too.
Colouring Book Day
This Colouring book is no longer available
___________