Microsoft Excel step by step (Office 2021 and Microsoft 365)
Book - 2022
Presents an overview of the latest version of the spreadsheet program, describing how to build worksheets, import data, filter information, create charts and tables, and use basic formulas and functions.
Saved in:
- Subjects
- Genres
- Handbooks and manuals
- Published
-
[London, England] :
Pearson Education, Inc
[2022]
- Language
- English
- Main Author
- Other Authors
- Item Description
- Includes index.
"Published with the authorization of Microsoft Corporation"--Title page verso. - Physical Description
- xxii, 458 pages : illustrations ; 24 cm
- ISBN
- 9780137564279
- Acknowledgments
- About the author
- Introduction
- Who this book is for
- The Step by Step approach
- Features and conventions
- Download the practice files
- Sidebar: Adapt exercise steps
- E-book edition
- Get support and give feedback
- Errata and support
- Stay in touch
- Part 1. Create and format workbooks
- 1. Set up a workbook
- Create workbooks
- Modify workbooks
- Modify worksheets
- Merge and unmerge cells
- Customize the Excel app window
- Manage the ribbon
- Manage the Quick Access Toolbar
- Customize the status bar
- Change the magnification level of a worksheet
- Arrange multiple workbook windows
- Skills review
- Practice tasks
- 2. Work with data and Excel tables
- Enter and revise data
- Manage data by using Flash Fill
- Move data within a workbook
- Sidebar: Quickly access data-formatting commands
- Find and replace data
- Correct and fine-tune data
- Define Excel tables
- Skills review
- Practice tasks
- 3. Perform calculations on data
- Name data ranges
- Sidebar: Operators and precedence
- Create formulas to calculate values
- Summarize data that meets specific conditions
- Copy and move formulas
- Create array formulas
- Find and correct errors in calculations
- Configure automatic and iterative calculation options
- Skills review
- Practice tasks
- 4. Change workbook appearance
- Format cells
- Define and manage cell styles
- Apply and modify workbook themes
- Apply and modify table styles
- Make numbers easier to read
- Change the appearance of data based on its value
- Add images to worksheets
- Skills review
- Practice tasks
- Part 2. Analyze and present data
- 5. Manage worksheet data
- Filter data ranges and tables
- Summarize filtered data
- Sidebar: Randomly select list rows
- Enforce data entry criteria
- Skills review
- Practice tasks
- 6. Reorder and summarize data
- Sort worksheet data
- Sort data by using custom lists
- Outline and subtotal data
- Skills review
- Practice tasks
- 7. Combine data from multiple sources
- Look up data from other locations
- Locate information in the same row (VLOOKUP)
- Locate information in the same column (HLOOKUP)
- Locate information anywhere (XLOOKUP)
- Link to data in other locations
- Consolidate multiple sets of data
- Skills review
- Practice tasks
- 8. Analyze alternative data sets
- Define and display alternative data sets
- Forecast data by using data tables
- Identify the input necessary to achieve a specific result
- Skills review
- Practice tasks
- 9. Create charts and graphics
- Create standard charts
- Create combo charts
- Create specialized charts
- Hierarchy charts
- Statistic charts
- Scatter charts
- Stock charts
- Map charts
- Customize chart appearance
- Identify data trends
- Summarize data by using sparklines
- Illustrate processes and realtionships
- Insert and manage shapes
- Sidebar: Insert mathematical equations
- Skills review
- Practice tasks
- 10. Create PivotTables and PivotCharts
- Analyze data dynamically in PivotTables
- Filter, show, and hide PivotTable data
- Edit PivotTables
- Format PivotTables
- Create dynamic PivotCharts
- Skills review
- Practice tasks
- Part 3. Collaborate and share in Excel
- 11. Print worksheets and charts
- Add headers and footers to printed pages
- Prepare worksheets for printing
- Fit your worksheet contents to the printed page
- Change page breaks in a worksheet
- Change the page printing order for worksheets
- Print worksheets
- Print parts of worksheets
- Print charts
- Skills review
- Practice tasks
- 12. Automate tasks and input
- Enable and examine macros
- Set macro security levels in Excel
- Examine macros
- Create and modify macros
- Run macros
- Assign a macro to a Quick Access Toolbar button
- Assign a macro to a shape
- Run a macro when a workbook opens
- Present information and options as form controls
- Skills review
- Practice tasks
- 13. Work with other Microsoft 365 apps
- Combine Excel, Word, and PowerPoint content
- Link from Excel to a document or presentation
- Embed file content
- Create hyperlinks from worksheets
- Copy or link to charts
- Skills review
- Practice tasks
- 14. Collaborate with colleagues
- Manage comments
- Protect workbooks and worksheets
- Finalize workbooks
- Save workbook content as a PDF file
- Create and distribute workbook templates
- Skills review
- Practice tasks
- Part 4. Perform advanced analysis
- 15. Perform business intelligence analysis
- Manage the Excel Data Model
- Sidebar: Power View data visualizations
- Define relationships between data sources
- Manage data by using Power Pivot
- Display data on timelines
- Import data by using Power Query
- Skills review
- Practice tasks
- 16. Create forecasts and visualizations
- Create forecast worksheets
- Linear forecasting
- Exponential smoothing forecasting
- Define and manage measures
- Define and display key performance indicators
- Create 3D data maps
- Skills review
- Practice tasks
- Appendix Keyboard Shortcuts
- Excel for Microsoft 365 keyboard shortcuts
- Excel function key commands
- Microsoft 365 app keyboard shortcuts
- Glossary
- Index