Microsoft
SoftwareHow to enter data quickly in Excel
Microsoft Excel users, follow these two easy methods to reduce data entry time and errors when customized features aren't available.
-
Image: PixieMe/Shutterstock -
Image: Screenshot Microsoft
SoftwareHow to conditionally return the last value in a column in Excel
Returning the last value based on a condition seems like a difficult problem to solve unless you try one of these easy-to-implement solutions.
-
Image: Wachiwit/Shutterstock Microsoft
SoftwareHow to average with and without the highest and lowest values in Excel
Averaging in Microsoft Excel is easy, until you start excluding specific values. Here are three ways to average a data set when giving special consideration to the highest and lowest values.
-
Image: justplay1412/Shutterstock Microsoft
SoftwareHow to add a page break to a Word style
Avoid using hard page breaks when you can use a style instead in Microsoft Word.
-
Image: Flamingo Images/Shutterstock Microsoft
SoftwareHow to make fewer mistakes and work more efficiently using predictive text in Microsoft 365
If you're a slow or inaccurate typist, consider turning on Windows' predictive text feature. It will help you reduce spelling and grammar errors.
-
Image: monticello/Shutterstock Microsoft
SoftwareHow to zoom in on small details in PowerPoint
Use this zooming effect to draw attention to a small or important detail in your next PowerPoint presentation.
-
Image: iStock/Oleg Elkov Microsoft
SoftwareHow to use the many text wrapping options in Microsoft Word
Understanding how text interacts with an inserted object in Word is the key to getting the look you want.
-
Image: iStockphoto/Rawpixel Ltd Microsoft
SoftwareHow to extract the date and time from a serial date in Excel
If you have to work with a date stamp in Microsoft Excel that includes date and time, you can use these simple expressions to extract both components, making them easier to work with.
-
Image: utah778, Getty Images/iStockphoto Microsoft
SoftwareHow to subtotal transactions by conditional date components in Excel
If you need a monthly or yearly balance for revenue transactions in Microsoft Excel, you're in luck because both are easy! Here's how to find the totals you need.
-
Illustration: Lisa Hornung, Getty Images/iStockPhoto Microsoft
SoftwareTwo ways to quickly delete paragraphs in Microsoft Word
You can delete multiple paragraphs in Word by relying on a style—a benefit that you might not have considered.