Microsoft Excel 2019 → <div class="excel-mastery-curriculum"> <h4 style="font-weight: 500; color: #333;">01. What’s New in Excel?</h4> <ul> <li>Excel overview for newer users</li> <li>Flash Fill and Quick Analysis tools</li> <li>Customizing the Ribbon</li> <li>New Functions: TextJoin, Concat, and Insights</li> <li>Working with 3D images</li> </ul> <h4 style="font-weight: 500; color: #333;">02. ABC’s of Sort & Filter</h4> <ul> <li>Apply Simple, Top 10, and Custom Filters</li> <li>Advanced Filters: Multiple OR, Complex, and Function-Driven criteria</li> <li>Converting Ranges to Tables and adding Total Rows</li> <li>Table Styles: Formatting and creating Custom Table Styles</li> <li>Conditional Formatting essentials</li> </ul> <h4 style="font-weight: 500; color: #333;">03. Clean Your Data!</h4> <ul> <li>Text to Columns: Splitting Delimited and Fixed Width data</li> <li>Consolidating data from multiple ranges</li> <li>Generating Quick Subtotals from Tables using Data Consolidation</li> <li>Removing Duplicate values efficiently</li> </ul> <h4 style="font-weight: 500; color: #333;">04. Get inFORMed!</h4> <ul> <li>Setting up Forms and adding Dropdown Lists</li> <li>Using Group Box and Option Button controls</li> <li>Adding Combo Box controls to Worksheet Forms</li> <li>Adding Form tools to the Quick Access Toolbar</li> </ul> <h4 style="font-weight: 500; color: #333;">05. Advanced Formulas (Mathematically Challenged?)</h4> <ul> <li>Named Ranges for cleaner formulas</li> <li>Essential Functions: SUM, MAX, MIN, and IF</li> <li>Text Cleanup: TRIM, PROPER, UPPER, and LOWER</li> <li>Conditional Math: SUMIF and COUNTIF / AND</li> <li>Data Extraction: LEFT, RIGHT, and CONCATENATE</li> <li>Lookups: Master the VLOOKUP</li> <li>Monitoring cell values with the Watch Window</li> </ul> <h4 style="font-weight: 500; color: #333;">06. Hands Off My Work! (Security)</h4> <ul> <li>Password protecting workbooks from unauthorized access</li> <li>Restricting cell changes and controlling workbook modifications</li> <li>Implementing multiple passwords for tiered access levels</li> <li>Digital Signatures and Tracking Changes</li> <li>Advanced Privacy: Totally hiding cell content</li> </ul> <h4 style="font-weight: 500; color: #333;">07. Let Macros Do It!</h4> <ul> <li>Recording Macros with Absolute and Relative references</li> <li>Assigning Macros to Shapes and Button controls</li> <li>Introduction to VBA (Visual Basic for Applications)</li> </ul> <h4 style="font-weight: 500; color: #333;">08. Chart, Spark, and Pivot</h4> <ul> <li>Introduction to Charts, Sparklines, and Pictograms</li> <li>Creating and formatting Pivot Tables</li> <li>Visual Filtering: Using Slicers and Timeline controls</li> <li>Pivot Table Layouts, Subtotals, and Cell Styles</li> <li>Adding Calculated Fields to Pivot Tables</li> <li>Visualizing data with Pivot Charts</li> </ul> </div>

Stay Updated with TOIT Services