Excel Is Fun

Highline Excel 2016 Class 16

DESCRIPTION In this video learn about Conditional Formatting Topics : (00:16) Introduction (00:43) Built-in Feature: Cell Contains (03:28) Logical Formula: Highlight Row (Record) where cell contains a value. (10:00) Built-in Feature: Below Average (10:55) Logical [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 >>>]

Dueling Excel

Dueling Excel 138

DESCRIPTION NETWORKDAYS.INTL Amazing New “Any Weekend” Argument Learn about amazing new feature in the NETWORKDAYS.INTL function for counting workdays that will accommodate any weekend scenario. See counting workdays and Conditional Formatting for weekdays or weekend. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1266

DESCRIPTION NETWORKDAYS.INTL: Each Employee has Different Weekend Schedule? Learn how to create one formula you can copy down column that will calculate net workdays where each employee has a different weekend schedule. See how to [Read More >>>]

Excel Is Fun

Excel Magic Trick 1265

DESCRIPTION NETWORKDAYS.INTL Function: Calculate Net Workdays (8 examples) Learn how to use NETWORKDAYS.INTL function to calculate net working days when you are given a start and end date, what days in the week are weekends [Read More >>>]

Excel Is Fun

Excel Magic Trick 1128

DESCRIPTION See how to create an automated Accounting Ageing Accounts Receivable Reports On Multiple Sheets With Array Formula, Excel Table Feature and Formula Table Nomenclature (Structured References): (00:16) Overview of end result: Automatic Ageing Reports [Read More >>>]

Excel Is Fun

Excel Magic Trick 1126

DESCRIPTION See how to complete a monthly employee calendar with the text “Training” based on a start and end date, and holiday and weekend dates. See the functions: IFERROR, WORKDAY.INTL, IF, AND, and NETWORKDAYS.INTL. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1125

DESCRIPTION See how to use Data Validation Custom Formula to verify that dates entered into cells are in current month and are NOT a weekend or holiday. See the AND and NETWORKDAYS.INTL functions as well [Read More >>>]

Excel Is Fun

Excel Magic Trick 1124

DESCRIPTION See how to Conditional Format Weekends & Holidays using the NETWORKDAYS.INTL & NOT functions. Conditionally format serial dates for weekends and holidays. Conditional Formatting. Format Conditionally. Logical Formulas. Format holidays and weekends. WORKBOOKS