Microsoft Office 365 and Excel 2019 Comprehensive Study Set 2

Creating a Worksheet and a Chart

Formulas,functions,and Formatting

Working With Large Worksheets,charting,and What-If Analysis

Financial Functions,data Tables,and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating,sorting,and Querying a Table

Creating Templates,importing Data,and Working With Smartart,images,and Screenshots

Working With Trendlines,pivot Table Reports,pivotchart Reports,and Slicers

Formula Auditing,data Validation,and Complex Problem Solving

Data Analysis With Power Tools and Creating Macros

User Interfaces,visual Basic for Applications Vba,and Collaboration Features in Excel