In an old post, I went over how to parse data using various different functions. This time around, I'm going to show you how much easier it is do that in Power Query. If you're not comfortable using LEN or MID functions, then this will make your lif ...
Are you looking for an easy way to add a date to your Excel spreadsheet? You can download my free date picker add-in for Excel. It is useful if you have a form and you want people to select dates or if you just want an easy way to enter a date witho ...
An Excel chart can provide lots of useful information but if it isn't easy to read, people may skip over its contents. There are many simple things you can do that can quickly add to the visual to make it fit seamlessly within a presentation and tha ...
Do you want to learn how to quickly count the number of cells that meet certain criteria? How about partial matches using wildcards? Below, I'll show you how you can do this using the COUNTIF function in Excel along with similar tasks. How does t ...
A stock screener allows you to filter through stocks that meet your investment criteria. It can help you find undervalued stocks and great dividend investments. But sometimes it can be cumbersome to always go back to a website and re-apply filters, ...
In a previous post, I covered how to create a form in Excel. Although I didn't go over drop down lists specifically, they are one element you could incorporate into them. The problem is that your list can change over time, getting bigger or smaller. ...
Charts can be great tools to help visualize data. And sometimes, you will want to combine different types of information in one place. That can be tricky because if the scales are different, information may not display the way you would like it to. ...
In a previous post, I covered how to add checkboxes. Now, I'm going to go a step further and show you how you can create a form in Excel from start to finish. And at the bottom of the page, you can download a file that you can use for your own custo ...
One way you can make a form in Excel more user-friendly is by adding checkboxes to it. There are a few different ways you can do this which I'll cover and I will also show you how you might incorporate this into a sample pricing sheet. https:// ...
Speeding saves time but it also can put yourself and other people in harm's way. But how about if you only speed 5 miles over the speed limit? What about 10 miles? Below, I'll do a sensitivity analysis in Excel to calculate just how much time you ar ...
