Excel Tutorials/Discussions — DataMighty

Learning is not attained

by chance, it must be

sought for with ardor and diligence

Reasons why SUMPRODUCT is better than SumIFs/CountIFs

Reasons why SUMPRODUCT is better than SumIFs/CountIFs

SUMPRODUCT is simply one of the most versatile formulas in Excel.

Mario SalazarMay 13, 2020DataMighty, Excel, Data, learn, motivation, analyst, leadership, leader, development, leader development, sumproduct, sumif, countif, countifs, sumifs, sum product, better, superior, which

Five (5) Reasons why you Should Always Convert Data to a Table

Five (5) Reasons why you Should Always Convert Data to a Table

Data within tables are more versatile, reliable, and all around more efficient.

Mario SalazarMay 12, 2020DataMighty, Excel, Data, learn, motivation, analyst, leadership, leader, development, leader development, table, convert, insert

Five (5) Excel Interview Mistakes

Five (5) Excel Interview Mistakes

You can never be perfect, but you can surely be prepared.

Mario SalazarMay 3, 2020DataMighty, Excel, Data, learn, motivation, analyst, leadership, leader, development, leader development, interview, prepare, mistakes

Three (3) Reasons why INDEX/Match is better than VLOOKUP

Three (3) Reasons why INDEX/Match is better than VLOOKUP

Both are useful formulas, but one is simply the better choice.

Mario SalazarMay 2, 2020DataMighty, Excel, Data, learn, motivation, analyst, leadership, leader, development, leader development, vlookup, index, match, index/match, superior, better, which

VLOOKUP Tutorial

VLOOKUP Tutorial

VLOOKUP is used to transfer data between to data-sets that have a common identifier.

Vlookup & INDEX/MatchMario SalazarApril 30, 2020vlookup, index/match, excel, tutorial, data, datamighty

SUMIF and COUNTIF Tutorial

SUMIF and COUNTIF Tutorial

SUMIF and COUNTIF formulas are simple but effective formulas to aggregate specific data into a single cell.

SUMPRODUCT & SUMIFCOUNTIFMario SalazarApril 29, 2020Unique, DIstinct, Excel, Remove, Duplicates, Duplicate, MIcrosoft, data, mighty, datamighty

Extract First and Last Name Tutorial

Extract First and Last Name Tutorial

You can easily apply this formula to quickly separate a Full Name into First & Last Name.

Mario SalazarApril 29, 2020DataMighty, Excel, Data, learn, motivation, analyst, leadership, leader, development, leader development, first, name, first name, last, last name, seperate, extract

SUMPRODUCT Tutorial

SUMPRODUCT Tutorial

SUMPRODUCT can be used in many different ways, making it one of the most versatile formulas in Excel.

SUMPRODUCT & SUMIFCOUNTIFMario SalazarApril 26, 2020DataMighty, Excel, Data, learn, motivation, analyst, leadership, leader, development, leader development, sumproduct, sum, product, countif, count, if, sumif

INDEX/MATCH Tutorial

INDEX/MATCH Tutorial

This formula is used as a reliable/efficient lookup function.

Vlookup & INDEX/MatchMario SalazarJuly 29, 2019vlookup, index/match, excel, tutorial, data, datamighty

IF Tutorial

IF Tutorial

The formula allows the user to test a specified scenario.

Mario SalazarJuly 25, 2019vlookup, index/match, excel, tutorial, data, datamighty

Search for a Word within a Cell

Search for a Word within a Cell

Used to identify whether or not a specific word is contained within a cell.

Mario SalazarJuly 24, 2019vlookup, index/match, excel, tutorial, data, datamighty

Unique/Distinct Values

Unique/Distinct Values

To get the unique/distinct values in a specific columns you have two options.

Mario SalazarNovember 1, 2015Unique, DIstinct, Excel, Remove, Duplicates, Duplicate, MIcrosoft, data, mighty, datamighty