Excel Is Fun

Highline Excel 2016 Class 22

DESCRIPTION In this video learn about: (00:16) Introduction to Entire Project, including what type of start files we have and what the final report looks like. (03:36) What is Data Modelling? Steps to creating a [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 >>>]

Dueling Excel

Dueling Excel 137

DESCRIPTION Start and End Date, What is Total Pay Over Period Given Month Salary? See Mr Excel and excelisfun use two methods to calculate Start and End Date, What is Total Pay Over Period Given [Read More >>>]

Templates

Staff Attendance Template 2016

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1239

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: [Read More >>>]

Dueling Excel

Dueling Excel 97

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 [Read More >>>]

Dueling Excel

Dueling Excel 038

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 [Read More >>>]

Dueling Excel

Dueling Excel 034

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1145

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 [Read More >>>]

Dueling Excel

Dueling Excel 033

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 [Read More >>>]