eBook[PDF]

Microsoft Excel 365 Complete In Practice 2026 EverGreen Release By Randy Nordell, Kathleen Stewart, Annette Easton, Pat Graves, Amie Mayhall

$30.00
Secure checkout
Instant digital download
PDF document

Document details

Pages
1,115
File size
45.31 MB
Format
Digital PDF
Category
eBook[PDF]
About this ebook
Microsoft Excel 365 Complete: In Practice (2026 Evergreen Release) by Randy Nordell, Kathleen Stewart, and co-authors is a comprehensive, 11-chapter textbook published by McGraw Hill Higher Education. The book utilizes the Topic, Instruction, and Practice (TIP) approach to build real-world spreadsheet capabilities through SIMnet integration. [1, 2, 3]
The book is structured into an introductory module followed by 11 core chapters: [1]
Foundational Modules & Basics
  • Introduction: Windows, Office, and File Management Basics.
  • Chapter 1: Creating and Editing Workbooks: Navigating the user interface, spreadsheet layout, cell entry, and workbook management.
  • Chapter 2: Working with Formulas and Functions: Foundational arithmetic, relative and absolute cell references, and text/statistical calculations.
  • Chapter 3: Creating and Editing Charts: Presenting data visually by generating, modifying, and styling data charts. [1, 2, 3, 4]
Intermediate Data Management & Logic
  • Chapter 4: Getting and Managing Data: Organizing, sorting, filtering, and preparing external data sources within spreadsheets.
  • Chapter 5: Exploring the Data and Insert Command Tabs: Advanced data layout features and leveraging insert options to build context.
  • Chapter 6: Exploring the Function Library: Deep dive into complex logical, financial, and lookup categories. [1, 2]
Collaboration, Automation & Advanced Analysis
  • Chapter 7: Working with Templates, Lambdas, and Collaboration: Utilizing reusable layouts, defining custom variables via LAMBDA, and co-authoring real-time changes with others. [1, 2]
  • Chapter 8: Working with Macros and Office Scripts: Introduction to basic automation, macro recorders, and cloud-ready scripting. [1, 2]
  • Chapter 9: Working with Data Analysis Tools: Leveraging built-in tools for advanced statistical evaluations and forecasting models. [1, 2]
  • Chapter 10: Exploring Business Intelligence: Navigating data structures via PivotTables, Power Query, data modeling, and business insights. [1, 2, 3]
  • Chapter 11: Customizing Excel and Using OneDrive and Office Online: Personalizing user interfaces, cloud storage syncing, and utilizing browser-based applications. [1, 2]

File included

PDF
tmpphp6cX4qf 45.31 MB

Topics