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

HstackVstack

Use VSTACK and HSTACK in Excel and Google Sheets to Consolidate Lists

June 6, 2023
by howtoexcel functionsstocks

Do you have multiple lists in Excel or Google Sheets that you want to combine together? With new functions such as VSTACK and HSTACK, you can do just that. In this post, I'll show you how you can also filter out duplicates and apply sorting so that ...

Read More
FuzzyLookup

How to Do a Fuzzy Lookup in Power Query

May 30, 2023
by howtoexcel lookuplookupspower query

Power Query is a powerful data transformation tool in Excel that allows you to effortlessly connect to various data sources, cleanse and manipulate data, and unlock advanced functionalities such as fuzzy matching. By leveraging the inherent "Fuzzy L ...

Read More
RSI

How to Calculate RSI in Excel

May 16, 2023
by howtoexcel financial analysisinvestingstocks

What is RSI? The Relative Strength Index (RSI) is a popular trading indcator that investors use for trading purposes. In this article, I'll go over details as to what RSI is, why it's useful, and how to calculate it in Excel. RSI is a bounded ...

Read More
CountWords

How to Count Words in Excel

May 2, 2023
by howtoexcel countfunctionslen

Excel has many different functions that can help you parse out text from cells. This includes the LEN, MID, LEFT, and RIGHT functions. By utilizing these and other functions, you can get just the values you want. And by determining the number of bla ...

Read More
NPVIRR

How to Calculate Net Present Value (NPV) and Internal Rate of Return (IRR) in Excel

April 26, 2023
by howtoexcel accountingfinancial analysis

What is Net Present Value (NPV)? Net Present Value (NPV) is a financial metric used to determine the current value of a series of cash inflows and outflows. It takes into account the time value of money, which means that a dollar received in the ...

Read More
GmailtoSheets

How to Get Emails Into Google Sheets

April 4, 2023
by howtoexcel appscriptgoogle sheets

Did you know that you can pull in emails from your Gmail account into Google Sheets? This can be useful if you don't want to open up Gmail and do a search; you can do it right within Google Sheets. You can extract the body, subject, and other attrib ...

Read More
15ExcelAccounting

15 Excel Functions Accountants Should Know

March 28, 2023
by howtoexcel accountingadvancedaverage

If you're an accountant, you know that working with large amounts of data can be a daunting task. But with Excel, that work can get a whole lot easier and more efficient. Understanding Excel's advanced features and functions can improve productivity ...

Read More
ConvertDMY

How to Convert Date Formats in Excel

March 21, 2023
by howtoexcel dates

If you've ever downloaded data and received dates in the wrong format, it can be a challenge to fix. If your regional settings are month/day/year but in a spreadsheet they are in day/month/year format, then odds are they will be reading in a text fo ...

Read More
BollingerBands

How to Create and Chart Bollinger Bands in Google Sheets and Excel

March 15, 2023
by howtoexcel investingstocks

What are Bollinger Bands? Bollinger Bands are used in technical analysis to help calculate and measure volatility. There are three bands that are included in chart: a moving average, and a lower and upper band. Normally, the upper and lower band ...

Read More
FlipData

Flip Your Data in Excel Without Sorting

March 9, 2023
by howtoexcel functionsindex

Want to show your data in reverse order, and want to do so without having to sort it? Using just a formula, you can change the way your data looks. Instead of going from oldest to newest, you can display it from newest to oldest. And you don't have ...

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