HowtoExcel.net
cropped-h2e100x100.png

HowtoExcel.net

Analytics. Automation. Process Improvement.

  • Home
  • Blog
  • Templates
  • Tools & Calculators
    • Average Down Calculator
    • Compounded Annual Growth Rate Calculator
    • Inflation Calculator
    • Investment Growth Calculator
    • Live T-Account Template
    • Minimum Payment Calculator
    • Money Spent Calculator
    • Mortgage Payment Calculator
    • Mortgage Payment Calculator — Interest Rate Sensitivity
    • Mortgage Payment Sensitivity Calculator
    • Price-to-Earnings P/E Calculator
    • Stock Average Calculator
    • Time Spent Calculator
  • Shop
  • Cart
  • Contact Me

nhl2021playoffsmay14

NHL Playoff Tree 2021: Prediction Template

March 25, 2017
by admin predictionstemplate

Standings updated as of May 14. The NHL playoffs are coming soon and so I have set up a template for predictions that you can use. https://youtu.be/r8uURQJZqnw Download Template It is fairly straightforward - you select the team you ex ...

Read More
0
Bank Reconciliation Categories

Bank Reconciliation Template: Automate and Easily Reconcile Transactions

March 22, 2017
by admin bank reconciliationtemplatevba

    PLEASE NOTE THERE IS A NEWER VERSION OF THIS TEMPLATE AVAILABLE HERE A bank reconciliation can be a time-consuming process but this template can help speed it up. By assigning categories and setup quick ways to match items, you can qui ...

Read More
3
RAND Functions

Use Excel’s Random Number Generators to Populate Sample Data

March 16, 2017
by admin indexintermediaterand

Excel has random number generator functions which are useful if you need to test a template or create some sample / dummy data.The RAND function returns a number between 0 and 1. You could multiply this by a factor of 10 or 100 to get a much lar ...

Read More
0
goal seek inputs

How to Use Goal Seek in Excel

March 7, 2017
by admin goalseekintermediatetips & tricks

Excel's what-if-analysis options aren't the greatest, but one option which is very useful and can save time is Goal Seek. What Goal Seek effectively does is it can do trial and error for you in seconds, and be much more precise than doing it manually ...

Read More
0
date difference intervals

Calculating Date Differences Using VBA

February 26, 2017
by admin datesfunctionsvba

In VBA there is a custom DateDiff function that allows you to easily calculate the difference between dates - whether you want the difference to be in days, weeks, months, years, it is easier to accomplish this in VBA than through regular Excel formu ...

Read More
0
Incrementing dates by month using a formula vs autofill.

How to Do Date Calculations in Excel (and Format Them)

February 19, 2017
by admin datesintermediate

In this post, I am going to cover some commonly used date functions and show you how to do some basic date calculations in Excel. Incrementing Dates by Days and Months One of the more common date calculations in Excel is to increment your dat ...

Read More
3
Forecast

Shading Areas on a Chart to Highlight Gaps and Variances

February 5, 2017
by admin chartsintermediatevariances

When comparing forecasted amounts vs actuals one way to help emphasize and highlight variances is by shading those areas. I'll show you how to easily do that in this post. Below is my starting data set I will need to create two extra columns to th ...

Read More
0
horizontal line data

Plotting Vertical and Horizontal Lines in Charts

January 27, 2017
by admin chartsintermediate

When charting something on Excel you sometimes may want to add vertical lines to identify key dates, or horizontal lines for target or benchmark amounts. In this post I'll show you how to do both.Horizontal lines can be used to identify target or ben ...

Read More
0
Cover Letter Menu

Create a Customer Cover Letter with my Form Letter Template

January 11, 2017
by admin lettertemplatevba

  Download TemplateThis template allows you to create a customized letter - be it a cover letter or any other kind of letter from a pre-defined list of sentences and paragraphs that can also utilize variables. In order to accomplish this you will fir ...

Read More
0

How to Freeze Panes

December 17, 2016
by admin beginner

Freezing panes in Excel is useful when you want to still see certain rows or columns as you scroll through a large data set. Without doing so you could easily get lost in your data trying to figure out which header or category the value you are looki ...

Read More
1
LOAD MORE
LOADING
cropped-h2e100x100.png

HowtoExcel.net

Analytics. Automation. Process Improvement.

© 2019 Company. All rights reserved.  Powered by  Phlox Theme

Shopping Basket

HowtoExcel.net

  • Home
  • Blog
  • Templates
  • Tools & Calculators
    • Average Down Calculator
    • Compounded Annual Growth Rate Calculator
    • Inflation Calculator
    • Investment Growth Calculator
    • Live T-Account Template
    • Minimum Payment Calculator
    • Money Spent Calculator
    • Mortgage Payment Calculator
    • Mortgage Payment Calculator — Interest Rate Sensitivity
    • Mortgage Payment Sensitivity Calculator
    • Price-to-Earnings P/E Calculator
    • Stock Average Calculator
    • Time Spent Calculator
  • Shop
  • Cart
  • Contact Me