Microsoft Excel Series - Part 2: Learn More about Macros 2017

Topics

• Bypassing filter drop-down lists by filtering based on cell contents with a single keystroke or mouse click
• Adding error-handling features to Excel macros to compensate for unexpected or missing data entry inputs
• Learning about Excel`s Goal Seek feature, which is useful in simplifying what-if analyses
• Understanding how to enable the Developer tab in Excel 2007 and later
• Using form controls to simplify data entry as well as control the input of other users
• Playing back macros that have been recorded to eliminate repetitive or tedious tasks
• Eliminating unwanted text using the Text to Columns feature

Who should Attend

Attendees with responsibilities in:

• Finance
• Banking
• Education
• Insurance
• IT
• Telecom
• CFOs
• CPAs
• Marketing
• Controllers
• Investments
• Sales
• Medical Devices
• Pharmaceutical
• Aviation
• FDA
• Retail
• Energy
• Logistics and Supply Chain
• Human Resource
• Audit
• Accountants