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

postspeeding

Excel Analysis: How Much Time Does Speeding Save?

March 24, 2021
by howtoexcel analysis

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 ...

Read More
0
H2EPostImagstockprices1

How to Get Stock Quotes From Yahoo Finance Using Power Query

March 18, 2021
by howtoexcel intermediateinvestingpower query

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 ...

Read More
0

Average Down Calculator 2.0

March 15, 2021
by howtoexcel investingstocks

Amount Invested Shares Owned Today Current Price Desired Average Price Your Average Price Price Movement ...

Read More
0
Convert1

How to Convert Numbers From Billions to Millions to Thousands in Excel

March 11, 2021
by howtoexcel beginnerformattingfunctions

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 ...

Read More
0
CorporateBingo

Play Corporate Bingo

March 4, 2021
by howtoexcel businesstemplate

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 ...

Read More
0
calendar1

Excel Calendar Template

February 24, 2021
by howtoexcel calendartemplate

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 ...

Read More
0
H2EMapChart-min

How to Make a Map Chart in Excel

February 20, 2021
by howtoexcel chartsintermediateslicers

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 ...

Read More
0
H2ESlowSpreadsheet-min

7 Ways to Fix a Slow Spreadsheet

February 13, 2021
by howtoexcel indirectintermediatepower query

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 ...

Read More
0
roadtrip1

Road Trip Planner Template

February 7, 2021
by howtoexcel template

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 ...

Read More
0
H2EIncrement-min

How to Extend and Increment Formulas

January 31, 2021
by howtoexcel functionsintermediatetips & tricks

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 ...

Read More
0
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