Excel Is Fun

Excel Magic Trick 1366

DESCRIPTION Full Lesson on Power BI Desktop to build Product Analysis for Gross Profit with Average, Standard Deviation, Coefficient of Variation and Histogram Calculations and Visualizations: (00:04) Files to download (00:12) Introduction (04:42) Import Related [Read More >>>]

Excel Is Fun

Excel Magic Trick 1307

DESCRIPTION Create Logical Formula to conditionally format only certain cell sin cross tabulated report using a Boolean Array Operation inside the SUM function: (00:13) Problem Set Up (01:25) Look at Logical Formula using AND and [Read More >>>]

Excel Is Fun

Excel Magic Trick 1285

OR Criteria & AND Criteria for Max & Min Calculations (5 Examples) DESCRIPTION Learn how to calculate the MIN and MAX values when there is complex criteria that mixes OR Logical Tests and AND Logical [Read More >>>]

Excel Is Fun

Excel Magic Trick 1284

History of Excel Max or Min with Conditions / Criteria (5 Examples) DESCRIPTION Learn about 5 methods to make a Max or Min AND Criteria (AND Logical Test) Calculation with multiple Conditions / Criteria that [Read More >>>]

Excel Is Fun

Excel Magic Trick 1282

Lookup And Return Multiple Items to a Single Cell: TEXTJOIN Function DESCRIPTION See how to use the amazing new Excel 2016 function TEXTJOIN to Find Multiple Lookup Values In First Colum AND return Multiple Items [Read More >>>]

WORKBOOKS & WORKSHEETS

Worksheet Basics

INTRODUCTION There are two types of worksheets. The standard worksheets that contains cells. Chart sheets which contain only graphs. ROWS AND COLUMNS Every standard worksheet layout consists of Rows and Columns. Rows numbered from 1 [Read More >>>]

Dueling Excel

Dueling Excel 125

DESCRIPTION Conditional Formatting Date Four Days Old & Not Paid See Mr Excel and excelisfun use two methods to Conditional Formatting Date That is Four Or More Days Old & Not Paid 1. Conditional Formatting [Read More >>>]

Excel Is Fun

Excel Magic Trick 1244

DESCRIPTION Transform GDP Data Set: Advanced Filter with Formula Criteria wins! From Bill Szysz at YouTube, see how to use a Formula in Criteria area of Advanced Filter to extract data based on three conditions [Read More >>>]

Excel Is Fun

Excel Magic Trick 1242

DESCRIPTION Transform Large Data Set to Final GDP Report: TTC, MATCH, Filter & Format Learn how to Take Large Data Set with Country Economic Data for the years 1970 to 2013 and filter, delete and [Read More >>>]

Excel Is Fun

Excel Magic Trick 1238

DESCRIPTION Are All Cells Equal? Is The Content In Each Cell The Same? 4 Examples Learn how to check whether the content of multiple cells is the same for each cell: (00:11) Problem Introduction (00:40) [Read More >>>]