Excel Is Fun

Excel Magic Trick 1281

March 23, 2017 0

TEXTJOIN & CONCAT New Excel 2016 functions (14 Examples of Joining Items) DESCRIPTION Learn about the new Excel 2016 functions TEXTJOIN and CONCAT. Compare and contrast these newer functions to the older methods of using […]

Dueling Excel

Dueling Excel 134

March 22, 2017 0

DESCRIPTION Merge Product and Sub-Product Text; VBA or Wild INDEX Formula See Mr Excel and excelisfun use two methods to take a table of product names, each with 6 sub-products, and unwind the table to […]

Excel Features

Using Excel Autocomplete

March 21, 2017 0

When you type the first few letter of an entry into a cell Excel can complete the entry automatically using an option known as Autocomplete. It does this by building a list based on the […]

Excel Is Fun

Excel Magic Trick 1280

March 20, 2017 0

How To Get Latest Excel Updates for Insider Program: Office 365 DESCRIPTION Learn how to download the Insider Program Version of Excel 2016 so you can get new periodic updates with new features such as […]

GETTING STARTED IN EXCEL

What’s New in Excel 2013

March 19, 2017 0

Welcome Screen The first thing you’ll see when you open Excel is a brand new look. It’s cleaner, but it’s also designed to help you get professional-looking results quickly. You’ll find many new features that […]

Excel Is Fun

Highline Excel 2013 Class Video 27

March 17, 2017 0

DESCRIPTION Topics in this video: 1. List of possible errors in Excel. 2. 4 Steps to finding formula errors. 3. 3 Examples of how to use the 4 steps. 4. Cleaning Text data with the […]

Excel Is Fun

Excel Magic Trick 1279

March 16, 2017 0

DESCRIPTION Learn how to create a New Running Count (Cumulative Count) Formula After Each Zero Value using the IF and SUM functions. Trick from Bill Szysz at YouTube. See that the SUM Function ignores Text […]

Dueling Excel

Dueling Excel 133

March 15, 2017 0

DESCRIPTION See Mr Excel and excelisfun use two methods to sum the three biggest values that match three criteria (3 conditions) 1. Advanced Filter and LARGE and MAX value 2. SUM and LARGE functions with […]

Excel Topics

Hide / Show Worksheet Gridlines

March 14, 2017 0

The gridlines displayed in a worksheet can be very useful especially when you are designing your worksheets. There are times however when you may want to hide the gridlines. How to hide/show gridlines for a […]