cropped-h2e100x100.png

HowtoExcel.net

Analytics. Automation. Process Improvement.

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

Home

All posts by : howtoexcel

VBAfolderpath

Use VBA Code So a User Can Select a File or Folder Path

January 31, 2023
by howtoexcel

If you need to reference other files or folders within an Excel sheet, trying to predict what the path will be can be challenging. The easier option is to just have the user select the file or folder from their computer, and then have the path get pasted ...

Read More
Alphabet's historical stock price.

Use MAXIFS and MINIFS to Find Values Within a Range

January 24, 2023
by howtoexcel

Whether you're using VLOOKUP or XLOOKUP, one limitation you're going to face with those functions is that you can't search within a range or use multiple criteria in your lookups. For example, suppose you're looking at a stock's history and wanted to kno ...

Read More
PE Multiples

How to Calculate Trailing P/E and Forward P/E Multiples in Excel

January 17, 2023
by howtoexcel

If you're looking to buy stocks, a one of the more common ratios you'll likely consider in your analysis is the price-to-earnings, or P/E multiple. You can look at either the trailing P/E or the forward P/E. Below, I'll look at what the difference betwee ...

Read More
ElapsedTime

How to Show Elapsed Time in Excel

January 10, 2023
by howtoexcel

Do you need to calculate the time that that has elapsed between two date values in Excel? In this post, I'll show you how you can show the difference in hours, minutes, and seconds. This can be useful if you need to determine hours on a work shift or jus ...

Read More
CalculatedFieldsImage

How to Add Calculated Fields to a Pivot Table

January 6, 2023
by howtoexcel

Pivot tables do a good job of summarizing your data and showing you the totals based on various splits and categories. In some cases, however, you may want to add calculated fields to your pivot table if it doesn't go far enough in analyzing your data. B ...

Read More
H2ESubtotals

When to Use Subtotals In Excel

December 27, 2022
by howtoexcel

Doing a simple summation in Excel is as easy as clicking on the AutoSum button or just using the SUM function. But in some cases, you don't want to be summing up everything within a range. In those situations, you may want to use the SUBTOTAL function in ...

Read More
World cup attendance figures between 1930 and 2018.

Use Drop-Down Lists With Charts in Excel to Make Them Dynamic

December 20, 2022
by howtoexcel

A drop-down list is a way you can control a user's input in Excel, to ensure that they don't make a mistake when entering in data. It can also serve as a helpful way to make your chart more dynamic. In this post, I'll show you how that's possible. ht ...

Read More
EconomicDashboard

Create a Dashboard in Excel to Track Economic Indicators

December 13, 2022
by howtoexcel

Creating a dashboard can be an effective and efficient way to pool in many data points. In this post, I'll show you how to create a dashboard that factors in several economic indicators, including inflation, interest rates, housing starts, GDP, unemploym ...

Read More
DuplicateValuesGoogleSheets

How to Find Duplicates and Unique Values in Google Sheets

December 6, 2022
by howtoexcel

Duplicate and unique values can be difficult to find in a large data set. In this post, I'll show you how you can find and highlight duplicate values, as well as how to extract unique values, in Google Sheets. In this example, I'm going to use a list tha ...

Read More
H2EKPIs

How to Create and Track KPIs in Excel Using Donut Charts

November 29, 2022
by howtoexcel

A key performance indicator (KPI) is a way to track how well you're progressing towards a particular goal. Oftentimes, you might have many KPIs that you will want to track. You can create these visuals in Excel using donut charts, and below, I'll show yo ...

Read More
LOAD MORE
LOADING

Recent Posts

VBAfolderpath

Use VBA Code So a User Can Select a File...

January 31, 2023

If you need to reference other files or folders within an E ...

Use MAXIFS and MINIFS to Find Values Wit...

January 24, 2023

Whether you're using VLOOKUP or XLOOKUP, one limitation you ...

PE Multiples

How to Calculate Trailing P/E and Forwar...

January 17, 2023

If you're looking to buy stocks, a one of the more common r ...

ElapsedTime

How to Show Elapsed Time in Excel

January 10, 2023

Do you need to calculate the time that that has elapsed bet ...

CalculatedFieldsImage

How to Add Calculated Fields to a Pivot ...

January 6, 2023

Pivot tables do a good job of summarizing your data and sho ...

Popular Posts

  • Popular
  • Recent
  • Comment
  • How to Setup Conditional Formatting (inc...

    June 7, 2017

    Conditional formatting is useful for highlighting cells or r ...

    prepaid expenses template excel spreadsheet

    Prepaid Expenses Template

    March 31, 2016

    If you’ve got several prepaid expenses to track then this te ...

    How to Do Date Calculations in Excel (an...

    February 19, 2017

    In this post, I am going to cover some commonly used date f ...

    Bank Reconciliation Template: Automate a...

    March 22, 2017

      PLEASE NOTE THERE IS A NEWER VERSION OF THIS TEMPLATE AVAI ...

    Using Slicers in Pivot Tables

    August 8, 2017

    I am going to use the same pivot table that I left off with ...

  • VBAfolderpath

    Use VBA Code So a User Can Select a File...

    January 31, 2023

    If you need to reference other files or folders within an E ...

    Use MAXIFS and MINIFS to Find Values Wit...

    January 24, 2023

    Whether you're using VLOOKUP or XLOOKUP, one limitation you ...

    PE Multiples

    How to Calculate Trailing P/E and Forwar...

    January 17, 2023

    If you're looking to buy stocks, a one of the more common r ...

    ElapsedTime

    How to Show Elapsed Time in Excel

    January 10, 2023

    Do you need to calculate the time that that has elapsed bet ...

    CalculatedFieldsImage

    How to Add Calculated Fields to a Pivot ...

    January 6, 2023

    Pivot tables do a good job of summarizing your data and sho ...

  • How to Setup Conditional Formatting (inc...

    June 7, 2017

    Conditional formatting is useful for highlighting cells or r ...

    prepaid expenses template excel spreadsheet

    Prepaid Expenses Template

    March 31, 2016

    If you’ve got several prepaid expenses to track then this te ...

    How to Do Date Calculations in Excel (an...

    February 19, 2017

    In this post, I am going to cover some commonly used date f ...

    Bank Reconciliation Template: Automate a...

    March 22, 2017

      PLEASE NOTE THERE IS A NEWER VERSION OF THIS TEMPLATE AVAI ...

    Using Slicers in Pivot Tables

    August 8, 2017

    I am going to use the same pivot table that I left off with ...

cropped-h2e100x100.png

HowtoExcel.net

Analytics. Automation. Process Improvement.

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

Shopping Basket
HowtoExcel.net

HowtoExcel.net

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