DEV Community

Andrews profile picture

Andrews

Founder of Geek Excel!! Blog for Excel Tutorials

Location Denmark Joined Joined on  Personal website https://geekexcel.com twitter website

Work

CER at Organisee Network

Four Year Club
Writing Debut
Three Year Club
Two Year Club
One Year Club
16 Week Writing Streak
8 Week Writing Streak
4 Week Writing Streak
How to Use Excel MONTH Function?

How to Use Excel MONTH Function?

Comments
4 min read

Want to connect with Andrews?

Create an account to connect with Andrews. You can also sign in below to proceed if you already have an account.

Already have an account? Sign in
Excel Formulas to Calculate Percentile IF in Excel table!!

Excel Formulas to Calculate Percentile IF in Excel table!!

1
Comments
3 min read
How to Change Text Case in Excel?

How to Change Text Case in Excel?

Comments
3 min read
How to Add Running Totals in Microsoft Excel

How to Add Running Totals in Microsoft Excel

Comments
3 min read
How to Convert Excel Files to PDF in Microsoft Excel?

How to Convert Excel Files to PDF in Microsoft Excel?

1
Comments
3 min read
How to Add Leading Zeros in Excel?

How to Add Leading Zeros in Excel?

1
Comments
4 min read
Concatenate Data with a LINE BREAK in Excel [ 5 Steps ]

Concatenate Data with a LINE BREAK in Excel [ 5 Steps ]

Comments
3 min read
Remove Unwanted Space Characters in Excel!

Remove Unwanted Space Characters in Excel!

Comments
3 min read
FLASH FILL Options in Microsoft Excel 365!

FLASH FILL Options in Microsoft Excel 365!

Comments
6 min read
Get the Weekday Name From A Date in Excel!

Get the Weekday Name From A Date in Excel!

Comments
3 min read
EXCEL TABLES- A Walk Through of using Tables in Excel!

EXCEL TABLES- A Walk Through of using Tables in Excel!

Comments
3 min read
How to Use Formula Bar for Various Purposes in Excel

How to Use Formula Bar for Various Purposes in Excel

Comments
3 min read
Worksheet Area in Excel- A Detailed Guide in MS Excel!

Worksheet Area in Excel- A Detailed Guide in MS Excel!

Comments
2 min read
Status Bar Options in Excel- Customize and Use Status Bar in Excel!

Status Bar Options in Excel- Customize and Use Status Bar in Excel!

Comments
2 min read
Simple Shortcuts for Other Options in MS Excel!

Simple Shortcuts for Other Options in MS Excel!

Comments
2 min read
Shortcuts for Dialog Box Options in MS Excel!

Shortcuts for Dialog Box Options in MS Excel!

Comments
2 min read
Simple Shortcut to Insert Columns in MS Excel 365!!!

Simple Shortcut to Insert Columns in MS Excel 365!!!

Comments
24 min read
Options in Quick Access Toolbar in Microsoft Excel!

Options in Quick Access Toolbar in Microsoft Excel!

Comments
2 min read
Excel Formulas to Calculate Two-way summary with SUMIFS!!

Excel Formulas to Calculate Two-way summary with SUMIFS!!

Comments
2 min read
Excel Formulas to calculate Basic array formula in excel!!

Excel Formulas to calculate Basic array formula in excel!!

Comments
3 min read
How to Vlookup Values from Bottom to Top in Excel 365?

How to Vlookup Values from Bottom to Top in Excel 365?

Comments
2 min read
How to Replace #N/A or Zero in Vlookup with Blank or Specified Text in Excel?

How to Replace #N/A or Zero in Vlookup with Blank or Specified Text in Excel?

Comments
2 min read
Excel Formulas to Calculate a ratio from two numbers in Excel!!

Excel Formulas to Calculate a ratio from two numbers in Excel!!

Comments
3 min read
Excel Formulas to Calculate win-loss tie totals in Excel 365!!

Excel Formulas to Calculate win-loss tie totals in Excel 365!!

Comments
2 min read
Excel Formulas to find Cap percentage at 100 in excel!!

Excel Formulas to find Cap percentage at 100 in excel!!

Comments
2 min read
Excel Formulas to Convert column letter to number in excel!!

Excel Formulas to Convert column letter to number in excel!!

Comments
3 min read
Excel Formulas to Check register balance in Excel 365!!

Excel Formulas to Check register balance in Excel 365!!

Comments
2 min read
Excel Formulas to find Cap percentage at a specific amount!!

Excel Formulas to find Cap percentage at a specific amount!!

Comments
2 min read
Excel Formula to Convert expense time units in Excel!!

Excel Formula to Convert expense time units in Excel!!

Comments
3 min read
Excel Formulas to use Conditional median with criteria in Excel!!

Excel Formulas to use Conditional median with criteria in Excel!!

Comments
3 min read
Excel Formula to use Conditional mode with criteria in Excel!!

Excel Formula to use Conditional mode with criteria in Excel!!

Comments
2 min read
Excel Formulas to find Coefficient of variation in Excel!!

Excel Formulas to find Coefficient of variation in Excel!!

Comments
3 min read
Excel Formula to Change negative numbers to positive Numbers!!

Excel Formula to Change negative numbers to positive Numbers!!

1
Comments
2 min read
Excel Formulas to convert Celsius to Fahrenheit in Excel!!

Excel Formulas to convert Celsius to Fahrenheit in Excel!!

1
Comments
2 min read
Excel Formulas To use Cash denomination calculator in Excel!!

Excel Formulas To use Cash denomination calculator in Excel!!

1
Comments
3 min read
Excel Formulas to Use Carry-on baggage Inches to centimeters!!

Excel Formulas to Use Carry-on baggage Inches to centimeters!!

1
Comments
3 min read
Excel Formulas for BMI calculation in Excel Office 365!!

Excel Formulas for BMI calculation in Excel Office 365!!

Comments
2 min read
Excel Formulas To Build hyperlink with VLOOKUP in Excel!!

Excel Formulas To Build hyperlink with VLOOKUP in Excel!!

Comments
3 min read
Excel Formula to use Basic outline numbering in Excel!!

Excel Formula to use Basic outline numbering in Excel!!

Comments
3 min read
Excel Formulas for Basic text sort formula in Excel!!

Excel Formulas for Basic text sort formula in Excel!!

Comments
2 min read
Excel Formulas to use Basic numeric sort formula in Excel!!

Excel Formulas to use Basic numeric sort formula in Excel!!

Comments
3 min read
Excel Formulas to Find Basic in cell histogram in Excel!!

Excel Formulas to Find Basic in cell histogram in Excel!!

Comments
2 min read
Excel Formulas for Basic error trapping in Excel Office 365!!

Excel Formulas for Basic error trapping in Excel Office 365!!

Comments
2 min read
Excel Formulas to use Basic attendance tracking formula in Excel!!

Excel Formulas to use Basic attendance tracking formula in Excel!!

1
Comments
3 min read
Excel Formulas to Calculate All dates in chronological order!!

Excel Formulas to Calculate All dates in chronological order!!

1
Comments
2 min read
Excel Formulas to Abbreviate state names in Excel 365!!

Excel Formulas to Abbreviate state names in Excel 365!!

Comments
2 min read
How to fix the #CALC! Error In Excel Office 365? – [With Example]

How to fix the #CALC! Error In Excel Office 365? – [With Example]

1
Comments
2 min read
How to fix a circular reference error In Excel Office 365? – [With Example]

How to fix a circular reference error In Excel Office 365? – [With Example]

1
Comments
2 min read
Excel Formulas to calculate SUMIFS with Excel Table!!

Excel Formulas to calculate SUMIFS with Excel Table!!

1
Comments
3 min read
Excel Formulas to Sum multiple tables in Excel office 365!!

Excel Formulas to Sum multiple tables in Excel office 365!!

Comments
3 min read
Excel Formulas To Calculate Running total in Excel Table!!

Excel Formulas To Calculate Running total in Excel Table!!

Comments
3 min read
Excel formulas to calculate running count in Table!!

Excel formulas to calculate running count in Table!!

Comments
3 min read
Excel Formulas to Get column name from index in table!!

Excel Formulas to Get column name from index in table!!

Comments
3 min read
Excel Formulas to Get column index in Excel Table ~ Quickly!!

Excel Formulas to Get column index in Excel Table ~ Quickly!!

Comments
3 min read
Excel Formulas to get Dynamic reference Table name!!

Excel Formulas to get Dynamic reference Table name!!

Comments
3 min read
Excel Formulas to use COUNTIFS with variable table column!!

Excel Formulas to use COUNTIFS with variable table column!!

Comments
4 min read
Excel Formulas to Count table columns in Excel 365!!

Excel Formulas to Count table columns in Excel 365!!

Comments
2 min read
Excel Formulas to use Basic inventory formula- Quickly!!

Excel Formulas to use Basic inventory formula- Quickly!!

1
Comments
3 min read
Excel Formulas to find Average last N values in a table in Excel!!

Excel Formulas to find Average last N values in a table in Excel!!

1
Comments
3 min read
Excel Formulas to calculate Total rows in range in Excel Office 365!!

Excel Formulas to calculate Total rows in range in Excel Office 365!!

1
Comments
2 min read
loading...