Excel Is Fun

Excel Magic Trick 1352

January 17, 2018 0

DESCRIPTION See how to create a formula that simultaneously looks up 3 item, joins then together in a single cell in order to produce a system code for CompanyName/PlantZipCode/. See 4 formula methods, including timing […]

Excel Is Fun

Excel Magic Trick 1351

January 14, 2018 0

DESCRIPTION Using Power Query (Get & Transform), see how to Import & Merge Text & Excel Files, Clean Data, Add Helper Columns for Company Name and Revenue, and add a Total Row & Slicer for […]

Excel Is Fun

Excel Magic Trick 1350

January 11, 2018 0

DESCRIPTION Learn how to create formulas to make calculations in a Standard PivotTable. See how to Create a PivotTable Report with PivotTable Formulas for Year, Product & Region with Total Cost Of Goods Sold, Total […]

Excel Is Fun

Excel Magic Trick 1349

January 8, 2018 0

DESCRIPTION See how to use Power Query (Get & Transform) with Input Variables from Excel Sheet to Extract Records and create a Revenue Report. Here are the steps: (00:15) Introduction including Preview of Finished Solution […]

Excel Is Fun

Excel Magic Trick 1348

January 5, 2018 0

DESCRIPTION See how to look up multiple items, retrieve the number associated with the items and add the array of numbers. Examples of SUM Many VLOOKUPs: (00:10) Introduction (01:00) Exact Math Lookup for Adding Multiple […]

Excel Is Fun

Excel Magic Trick 1347

January 2, 2018 0

DESCRIPTION See how to create a Power Query (Get & Transform) Custom Function with a parameter in order to create five Sub Tables, one for each product, each on a new sheet, from a Master […]

Excel Is Fun

Excel Magic Trick 1346

December 21, 2017 0

DESCRIPTION See how to use formulas to extract records from a Master Table to Sub Tables on Each Excel Worksheets for each product in the Master Table: (00:17) Introduction. Look at Dynamic End Result Solution. […]

Excel Is Fun

Excel Magic Trick 1345

December 19, 2017 0

DESCRIPTION See how to use a Logical Formula and Conditional Formatting to highlight Product Name when no items are entered in the row. See 4 methods: (00:11) Introduction to Using Logical Formulas to Apply Conditional […]

Excel Is Fun

Excel Magic Trick 1344

December 17, 2017 0

DESCRIPTION See how to use a formula to apply Conditional Formatting to apply formatting to an entire row based on a condition in an Excel Table. This video shows the Excel Table Feature which allows […]

Excel Is Fun

Excel Magic Trick 1343

December 15, 2017 0

DESCRIPTION See Three methods for creating Chart Labels that have two lines: (00:10) Introduction (00:48) Basics of Text Formula and Join Operator, Ampersand. (01:35) Access Select Data dialog box to edit references in an Excel […]