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 Microsoft Word’s spell check not working? This article provides solutions to common spell-check issues, including verifying language settings, checking proofing exceptions, and renaming your Word template. It also covers how to repair the installation, rename a Windows registry folder, and check your custom dictionary for errors. In the meantime, you can try using online alternatives like Google Docs or Microsoft Word Online for spell checking. Then, fix your spell-check issues and get back to writing flawlessly.
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.
Convert Excel Columns to Rows for Easier Analysis
Ever struggled with data analysis due to the orientation of your Excel data? This tutorial introduces Excel’s Transpose function. A tool that effortlessly switches columns and rows. It’s a must-have for data organization, enabling you to view your data in a way that best suits your needs.
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 Template in Microsoft Word: Easy as ABC
Want to elevate your brand and create professional-looking documents? Learn how to design a custom letterhead in Microsoft Word with this easy-to-follow tutorial. Discover how to incorporate your logo, contact information, and design elements for a polished and consistent look. Enhance your business communications and make a lasting impression with a personalized letterhead.
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.