From Tech Trouble to Tech Triumph: Simple Tutorials for All

Struggling with technology even though you’ve got the right tools? Staring at a screen, clueless and frustrated? You’re not alone. At Productivity Portfolio, we understand that achieving productive outcomes goes beyond technological know-how. Our mission is simple: to provide a portfolio of clear, accessible tutorials to help you leverage technology.

Whether navigating through Microsoft Excel, managing your online security, or exploring the potentials of Artificial Intelligence (AI), our portfolio of step-by-step guides ensures technology accelerates your productivity rather than hinders it.

TODAY’S TECH TIP

Hide Excel Cell Data Tip

Ever have a scenario where you want to hide some cell values but still have them show in the formula bar?

  1. Highlight the data to hide.
  2. Press Ctrl + ..
  3. In the Format Cells dialog, select Custom.
  4. Replace the General in the Type textbox field with ;;;
  5. Click OK.
Format cell data to hide contents.

FEATURED ARTICLES

  • Brain.fm: An Innovative Audio Tool for Focus & Productivity

    Brain.fm: An Innovative Audio Tool for Focus & Productivity

    Struggling with focus or seeking deeper relaxation? Brain.fm offers a scientifically-backed solution: functional music. Discover how this innovative platform combines neuroscience and AI to create personalized soundtracks that enhance your cognitive performance. Explore customizable features like genre selection, neural effect levels, and unique timer settings to optimize your focus sessions and work breaks.

    SHOW ME MORE


EASY TUTORIALS

  • How to Split Names in Excel for Cleaner Data

    Learn how to separate names in Excel to boost productivity and improve data organization. This article teaches you various techniques, including using the Text to Columns tool, formulas like LEFT, RIGHT, and MID, and the powerful Flash Fill function. Apply these methods to streamline your workflow and make your data more manageable.

    SHOW ME MORE

    Excel formula to parse name

  • Why is Spell Check Not Working in Word? Find Easy Fixes

    Is your Word spell check not working? It’s a common source of frustration for many users. In this guide, I’ll show you how to check language settings, proofing exceptions, and template files. You’ll learn how to fix problems in single documents or across your entire Word installation. While you troubleshoot, you can use suggested online…

    SHOW ME MORE

    Word document with Reveal Formatting and Languages dialog.

  • How to Use the IF Function in Excel: Formulas and Examples

    Learn how to use the IF function in Excel for making quick decisions and comparisons. This versatile logical comparison function can handle many scenarios, from financial models to assigning allowances. Follow this tutorial and practice worksheet to master the basics and start using it in more complex scenarios.

    SHOW ME MORE

    Example of IF function and arguments.

  • How to Make a Letterhead in Word: Easy as ABC

    Need to create a professional letterhead in Microsoft Word? Many users struggle with placing logos, contact details, and formatting correctly. In this guide, I’ll show you how to design custom letterheads using headers, footers, and template features. You’ll learn how to add company graphics, position contact information, and save reusable templates. Each step includes clear…

    SHOW ME MORE

    Header area of Word letterhead

  • How to Create a Distribution List in Gmail for Efficient Group Emails

    Are you tired of manually entering multiple email addresses? Discover how to create and use Gmail distribution lists. This tutorial provides step-by-step instructions on setting up Contact Labels, sending group emails, and managing your lists. Learn time-saving tips and best practices for efficient email communication. Boost your productivity and send group emails like a pro…

    SHOW ME MORE

    Assign labels to Google Contacts.

  • How to Type Symbols & Characters With Your Keyboard

    Have you ever wished to craft keyboard symbols and special characters but lacked the know-how? Our guide will instruct you on the nuances of Alt codes, Unicodes, and other ways to make these distinctive symbols. Master the application of special characters across different platforms, including Microsoft Office, email, and web design. Explore the wide array…

    SHOW ME MORE

    Character Map with Cents Sign

FEATURED VIDEO

  • Video: Excel Conditional Formatting

    Video: Excel Conditional Formatting

    Below is a short video showing you how to use Excel’s conditional formatting feature. You can see the full steps from this tutorial.

    LEARN MORE