Microsoft Excel's IF function to lookup values with multiple criteria. DOWNLOADABLE RESOURCES

Take control of your Debt with The Snowball Debt Strategy! The term "snowball debt" typically refers to a debt repayment strategy aimed...

CLICK FOR MICROSOFT LINK DOWNLOADABLE RESOURCES

The TOCOL Function takes an array of data and turns it into a Column of data. You can also nest the TOCOL function with other functions...

Watch as we attempt to answer the question of "Would you rather have $1,000,000 upfront or would you take a penny that doubled every day...

How to Add-In the Mini Calendar option into Excel. Use it to quickly select a date to insert into a cell. Also, a little VBA code to have...

Summing large set of data with the help of just 2 Keys! Creating a Chart with 1 Function key! Making a Table with the help of just 2...

Check out this super quick Microsoft Excel tip. Use the ALT + = shortcut key to perform an AutoSum for all your data.

Having a hard time finding the correct Formula to use in Excel? Ask ChatGPT ChatGPT is an artificial intelligence chatbot ChatGPT is a...

The IMAGE function inserts images into cells from a source location along with alternative text. You can then move and resize cells, sort...

Learn How to use Excel Functions in Google Sheets! We understand that Excel and Google Sheets are very similar, and Google Sheets has a...

Flash Fill automatically fills your data when it senses a pattern. For example, you can use Flash Fill to Combine first and last names...

Grouping data in a PivotTable can help you show a subset of data to analyze. For example, you may want to group an unwieldy list of...

Use the REPT function to show any type of Rating based on a percentage The REPT function in Excel helps users repeat a text string,...

Check out the Top 5 most watched YouTube Video's Created by Kyle Pew (OfficeNewB) Click on each link below to watch the Video! #1 Create...

Using Page Breaks and Section Breaks to manage and maintain large documents Use page breaks to control where a page ends and where a new...

Nesting Functions like Index, Small, IF, Row & Column when using Excel 2016 and Older. Also Nesting Functions like Textjoin & IF when...

In Word, you can automate frequently used tasks by creating and running macros. A macro is a series of commands and instructions that you...

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...

Use SUMIF, SUMIFS or SUMPRODUCT to SUM a range of cells Conditionally =SUMIF(range, criteria, [sum_range]) The SUMIF function syntax has...