Excel Is Fun

Excel Magic Trick 1470

DESCRIPTION Learn about how to take a rainfall data set with Time-Date Stamps and add rain totals for each day and have the ability to change the definition of the 24 hour period by subtracting [Read More >>>]

Excel Is Fun

Excel Magic Trick 1469

DESCRIPTION Learn about how to take a rainfall data set with Time-Date Stamps and add rain totals for each day and have the ability to change the definition of the 24 hour period. Topics: (00:11) [Read More >>>]

Excel Is Fun

Excel Magic Trick 1468

DESCRIPTION Learn about how Topics: (00:16) Introduction (00:51) Discussion about the two different Data Ribbon Tabs and Get & Transform groups that you may see in Excel 2016 (03:51) Example #1: Clean Data and create [Read More >>>]

Excel Is Fun

Office 2016 37

DESCRIPTION Topics in this Video: (00:01) Introduction to Power Query and the examples in this video (02:50) Difference between Data Ribbon Tabs in Office 365 Excel 2016 and Non-Office 365 Excel 2016 (04:32) Example #1: [Read More >>>]

Excel Is Fun

Office 2016 34

DESCRIPTION Learn about how to set Default Layout for a PivotTable in Excel 2016 Office 365 or later versions. NOTES WORKBOOKS

Excel Is Fun

Excel Magic Trick 1456

DESCRIPTION In this video see how to create an 8 Year Span Monthly Revenue Report for a selected Product. WORKBOOKS

Excel Is Fun

Office 2016 32

DESCRIPTION Topics in this video: (00:01) Introduction (01:51) Review of PivotTables we have already completed in this class. (03:15) What is Data Analysis in one sentence (03:34) What’s is Proper Data Set in Excel? (03:50) [Read More >>>]

Excel Is Fun

Excel Magic Trick 1452

DESCRIPTION See two methods: 1) PivotTable Method, 2) Array Formula Method. The PivotTable Method is the easy way to accomplish this. The Array Formula method is a difficult Array Formula, but it can make all [Read More >>>]

Excel Is Fun

Excel Magic Trick 1451

DESCRIPTION Topics in This Video: (00:04) How to Download Files. (00:14) Introduction to building Data Model with Relationships and DAX Formulas without buying Power Pivot in Excel 2016. (02:47) Import Tables and Build Relationships using [Read More >>>]

Excel Is Fun

Excel Magic Trick 1450

DESCRIPTION Learn how to use Relationships in Excel 2016 (or later versions) rather than the VLOOKUP Function when you are making PivotTable Reports from multiple tables. See how to create a Product / Region Yearly [Read More >>>]