Productivity Portfolio

Valuing your time & technology

  • Home
  • Tutorials
    • Excel
    • Google
    • Word
    • Terms
  • Quick Tips
    • Email
    • Security
    • Web
    • Windows
    • Internet of Things
    • Cell
  • Reviews
    • Health
    • Services
    • Software
    • Hardware
  • About
    • About Me
    • Contact Page
    • Privacy Policy
  • Newsletter
  • Resources
    • Practical Gift Ideas
    • Books
    • Favorite Podcasts
    • Gadgets
    • Online Courses
    • Online Services
You are here: Home / Archives for Featured

Featured Stories

Quick Guide to Excel Solver

Last Updated on 27-Sep-2019 by Anne Hennegar

Solver results on top of original results.

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.

Filed Under: Excel, Featured, Tutorials

Beginners Guide to XLOOKUP in Excel

Last Updated on 28-Nov-2019 by Anne Hennegar

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.

Filed Under: Excel, Featured, Tutorials Tagged With: excel formulas

How to Add Your Outlook HTML Signature

Last Updated on 17-Aug-2019 by Anne Hennegar

Insert file dialog with Insert as Text option.

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.

Filed Under: Email, Featured, Quick Tips Tagged With: outlook

Test Before You Import Contacts to Gmail

Last Updated on 27-Sep-2019 by Anne Hennegar

csv file with column headings for Google

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.

Filed Under: Featured, Google

Practical Gift Ideas For Anytime

Last Updated on 4-Dec-2019 by Anne Hennegar

hands delivering gift box

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.

Filed Under: Featured, Product & Service Reviews

Easy Ways to Clear Cookies in Chrome

Last Updated on 14-Jul-2019 by Anne Hennegar

Listing of all cookies sorted by domain.

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.

Filed Under: Featured, Google, Tutorials Tagged With: Chrome, cookies

Customizing the Excel Ribbon for Your Needs

Last Updated on 28-Nov-2019 by Anne Hennegar

Excel Ribbon Display Options

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.

Filed Under: Excel, Featured, Tutorials

When Alexa Voice Recognition Gets it Wrong

Last Updated on 27-May-2018 by Anne Hennegar

Alexa account history menu

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.

Filed Under: Featured, Internet of Things, Quick Tips

How to Check Computer Specs with these Free Windows Tools

Last Updated on 21-Apr-2019 by Anne Hennegar

Speccy summary panel

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.

Filed Under: Featured, Quick Tips, Windows

Easy Ways to Make a Google Docs Letterhead Template

Last Updated on 26-Mar-2018 by Anne Hennegar

Google Docs template gallery

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.

Filed Under: Featured, Google, Tutorials

  • 1
  • 2
  • Next Page »

© 2019 · Productivity Portfolio | PO BOX 117361 Burlingame, CA 94011