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

Excel Is Fun

Excel Magic Trick 1362

DESCRIPTION See how to: 1. File, Options, Add-ins, Manage: select “Com Add-ins”, Click Go, Check Power View, OK 2. Right-click any Ribbon Tab, “Customize the Ribbon”, Add Group, Rename Group 3. With Group Selected, from [Read More >>>]

Tricks & Tips

Remove All Data After /

Question: I have list of domains in excel I would like to delete all the subfolders without going in one by one is there a way to do? example: www.domain.com/subfoldername www.domain2.com/subfoldername my list has about [Read More >>>]

Excel Is Fun

Excel Magic Trick 1360

DESCRIPTION See how to use Power BI Desktop to import, clean and transform Sales Tables from Multiple Excel Files and consolidate into a Single Proper Data Set that can be linked in a Relationship to [Read More >>>]

Excel Is Fun

Excel Magic Trick 1359

DESCRIPTION Learn about the basics of the VLOOKUP Function and about Time Values in Excel. Topics in this video: (00:12) Introduction to goal of video (01:08) Build Lookup Table with Time Values/Time Categories (8 Equal [Read More >>>]

Excel Is Fun

Excel Magic Trick 1358

DESCRIPTION See an example of how to invoke Query Dependencies View in Power Query (Get & Transform) WORKBOOKS