There are a few different ways you can pull stock prices into Excel. You can use the new STOCKHISTORY function, pull data from Google Sheets which has a native stock function, or you can also use Power Query. In this post, Power Query is what I am g ...
Amount Invested Shares Owned Today Current Price Desired Average Price Your Average Price Price Movement ...
Depending on what kind of data you are working with and how you need to present it, you may need to show numbers in thousands, millions, or billions. Below, I'll show you how you can quickly and easily make those conversions. You'll also learn how t ...
Are you stuck doing boring Zoom calls or have a boss that likes to say the same phrases over and over? I've got a great way for you to help pass the time at the office and make your meetings more interesting: play Corporate Bingo with your co-worker ...
Do you need a calendar in Excel to quickly write down your tasks or keep track of deadlines and appointments? With this free template, you can create a calendar within seconds for the month and year that you want. You can copy multiple tabs and crea ...
If you're creating a dashboard or just want to visualize your data by what part of the world it's coming from, a map chart can be a great way to accomplish that. Below, I'll show how you can use a map chart to show data points at regional and global ...
Is your spreadsheet running slow or constantly freezing and crashing on you? There are many ways you can make it quicker and more efficient. Below, I'll cover seven different ways you can fix some of the more common reasons your file may not running ...
Whether you're going on a road trip soon or just want to start planning one, this free road trip planner template can help you with that. Not only can you plot up to 10 destinations, you can factor in breaks, select either a desired start or end tim ...
When you have created formulas in Excel, you may want to extend and increment them down to other cells. In many cases, you can just drag down a cell that contains the formula and pull it down so that it automatically gets copied. However, there's a ...
Merged cells are great for presentation purposes but not so ideal when you're creating a model or a complex spreadsheet. It can make copying cells or formulas painful as you can get an error or unintended results when doing so. However, there's a wa ...
