Tricks & Tips

Display Day Name From A Date

If you need to get the day name (Monday, Tuesday, Wednesday etc.) from a date there are several options depending on your needs. In this article we will show you a few examples on how [Read More >>>]

Excel Is Fun

Excel Magic Trick 1473

DESCRIPTION Learn about how to create a formula to create a product code where the middle part of the code must increment as it is copied down a column. See the Functions ROWS and TEXT. [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 1399

DESCRIPTION See how to Join All Dates Together in a Cell using TEXTJOIN & TEXT Array Formula. WORKBOOKS

Excel Is Fun

Highline Excel 2016 Class 19

DESCRIPTION In this video learn about: (00:14) Introduction to Advanced Filter (02:50) Extract Records based on AND Logical Test (AND Criteria). Comprehensive Example including Defined Names that are created and how to run the Advanced [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 09

DESCRIPTION In this video learn about: (00:12) Introduction (00:22) Reminder of Date Math and Serial Number Dates and Number Formatting (02:14) TODAY and NOW functions to show the current date and time (03:13) EOMONTH function [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 08

DESCRIPTION In this video learn about: (00:12) Introduction (00:46) Text Formulas: Ampersand to Join Items together (01:38) Text Functions to extract partial text items from a larger text item. (02:57) Extract State with LEFT function [Read More >>>]

Excel Is Fun

Excel Magic Trick 1312

DESCRIPTION Learn: (00:08) Problem introduction. (00:33) How to use NETWORKDAYS.INTL to count the number of working days between a start and end date. NETWORKDAYS.INTL is in Excel 2010 or later versions. (01:46) Formula to count [Read More >>>]

Excel Is Fun

Excel Magic Trick 1272

DESCRIPTION Max Value for Each Day Of The Week: AGGREGATE Function (2 Methods) Learn how to find the max value for each day of the week using the Excel 2010 or later function AGGREGATE. See [Read More >>>]

Excel Is Fun

Excel Magic Trick 1262

DESCRIPTION Convert Times Values to HHMM Text or Text HHMM Values to Time Values Learn how to use the TEXT function and custom Number Formatting to: (00:12) Convert Times Values to HHMM Text with TEXT [Read More >>>]