Microsoft Excel Step by Step (Office 2021 and Microsoft 365)

Buy Valium From Mexico Cover Page Title Page Copyright Page Pearson’s Commitment to Diversity, Equity, and Inclusion Contents Acknowledgments About the author Introduction Who this book is for The Step by Step approach Features and conventions Download the practice files E-book edition Get support and give feedback 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 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 Find and replace data Correct and fine-tune data Define Excel tables Skills review Practice tasks 3. Perform calculations on data Name data ranges 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 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 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 Customize chart appearance Identify data trends Summarize data by using sparklines Illustrate processes and relationships Insert and manage shapes 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 Print worksheets Print parts of worksheets Print charts Skills review Practice tasks 12. Automate tasks and input Enable and examine macros Create and modify macros Run macros Present information and options as form controls Skills review Practice tasks 13. Work with other Microsoft 365 apps Combine Excel, Word, and PowerPoint 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 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 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