You are here

Applied Excel:Best Practices,Data Sets & Scenario

Applied Excel:Best Practices,Data Sets & Scenario


Training The Street
275 Madison Ave
12th Fl, Ste 1201
New York, NY 10016
Register for Course
Friday, January 18, 2019 - 4:00am


A hands-on one-day workshop focused on the efficient use of Excel; designed to build and sharpen the technical skills of organizing, sensitizing, and interpreting numbers. This intensive, hands-on workshop will benefit any professional who is focused on improving their Excel skills and efficiencies. We welcome all backgrounds and skill levels of Excel users. Course Overview This one-day Applied Excel workshop is designed to improve the participants ability to use Excel efficiently to interpret data by utilizing both basic and advanced Excel tools. Participants can dramatically improve their efficiency in data organization, allowing them spend more time interpreting and sensitizing the data, creating more value to the project team and the client. The course will start with Excel best practices and continue throughout the day to layer in more advanced Excel functionality focused on data manipulation and management. Applied Excel Outline: 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 Introduction to macros & distribution of TTS proprietary macro toolkit 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 Case Study Exercise: Designed to emphasize and reinforce skills taught during seminar What to Bring Each participant will need the following: PC Laptop* with an English version of Microsoft Excel, Word, and Adobe Acrobat Reader USB memory stick ability (for file sharing and distribution)

Register for Course

Additional Sessions