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

Excel Is Fun

Excel Magic Trick 1364

DESCRIPTION See how to: 1. Open Power BI Desktop 2. Import Excel File with image URL web addresses 3. Select Column with URL, and in Modeling Ribbon Tab, in the Properties group, Data Category drop-down, [Read More >>>]

Excel Is Fun

Excel Magic Trick 1363

DESCRIPTION See how to use images in Power View Report: 1. Create Column with web address to pictures using a Text Formula 2. Add Table to Power Pivot Data Model: From Power Pivot Ribbon Tab, [Read More >>>]