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

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