Phu Xuan University Library
|
PXU E-LIB
Sign in
CPSI10003 Microcomputer Applications 1 - Microsoft Excel

External

CPSI10003 Microcomputer Applications 1 - Microsoft Excel

This book provides a complete guide to Microsoft Excel, starting with foundational skills like navigating the interface, entering and formatting data, and using basic formulas and functions. It then builds into advanced techniques such as custom formatting, data tables, complex formulas, and What-If analysis to support deeper data evaluation and decision-making. The content also emphasizes effective data visualization through charts, sparklines, and PivotCharts, along with tools that enhance pre

Workforce
Author
LueCrecy Ragan
Publisher
Arkansas State University-Beebe
Source
LibreTexts
License
CC BY-NC-SA
Language
EN
Category
Information Technology
Read online Download PDF (open licence)
Contents· 44 sections
  1. 01: Microsoft Excel- Setting a Foundation
  2. 1.01: Microsoft Excel - Setting a Foundation Sections
  3. 1.1.01: Introduction to Microsoft Excel
  4. 1.1.02: The Excel Ribbon
  5. 1.1.03: The Excel Workbook
  6. 1.1.04: Text and Numbers in Microsoft Excel
  7. 1.1.05: Headers Footers and Page Layout
  8. 1.1.06: Renaming and Organizing Worksheets
  9. 1.1.07: Formatting and Templates in Microsoft Excel
  10. 1.1.08: Entering Selecting Sorting and Formatting Data
  11. 1.1.09: Microsoft Excel Calculations and Formulas
  12. 1.1.10: Basics- Functions and Formulas
  13. 1.1.11: Data Tables and Ranges
  14. 1.1.12: More About Formulas
  15. 1.1.13: Using Arithmetic Statistical and Logical Functions
  16. 02: Microsoft Excel- Building Proficiency
  17. 2.01: Microsoft Excel - Building Proficiency Sections
  18. 2.1.01: Advanced Formatting Techniques
  19. 2.1.02: Inserting Images Shapes and SmartArt
  20. 2.1.03: Data Tables and Ranges
  21. 2.1.04: Advanced Formulas and Functions
  22. 2.1.05: What-If Analysis
  23. 2.1.06: Logical and LookUp Functions
  24. 2.1.07: More Math Functions
  25. 2.1.08: Introduction to Charts and Visualizations
  26. 2.1.09: Creating and Customizing Charts
  27. 2.1.10: Chart Elements and Design
  28. 2.1.11: Pie Charts
  29. 2.1.12: Bar and Column Charts
  30. 2.1.13: Line Charts
  31. 2.1.14: Combining Charts with Formulas
  32. 2.1.15: Sparklines
  33. 2.1.16: PivotCharts for Dynamic Visualization
  34. 03: Microsoft Excel Overview and Emerging Features
  35. 3.01: Microsoft Excel Overview and Emerging Features Sections
  36. 3.1.01: Artificial Intelligence and Excel
  37. 3.1.02: New Tool - Solver
  38. 3.1.03: Power Power Power - Oh so much power
  39. 3.1.04: 3-D References
  40. 3.1.05: Excel Summary and Helpful Tips
  41. 3.1.06: Real World Applications
  42. 3.1.07: Excel Terminology
  43. 3.1.08: Excel Terminology Flashcards
  44. 3.1.09: Excel Hands-on Exercises