Microsoft 365 Excel All-in-One For Dummies

Höfundar: David H. Ringstrom; Michael Alexander; Dick Kusleika; Paul McFedries; Ken Bluttman (Útgáfa: 1)
Microsoft 365 Excel All-in-One For Dummies

Kaup valmöguleikar

Get into the nitty gritty of Excel, the all-important spreadsheet tool Microsoft 365 Excel All-in-One For Dummies offers an all-new way to tackle data in Excel. Start with the basics of inputting, formatting, and organizing data and work your way to pro techniques that help with any career field or reason for using the app. Gain the skills to apply advanced formulas and functions, create stunning data visualizations, build dashboards and reports, and automate your spreadsheets.

You'll also get a glimpse into how AI tools can boost your work. Eight mini-books come together in this expanded Excel reference. With Microsoft 365 Excel All-in-One For Dummies, you'll soon be the go-to Excel guru in your office or school. Learn the basics of Excel--organizing data, performing calculations, and formatting your spreadsheet. Use functions to handle advanced math and financial analysis.

Nánar um bókina

Útgefandi
Wiley Professional Development (P&T)
ISBN
9781394344642
Print ISBN
9781394344635
Format
ePub
Útgáfa
1
Höfundar
David H. Ringstrom; Michael Alexander; Dick Kusleika; Paul McFedries; Ken Bluttman
Tungumál
English
Útgefið
2025-07-29
Prent takmörkun á líftíma
100
Prent takmörkun
10
Afritunar takmörkun
2

Kaflar

  • Cover
  • Table of Contents
  • Title Page
  • Copyright
  • Introduction
  • About This Book
  • Foolish Assumptions
  • Icons Used in This Book
  • Beyond the Book
  • Where to Go from Here
  • Book 1: Getting Started with Excel
  • Chapter 1: Getting Started with Spreadsheets
  • Exploring Excel’s User Interface
  • Entering and Editing Data
  • Handling Workbook Operations
  • Managing Worksheet Tasks
  • Collaborating with Others
  • Chapter 2: Carrying Out Basic Calculations
  • Understanding Operators
  • Exploring the Order of Operations
  • Contrasting Cell References
  • Replicating Formulas
  • Calculating Sums
  • Analyzing Data with Statistical Functions
  • Chapter 3: Formatting Cells and Worksheets
  • Applying Basic Formatting Commands
  • Exploring the Format Cells Dialog Box
  • Applying Cell Styles
  • Merging and Centering Cells
  • Wrapping Text
  • Tapping into Text Boxes
  • Inserting Images
  • Enhancing Accessibility
  • Adjusting Row Heights and Column Widths
  • Hiding and Unhiding Rows and Columns
  • Hiding and Unhiding Workbooks
  • Modifying Page Setup
  • Chapter 4: Organizing Data and Creating Tables
  • Organizing Data
  • Creating Tables
  • Chapter 5: Navigating Worksheets and Workbooks
  • Finding and Replacing Data within Cells
  • Exploring with the Navigation Task Pane
  • Jumping to Locations with Go To
  • Targeting Specific Cells with Go To Special
  • Navigating with the Name Box
  • Activating Worksheets
  • Reordering Worksheets
  • Splitting Worksheet Windows
  • Viewing Two or More Worksheets at Once
  • Applying Custom Views
  • Zooming In and Out
  • Book 2: Working with Formulas and Functions
  • Chapter 1: Tapping Into Formula and Function Fundamentals
  • Working with Excel Fundamentals
  • Gaining the Upper Hand on Formulas
  • Using Functions in Formulas
  • Chapter 2: Saving Time with Function Tools
  • Getting Familiar with the Insert Function Dialog Box
  • Finding the Correct Function
  • Entering Functions Using the Insert Function Dialog Box
  • Directly Entering Formulas and Functions
  • Chapter 3: Building Array Formulas and Functions
  • Discovering Arrays
  • Using Arrays in Formulas
  • Changing the Shape of Arrays
  • Working with Functions That Return Arrays
  • Chapter 4: Fixing Errors in Formulas
  • Catching Errors as You Enter Them
  • Auditing Formulas
  • Watching the Watch Window
  • Evaluating and Checking Errors
  • Making an Error Behave the Way You Want
  • Book 3: Going Farther with Functions
  • Chapter 1: Calculating Loans, Interest, and Depreciation
  • Understanding How Excel Handles Money
  • Figuring Loan Calculations
  • Looking into the Future
  • Depreciating the Finer Things in Life
  • Measuring Your Internals
  • Chapter 2: Performing Functional Math
  • Adding It All Together with the SUM Function
  • Rounding Out Your Knowledge
  • Leaving All Decimals Behind with INT
  • Leaving Some Decimals Behind with TRUNC
  • Looking for a Sign
  • Ignoring Signs
  • Using PI to Calculate Circumference and Diameter
  • Generating and Using Random Numbers
  • Creating a Sequence
  • Raising Numbers to New Heights
  • Multiplying Multiple Numbers
  • Summing Things Up
  • Chapter 3: Working with Date and Time Functions
  • Understanding How Excel Handles Dates
  • Formatting Dates
  • Making a Date with DATE
  • Breaking a Date with DAY, MONTH, and YEAR
  • Converting a Date from Text
  • Finding Out What TODAY Is
  • Determining the Day of the Week
  • Working with Workdays
  • Understanding How Excel Handles Time
  • Formatting Time
  • Deconstructing Time with HOUR, MINUTE, and SECOND
  • Finding the Time NOW
  • Chapter 4: Manipulating Text with Functions
  • Breaking Apart Text
  • Putting Text Together
  • Changing Text
  • Comparing, Finding, and Measuring Text
  • Book 4: Analyzing Data
  • Chapter 1: Using Basic Data Analysis Techniques
  • What Is Data Analysis, Anyway?
  • Analyzing Data with Conditional Formatting
  • Summarizing Data with Subtotals
  • Grouping Related Data
  • Consolidating Data from Multiple Worksheets
  • Chapter 2: Working with Data Analysis Tools
  • Working with Data Tables
  • Analyzing Data with Goal Seek
  • Analyzing Data with Scenarios
  • Optimizing Data with Solver
  • Chapter 3: Analyzing Table Data with Functions
  • Introducing the Database Functions
  • Retrieving a Value from a Table
  • Summing a Column’s Values
  • Counting a Column’s Values
  • Averaging a Column’s Values
  • Determining a Column’s Maximum and Minimum Values
  • Multiplying a Column’s Values
  • Deriving a Column’s Standard Deviation
  • Calculating a Column’s Variance
  • Book 5: Summarizing, Visualizing, and Illustrating Data
  • Chapter 1: Creating Charts
  • Introducing Excel Charts
  • Creating a Chart from Scratch
  • Deconstructing and Customizing Charts
  • Chapter 2: Creating and Using PivotTables
  • Understanding PivotTables
  • Exploring PivotTable Features
  • Building a PivotTable from an Excel Range or Table
  • Creating a PivotTable from External Data
  • Refreshing PivotTable Data
  • Adding Multiple Fields to a PivotTable Area
  • Pivoting a Field to a Different Area
  • Grouping PivotTable Values
  • Filtering PivotTable Values
  • Chapter 3: Performing PivotTable Calculations
  • Messing Around with PivotTable Summary Calculations
  • Working with PivotTable Subtotals
  • Introducing Custom Calculations
  • Inserting a Custom Calculated Field
  • Inserting a Custom Calculated Item
  • Editing a Custom Calculation
  • Deleting a Custom Calculation
  • Chapter 4: Building PivotCharts
  • Introducing the PivotChart
  • Creating a PivotChart
  • Working with PivotCharts
  • Book 6: Reporting and Querying Data
  • Chapter 1: Introducing Power Pivot
  • Understanding the Power Pivot Internal Data Model
  • Linking Excel Tables to Power Pivot
  • Chapter 2: Advanced Moves with PivotTables
  • Creating a PivotTable
  • Customizing PivotTable Reports
  • Understanding Slicers
  • Creating a Standard Slicer
  • Getting Fancy with Slicer Customizations
  • Controlling Multiple PivotTables with One Slicer
  • Creating a Timeline Slicer
  • Chapter 3: Working Directly with the Internal Data Model
  • Directly Feeding the Internal Data Model
  • Managing Relationships in the Internal Data Model
  • Managing Queries and Connections
  • Creating a New PivotTable Using the Internal Data Model
  • Filling the Internal Data Model with Multiple External Data Tables
  • Chapter 4: Adding Formulas to Power Pivot
  • Enhancing Power Pivot Data with Calculated Columns
  • Utilizing DAX to Create Calculated Columns
  • Understanding Calculated Measures
  • Chapter 5: Meeting Power Query and Its Connection Types
  • Power Query Basics
  • Understanding Column-Level Actions
  • Understanding Table Actions
  • Importing Data from Files
  • Importing Data from Database Systems
  • Managing Data Source Settings
  • Data Profiling with Power Query
  • Book 7: Creating Dashboards and Reports
  • Chapter 1: Getting in the Dashboard State of Mind
  • Defining Dashboards and Reports
  • Preparing for Greatness
  • A Quick Look at Dashboard Design Principles
  • Chapter 2: Building a Super Model
  • Understanding Data Modeling Best Practices
  • Finding Excel Functions That Really Deliver
  • Using Smart Tables That Expand with Data
  • Introducing Dynamic Arrays
  • Exploring Dynamic Array Functions
  • Chapter 3: Dressing Up Your Data Tables
  • Table Design Principles
  • Getting Fancy with Custom Number Formatting
  • Chapter 4: Formatting Your Way to Visualizations
  • Enhancing Reports with Conditional Formatting
  • Using Symbols to Enhance Reporting
  • Wielding the Magical Camera Tool
  • Enhancing Excel Reports with Shapes
  • Chapter 5: Displaying Performance against a Target
  • Showing Performance with Variances
  • Showing Performance against Organizational Trends
  • Using a Thermometer-Style Chart
  • Using a Bullet Graph
  • Showing Performance against a Target Range
  • Book 8: Automating Excel with Macros and VBA
  • Chapter 1: Macro Fundamentals
  • Choosing to Use a Macro
  • Recording a Macro
  • Understanding Macro Security
  • Storing and Running Macros
  • Exploring Macro Examples
  • Chapter 2: Getting Cozy with the Visual Basic Editor
  • Working in the Visual Basic Editor
  • Working with the Project Explorer
  • Working with a Code Pane
  • Customizing the VBE
  • Chapter 3: The Anatomy of Macros
  • A Brief Overview of the Excel Object Model
  • A Brief Look at Variables
  • Understanding Event Procedures
  • Error Handling in a Nutshell
  • Chapter 4: Working with Workbooks
  • Installing Macros
  • Creating a New Workbook from Scratch
  • Saving a Workbook When a Particular Cell Is Changed
  • Saving a Workbook before Closing
  • Protecting a Worksheet on Workbook Close
  • Unprotecting a Worksheet
  • Opening a Workbook to a Specific Tab
  • Opening a Specific Workbook Chosen by the User
  • Determining Whether a Workbook Is Already Open
  • Determining Whether a Workbook Exists in a Directory
  • Closing All Workbooks at Once
  • Printing All Workbooks in a Directory
  • Preventing the Workbook from Closing until a Cell Is Populated
  • Creating a Backup of the Current Workbook with Today’s Date
  • Index
  • About the Authors
  • Connect with Dummies
  • End User License Agreement