Excel Is Fun

Office 2016 36

DESCRIPTION Topics in this Video: (00:01) Introduction to Excel Charts & Graphs (02:46) Excel Chart Terminology (04:00) What is Chart Junk? (05:35) Column and Bar Charts for comparing numbers across categories (11:35) Formatting Chart Elements [Read More >>>]

Excel Is Fun

Office 2016 35

DESCRIPTION Topics in this Video: (00:01) Introduction about Data Analysis features (01:40) Sorting (11:45) Filtering (21:50) Flash Fill (29:01) Summary NOTES WORKBOOKS

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

Office 2016 33

DESCRIPTION In this video learn about how to use Excel Tables, One-To-Many Relationships and the Data Model as a substitute for a VLOOKUP Function Helper Column for a Large Data Set. Discuss pros and cons. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1460

DESCRIPTION Learn how to look up an item in a list of items and list all the relative positions for that item in a single cell. See the functions TEXTJOIN, IF, ISNA, MATCH. See extensive [Read More >>>]

Excel Is Fun

Excel Magic Trick 1459

DESCRIPTION Learn how to create use SUMIFS and SUMPRODUCT functions to add the costs for each dog based on whether the expense is for Food or it is an Accessory. This video shows how to [Read More >>>]

Excel Is Fun

Excel Magic Trick 1458

DESCRIPTION Learn how to lookup the price for PVC Pipe in three different tables using VLOOKUP and INDIRECT Function and Defines Names. Defined Names allow us to assign a Named Reference to a lookup table. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1457 Part 2

DESCRIPTION In the English United States Regional Settings, SUMIFS seems to be recognizing Text and Number Dates as equivalent Criteria. But when we change the Reginal Settings, SUMIFS correctly interprets Text Dates and Number Dates [Read More >>>]

Excel Is Fun

Excel Magic Trick 1457 Part 1

DESCRIPTION Learn about how different functions in Excel and Direct Operations interact and interpret Date and Time Values with the different Data Types: Number or Text. Learn how the Functions: SUMIFS, COUNTIFS, COUNT, SUM, EOMONTH, [Read More >>>]

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