What's Your IT Question?

Want to know more about this topic or about us? Contact us!

All posts in microsoft excel

How to Format a Copy for Excel Worksheet Columns and Rows

Formatting allows viewers to distinguish values by type and even sections. Applying the right formatting is critical to readability, and most users learn how to format cells and regions early on. After learning the basics, users quickly move on to using Format Painter to copy existing formats to other cells . . . Read more

Microsoft Opens Copilot for Microsoft 365 Up to Small and Medium Businesses

Microsoft’s generative AI assistant Copilot for Microsoft 365 is now available for businesses interested in providing the product to fewer than 299 seats. The Copilot for Microsoft 365 subscription for business use lets employees use data from across their company’s Microsoft products to provide more data to the generative AI, . . . Read more

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. Excel tries to determine an input value’s data type — and, for most of us, that’s helpful. For instance, if you enter a string that represents a date, Excel automatically converts . . . Read more

87 Excel Tips and Tricks: From Beginners to Pros

Microsoft Excel was first released in 1985, and the spreadsheet program has remained popular through the years. You can master Excel by reading these tips and tricks on how to add a dropdown list in an Excel cell to find duplicates, how to delete blank rows in Excel and more. . . . Read more

87 Excel Tips and Tricks: From Beginners to Pros

Microsoft Excel was first released in 1985, and the spreadsheet program has remained popular through the years. You can master Excel by reading these tips and tricks on how to add a dropdown list in an Excel cell to find duplicates, how to delete blank rows in Excel and more. . . . Read more

How to Extract a Substring in Excel Using FIND() and MID() Functions

Parsing data is a common task in Excel. For the most part, you’ll do so when you need to work with substrings rather than the whole source values. For instance, you might want to parse a store or customer identification number from a transaction string that includes all the information . . . Read more

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. If you’re putting together a Microsoft Office document and receive textual content in the form of an image file, you might panic, especially . . . Read more

How to Hide and Handle Zero Values in an Excel Chart

Editor’s note: In the video, Brandon Vigliarolo walks you through a couple of ways for suppressing 0 values in Excel charts. For this demo, he uses Microsoft Office 365. The steps are similar to what Susan Harkins describes in the following tutorial. A drop to zero in a chart can . . . Read more

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. You might receive foreign data in the form of characters strung together that you must import into Microsoft Excel. Generally, you’ll import the full dataset, even if . . . Read more