Microsoft Office & 365 Apps
Data Analysis and Visualization with Microsoft Excel
Analyse and visualise data in Excel over two days.
2 daysIntermediate10 modules
About this course
Analyse and visualise data in Excel over two days. You will clean and prepare data, analyse trends with formulas, PivotTables and PivotCharts, build interactive dashboards, apply geospatial and statistical tools and model data with Power Pivot.
What you'll learn
- Clean and prepare data using tables, formulas, and functions
- Analyze trends and patterns with PivotTables and PivotCharts
- Build interactive dashboards with slicers and timelines
- Use geospatial and statistical tools to deepen your analysis
- Model data using Power Pivot and connect multiple sources
Curriculum
10 modules
- Introduction to data science
- Create and modify tables
- Sort and filter datasets
- Create charts to represent trends and comparisons
- Format and style visualizations for clarity
- Apply best practices in chart design
- Use formulas and named ranges for efficient analysis
- Apply logical and lookup functions
- Build forms, use data validation, and automate inputs
- Build PivotTables from raw data
- Analyze, filter, and summarize results
- Use PivotCharts to visualize dynamic data
- Add slicers and timelines for interactivity
- Combine visual elements into a dashboard
- Create map charts to show data by location
- Customize and interpret map-based visuals
- Use sparklines and trendlines to show patterns
- Apply the Data Analysis ToolPak for statistical insights
- Connect to outside data sources with queries
- Clean, combine, and shape raw data for analysis
- Enable Power Pivot and load data models
- Use DAX formulas for advanced calculations
- Create relationships between datasets
- Plan and build formatted Excel reports for stakeholders
Who it's for
Excel users with foundation skills who analyse data.
Before you start
- Excel - Part 1 & 2 or equivalent experience
Part of these Alalamia diplomas
Related courses
More in Microsoft Office & 365 Apps →Intermediate
Excel - Data Analysis with Power Pivot
Microsoft Office & 365 Apps
View course →Foundation
Excel Part 1: Excel for Beginners
Microsoft Office & 365 Apps
View course →Intermediate
Excel Part 2 - Excel Intermediate
Microsoft Office & 365 Apps
View course →Advanced
Excel Part 3 - Advanced Excel
Microsoft Office & 365 Apps
View course →Advanced
55205 Mastering Microsoft Project 2016
Microsoft Office & 365 Apps
View course →Intermediate
55234 SharePoint 2016 Site Collections and Site Owner Administration
Microsoft Office & 365 Apps
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.