How to Control Data Conversions in Excel for Windows and Mac
After years of struggling with Microsoft Excel's internal conversion feature, users can now disable Excel's internal data conversion feature.
87 Excel Tips and Tricks: From Beginners to Pros
Discover 87 Excel tips and tricks that will take you from a beginner to a pro. Improve your efficiency, productivity and skills with these helpful Excel techniques.
How to Extract a Substring in Excel Using FIND() and MID() Functions
Learn how to use MID() and FIND() and then combine them to parse substrings from inconsistent data.
How to Convert an Image Into Editable Text Using Microsoft Word and Adobe
If you receive a picture of data, don’t panic: You don’t have to enter it by hand. Microsoft Word can convert the image into text for you.
How to Hide and Handle Zero Values in an Excel Chart
Charted zero values can have unintended results you can easily miss. Here are a few techniques you can use to hide and manage zeros in your workbook to keep that from happening.
How to Extract Delimited Data Using Excel Power Query
Learn how to use Excel Power Query's extract and split column features to extract delimited strings into their components with this step-by-step tutorial.
How to Sort One Column by Another Column in Power BI
If the natural data can't support the sorting and filtering requirements, you might need to add an index column and sort by it.
How to Calculate the Hours Worked Using Excel
Follow along in this step-by-step guide to learn how to easily calculate hours worked in Microsoft Excel.
How to Print From Microsoft Excel and Avoid Printing Problems
Adjusting print settings, margins and sheet options are all great ways to avoid issues when printing an Excel spreadsheet. Learn how in this guide.
3 Ways to Suppress 0 in Excel
Learn how to suppress or hide zero values in an Excel sheet using one of these quick and easy methods.