This Excel tutorial is the follow up to the previous article we did on using Excel’s built-in macro recorder. It will introduce you to the macro editor and layout so you can create or edit your own macros. It’s also a great way to learn how the macros work.
These pages include all the site tutorials regardless of category. These mainly cover Microsoft and Google products. In addition, there are some posts that provide information about key terms. Presently, the categories include:
This section is several pages long so be sure to use the blue Next Page >> button at the bottom or the search box to the right.
Some reader favorites include:
Excel allows you to sort your columns and rows by lots of ways. One less obvious way is to sort items by color. This is handy if you apply a background color to a cell or different font color. This tutorial explains how to do the sort. You can also filter by color.
Somedays, I just want to scream when things that did work, no longer work. This happened this week when I needed to contact a vendor by email. This is usually a simple task where you click an email link and it opens in your default application. Instead of getting Gmail to open up in Chrome, I was staring at the Microsoft Store email app.
Do you find you’re seeing more browser push notifications? Some of these are quite useful, but others are a result of me clicking to allow something in my haste. This week, I hit the tipping point. Each time the little box would push out from the right side of Chrome, I’d want to smack it. While that might make me feel good, the better solution was to change my browser settings.
Recently I was watching an Excel product review and noticed the author copy Excel values from a formula into another column. This was fine, but then he deleted the column with the formula. Sound familiar? In this tutorial, Ill show you two faster and easier ways to overwrite formulas with their values. (Includes video demo and sample spreadsheet.)
Back in the old internet days, people rarely changed email addresses. Today is a different story with people changing jobs and having multiple email addresses. Sometimes email programs don’t want to let go of the old addresses and keep displaying them for us, which can present problems. I’ll skip the embarrassing parts and show you an easy way to remove stale addresses from the Google’s auto-complete list.
One bad habit I have is letting my Gmail inbox get too big. I don’t always delete emails as fast as I should. These accrued items tend to be non-urgent items I get on a recurring basis that I haven’t flagged as a priority. Eventually, I reach that tipping point and want to delete these Google emails in mass. There are many ways to delete Gmail items, but here’s one tutorial that requires minimal effort and you can do at your own pace.
Browser extensions are great add-ons when they work. But I ran into a problem where one of them continually crashed when I opened Google Chrome. Worse, because it didn’t load properly, I couldn’t uninstall the Chrome extension in the normal manner. Fortunately, there is another solution to this problem.
There was a lot of interest in websites that show searches from both Google and Yahoo! These sites displayed your query results side by side. The approach is interesting, but if people are looking for combined results, a better approach might be a meta-search engine. (Update: metasearch engines are not as popular as they once were when this article was written.)
Earlier this month, I got a request from a manager in town asking if I could randomly select 150 people from a membership list. No darts allowed. I think the purpose was to do a survey, but maybe it was to select contest winners. It turns out that Microsoft Excel has a random number generator which was the key to my solution.