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

The FILTER function allows you to filter a range of data based on criteria you define. =FILTER(ARRAY,INCLUDE,[IF_EMPTY]) ARRAY = THE...

With just a little bit of cell formatting, a pinch of Excel function magic and Excel conditional formatting, you can create an...

Microsoft is releasing a handful of TEXT based functions that make splitting column values into multiple columns, super easy to do. For...

How can you take a column with duplicate values and extract just the unique values? Follow along as I demonstrate four techniques you can...

Microsoft Excel PivotTables are one of the most popular features of Excel. Take a look at the videos below to find out why PivotTables...

Excel Power Query Microsoft Excel's Power Query feature allows you to append multiple data lists, creating a master list to user within...

Microsoft Excel contains loads of Shortcut keys to help you become more efficient and save time while working with your Excel data. Below...

***** This feature has been introduced to Microsoft Office Beta users and will be made available to the public soon. Microsoft is...

Have you ever needed to sort Excel data in a specific order other than alphabetical, Ascending/Descending? For example, if you have a...

Check out the differences between Microsoft Excel Relative and Absolute Cell references in Excel formulas. DOWNLOAD EXERCISE FILE TO...

QUESTION: “Is it possible to make one validation column dependent upon choices from another validation column?” Here’s an example;...

A student, in my Excel Beginner to Advanced course on Udemy, recently asked an excellent question on Excel's VLOOKUP function. I thought...

Below is a quick video demonstration on Microsoft Excel Array Formulas. Arrays, simply put, are a collection of data. For example you may...

Another great question from a student in my Complete Excel training course on Udemy. Download the example file to try yourself:...