PC Applied Excel

Description

Learn techniques we teach around the world...

This intensive one day, hands-on workshop will benefit any professional focused on importing, preparing, analyzing and presenting data in Excel. The course will also focus on improving Excel skills and efficiencies via shortcuts and functions. We welcome all backgrounds and skill levels of Excel users.

A mix of microlectures and self-paced Excel exercises providing hands-on, real world, practical applications of the standards and methods that a professional needs.

Led by our experienced instruction team of former practitioners, you get a unique blend of industry insight combined with a passion for teaching. The average TTS instructor has been part of the team for 8.5 years.

What’s Included
Instructor-led classroom training
Ongoing instructor support
One-year online access to course materials, Excel files, and these self-study courses for additional reference and review
• Excel Best Practices
• Applied Excel

Schedule
9:00 am to 4:30 pm with an hour lunch around noon and shorter breaks throughout the day.

Prerequisites
Beyond having some basic Excel familiarity, there are no prerequisites.

What you will learn

Excel Best Practices:

• Basic Excel setup including iterations & calculations settings
• Excel best practices, including common “shortcut” keys and other efficiency tips
• Best practices for building formulas (auto sum, filling, anchoring)
• Customizing toolbars in Excel (including adding icons to your toolbar)
• Auditing formulas and cell references

Working with Client Data:

• Text to columns
• Text functions within Excel: LEFT, RIGHT, UPPER, LOWER, CONCATENATE

Analyzing Data:

• Lookup functions: VLOOKUP, HLOOKUP
• INDEX and MATCH Functions
• Analyzing data using SUMIF, COUNTIF, and Nested IF functions
• Pivot Tables

Scenario Analysis:

• Sensitivity analysis including data tables
• Conditional formatting
• Scenario analysis using CHOOSE & OFFSET functions
• Utilizing “named” cells

Macros and User Friendly Tools:

• Introduction to macros
• Introduction to Visual Basic for Applications (VBA)
• Creations of basic print macros and editing of basic VBA code
• Insertion of a “print button”