Microsoft Excel is perhaps the most used business application today. Yet, many Excel users remain bogged down in yesterday’s spreadsheet practices. Participate in this session to master ten terrific features you should use to enhance your productivity with Excel.
Learning Objectives
• Identify at least three primary features associated with Power Query
• Compare examples of the benefits related to using dynamic
• Identify the necessary steps to utilize modern collaboration options in Excel arrays
• Differentiate between Solver and Scenario Manager as optimization tools
Major Topics
• Best practices for working with large volumes of data
• How to securely and efficiently collaborate with others
• Using Excel for optimization scenarios
• Creating “audit trails” in Excel
• Define “dynamic arrays” and list examples of their benefits