Skip to content

Primary Navigation

Home
Read
Sign in
Search in book:

Want to create or adapt books like this? Learn more about how Pressbooks supports open publishing practices.

Book Contents Navigation

Introduction
I. Chapter 1 – Fundamental Skills
II. Chapter 2 – Mathematical Computations
III. Chapter 3 – Formulas, Functions, Logical and Lookup Functions
IV. Chapter 4 – Presenting Data with Charts
V. 3 Advanced – Power Tools and Macros
VI. Chapter 5 – Tables
VII. Chapter 7 – Multiple Sheet Files
1. 31. 7.1 Multiple Sheet Basics
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
2. 32. 7.2 Formulas with 3-D References
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
3. 33. 7.3 Templates
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
4. 34. 7.4 Preparing to Print
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
5. 35. 7.5 Chapter Practice
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
6. 36. 7.6 Chapter Assessment
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
VIII. Chapter 6 - Pivot Tables and Pivot Charts
1. 37. Chapter 6: Pivot Tables and Charts
2. 38. 6.1 Creating PivotTables
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
3. 39. 6.2 Sort & Filter PivotTable Data
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
4. 40. 6.3 PivotCharts
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
5. 41. 6.4.1 Chapter Practice 1: EIA Imports Data
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
6. 42. 6.4.2 Chapter Practice 2: FDA Recall Data
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
7. 43. 6.4.3 Chapter Practice 3: CFPB Complaint Data
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
8. 44. 6.5 Chapter Assessment
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
IX. Chapter 8: Advanced Logic & Conditional Functions
1. 45. 8.1 Nested IF Functions
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
2. 46. 8.2 NESTING AND, OR, NOT FUNCTIONS INSIDE AN IF FUNCTION
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
3. 47. 8.3 Conditional Functions
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
4. 48. 8.4 Chapter Practice
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
5. 49. 8.5 Chapter Assessment
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
X. Chapter 9: Functions for Personal Finance
1. 50. 9.1 The PMT (Payment) Function for Loans
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
2. 51. 9.2 The PMT (Payment) Function for Leases
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
3. 52. 9.3 Creating a Budget Summary Worksheet
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
4. 53. 9.4 Chapter Practice
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
5. 54. 9.5 Chapter Assessment
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
XI. Chapter 10: Integrating Microsoft Office Suite Applications
1. 55. 10.1 Cleaning And Restructuring Data In Excel
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
2. 56. 10.2 Mail Merge
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
3. 57. 10.3 Integrating Excel® with Word® and PowerPoint®
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
4. 58. 10.4 Chapter Practice
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
5. 59. 10.5 Chapter Assessment
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
XII. Appendix
1. 60. Data Files
  Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
Private: Appendix

Excel

This is where you can add appendices or other back matter.

Previous/next navigation

Previous: Data Files

License

Private: Appendix Copyright © 2021 by Open Oregon. All Rights Reserved.

Share This Book

Powered by Pressbooks

Pressbooks User Guide
|Pressbooks Directory
|Contact

Pressbooks on YouTube Pressbooks on LinkedIn