Excel Is Fun

Office 2016 10

DESCRIPTION Topics in this video: (00:01) Introduction (00:27) Create a New Style so it is available in other documents (06:50) Create Table of Contents using Header 1 Style (11:26) Send Word Document to PowerPoint using [Read More >>>]

Excel Is Fun

Office 2016 09

DESCRIPTION In this video learn how to create a numbered list or Multi Leveled List in Word, including the keyboards: Tab and Shift Tab. Topics: (00:01) Introduction (00:50) Create a numbered list or Multi Levelled [Read More >>>]

Excel Is Fun

Excel Magic Trick 1435

DESCRIPTION See how to query the Data Model with DAX Code to Export Data to an Excel Sheet: (00:14) Introduction, including looking at Data Model that downloadable file contains (02:13) Use Existing Connections in Data [Read More >>>]

Excel Is Fun

Excel Magic Trick 1434

DESCRIPTION See how to use the DAX SAMPLE Function in Excel 2016 to extract a sample of size n from a Data Set. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1433

DESCRIPTION Because we don’t have an F9 key to evaluate formula elements like we do in Excel, learning how to materialize or evaluate or “see” DAX Formula elements is important. In this video see three [Read More >>>]

Excel Is Fun

Excel Magic Trick 1432

DESCRIPTION See how to create nine DAX Formulas that build a Confidence Interval: (00:13) Introduction to the Confidence Interval example, reference video about Statistics, and introduction to Data Model used in this video (03:34) Formula [Read More >>>]

Excel Is Fun

Excel Magic Trick 1431

DESCRIPTION See how to: (00:10) Introduction (00:52) XNPV, OFFSET and VLOOKUP formula to calculate the Net Present Value for each Project (10:45) XIRR, OFFSET and VLOOKUP formula to calculate the Net Present Value for each [Read More >>>]

Excel Is Fun

Office 2016 08

DESCRIPTION Topics in this video: (00:01) Introduction (01:00) Rules for MLA Documentation Style (04:19) Set MLA Style (05:10) Set Margins (05:50) Insert Header (09:05) Insert Footer to show Page Numbers (12:28) Add First Line Indent [Read More >>>]

Excel Is Fun

Office 2016 07

DESCRIPTION Topics in this video: (00:01) Introduction (00:13) Guidelines for Resume (02:18) Look at Word Resume Templates (03:03) Set System Name in Word Options (03:28) How to use Template (03:50) Understanding Word Tables (06:08) Download [Read More >>>]

Excel Is Fun

Excel Magic Trick 1430

DESCRIPTION See how to use the DAX Functions XNPV and XIRR to calculate the Net Present Value and Internal Rate of Return of Cash Flows that occur at irregular date intervals. WORKBOOKS