See How TTS Excel Training Makes Consulting Teams Better, Faster and More Efficient.
Our custom eBook explores the important ways Excel training programs prepare new hires for success and up-skill current employees. See how being desk-ready can boost productivity and retain and motivate your team to grow your business.
Key Topics Covered:
- Modeling and Best Practices
- Preparing Client Data for Analysis
- Analyzing Data in Excel
- Charting
- Using Cell Formats (historical, input, calculation etc.)
Additional Topics:
- Data Storytelling
- Automation Using VBA
- Python for Data Analysis
- Google Sheets
“Great class. I learned more in 1.5 days than my entire Excel career” -TTS Excel studentÂ
Ready to make an impact on your team’s proficiency with Excel?Â
Contact us today to learn how we enable productivity for the most prestigious consulting firms in the world…
A Leading Strategy House recently retained us to help develop a new Excel training and development program.
Sample Management Consultant TTS Excel Training Topics:
Excel and Modeling Best Practices:
Excel tips and tricks
- Key Excel settings
- Productivity-enhancing keyboard shortcuts
- Navigation and selecting
- Copy and pasting (including Paste Special)
- Formula construction and editing
- Core functions (e.g. SUM; MAX; MIN)
- Formatting
- Excel speed and accuracy test
Working with Client Data
- Text to columns
- Text functions: LEFT, RIGHT, MID, FIND, UPPER, LOWER, CONCATENATE
Analyzing Data in Excel
- Lookup functions (VLOOKUP, HLOOKUP, XLOOKUP)
- INDEX and MATCH functions
- Analysis of data (IF, SUMIFS, COUNTIFS, Nested IFS, SUMPRODUCT)
- Pivot Tables
- Introduction to Pivot Tables
- Inserting calculated fields
Visual Basic & Macros
- Introduction to VBA
- Creating macros using the macro recorder
