Excel Is Fun

Power BI for Accountants

DESCRIPTION Topics in Video: 01. Download Files 02. Video Introduction and review of Topics covered in video 03. Introduction to Power BI Desktop 04. Overview of process of using Power BI Desktop to build our [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

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