Illustrated Microsoft® Office 365® & Excel 2019 Comprehensive 1st Edition By Lynn Wermers | eBook [PDF]

Document Content and Description Below

eBook for Illustrated Microsoft® Office 365® & Excel 2019 Comprehensive, 1st Edition By Lynn Wermers Get all 12 Chapters eBook PDF. Table of Contents Excel 2019 Module 1: Getting Started w... ith Excel Explore Excel Enter Data Edit Data Copy and Move Cell Data Enter Formulas and Use AutoSum Copy Formulas with Relative Cell References Copy Formulas with Absolute Cell References Enter a Formula with Multiple Operators Insert a Function Switch Worksheet Views Choose Print Options Practice Module 2: Formatting a Worksheet Format Values Change Font and Font Size Change Font Styles and Alignment Adjust Column Width Insert and Delete Rows and Columns Apply Colors, Borders, and Documentation Apply Conditional Formatting Rename and Move a Worksheet Check Spelling Practice Module 3: Analyzing Data Using Formulas Enter a Formula Using the Quick Analysis Tool Build a Logical Formula with the IF Function Build a Logical Formula with the AND Function Round a Value with a Function Build a Statistical Formula with the COUNTA Function Enter a Date Function Work with Equation Tools Control Worksheet Calculations Practice Module 4: Working with Charts Plan a Chart Create a Chart Move and Resize a Chart Change the Chart Design Change the Chart Layout Format a Chart Create a Pie Chart Summarize Data with Sparklines Identify Data Trends Practice Module 5: Working with Tables Create and Format a Table Add and Delete Table Data Sort Table Data Use Formulas in a Table Filter a Table Look Up Values in a Table Summarize Table Data Validate Table Data Practice Module 6: Managing Workbook Data View and Arrange Worksheets Protect Worksheets and Workbooks Save Custom Views of a Worksheet Prepare a Workbook for Distribution Insert Hyperlinks Save a Workbook for Distribution Work with Grouped Data Work with Grouped Worksheets Practice Module 7: Working with Images and Integrating with Other Programs Plan a Data Exchange Import a Text File Import Data from Another Workbook Import a Database Table Link Worksheet Data to a Word Document Link an Excel Chart to a PowerPoint Slide Import Excel Data into Access Insert a Graphic File in a Worksheet Practice Module 8: Analyzing Data with PivotTables Plan and Design a PivotTable Report Create a PivotTable Report Change a PivotTable's Summary Function and Design Filter PivotTable Data Explore PivotTable Data Relationships Create a PivotChart Report Update a PivotTable Report Use the GETPIVOTDATA Function Practice Module 9: Automating Worksheet Tasks Plan a Macro Enable a Macro Record a Macro Run a Macro Edit a Macro Assign a Macro to a Button Assign a Macro to a Command Button Assign a Macro to a Form Control Practice Module 10: Advanced Worksheet Management Create and Apply a Template Import HTML Data Create a Custom AutoFill List Work with Themes Work with Cell Comments Customize an Excel Workbook Encrypt a Workbook with a Password Work with Ideas Practice Module 11: Advanced Formulas and Functions Separate Data Using Flash Fill Sum a Data Range Based on Conditions Find Values Based on Conditions Construct Formulas Using Named Ranges Consolidate Worksheet Data Audit a Worksheet Calculate Payments with the PMT Function Practice Module 12: Performing What-If Analysis Define What-If Analysis Track What-If Analysis with Scenario Manager Generate a Scenario Summary Project Figures Using a Data Table Use Goal Seek Find Solutions Using Solver Manage Data Using a Data Model Analyze Data Using Power Pivot Practice Index [Show More]

Last updated: 7 months ago

Preview 1 out of 448 pages