Все публикации

Forecast Seasonality in EXCEL!

Predict the Impact of Diversity, Equity & Inclusion (DEI) on Income in EXCEL!

Multiple Regression in Excel - Predict Results with Numerical & Non-Numerical Data with 3 Values!

Multiple Regression in Excel Predict Results with Numerical & Non Numerical Data with 2 Values!

MULTIPLE REGRESSION with Excel – How to predict the output based on multiple numerical variables!

How to use Simple Linear Regression for Prediction with Excel!

How to use FIND function with IFERROR, REPLACE, LEFT, RIGHT, MID, LEN, ISNUMBER!

EXTRACT TEXT from cells with LEFT, MID & RIGHT EXCEL Functions!

CHANGE TEXT CASE in EXCEL using UPPER, LOWER, PROPER & FLASH FILL!

How to use the TRIM function in EXCEL for DATA CLEANING!

How to use TEXT TO COLUMNS in EXCEL for DATA CLEANING!

How to convert a TEXT TAB DELIMITED file into EXCEL!

How to convert an EXCEL file into TEXT TAB DELIMITED file!

How to build an Interactive HR Dashboard in Excel!

EXCEL Shortcut Keys with CONTROL A to Z

ROUND FUNCTIONS IN EXCEL (ROUND, ROUNDDOWN, ROUNDUP, MROUND)!

2-WAY LOOKUPS (XLOOKUP vs INDEX & MATCH)!

How to Use XLOOKUP in EXCEL!

XLOOKUP vs VLOOKUP vs HLOOKUP

How to use IFERROR in EXCEL

How to use HLOOKUP in EXCEL!

How to show formulas with FORMULATEXT Function!

What is COMPA RATIO and how do you use it for pay decisions?

How to create a MERIT MATRIX to allocate salary increases!