microsoft excel 2019 & 365: level 2
TRANSCRIPT
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