Skip to content
  • Home
  • About Us
  • Tutorials
  • Contact Us
Excel VBA Instr Function

An Explanation on Excel VBA Instr Function

Excel Paste Special Shortcut

Excel Paste Special Shortcut

Show Formulas in Excel Instead of the Values

Show Formulas in Excel Instead of the Values

Options and Precautions to Recover Unsaved Excel Files

Options and Precautions to Recover Unsaved Excel Files

Remove Extra Spaces

Remove Extra Spaces in Excel (Leading, Trailing, or Double Spaces)

Formatting & Highlighting Blank Cells

Formatting & Highlighting Blank Cells (Conditional)

Excel AUTOFIT

Excel AUTOFIT: Make Rows/Columns Fit the Text Automatically

Excel Concatenate Strings

Excel Concatenate Strings – Combine Rows, Cells, Columns & Strings!

Vlookup to Compare Two Columns

Vlookup to Compare Two Columns – Show Differences in 3rd Column & More

Freeze Panes Excel

Freeze Panes Excel – Lock Row or Column Headers

SUMIFS Date Range

SUMIFS Date Range: The Sum Between Multiple Dates

How to Insert a Check Mark

Guide on How to Insert a Check Mark (Tick ✓) Symbol in Excel

Unmerge Cells excel

Easy Ways You Can Unmerge Cells in Excel

How to Unhide Sheets in Excel (Single or All Sheets)

Standard Deviation Excel

Standard Deviation Excel – How to Calculate Using Excel

IfError VLookUp

IfError VLookUp

Excel DATEDIF Function

Excel DATEDIF Function

xlookup

The Function of XLookUp

The Sum of Two

The Sum of Two

Excel Strikethrough Shortcut

Excel Strikethrough Shortcut

Unhide Columns, Rows & Cells in Excel

Unhide Columns, Rows & Cells in Excel

Multiple Criteria in Excel Functions COUNTIF and COUNTIFS

How to Use Multiple Criteria in Excel Functions COUNTIF and COUNTIFS

calculate cagr

How to Calculate CAGR in Excel

Multiple Criteria for VLOOKUP

Multiple Criteria for VLOOKUP

Excel Function AVERAGEIF

Excel Function AVERAGEIF – Ways You Can Use the

excel gridlines

Excel Gridlines: Ways You Can Have Gridlines Added, Changed, Removed, and Printed Out

Change, Remove, Print, and Add Gridlines in Excel

How you can Change, Remove, Print, and Add Gridlines in Excel

Automatically Allow Columns and Rows to Fit the Text with Excel Autofit

Creating a Population Pyramid Style Chart

Creating a Population Pyramid Style Chart

Interest Functions in Excel

Interest Functions in Excel

Post navigation
Older posts
Page1 Page2 … Page12 Next →

Testimonials from Our Readers

I refer to this site for formulas and functions that we use every couple months to close out a quarter. With so much going on, I just cant keep up with all the functions and formulas that I need, so I refer back to ExcelMaster when I need something. Thanks Team!

Jean Harper

CPA & BookKeeper

Love this site, we use it in our office every week to get information and solutions about our excel spreadsheets! We use many of the excel dashboards that they've put together, as well as other bookkeeping related functions and sheets.

Denise Elizabeth

Controller

We refer to ExcelMaster quite often when looking to close out a month for our ecommerce store. We use many of the formulas and solutions they have on their site including CAGR and VLOOKUPs for inventory checks.

Nancy Temple

Bookkeeper

2022 Excel Master | Design with Love in Seattle, WA