How To Excel Blog
1,284 FOLLOWERS
Hi, I'm John and I'm the creator of How To Excel. I've been using Excel for over 10 years now and I'm kind of an Excel nerd. I hate doing things the hard way, so I'm always looking for the best ways to solve my problems in Excel. I created this site because I wanted to help you get your work done quickly and get you out of the office on time.
How To Excel Blog
2w ago
Wondering how to count the number of occurrences in Excel? You’ve reached the right resource! Keep reading. Suppose, you’ve got a tabular dataset in your worksheet where you must perform data analysis tasks like frequency analysis, error detection, duplicate analysis, and so on. In all such scenarios, you must use the skill of counting the ..read more
How To Excel Blog
2w ago
This Microsoft Excel tutorial helps you to learn how to make a negative number positive in Excel. When working with numerical values in Excel, you often need to convert one number format to another, like positive numbers to negative, whole numbers to decimals, and so on. Among these, one of the most popular is making ..read more
How To Excel Blog
2w ago
Wondering how to add a secondary axis in Excel? It’s so easy if you follow along with this effortless Excel tutorial. Microsoft Excel is an excellent data visualization tool because you barely need to do any chart configuration. All you need to do is select the whole dataset and insert an appropriate chart from automatic ..read more
How To Excel Blog
1M ago
This effortless Microsoft Excel tutorial shall explain how to find and replace in Excel with different situations and use cases. Often you want to locate a value or text string on your Excel worksheet for data analysis and visualization purposes. Also, you may want to look for a specific item in an Excel workbook whether ..read more
How To Excel Blog
1M ago
Do you want to learn how to remove leading zeros in Excel? This quick Excel tutorial contains some of the best techniques you can use. Microsoft Excel removes leading zeroes when you’re entering your data in the Number or General format. However, often you work with datasets imported from third-party software or databases where you ..read more
How To Excel Blog
1M ago
Do you want to learn how to highlight every other row in Excel? Join me in this article as I show you the tried and tested methods with real-world datasets. If your Microsoft Excel worksheet contains data spread in many rows without any whitespace in between rows, it’s tough to follow the data. Here, you ..read more
How To Excel Blog
1M ago
This effortless Excel tutorial shall show you how to make numbers negative in Excel step by step with real worksheet images. It’s often necessary to input negative numbers in Microsoft Excel for financial analysis, data manipulation, error handling, and mathematical operations. The conventional wisdom says you type the subtraction operator (the minus sign) followed by ..read more
How To Excel Blog
2M ago
Do you want to learn how to unshare an Excel file? You’ve landed on the best resource. Keep reading! Microsoft Excel has made it truly easy to share your workbooks or worksheets directly from the desktop or web app. There’s no need to manually upload your workbook to cloud storage like OneDrive, Google Drive, or ..read more
How To Excel Blog
2M ago
Today I’ll show you how to add bullet points in Excel with steps and illustrative images so you can also do the same to highlight key points in your Excel workbook reports for clarity and enhanced readability. Bullet points enhance the visual appeal of a document or presentation by adding structure and white space. Bullet ..read more
How To Excel Blog
2M ago
Have you ever felt lost in a huge Excel spreadsheet especially when you need to look up a value along the rows or columns? Do you often scan through large Excel datasets to pinpoint interesting data and create a list of those manually, and put a huge strain on your eyes in the process? Then ..read more