Pivot Table Terminology
In this video, we review (in a mercifully brief fashion) the most important terminology associated with pivot tables.
Dave Bruns
How to drill down into a pivot table
In this video, we show you how to drill down into pivot table summaries to see the data used to create totals and subtotals.
How to refresh data in a pivot table
In this video, we show you how to update the data that flows through a pivot table using the refresh command.
How to quickly create a pivot table
In this video, we show you how to make a pivot table fast.
What is a pivot table?
In this video, we introduce you to the pivot table and explain why pivot tables are useful.
Calculating the break-even point for Google Adwords
In this article, we build a model using the seldom-seen Data Table to visualize at what point an Adwords campaign becomes profitable.Read more
How to find and replace a value
In this video we'll look at how to replace what you've found. Find and replace is a powerful tool when making global changes to worksheets...
How to use Mac function keys with Excel
A summary of how to use Function keys on a Mac with Excel and other applications, including information on system defaults and how to change these defaults.Read more
YEARFRAC Function
YEARFRAC returns a decimal number representing years between two dates. For example:
=YEARFRAC("1-Jan-2019","1-Jan-2020") // returns 1
=YEARFRAC("1-Jan-2019","1-Jul-2020") // returns 1.5
=YEARFRAC("1-Jan-2019","1-Jan-2021") // returns 2
...Read more
DAYS360 Function
The DAYS360 function returns the number of days between two dates, based on a year where all months have 30 days. Both dates must be valid Excel dates or text values that can be parsed as dates. The DAYS360 function only works with whole numbers, time values ...Read more