top of page
Search
Kyle Pew
- Sep 14, 2022
- 1 min
Using Excel Functions to return Multiple Values
Nesting Functions like Index, Small, IF, Row & Column when using Excel 2016 and Older. Also Nesting Functions like Textjoin & IF when...
1,454 views0 comments
Kyle Pew
- Aug 19, 2022
- 1 min
Working with Macros inside of Microsoft Word
In Word, you can automate frequently used tasks by creating and running macros. A macro is a series of commands and instructions that you...
438 views0 comments
Kyle Pew
- Jul 29, 2022
- 1 min
Part 2 - Create an Interactive Crossword Puzzle with Microsoft Excel
In Part 2 of creating an Excel Crossword Puzzle we use Excel Functions, Conditional Formatting and little bit of VBA In this video I will...
359 views0 comments
Kyle Pew
- Jul 21, 2022
- 1 min
SUM Excel Range with Conditions
Use SUMIF, SUMIFS or SUMPRODUCT to SUM a range of cells Conditionally =SUMIF(range, criteria, [sum_range]) The SUMIF function syntax has...
874 views0 comments
bottom of page