Presented at INFOCUS 2023
Session ID: 102640

What are the best tasks for Excel in a world with ever more demanding analytics needs? Excel is widely used in business for a broad range of functions from simple math to extremely complicated computations, but it is not a secure development platform and is prone towards formula errors, data loss/rework, and conflicting results.

This session will examine Excel’s strengths and weaknesses and explore the following:
• How to store business calculations in a central location instead of in dozens of spreadsheets.
• How to ensure security is correctly applied so that sensitive information is protected.
• How to give business users the flexibility of Excel without downloading megabytes of data into the file.
• See how built-in Excel functions (e.g. pivot tables, cube functions) can add new functionality and insights in your business.