In this tutorial, master extracting text from Excel cells with simple text functions. Grasp the concept of Excel substrings and tackle text string messes. Next, skillfully build nested formulas using LEFT, FIND, and RIGHT functions to separate street numbers and names. Finally, transform your spreadsheet by converting formulas to values and adjusting cell formats. Includes practice workbook.
Tutorials
This site has many tutorials, and I don’t think it would be efficient to list them all because you’d have to click through many pages. Instead, I opted to show the most recent across all categories. The Top 10 list will change over time, and new categories may appear.
I think this is a better user experience, but I’d be interested in your thoughts.
You can also skip this list and jump to a specific category and its listing. Or, you can always use the Search function at the top of each page.
Google Tutorials
Microsoft Excel Tutorials
Microsoft Word Tutorials
Microsoft Outlook Tutorials
Terms to Learn
Recent Tutorials & Updates
Mass Delete Gmail: 6 Ways to Clear Your Email Clutter
Are you overwhelmed by the number of unread emails in your Gmail? Streamline your email management and achieve inbox zen by learning how to delete Gmail in bulk. Our detailed guide offers easy-to-follow steps, empowering you to reclaim control of your inbox. Discover the art of efficient email management.
Excel VLOOKUP Made Easy – Learn Basics with Practice File & Video
One of the popular Excel tutorial requests is how do you look up a value on one Excel worksheet and use it on another Excel worksheet? For example, you need to translate a product number into a product name. One of my favorite functions is the VLOOKUP function and it can help with this task. (Includes example spreadsheet and video.)
Best Ways to Import Contacts to Google Contacts
Are you tired of retyping contact information across email platforms? Then, save time and effort by learning the most effective ways to import contacts to Gmail from my mistakes. Our comprehensive guide covers multiple scenarios, including importing from Microsoft Outlook, vCard, and CSV files. Plus, get tips on preparing your contact data before importing, ensuring a smooth and error-free process.
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 alternatives as temporary solutions. Each solution includes clear steps and practical troubleshooting tips to get your spell check working as expected.
Google NotebookLM: AI Research Assistant
This starter guide explores the ins and outs of NotebookLM, from understanding its unique “grounded” AI approach to learning its key features including the Notebook Guide and insights. See how to maximize your research efficiency and explore real-world applications of this innovative tool.
Quickly Switch Columns and Rows in Excel: Simplify Your Analysis
Need to switch columns and rows in Excel? It can be a pain when your data isn’t oriented the way you need it. This guide shows you easy methods using Paste Special, the TRANSPOSE function, and helpful keyboard shortcuts. You’ll learn how to quickly transpose your data, saving time and making your spreadsheets more effective. These techniques work across different Excel versions so you can easily reorganize your data no matter which version you’re using.
How to Make a Cornell Notes Template with Word
The Cornell Note-taking method enhances learning by structuring notes in a specific layout. This tutorial guides users in creating a Cornell Notes Template using Microsoft Word. The method divides a page into three sections: Cue Column for keywords and questions, a main note-taking area, and a summary section for key points. The template can be personalized, and there’s also a printable PDF version available.
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 instructions and practical tips for achieving a polished, professional result that maintains consistency across all your business documents
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.