Microsoft Excel Series - Part 3: Beyond IF and Excel Macros 2017

Topics

• Creating a macro that enables you to unhide all hidden worksheets within a workbook at once, instead of one at a time, through Excel`s user interface
• Comparing For, Do Until, and Do While for creating loops within Excel macros
• Formatting data and carrying out actions within your spreadsheets based on criteria you specify
• Contrasting decision-making capabilities with IF statements and the SELECT CASE function
• Utilizing Breakpoints to simplify debugging errors in your programming code
• Understanding the risks of creating loops that can put Excel into an unusable state

Who should Attend

• 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