Chapter 3, Importing Data into Excel from Different Data Sources. Chapter 4, Data Cleansing and Preliminary Data Analysis. ... Chapter 7, Implementing Time Series. Chapter-7: Custom (Formula) Validation We can put our own desired validation in the Excel cell or range by using the Custom Validation. We need to put the logical formula which will return TRUE or FALSE.
Throughout our textbook, we have worked with Excel files that have included multiple sheets. Depending on the version of Excel you are using, a new Excel file starts with several sheets. In this chapter, we will be working with a personal budget file that contains income and expenses for an entire year.