Category: MS Office

Excel 2016 – Using an IF statement to test a cell

In this video I show you how to use a logical function, namely and IF statement to test the value of a cell.

Posted on October 22nd, 2016, by NazContinue Reading →

Excel 2016 – Extract text string using LEFT, MID, RIGHT and FIND

In this video I show you how to extract specific text strings from within a cell using the Excel functions Left, Mid, Right, and Find.

Posted on October 22nd, 2016, by NazContinue Reading →

Excel 2016 – How to count a range based on multiple criteria using COUNTIFS

In this video I show you how you can count a range of cells based on multiple criteria using the COUNTIFS function in Excel.

Posted on October 22nd, 2016, by NazContinue Reading →

Excel 2016 – How to sum a range based on multiple criteria using SUMIFS

In this video I show you how to sum a range based on multiple criteria using a function called SUMIFS.

Posted on October 22nd, 2016, by NazContinue Reading →

Excel 2016 – Using HLOOKUP to lookup information

In this video I show you how to use the HLOOKUP function to return information based on the value of a cell in a row.

Posted on October 21st, 2016, by NazContinue Reading →

Excel 2016 – Using VLOOKUP to lookup information

In this video I show you how to lookup information in a column based on the value of a cell in a column using the VLOOKUP function.

Posted on October 21st, 2016, by NazContinue Reading →

Excel 2016 – Using SUMIF and COUNTIF to sum and count based on criteria

In this video I show you how to use the SUMIF function to sum a range based on a criteria and how to use the COUNTIF function to count a range based on criteria.

Posted on October 21st, 2016, by NazContinue Reading →

Excel 2016 – Text Functions, Counta, TextJoin, Upper, Len, Left

In this video I introduce you to some text functions in Excel, including Counta, TextJoin, Upper, Len, and Left.

Posted on October 20th, 2016, by NazContinue Reading →

Excel 2016 – Formulas and functions

In this video I introduce you to formulas and functions in Excel, I also show you the difference between relative and absolute cell references, how to use named ranges and the format painter.

Posted on October 20th, 2016, by NazContinue Reading →

Excel 2016 – Printing Your Worksheet Tutorial

In this video I show you the basic of how to print your worksheet in Excel 2016.

Posted on October 19th, 2016, by NazContinue Reading →