Dueling Excel

Dueling Excel 138

April 19, 2017 0

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. […]

Excel Is Fun

Excel Magic Trick 1266

January 30, 2017 0

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 […]

Excel Is Fun

Excel Magic Trick 1265

January 26, 2017 0

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 […]

Excel Is Fun

Excel Magic Trick 1128

April 28, 2015 0

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 […]

Excel Is Fun

Excel Magic Trick 1126

April 26, 2015 0

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

April 25, 2015 0

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 […]

Excel Is Fun

Excel Magic Trick 1124

April 24, 2015 0

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

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 01

April 1, 2015 0

DESCRIPTION Basics of PowerPivot: Why PowerPivot?, Add to Data Model, Relationships, Calculated Column, Calculated Field, Build report with PivotTable based on Data Model: (00:22) Smartest People with PowerPivot (01:31) Which Versions of Excel 2013 contain […]