Workshop: Excel Data Analysis & Visualization

Two-Day

Are you looking to turn your raw data into understandable visual information for better decision-making?

Data visualization refers to the process of using Excel to examine and interpret large datasets b applying various functions and tools to identify patterns and trends. The findings are then communicated by visually representing the data through charts and graphs.

Prerequisites: Familiarity using a personal computer including a mouse and keyboard, comfort working in the Windows environment, and Microsoft Excel Parts 1, and 2 or equivalent knowledge. The learner should have a fundamental understanding of Excel including how to construct formulas and functions.

What you’ll learn in this workshop:

    • Perform data analysis fundamentals.

    • Visualize data with Excel.

    • Analyze data with formulas and functions.

    • Analyze data with PivotTables.

    • Present visual insights with dashboards in Excel.

    • Perform statistical analysis.

    • Get and transform data.

    • Model and analyze data with Power Pivot.

    • Present insights with reports.