Working with Text
How to Extract Last Name in Excel
Learn how to extract the last name from a person’s full name in Microsoft Excel with this simple step-by-step guide. Save time and improve your data accuracy today.
May 20, 2023
All Excel Guides
Every tutorial, formula reference, and how-to guide on the site, newest first.
Page 54 of 112
Working with Text
How to Extract Numbers from a String in Excel
Learn how to extract numbers from a string in Excel with this easy step-by-step guide. Using functions like LEFT, RIGHT, and MID, you can quickly isolate numerical data.
May 20, 2023
Working with Text
How to Extract Text from a Cell in Excel
Learn how to extract text from a cell in Excel with this step-by-step guide. Discover helpful tips and tricks to make the process easier and more efficient.
May 20, 2023
Working with Text
How to Extract Year from Date in Excel
Learn how to extract the year from a date in Excel effortlessly. Follow these simple instructions to easily get the year in a separate cell using formulas.
May 20, 2023
How To
How to Extrapolate in Excel
Learn how to extrapolate data in Excel with our step-by-step guide. Easily predict future trends and make informed decisions based on accurate data.
May 20, 2023
How To
Where Is the F4 Key on Mac for Excel?
Learn where to find the F4 key on your Mac for Excel with ease. This comprehensive guide gives you the answers you need to use your keyboard shortcuts efficiently.
May 20, 2023
How To
What Is F4 on Mac for Excel?
Learn what F4 does in Microsoft Excel when using a Mac. Find out how this shortcut key helps you perform tasks faster and more efficiently. Discover its many uses in your spreadsheet work.
May 20, 2023
How To
How to Do Factorials in Excel
Learn how to perform factorials in Excel with this step-by-step guide. Whether you are working with small or large numbers, Excel can do it all.
May 20, 2023
How To
Which Feature of Excel Changes Obvious Misspellings Automatically
Discover which feature of Excel can fix obvious misspellings automatically, saving you time and effort. Keep your spreadsheets error-free with this convenient tool.
May 20, 2023
Excel Basics and General Knowledge
How to Fill Blank Cells with Value Above in Excel
Learn how to easily fill blank cells in Excel based on the values above them. Streamline your data entry process and save time with this simple technique.
May 20, 2023
How To
How to Fill Down in Excel
Learn how to easily fill down in Excel with our step-by-step guide. This tutorial covers everything you need to know, from selecting cells to using shortcuts.
May 20, 2023
How To
What Is a Fill Handle in Excel
Learn what a fill handle is in Excel and how to use it to fill cells with data or formulas quickly and easily. Improve your efficiency with this essential Excel tool.
May 20, 2023
Form Controls and User Interaction
How to Fill Without Formatting in Excel
Learn how to fill cells in Excel without formatting by following these simple steps. This tutorial will show you how to fill data in Excel without losing the original formatting of your sheet.
May 20, 2023
Excel Data Manipulation and Transformation
How to Filter by Color in Excel
Learn how to easily filter cells by color in Microsoft Excel. This tutorial will show you step-by-step instructions on how to use this powerful feature to streamline your data analysis process.
May 20, 2023
Excel Data Manipulation and Transformation
How to Filter Columns in Excel
Learn how to filter columns in Excel to better organize and analyze your data. Our step-by-step guide will show you how to use the filtering function effectively.
May 20, 2023