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.
- Front Matter
- TitlePage
- InfoPage
- Table of Contents
- Licensing
- 1: Introduction to Excel and Workbooks
- 1.1: Introduction
- 1.2: Overview of Microsoft Excel
- 1.3: Opening, Saving, and Managing Workbooks
- 1.4: Navigating the Excel Interface
- 1.5: Entering, Editing, and Formatting Data
- 1.6: Renaming and Organizing Worksheets
- 1.7: Conclusion
- 1.8: End of Module Resources
- 1.9: Hands-on Exercise- Creating a Personal Expense Tracker
- 1.10: Real World Applications
- 2: Formulas and Functions
- 2.1: Introduction
- 2.2: Entering and Editing Data for Formulas
- 2.3: Arithmetic Operations
- 2.4: Relative vs. Absolute References
- 2.5: Statistical Functions
- 2.6: Logical Functions (IF, AND, OR, NOT)
- 2.7: Lookup Functions (VLOOKUP, HLOOKUP, INDEX/MATCH, XLOOKUP)
- 2.8: Conclusion
- 2.9: End of Module Resources
- 2.10: Hands-on Exercise - Gradebook challenge
- 2.11: Real World Applications
- 3: Formatting and Professional Presentation
- 3.1: Introduction
- 3.2: Font and Number Formatting
- 3.3: Alignment, Borders, and Cell Styles
- 3.4: Themes and Cell Formatting
- 3.5: Conditional Formatting Basics
- 3.6: Printing for Reports
- 3.7: Printing and Page Layout Features
- 3.8: Accessibility and Professional Standards
- 3.9: Conclusion
- 3.10: End of Module Resources
- 3.11: Hands-on Exercise - Formatting a Monthly Budget Report
- 3.12: Real World Applications
- 4: Business and Financial Functions
- 4.1: Introduction
- 4.2: Creating Financial Models in Excel
- 4.3: Key Financial Functions
- 4.4: Conclusion
- 4.5: End of Module Resources
- 4.6: Hands-on Exercise - Loan and Savings Model
- 4.7: Real World Applications
- 5: Data Management and Database Features
- 5.1: Introduction
- 5.2: Excel as a Flat Database- Tables and Structured References
- 5.3: Conclusion
- 5.4: End of Module Resources
- 5.5: Hands-on Exercise - Small Business / Freelance
- 5.6: Real World Applications
- 6: Charts and Visualizations
- 6.1: Introduction
- 6.2: Creating and Customizing Charts
- 6.3: Creating Column, Line, and Pie Charts
- 6.4: Chart Elements and Design
- 6.5: Combining Charts with Formulas
- 6.6: PivotCharts for Dynamic Visualization
- 6.7: Design Best Practices- Choosing the Right Chart Type
- 6.8: Inserting Images, Shapes, and SmartArt
- 6.9: Conclusion
- 6.10: End of Module Resources
- 6.11: Hands-on Exercise - Sales Dashboard with Dynamic Charts
- 6.12: Real World Applications
- 7: Analyzing and Troubleshooting Data
- 7.1: Introduction
- 7.2: PivotTables for Data Analysis
- 7.3: What-If Analysis- Goal Seek and Scenario Manager
- 7.4: Common Errors in Excel
- 7.5: Formula Auditing Tools
- 7.6: Spreadsheet Best Practices
- 7.7: Conclusion
- 7.8: End of Module Resources
- 7.9: Hands-on Exercise - Mini Decision Lab (Pivot + What-If + Audit)
- 7.10: Real World Applications
- 8: Macros and Automations
- 8.1: Introduction
- 8.2: What Are Macros? When Should You Automate?
- 8.3: Recording Your First Macro
- 8.4: Assigning a Macro to a Button or Shape
- 8.5: Saving Macro-Enabled Workbooks (.xlsm)
- 8.6: VBA Basics (Awareness) and Security
- 8.7: Simple Automation Examples
- 8.8: Conclusion
- 8.9: End of Module Resources
- 8.10: Hands-on Exercise - “One-Click Report Kit”
- 8.11: Real World Applications
- Back Matter
- Index
- Glossary
- Detailed Licensing
- Detailed Licensing