Excel Level 3: Data List Management

Master Excel data management with tables, filters, PivotTables, PivotCharts, slicers, subtotals, and dynamic array formulas. Take your Excel skills to the next level with this advanced, instructor-led course focused on managing, analyzing, and summarizing data. Learn how to work with Excel tables, sort and filter large datasets, use lookup tools, create subtotals, and build powerful PivotTables and PivotCharts. You'll also explore slicers and dynamic array formulas to make data analysis faster and more efficient. This course is ideal for professionals who regularly work with data and want to improve their reporting, analysis, and decision-making capabilities in Excel. Duration: 1 Day (8:30 AM - 4:30 PM CST) Format: Online or In-Person (Regina) Cost: $375 + GST/PST (SK) Learning Outcomes By the end of this course, participants will be able to: • Create and manage Excel tables • Sort and filter data using advanced techniques • Use lookup tools and data forms • Summarize data with subtotals and database functions • Create and customize PivotTables and PivotCharts • Use slicers for interactive filtering • Work with dynamic array formulas Course Topics Maintaining Data • Excel tables and data lists • Lookup tables • Data forms Sorting Lists • Sorting methods • Custom sort orders Filtering Lists • AutoFilter • Advanced Filter • Working with filtered data Summarizing Data • Automatic subtotals • Summary functions • Data analysis techniques Working with PivotTables • Creating and modifying PivotTables • PivotCharts • Slicers Dynamic Array Formulas • Creating dynamic lists • Sorting arrays • Filtering arrays Prerequisites Participants should have prior experience with Excel and be comfortable working with worksheets, formulas, and basic spreadsheet functions. Upcoming Session November 4 🕗 8:30 AM - 4:30 PM CST • Online • In-Person (Regina) Price: $375 + applicable taxes Cancellation & Refund Policy If you need to cancel your registration, request a refund, or discuss transfer options, please contact a MicroAge Training Specialist directly. 📧 Email: [email protected] Our team will be happy to assist with cancellations, refunds, and registration changes.