CPSI10003 Microcomputer Applications 1 - Microsoft Excel

by LueCrecy Ragan

Read here Read at LibreTextsPDF

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

Description from LibreTexts.

Publisher
Arkansas State University-Beebe
Subjects
Workforce
Licence
CC BY-NC-SA, as LibreTexts states it. Non-commercial use only.
Who can read
Teens 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: Microsoft Excel- Setting a Foundation
  7. 1.1: Microsoft Excel - Setting a Foundation Sections
  8. 1.1.1: Introduction to Microsoft Excel
  9. 1.1.2: The Excel Ribbon
  10. 1.1.3: The Excel Workbook
  11. 1.1.4: Text and Numbers in Microsoft Excel
  12. 1.1.5: Headers, Footers, and Page Layout
  13. 1.1.6: Renaming and Organizing Worksheets
  14. 1.1.7: Formatting and Templates in Microsoft Excel
  15. 1.1.8: Entering, Selecting, Sorting, and Formatting Data
  16. 1.1.9: Microsoft Excel Calculations and Formulas
  17. 1.1.10: Basics- Functions and Formulas
  18. 1.1.11: Data Tables and Ranges
  19. 1.1.12: More About Formulas
  20. 1.1.13: Using Arithmetic, Statistical, and Logical Functions
  21. 2: Microsoft Excel- Building Proficiency
  22. 2.1: Microsoft Excel - Building Proficiency Sections
  23. 2.1.1: Advanced Formatting Techniques
  24. 2.1.2: Inserting Images, Shapes, and SmartArt
  25. 2.1.3: Data Tables and Ranges
  26. 2.1.4: Advanced Formulas and Functions
  27. 2.1.5: What-If Analysis
  28. 2.1.6: Logical and LookUp Functions
  29. 2.1.7: More Math Functions
  30. 2.1.8: Introduction to Charts and Visualizations
  31. 2.1.9: Creating and Customizing Charts
  32. 2.1.10: Chart Elements and Design
  33. 2.1.11: Pie Charts
  34. 2.1.12: Bar and Column Charts
  35. 2.1.13: Line Charts
  36. 2.1.14: Combining Charts with Formulas
  37. 2.1.15: Sparklines
  38. 2.1.16: PivotCharts for Dynamic Visualization
  39. 3: Microsoft Excel Overview and Emerging Features
  40. 3.1: Microsoft Excel Overview and Emerging Features Sections
  41. 3.1.1: Artificial Intelligence and Excel
  42. 3.1.2: New Tool - Solver
  43. 3.1.3: Power, Power, Power - Oh, so much power!!!
  44. 3.1.4: 3-D References
  45. 3.1.5: Excel Summary and Helpful Tips
  46. 3.1.6: Real World Applications
  47. 3.1.7: Excel Terminology
  48. 3.1.8: Excel Terminology Flashcards
  49. 3.1.9: Excel Hands-on Exercises
  50. Back Matter
  51. Index
  52. Glossary
  53. Detailed Licensing
  54. Detailed Licensing