Excel Is Fun

Office 2016 16

DESCRIPTION Topics in this video: (00:01) Introduction (01:22) What Excel can do: 1) Calculations, Data Analysis (01:58 and 03:22) What is Data Analysis? (04:00) What is a Proper Data Set? (06:26) SUMIFS for Regional Sales [Read More >>>]

Excel Is Fun

Office 2016 15

DESCRIPTION Topics in this video: (00:01) Introduction (00:41) Different kinds of counting and adding (02:28) Function Drop-down and screen tips to learn which function to use (04:05) COUNT Function (05:04) COUNTA Function (06:16) SUM Function [Read More >>>]

Excel Is Fun

Excel Magic Trick 1438

DESCRIPTION See how to use SUMIFS and SUMPRODUCT Functions to create a Cross Tabulated Table to add Sales with Sales Channel Criteria as the Row Header Criteria and Product Group OR Criteria as the Column [Read More >>>]

Excel Is Fun

Excel Magic Trick 1424

DESCRIPTION See how to calculate Average, Moving Average at Different Granularity in both DAX and Excel Formulas: (00:14) Introduction (00:27) What is Granularity? (02:15) Look at Data Model and Hide Columns from Client Tool (03:29) [Read More >>>]

Excel Is Fun

Excel Magic Trick 1417

DESCRIPTION See how to use Excel Spreadsheet Formulas to rank profits and profits per unit for both All The Products and Products Within Manufacturer. Also see throughout the video various ways to copy a formula [Read More >>>]

Excel Is Fun

Excel Magic Trick 1410

DESCRIPTION See how to Calculate Closing Balance for Each Month from Balance Transaction Table: (00:10) Introduction (01:20) SUMIFS and MAXIFS method (03:45) SUMIFS and AGGREGATE method (06:07) SUMIFS and VLOOKUP method (07:35) SUMIFS and MAX [Read More >>>]

Excel Is Fun

Excel Magic Trick 1409

DESCRIPTION In Excel 2016, see how to create a relationship between two tables so that the PivotTable dialog box will list two tables that we can drag and drop fields from both tables to create [Read More >>>]

Excel Is Fun

Excel Magic Trick 1405

DESCRIPTION See how to calculate Monthly Totals for Sales from Daily Records and Ad Costs from Month Records using SUMIFS and EOMONTH functions. This Granularity mismatch between Month and Day is easy to deal with [Read More >>>]

Excel Is Fun

Excel Magic Trick 1404

DESCRIPTION See how to create a three-year Sales per Working Day by Month Report Where the Date Table lists the Working Days and the Sales Table will be updated with new data regularly: (00:10) Introduction [Read More >>>]

Excel Is Fun

Excel Magic Trick 1394

DESCRIPTION See how to use formulas to calculate “PivotTable Show Values As: Calculations: (00:14) Introduction to unusual formulas for standard PivotTable Show Values As Calculations (01:29) Total Revenue Formula for either Product or Manufacturer in [Read More >>>]