Phu Xuan University Library
|
PXU E-LIB
Sign in
Introduction to Spreadsheets (BSOT 112)

External

Introduction to Spreadsheets (BSOT 112)

Business
Author
Gabrielle Brixey
Publisher
Coalinga College
Source
LibreTexts
License
CC BY-NC-SA
Language
EN
Category
Business Administration
Read online Download PDF (open licence)
Contents· 87 sections
  1. 01: Introduction to Excel and Workbooks
  2. 1.01: Introduction
  3. 1.02: Overview of Microsoft Excel
  4. 1.03: Opening Saving and Managing Workbooks
  5. 1.04: Navigating the Excel Interface
  6. 1.05: Entering Editing and Formatting Data
  7. 1.06: Renaming and Organizing Worksheets
  8. 1.07: Conclusion
  9. 1.08: End of Module Resources
  10. 1.09: Hands-on Exercise- Creating a Personal Expense Tracker
  11. 1.10: Real World Applications
  12. 02: Formulas and Functions
  13. 2.01: Introduction
  14. 2.02: Entering and Editing Data for Formulas
  15. 2.03: Arithmetic Operations
  16. 2.04: Relative vs. Absolute References
  17. 2.05: Statistical Functions
  18. 2.06: Logical Functions (IF AND OR NOT)
  19. 2.07: Lookup Functions (VLOOKUP HLOOKUP INDEX MATCH XLOOKUP)
  20. 2.08: Conclusion
  21. 2.09: End of Module Resources
  22. 2.10: Hands-on Exercise - Gradebook challenge
  23. 2.11: Real World Applications
  24. 03: Formatting and Professional Presentation
  25. 3.01: Introduction
  26. 3.02: Font and Number Formatting
  27. 3.03: Alignment Borders and Cell Styles
  28. 3.04: Themes and Cell Formatting
  29. 3.05: Conditional Formatting Basics
  30. 3.06: Printing for Reports
  31. 3.07: Printing and Page Layout Features
  32. 3.08: Accessibility and Professional Standards
  33. 3.09: Conclusion
  34. 3.10: End of Module Resources
  35. 3.11: Hands-on Exercise - Formatting a Monthly Budget Report
  36. 3.12: Real World Applications
  37. 04: Business and Financial Functions
  38. 4.01: Introduction
  39. 4.02: Creating Financial Models in Excel
  40. 4.03: Key Financial Functions
  41. 4.04: Conclusion
  42. 4.05: End of Module Resources
  43. 4.06: Hands-on Exercise - Loan and Savings Model
  44. 4.07: Real World Applications
  45. 05: Data Management and Database Features
  46. 5.01: Introduction
  47. 5.02: Excel as a Flat Database- Tables and Structured References
  48. 5.03: Conclusion
  49. 5.04: End of Module Resources
  50. 5.05: Hands-on Exercise - Small Business Freelance
  51. 5.06: Real World Applications
  52. 06: Charts and Visualizations
  53. 6.01: Introduction
  54. 6.02: Creating and Customizing Charts
  55. 6.03: Creating Column Line and Pie Charts
  56. 6.04: Chart Elements and Design
  57. 6.05: Combining Charts with Formulas
  58. 6.06: PivotCharts for Dynamic Visualization
  59. 6.07: Design Best Practices- Choosing the Right Chart Type
  60. 6.08: Inserting Images Shapes and SmartArt
  61. 6.09: Conclusion
  62. 6.10: End of Module Resources
  63. 6.11: Hands-on Exercise - Sales Dashboard with Dynamic Charts
  64. 6.12: Real World Applications
  65. 07: Analyzing and Troubleshooting Data
  66. 7.01: Introduction
  67. 7.02: PivotTables for Data Analysis
  68. 7.03: What-If Analysis- Goal Seek and Scenario Manager
  69. 7.04: Common Errors in Excel
  70. 7.05: Formula Auditing Tools
  71. 7.06: Spreadsheet Best Practices
  72. 7.07: Conclusion
  73. 7.08: End of Module Resources
  74. 7.09: Hands-on Exercise - Mini Decision Lab (Pivot What-If Audit)
  75. 7.10: Real World Applications
  76. 08: Macros and Automations
  77. 8.01: Introduction
  78. 8.02: What Are Macros When Should You Automate
  79. 8.03: Recording Your First Macro
  80. 8.04: Assigning a Macro to a Button or Shape
  81. 8.05: Saving Macro-Enabled Workbooks (.xlsm)
  82. 8.06: VBA Basics (Awareness) and Security
  83. 8.07: Simple Automation Examples
  84. 8.08: Conclusion
  85. 8.09: End of Module Resources
  86. 8.10: Hands-on Exercise - One-Click Report Kit
  87. 8.11: Real World Applications