Primary Navigation
Want to create or adapt books like this? Learn more about how Pressbooks supports open publishing practices.
Book Contents Navigation
Introduction
1. 1.1 Overview of Microsoft Excel
2. 1.2 Entering, Editing, and Managing Data
3. 1.3 Formatting and Data Analysis
4. 1.4 Printing
5. 1.5 Chapter Practice
6. 1.6 Scored Assessment
7. 2.1 Formulas
8. 2.2 Introductory Statistical Functions
9. 2.3 Functions for Personal Finance
10. 2.4 Preparing to Print
11. 2.5 Chapter Practice
12. 2.6 Chapter Scored
13. 3.1 More on Formulas and Functions
14. 3.2 Logical and Lookup Functions
15. 3.3 Conditional Formatting
16. 3.4 Preparing to Print
17. 3.5 Chapter Practice
18. 3.6 Chapter Scored
19. 3 Advanced – Advanced Formulas, Functions and Macros
20. 4.1 Choosing a Chart Type
21. 4.2 Formatting Charts
22. 4.3 Using Charts with Microsoft® Word® and Microsoft® PowerPoint®
23. 4.4 Preparing to Print
24. 4.5 Chapter Practice
25. 4.6 Scored Assessment
26. 5.1 Table Basics
27. 5.2 Intermediate Table Skills
28. 5.3 Preparing to Print
29. 5.4 Chapter Practice
30. 5.5 Scored Assessment
31. 7.1 Multiple Sheet Basics
Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
32. 7.2 Formulas with 3-D References
33. 7.3 Templates
34. 7.4 Preparing to Print
35. 7.5 Chapter Practice
36. 7.6 Chapter Assessment
37. Chapter 6: Pivot Tables and Charts
38. 6.1 Creating PivotTables
39. 6.2 Sort & Filter PivotTable Data
40. 6.3 PivotCharts
41. 6.4.1 Chapter Practice 1: EIA Imports Data
42. 6.4.2 Chapter Practice 2: FDA Recall Data
43. 6.4.3 Chapter Practice 3: CFPB Complaint Data
44. 6.5 Chapter Assessment
45. 8.1 Nested IF Functions
46. 8.2 NESTING AND, OR, NOT FUNCTIONS INSIDE AN IF FUNCTION
47. 8.3 Conditional Functions
48. 8.4 Chapter Practice
49. 8.5 Chapter Assessment
50. 9.1 The PMT (Payment) Function for Loans
51. 9.2 The PMT (Payment) Function for Leases
52. 9.3 Creating a Budget Summary Worksheet
53. 9.4 Chapter Practice
54. 9.5 Chapter Assessment
55. 10.1 Cleaning And Restructuring Data In Excel
56. 10.2 Mail Merge
57. 10.3 Integrating Excel® with Word® and PowerPoint®
58. 10.4 Chapter Practice
59. 10.5 Chapter Assessment
60. Data Files
Private: Appendix
This is where you can add appendices or other back matter.
Previous/next navigation
Private: Appendix Copyright © 2021 by Open Oregon. All Rights Reserved.
