Some time back, I wrote an article about a useful function in Microsoft Excel called Goal Seek. It quickly allows you to solve easy “what-if” scenarios. Although helpful, it comes with limitations. However, Microsoft has a more powerful add-in analysis tool called Excel Solver that overcomes these issues. You can even add a constraint.
Tutorial Listing
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:
Microsoft Excel
Microsoft Word
Google - (Includes Chrome, Gmail, Docs & Search)
Terms - Articles about different technologies
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:
How to use VLOOKUP
How to clean up your Gmail account
How to remove Chrome Extensions
How to create a Gmail distribution list
How to create a Cornell Notes template in Word
Beginners Guide to XLOOKUP in Excel
One of the more exciting software features to be released in Excel is the XLOOKUP function. Just looking at the name, you might think I did a typo and meant vlookup. No, this is an entirely new spreadsheet function that makes looking up data easier with fewer limitations on your lookup column.
Test Before You Import Contacts to Gmail
I was updating a Google article and decided I need to start fresh because the interface changed. I thought it would be faster if I imported a CSV file to Google Contacts. Not really. It took me a couple of tries. The good news is that you can learn from my mistakes.
Simple Ways to Protect Your Online Accounts
Recently, I met a friend who looked stressed. He returned home from work only to find out that someone had broken into his online accounts. Naturally, he was concerned about the data, but also the amount of time it would take to fix the problem. I told him an easy way to reduce the risk of account breaches is to use something called “two factor authentication” or 2FA. But, it has some issues if you’re not careful.
How to Freeze Cells in Excel – 4 Easy Examples
Recently, I volunteered to help a friend on a project which required delivering a weekly Excel summary. When I asked my friend how the spreadsheet looked, he hesitated. He looked me in the eyes and said, “It’s too complicated”. My immediate reaction was disappointment. I knew the one I produced was simpler, but I didn’t know what “too complicated” meant. It turns out the data was fine. I simply needed to show him how to freeze the Excel columns to make scrolling easier.
How to Review Your Google Security Settings
We’re living in an interconnected world which offers a lot of conveniences. We can use Google, Facebook, OAuth to connect us to online services and apps. The downside is that there are more “bad actors” trying to trick us and gain access to our info.
Customizing the Excel Ribbon for Your Needs
One issue I run into with this site is software updates. I’ll be updating an article and low and behold, something is missing or changed. Usually, this is a result of software changes. The area that is impacted the most is the Excel Ribbon. In two articles, I noticed I was missing the Forms button and in the other case, the Excel Developer tab. Both issues are easily fixed when you know how to customize the ribbon.
How to Learn Gmail Shortcuts with TinyCards
Keyboard shortcuts are a great way to enhance your productivity. The benefits are compounded the more you use a program like Gmail. The problem is learning them and committing them to memory. In the case of Gmail, there are quite a few and some don’t seem intuitive to me. I decided to test the TinyCards system and build a card deck to help me learn them faster. And you can get it too.
Easy Ways to Make a Google Docs Letterhead Template
People often think Google Docs isn’t full-featured. However, it can handle many of the tasks of commercial programs. But sometimes, you just have to know how to work around the system. In this tutorial, I show how to make a letterhead template with a logo.
Word Spell Check Woes
Ever have one of those days where you're trying to get out an important document, but you find the spellchecker in Word isn't working? Sometimes you can't check a specific document and other times you can't spell-check any documents. Either way, you might try some of these suggested solutions.
- 1
- 2
- 3
- …
- 7
- Next Page »