Thư viện Trường Đại học Phú Xuân
|
PXU E-LIB
Đăng nhập
Introduction to Spreadsheets (BSOT 112)

Nguồn ngoài

Introduction to Spreadsheets (BSOT 112)

Business
Tác giả
Gabrielle Brixey
Nhà xuất bản
Coalinga College
Nguồn
LibreTexts
Giấy phép
CC BY-NC-SA
Ngôn ngữ
EN
Danh mục
Quản trị kinh doanh
Đọc trực tuyến Tải PDF (nguồn mở)
Mục lục· 87 mục
  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