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

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

DESCRIPTION See how to use Excel Formulas to analyze a group of customers who have been given coupons to three stores. Our goal is to create a single cell Array Formula that counts how many [Read More >>>]

Excel Is Fun

Excel Magic Trick 1443

DESCRIPTION Learn how to calculate Sales per working day based on a Data Model with Sales and Data Table. See the DAX Functions: CALCULATE, COUNTROWS, SUM, CROSSJOIN, VALUES, SUMX, IF, FILTER and MAX. Learn how [Read More >>>]

Excel Is Fun

Office 2016 24

DESCRIPTION Topics in this video: (00:01) Introduction (00:30) Different Types of Formulas (02:07) Formula Elements – what you can out into a formula. (04:55) Formula 01: Goal: Add calls made a service centre last week.: [Read More >>>]

Excel Is Fun

Office 2016 22

DESCRIPTION Topics in this video: (00:01) Introduction (01:25) Keyboard to toggle Ribbon Tabs on and off (01:46) Date Number Formatting (04:55) Number Days Invoice Late Calculation (05:30) Keyboard to hard code today’s date in a [Read More >>>]

Excel Is Fun

Office 2016 19

DESCRIPTION In this video learn these amazing Excel Keyboard Shortcuts: 1. Ctrl + Arrow Key == Jump to end. If all empty, jump to last empty 2. Ctrl + Home == Go To A1 3. [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

Office 2016 13

DESCRIPTION Topics in this video: (00:01) Introduction (01:30) Excel file = “Workbook”, not “Document” (02:22) Columns (Represented by Letters) and Rows (Represented by Numbers) (02:29) Cells = Intersection of Column and Row = Name or [Read More >>>]