Make your data intelligent with Excel

June 26, 2018 /

Course Length: 2 Hours

What you will learn:

  1. Understand the advanced analysis features of Excel
  2. Learn about the DAX formulaic language
  3. Integrations with business intelligence platforms

In the “Analyzing and Visualizing Data with Excel” course, users are taught how to utilize Excel with its advanced capabilities. This includes learning about the formulaic language of Data Analysis Expressions (DAX) that Excel formulas are comprised of. With DAX, a user can create custom calculations for columns and fields. DAX includes additional functions and deployments intended to analyze relational data and program and deploy dynamic aggregation models. Plus, you’ll learn about the plethora of benefits that come with using Excel and the Microsoft Power BI platform, a business intelligence SaaS application sold separately.

Multidimensional data and compelling insights can give any Congressional office an in-depth understanding of who comprises their constituency, press contacts, or universe of VIPs.

Also, consider the utility Excel provides office managers; most assist Chiefs of Staff with balancing budgets, financial disclosure reporting, managing office accounts, and asset management. Office managers can utilize workbooks to track expenses via balance sheets, accounting for assets, and projecting budget forecasts from prior fiscal years’ data.

Staffers who have extensive experience with Microsoft Excel should take this course as a refresher. Additionally, junior staffers and interns should take this course as an immediate follow up to the first two training modules presented above.

Click here to access the “Analyzing and Visualizing Data with Excel” course on Microsoft Virtual Academy.

<< Previous | Next >>

Jump Ahead:

Microsoft Excel: Understanding the lifeblood of your data

Mastering the basics of Excel

Using Excel to analyze data

Using Microsoft Excel with existing Congressional SaaS platforms