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.
Featured Articles
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.
How to Add Your Outlook HTML Signature
Email signatures can be a great marketing tool. However, I often run into people and business owners who struggle with trying to get their HTML versions into Microsoft Outlook. The process to add the code to emails is a bit different. Included are two ways you can add them.
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.
Practical Gift Ideas For Anytime
Are you looking for gift ideas? If so, I’ve assembled some items by price category that I’ve bought and used. I’ve tried to keep the ideas practical and have intentionally omitted things like gift certificates or other soft goods.
Easy Ways to Clear Cookies in Chrome
I’m a creature of habit and each Wednesday I go to my local supermarket’s website to see the specials. Certain of these specials are unique to me so I need to log in to see them. This week I couldn’t log in. Each time I got a message saying my session expired and to log in again. I had a pretty good idea that the problem was with some site cookie. The good news is there are multiple ways to clear cookies for one site with Google Chrome.
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.
When Alexa Voice Recognition Gets it Wrong
Image my surprise this morning when I looked at my To Do list and saw, “do a review on grimm kermit call marilee”. I stared at the screen for a good 20 seconds hoping something would pop to mind. I was stumped. Fortunately, I could tell the task had been placed the day before by Alexa. Now, the question was how to figure out what Alexa voice recognition heard. It was time to go to the source.
How to Check Computer Specs with these Free Windows Tools
Recently, I was trying to track down some system specs for my computers and ran into a snag. It had to do with this Meltdown and Spectre chipset nonsense. It seemed that some articles referenced the “chipset” and others the “code” name. I didn’t have a decoder ring so decided to see if various system utilities could help me check my computer specs. I came away thinking that these profiler tools vary widely in information and details.
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.