Excel Is Fun

Excel Magic Trick 1425

DESCRIPTION See how to use INDEX function & Number Increments to Convert 2-Way Table to Single Column Table: (00:11) Introduction (00:52) Copy Paste Trick to Convert 2-Way Table to Single Column Table (01:46) Number Increment [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 1423

DESCRIPTION Learn about the Power Query Function Number.ToText to use some Excel Custom Number Formatting and Power Query Custom Number Formatting to format numbers and convert then to text. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1422

DESCRIPTION Learn how to use the Power Query user interface and type M Code to quickly take all the items from an invoice and list them in a cell with a delimiter. The Data is [Read More >>>]

Excel Is Fun

Office 2016 04

DESCRIPTION Topics in this video: (00:01) Introduction (01:10) Add Word Shortcut to Task Bar (02:15) Why we use Word (02:50) Title Bar & Save As (04:09) Alt + Tab Keyboard to jump between Active Windows [Read More >>>]

Excel Is Fun

Office 2016 03

DESCRIPTION Topics in this video: (00:01) Introduction (00:24) Example of Logical System of folders to organise files (02:53) Create System of Folders for our class (13:32) Importance of correct names for Test Folders (14:53) Hint [Read More >>>]

Excel Is Fun

Excel Magic Trick 1420

DESCRIPTION See how to connect to an SQL Database, Append an Excel Table to the SQL Imported Data, Group By to add Total Units for each Product, then Sort, Grouping, Indexes and Custom Columns to [Read More >>>]

Excel Is Fun

Excel Magic Trick 1419

DESCRIPTION See how to use the RANKX Function in DAX. Learn : (00:15) Introduction. Look at Finished Data Model PivotTable. Look at Established Data Model. (02:24) Create Total Profit Formula, start PivotTable. (04:14) Discuss how [Read More >>>]

Excel Is Fun

Excel Magic Trick 1418

DESCRIPTION See how to use Standard PivotTables to rank profits and profits per unit for both All The Products and Products within Manufacturer: (00:10) Introduction (01:31) PivotTable #1 for Total Profit per Product and Ranking [Read More >>>]