Excel Is Fun

Excel Magic Trick 1466

DESCRIPTION Learn about how to create Formulas For Start of Month & Number Days in Month From Any Date using the EOMONTH and EDATE Functions. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1457 Part 1

DESCRIPTION Learn about how different functions in Excel and Direct Operations interact and interpret Date and Time Values with the different Data Types: Number or Text. Learn how the Functions: SUMIFS, COUNTIFS, COUNT, SUM, EOMONTH, [Read More >>>]

Excel Is Fun

Office 2016 22

DESCRIPTION Topics in this video: (00:01) Introduction (01:25) Keyboard to toggle Ribbon Tabs on and off (01:46) Date Number Formatting (04:55) Number Days Invoice Late Calculation (05:30) Keyboard to hard code today’s date in a [Read More >>>]

Excel Is Fun

Excel Magic Trick 1406

DESCRIPTION See how to use the AVEARGEIFS & EOMONTH Functions with Custom Number Formatting to create a 12 Month Moving Average Report for a two year span. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1405

DESCRIPTION See how to calculate Monthly Totals for Sales from Daily Records and Ad Costs from Month Records using SUMIFS and EOMONTH functions. This Granularity mismatch between Month and Day is easy to deal with [Read More >>>]

Excel Is Fun

Excel Magic Trick 1404

DESCRIPTION See how to create a three-year Sales per Working Day by Month Report Where the Date Table lists the Working Days and the Sales Table will be updated with new data regularly: (00:10) Introduction [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 >>>]

Excel Is Fun

Highline Excel 2016 Class 06

DESCRIPTION In this video learn about All the ways to make conditional Calculations with Formulas in Excel: Built-in Functions like SUMIFS, AND function, OR Function, IS Functions, Array Formulas, D Functions and more: (00:23) Introduction [Read More >>>]

Excel Is Fun

Excel Magic Trick 1367

DESCRIPTION How to make Calendar Table in Power BI Desktop? See how to create three types of Calendar Tables in Power BI Desktop using the CALENDAR Function and various other functions: (00:02) Files to Download [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 >>>]