iii

Contents

Preface v

Excel Chapter 6: Advanced Workbook Formatting

Formatting with Themes 150Customizing Themes 151

Cell Styles 153Using the Format Cells Dialog Box 155

Cell Borders and Fill 156Creating Custom Number Formats 157

International Formatting 158Customizing the Page Setup 160

Adding a Worksheet Background Image 160Editing Document Properties 161Reinforce Your Skills 163Apply Your Skills 166Project Grader 168Extend Your Skills 170

Excel Chapter 7: Date Functions and Conditional Formatting

Date Serial Numbers 172Applying Custom Date Formatting 172Entering Time Information 175Using Date Functions 176Calculations Using Date and Time 177Conditional Formatting Using Graphics

and Custom Rules 179Conditional Formatting with Graphics 179The Conditional Formatting Rules Manager 180Conditional Formatting Using Formulas 180

Reinforce Your Skills 184Apply Your Skills 187Project Grader 189Extend Your Skills 191

Excel Chapter 8: Financial Functions and What-If Analysis

Creating Financial Functions 194Financial Function Arguments 194PMT Function 195FV Function 197NPER Function 198

Using What-If Analysis Tools 199Data Tables 199

Scenario Manager 203Goal Seek 206Reinforce Your Skills 208Apply Your Skills 212Project Grader 215Extend Your Skills 217

Excel Chapter 9: Text Functions, Conditional Functions, and Formula Auditing

Using Functions to Modify Text 220Changing Case 220Extracting Text 221Merge and Modify Text with Functions and Flash Fill 221Other Text Functions 222

Creating Conditional Functions Using IF Criteria 225Nested Functions 228

The IFS Function 229The SWITCH Function 229

Troubleshooting Formulas 232Trace Precedents and Dependents 232Checking for Errors 234Evaluate a Formula 235The Watch Window 235

3-D Cell References 238Reinforce Your Skills 240Apply Your Skills 244Project Grader 247Extend Your Skills 250

Microsoft Excel 2019 & 365: Level 2 © 2019 Labyrinth Learning – Not for Sale or Classroom Use

Labyrinth Learning http://www.lablearning.com

iv Contents

Excel Chapter 10: Lookup Functions and Outlines

Introducing Lookup Functions 252VLOOKUP and HLOOKUP 252

The Outline Feature 255Subtotals 257

The Subtotal Dialog Box 258The Quick Analysis Tool 260Reinforce Your Skills 263Apply Your Skills 267Project Grader 269Extend Your Skills 271

Glossary 273Index 275

Microsoft Excel 2019 & 365: Level 2 © 2019 Labyrinth Learning – Not for Sale or Classroom Use

Labyrinth Learning http://www.lablearning.com