Excel Is Fun

Excel Magic Trick 1374

DESCRIPTION See how to Create Shrinking and Expanding Range with INDEX function. See how to Get the Total for each employee when the Employee Name column has many empty cells and the “TOTAL” is in [Read More >>>]

Excel Is Fun

Excel Magic Trick 1373

DESCRIPTION See how to Conditionally Format Every 5th Value and Extract Every 5th Value: 1. Introduction 2. Formula 1 for counting how many values will be extracted. ROWS & ROUNDDOWN Functions. 3. Formula 1 for [Read More >>>]

Excel Is Fun

Excel Magic Trick 1372

DESCRIPTION See how to Get the Total for each employee when the Employee Name column has many empty cells and the “TOTAL” is in a row without an employee name. See five methods: (00:13) Introduction [Read More >>>]

Excel Is Fun

Excel Magic Trick 1371

DESCRIPTION See how to Create Excel Formula To Add Last Five Values in an Excel Table using INDEX function to create a Dynamic Range inside the SUM Function. Topics: (00:14) Introduction to add Last 5 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1370

DESCRIPTION See how to Create Formula to Extract Each Item In List & Display In Every Third Column. Topics: (00:15) Introduction to Problem (01:03) Formula Element Number Incrementor to create pattern like: 1,1,1,2,2,2,3,3,3… See functions [Read More >>>]

Excel Is Fun

Excel Magic Trick 1369

DESCRIPTION See two methods to Count Entered Results For Shift & Date Range using COUNTIFS function: 1. Introduction to a well asked question 2. Create Defined Names 3. Create COUNTIF Formula #1, where we have [Read More >>>]

Excel Is Fun

Excel Magic Trick 1368

DESCRIPTION See how to use the SUMIFS and SUMPRODUCT functions to Calculate Sum Of Amazon And Google Under Each Region. Properly you will learn about OR Logical Tests and AND Logical Tests so that we [Read More >>>]

Excel Is Fun

Excel Magic Trick 1367

DESCRIPTION How to make Calendar Table in Power BI Desktop? See how to create three types of Calendar Tables in Power BI Desktop using the CALENDAR Function and various other functions: (00:02) Files to Download [Read More >>>]

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 1365

DESCRIPTION See how to import an Excel Power Pivot Data Model with tables, relationships and DAX Measures into Power BI Desktop using the File (Upper Left icon), Import, Excel Workbook option in Power BI Desktop. [Read More >>>]