2018-09-10 05:56
This add-in is completely free and includes over 20 macros that I have worked on myself and that I hope will help you. Any feedback is welcome, as well as any suggestions for other macros yo… Read More
Blog Directory > Software Blogs > Programming Blogs > HowtoExcel programming Blog >
Howtoexcel Blog
howtoexcel.net
Tips, tutorials and templates for Microsoft Excel to help improve your productivity.
2018-07-28 15:53
A stacked chart in Excel allows users to take advantage of the best of both worlds: a column chart that shows period-over-period totals and a pie chart that can show what made up those total… Read More
2018-07-21 18:34
Often times in a data set you'll have to handle with errors that can wreck your data, especially if you need to do any analysis on it. There are several ways that you can handle errors so th… Read More
2018-07-01 05:34
If you're looking up data, often times just using a VLOOKUP function can be enough to get you your desired result. Sometimes, however, it doesn't do enough, especially if you're looking for… Read More
2018-06-14 13:27
Retrieving the maximum and minimum values is done relatively easily in Excel using the MIN() and MAX() functions, but what if you wanted to extract the five largest or smallest values?Two le… Read More
2018-05-28 05:52
If you've got a big Excel file (e.g. more than 10 mb) and you don't have tens of thousands of rows, you may want to see what you can do about bringing that size down. If you have lots of dat… Read More
2018-05-04 14:20
One of the challenges sometimes with sending your spreadsheet to someone, whether it's to review or to make changes to it, is that it contains sensitive information.So I've created a templat… Read More
2018-04-29 02:20
There are a lot of ways you can speed up data entry and analysis in Excel, and while most people know about copying and pasting and how to undo actions, there are some useful ones that many… Read More
2018-04-22 22:42
In my previous post I went over advanced filters in Excel. This time around I'll go over how to achieve the same result using just a formula. No macros, no VBA, just through a not-so-simple… Read More
2018-03-10 09:31
There are many ways you can filter data in Excel, and in this post I'll cover the Advanced Filter.Using the Advanced Filter will allow you to set a criteria in place for your filter and then… Read More
2018-02-28 08:37
With the stocks markets tanking earlier this month, I thought it'd be interesting to track their historical performance and put into perspective just how badly things have been going lately… Read More
2018-01-27 22:59
Do you want to create a dashboard that will update all of your charts simultaneously based on what filters your users select? Follow the steps below and you can create a professional-looking… Read More
2017-12-19 07:37
Excel has a lot of different charts that you can use to summarize your data with. If you want to use your chart in PowerPoint or Word it's an easy copy and paste job, but suppose you wanted… Read More
2017-09-09 04:32
When you're creating a template in Excel for other users often times there is information in the backend that you'd prefer users not be able to access or modify. In some cases it might be pr… Read More
2017-08-08 15:07
I am going to use the same pivot table that I left off with in my last post and now I am going to add slicers to show you how they can make your life easier.***Please note slicers are a… Read More
2017-08-08 05:58
Pivot tables in Excel allow you to easily summarize data and group information by category. The benefits of pivot tables is you can also double click on any number to see the individual item… Read More
2017-07-15 03:24
One of the advantages of using Google Sheets over Excel is that it is easier to access live, dynamic data that you can access from any device that can install the app.Pulling Stock QuotesA g… Read More
2017-07-05 07:48
Excel makes it easy to convert a data set into a chart. The problem is that often the default chart settings aren't the greatest. Below I have some sample data that I will convert into a cha… Read More
2017-06-28 17:22
In a previous post I have gone over how to use LEFT and MID functions for parsing data, but in this post I'll go through a specific example from start to finish.I am going to pull my data fr… Read More
2017-06-25 03:38
There are a few ways to determine correlations between data. The first way I'll go over is using the Data Analysis add-in, the second being by formula.Using the Data Analysis Add-InTo enable… Read More
2017-06-14 16:47
Download TemplateThis template allows you to monitor and forecast out cash flows for a specified number of days. The current date defaults to today's date but you can override it manually bu… Read More
2017-06-07 19:44
Conditional formatting is useful for highlighting cells or ranges if a condition is true. For example: highlighting negative values as red or positive ones as green. You can also do more com… Read More
2017-05-31 06:47
Download templateThis mortgage calculator will allow you to accomplish three different things:1) Determine the housing price based on a desired monthly payment, interest rate, and terms.2) D… Read More
2017-05-28 15:00
In a previous post I covered my amortization/depreciation template.Here I will cover how to do present value and future value calculations that are used in that template. I will start with a… Read More
2017-05-20 16:01
I have saved this sample file here if you would like to look at the data set and have a closer look at how the formulas work.In this post I will cover some simple summation formulas and when… Read More
2017-05-14 13:33
Download TemplateThis template allows you to track multiple amortization / depreciation schedules and summarize them all in one tab. Above is a completed schedule with the inputs (highlighte… Read More
Subscribe to Howtoexcel
Get updates delivered right to your inbox!