Chapter 11: Date-Time Functions and Enhancing PivotTable Dashboards
In this chapter, we will explore date functions and look at how to work with time. Here, we concentrate on DATEDIF(), YEARFRAC(), EDATE(), WORKDAY(), and many more functions to be more productive in the workplace. In addition, a large part of this chapter will explore a host of PivotTable customizations and a walk-through on creating dashboards. We will also learn to construct the GETPIVOTDATA function to reference cells in a PivotTable report.
The following topics are covered in this chapter:
- Working with dates
- Working with time
- Enhancing PivotTables
- Creating dashboards
- Additional PivotTable customizations
Technical requirements
Before starting this chapter, you should have ...
Get Learn Microsoft Office 2021 - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
