<div class="c-un-numbered-headers-and-contents-list__container"> <h3>MICROSOFT OFFICE</h3> <ul> <li><strong>Chapter 1: Microsoft Office Common Features and Windows 10 Features and File Management</strong> <ol> <li>Explore Microsoft Office</li> <li>Create a Folder for File Storage</li> <li>Download and Extract Zipped Files and Enter, Edit, and Check the Spelling of Text in an Office Program</li> <li>Perform Office Commands and Apply Office Formatting</li> <li>Finalize an Office Document</li> <li>Use the Office Help Features</li> <li>Explore Windows 10</li> <li>Prepare to Work with Folders and Files</li> <li>Use File Explorer to Extract Zipped Files and to Display Locations, Folders, and Files</li> <li>Start Programs and Open Data Files</li> <li>Create, Rename, and Copy Files and Folders</li> </ol></li> </ul> <h3>EXCEL</h3> <ul> <li>Introducing Microsoft Excel 2019</li> </ul> <ul> <li><strong>Chapter 1: Creating a Worksheet and Charting Data</strong> <ol> <li>Create, Save, and Navigate an Excel Workbook</li> <li>Enter Data in a Worksheet</li> <li>Construct and Copy Formulas and Use the SUM Function</li> <li>Format Cells with Merge & Center, Cell Styles, and Themes</li> <li>Chart Data to Create a Column Chart and Insert Sparklines</li> <li>Print a Worksheet, Display Formulas, and Close Excels</li> <li>Check Spelling in a Worksheet</li> <li>Enter Data by Range</li> <li>Construct Formulas for Mathematical Operations</li> <li>Edit Values in a Worksheet</li> <li>Format a Worksheet</li> </ol></li> <li><strong>Chapter 2: Using Functions, Creating Tables, and Managing Large Workbooks</strong> <ol> <li>Use Flash Fill and the SUM, AVERAGE, MEDIAN, MIN, and MAX Functions</li> <li>Move Data, Resolve Error Messages, and Rotate Text</li> <li>Use COUNTIF and IF Functions and Apply Conditional Formatting</li> <li>Use Date & Time Functions and Freeze Panes</li> <li>Create, Sort, and Filter an Excel Table</li> <li>View, Format, and Print a Large Worksheet</li> <li>Navigate a Workbook and Rename Worksheets</li> <li>Enter Dates, Clear Contents, and Clear Formats</li> <li>Copy and Paste by Using the Paste Options Gallery</li> <li>Edit and Format Multiple Worksheets at the Same Time</li> <li>Create a Summary Sheet with Column Sparklines</li> <li>Format and Print Multiple Worksheets in a Workbook</li> </ol></li> <li><strong>Chapter 3: Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools</strong> <ol> <li>Chart Data with a Pie Chart</li> <li>Format a Pie Chart</li> <li>Edit a Workbook and Update a Chart</li> <li>Use Goal Seek to Perform What-If Analysis</li> <li>Design a Worksheet for What-If Analysis</li> <li>Answer What-If Questions by Changing Values in a Worksheet</li> <li>Chart Data with a Line Chart</li> </ol></li> <li><strong>Chapter 4: Creating PivotTables and PivotCharts</strong> <ol> <li>Create a PivotTable Report</li> <li>Use Slicers and Search Filters</li> <li>Modify a PivotTable</li> <li>Create a PivotChart</li> <li>Create a PivotTable from a Data Model</li> <li>Create and Format a 3-D Pie PivotChart</li> </ol></li> <li><strong>Chapter 5: Managing Large Workbooks and Using Advanced Sorting and Filtering</strong> <ol> <li>Navigate and Manage Large Worksheets</li> <li>Enhance Worksheets with Themes and Styles</li> <li>Format a Worksheet to Share with Others</li> <li>Save Excel Data in Other File Formats</li> <li>Use Advanced Sort Techniques</li> <li>Use Custom and Advanced Filters</li> <li>Subtotal, Outline, and Group a List of Data</li> </ol></li> <li><strong>Chapter 6: Creating Charts, Diagrams, and Templates</strong> <ol> <li>Create and Format Sparklines and a Column Chart</li> <li>Create and Format a Line Chart</li> <li>Create and Modify a SmartArt Graphic</li> <li>Create and Modify a Funnel Chart</li> <li>Create an Excel Template</li> <li>Protect a Worksheet</li> <li>Create a Worksheet Based on a Template</li> </ol></li> <li><strong>Chapter 7: Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets</strong> <ol> <li>Use Financial Functions</li> <li>Use Goal Seek</li> <li>Create a Data Table</li> <li>Use Defined Names in a Formula</li> <li>Use Lookup Functions</li> <li>Validate Data</li> <li>Audit Worksheet Formulas</li> <li>Use the Watch Window to Monitor Cell Values</li> <li>Use the INDEX and MATCH Functions</li> </ol></li> <li><strong>Chapter 8: Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas</strong> <ol> <li>Calculate a Moving Average</li> <li>Project Income and Expenses</li> <li>Determine a Break-Even Point</li> <li>Use Solver</li> <li>Create Scenarios</li> <li>Use Logical Functions</li> <li>Create Complex Formulas</li> </ol></li> <li><strong>Chapter 9: Using Macros and Visual Basic for Applications</strong> <ol> <li>Record a Macro</li> <li>Assign a Macro to a Button on the Quick Access Toolbar</li> <li>Modify a Macro</li> <li>Write a VBA Procedure to Use an ActiveX Control</li> <li>Restore Initial Settings</li> </ol></li> <li><strong>Chapter 10: External Data, Database Functions, and Side-by-Side Tables, and Workbook Distribution and Collaboration</strong> <ol> <li>Get External Data into Excel</li> <li>Clean Up and Manage Imported Data</li> <li>Use Database Functions</li> <li>Insert a Second Table into a Worksheet</li> <li>Apply Conditional Formatting to Side-by-Side Tables</li> <li>Create Custom Headers and Footers</li> <li>Inspect a Workbook</li> <li>Use Co-Authoring and Prepare a Final Workbook for Distribution</li> </ol></li> </ul> </div>
