Join a complimentary two-day, three-hour session, having a choice of either class individually or both concurrently with a Microsoft Certified Trainer to enhance efficiency and refine your Excel skills.  The sessions feature hands-on practice, a self-assessment lab, and access to class recordings for future review. This scalable and engaging training solution is designed to accommodate all job titles and skill levels in your Company, fostering a sense of opportunity and growth across key departments in your organization.  Registration deadline to register is Friday, April 25.

Who should attend:   Managers of all levels, Team Leaders, Human Resources, Administration, Payroll, Accountant, Bookkeeper

Here's what you can expect: 

DAY 1 - April 29 9am-12noon: Templates: Use these for design ideas

• Formula auditing: Reverse engineer your coworkers spreadsheets
• Basic Formulas and Keyboard shortcuts: Such as insert or delete rows or columns
• Autofill versus Flash Fill
• Relative and absolute references
• Data: Sort, Filter, Unique and Transpose

DAY 2 - April 30 9am-12noon: Formula Auditing: The Data Subtotal function, Group and Outline

• PivotTables: Easily summarize and report on large data sets
• Named Ranges: Simplify writing and reading complex formulas
• SumIfs and CountIfs functions: The foundation of PivotTables
• Data Validation – Create in-cell drop down lists