Templates

Staff Attendance Template 2016

October 22, 2016 0

OVERVIEW The Staff Attendance Template 2016 is designed to help monitor staff attendance, sickness, holidays etc. The template is very dynamic allowing you to The template can monitor up to 1000 staff names Modify Leave […]

Excel Is Fun

Excel Magic Trick 1239

October 17, 2016 0

DESCRIPTION Formula To Indicate a Date is in Leap Year Learn how to create a Logical Formula that will deliver a TRUE or FALSE To Indicate a Date is in Leap Year. See the functions: […]

Dueling Excel

Dueling Excel 97

August 26, 2016 0

Determine Quarter For column of Dates: CHOOSE or CEILING function? DESCRIPTION See Mr Excel and excelisfun use two methods to create a formula that can take any date and determine what quarter it is. See […]

Dueling Excel

Dueling Excel 038

August 26, 2015 0

Weekly Report Formula or Pivot Table? DESCRIPTION See Mr Excel and excelisfun take daily transactional data and create Weekly Summary Reports using a Pivot Table (PivotTable) and a series of formulas. Learn about: 1.Formula for […]

Dueling Excel

Dueling Excel 034

July 29, 2015 0

Dynamic Range for Adding Three Methods DESCRIPTION See Mr Excel and excelisfun add a range of values that is dynamic in two directions. The range of values to add changes depending on what you select […]

Excel Is Fun

Excel Magic Trick 1145

July 23, 2015 0

Create Random Data Set with Formulas: 4 Unusual Formulas DESCRIPTION See how to: (00:08) Overview of Different data Types (01:02) FORMULA 1: Create Random Serial Number Dates with RANDBETWEEN and actual Serial Numbers (02:10) Keyboards […]

Dueling Excel

Dueling Excel 033

July 22, 2015 0

First Monday For Reporting Period DESCRIPTION See Mr Excel and excelisfun show three formulas for finding first Monday of reporting period: If 1st day of month is Monday, then that day, otherwise the last Monday […]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 11

April 11, 2015 0

DESCRIPTION See how to: (00:47) Group By Date: Excel PivotTable: 1) Drag Date to Rows, Right-click Group, Years and Months (02:04) Group By Date: PowerPivot PivotTable: (02:07) Add Revenue Table to PowerPivot Data Model (02:46) […]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 07

April 7, 2015 0

DESCRIPTION See how to: (00:17) Calendar Table in Diagram View with no Calculated Fields (00:58) Format Date Column (01:08) Create Calculated Column #01: Month Number using MONTH function. (01:53) Create Calculated Column #02: Month Name […]

Excel Is Fun

Excel Magic Trick 1104

March 2, 2015 0

DESCRIPTION See how to add unit numbers with AND and OR Criteria where the criteria are given as years and months but date column contains serial number dates. See how to use SUMIFS function to […]