Introduction to Spreadsheets (BSOT 112)

by Gabrielle Brixey

Publisher
Coalinga College
Subjects
Business
Licence
CC BY-NC-SA 4.0, as LibreTexts states it. Non-commercial use only.
Who can read
Tweens profiles and older, judged from its title and subjects

Contents

LibreTexts writes equations in TeX, and here they show as TeX; the PDF has them typeset.

  1. Front Matter
  2. TitlePage
  3. InfoPage
  4. Table of Contents
  5. Licensing
  6. 1: Introduction to Excel and Workbooks
  7. 1.1: Introduction
  8. 1.2: Overview of Microsoft Excel
  9. 1.3: Opening, Saving, and Managing Workbooks
  10. 1.4: Navigating the Excel Interface
  11. 1.5: Entering, Editing, and Formatting Data
  12. 1.6: Renaming and Organizing Worksheets
  13. 1.7: Conclusion
  14. 1.8: End of Module Resources
  15. 1.9: Hands-on Exercise- Creating a Personal Expense Tracker
  16. 1.10: Real World Applications
  17. 2: Formulas and Functions
  18. 2.1: Introduction
  19. 2.2: Entering and Editing Data for Formulas
  20. 2.3: Arithmetic Operations
  21. 2.4: Relative vs. Absolute References
  22. 2.5: Statistical Functions
  23. 2.6: Logical Functions (IF, AND, OR, NOT)
  24. 2.7: Lookup Functions (VLOOKUP, HLOOKUP, INDEX/MATCH, XLOOKUP)
  25. 2.8: Conclusion
  26. 2.9: End of Module Resources
  27. 2.10: Hands-on Exercise - Gradebook challenge
  28. 2.11: Real World Applications
  29. 3: Formatting and Professional Presentation
  30. 3.1: Introduction
  31. 3.2: Font and Number Formatting
  32. 3.3: Alignment, Borders, and Cell Styles
  33. 3.4: Themes and Cell Formatting
  34. 3.5: Conditional Formatting Basics
  35. 3.6: Printing for Reports
  36. 3.7: Printing and Page Layout Features
  37. 3.8: Accessibility and Professional Standards
  38. 3.9: Conclusion
  39. 3.10: End of Module Resources
  40. 3.11: Hands-on Exercise - Formatting a Monthly Budget Report
  41. 3.12: Real World Applications
  42. 4: Business and Financial Functions
  43. 4.1: Introduction
  44. 4.2: Creating Financial Models in Excel
  45. 4.3: Key Financial Functions
  46. 4.4: Conclusion
  47. 4.5: End of Module Resources
  48. 4.6: Hands-on Exercise - Loan and Savings Model
  49. 4.7: Real World Applications
  50. 5: Data Management and Database Features
  51. 5.1: Introduction
  52. 5.2: Excel as a Flat Database- Tables and Structured References
  53. 5.3: Conclusion
  54. 5.4: End of Module Resources
  55. 5.5: Hands-on Exercise - Small Business / Freelance
  56. 5.6: Real World Applications
  57. 6: Charts and Visualizations
  58. 6.1: Introduction
  59. 6.2: Creating and Customizing Charts
  60. 6.3: Creating Column, Line, and Pie Charts
  61. 6.4: Chart Elements and Design
  62. 6.5: Combining Charts with Formulas
  63. 6.6: PivotCharts for Dynamic Visualization
  64. 6.7: Design Best Practices- Choosing the Right Chart Type
  65. 6.8: Inserting Images, Shapes, and SmartArt
  66. 6.9: Conclusion
  67. 6.10: End of Module Resources
  68. 6.11: Hands-on Exercise - Sales Dashboard with Dynamic Charts
  69. 6.12: Real World Applications
  70. 7: Analyzing and Troubleshooting Data
  71. 7.1: Introduction
  72. 7.2: PivotTables for Data Analysis
  73. 7.3: What-If Analysis- Goal Seek and Scenario Manager
  74. 7.4: Common Errors in Excel
  75. 7.5: Formula Auditing Tools
  76. 7.6: Spreadsheet Best Practices
  77. 7.7: Conclusion
  78. 7.8: End of Module Resources
  79. 7.9: Hands-on Exercise - Mini Decision Lab (Pivot + What-If + Audit)
  80. 7.10: Real World Applications
  81. 8: Macros and Automations
  82. 8.1: Introduction
  83. 8.2: What Are Macros? When Should You Automate?
  84. 8.3: Recording Your First Macro
  85. 8.4: Assigning a Macro to a Button or Shape
  86. 8.5: Saving Macro-Enabled Workbooks (.xlsm)
  87. 8.6: VBA Basics (Awareness) and Security
  88. 8.7: Simple Automation Examples
  89. 8.8: Conclusion
  90. 8.9: End of Module Resources
  91. 8.10: Hands-on Exercise - “One-Click Report Kit”
  92. 8.11: Real World Applications
  93. Back Matter
  94. Index
  95. Glossary
  96. Detailed Licensing
  97. Detailed Licensing