Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.
The course guides you through the basic and advanced features of Excel to help you discover the gems hidden inside. From data analysis, to visualization, the course walks you through the steps required to become a superior data analyst.
Microsoft Excel is one of the most powerful and popular data analysis desktop application on the market today. Having a deep practical knowledge of Excel will greatly increase your productivity. You will be seen as a very skilled business data analyst in the organization. And will lead to a much greater opportunities for you.
Excel is the number-one spreadsheet application, with a plethora of capabilities. If you're only using the basic features, you're missing out on a host of features that can benefit your business by uncovering important information hidden within raw data. This Excel Data Analysis course allows you to harness the full power of Excel to do all the heavy lifting for you.
The course guides you through the basic and advanced features of Excel to help you discover the gems hidden inside. From data analysis, to visualization, the course walks you through the steps required to become a superior data analyst.
By attending this ICL training course, delegates will be able to:
Understand and Identify the principles of data analysis
Build presentation ready dashboards in Excel
Apply analysis techniques to datasets in Excel
Become adept at using Excel functions and techniques for analysis
Learn how to use Pivot Tables and Pivot Charts to streamline your workflow in Excel
Use effective design principles when creating and presenting data
Learn about Excel's Ubiquity And Strategic Importance as a BI Tool
Learn about the Excel Data Model
GeoFLow
Working with External Databases
Integration with Sharepoint
Presenter-taught training in a computer lab
Online training via the platform Zoom or MS Teams
Anyone who wants to learn to apply data analysis techniques using Excel
Anyone who wants to become good at using Excel for data analysis
Anyone who wants to learn the core concepts of data analysis in Excel
Anyone who wants to learn about PowerPivot, Pivot Charts etc..
Additional information
Please bring a USB flash drive to class if you would like to make a copy of your work or any relevant class materials. Alternatively, you can save these to a cloud storage space or email them to your personal email address.
Software
Recommended operating system: Windows or Mac
Recommended software for PC: MS Excel 2013, 2016, 2019, 365
Recommended software for Mac OS: MS Excel 2016, 2019, 365
Recommended browser: Chrome
Excel as a BI Tool
Excel's Ubiquity And Strategic Importance
Excel Analytics Facilities
Data Management and Modelling: Core Excel and the Excel Data Model
Core Excel BI
DEMO: Web Queries and the Data Connection Wizard
Office Data Connections
DEMO: Managing Office Data Connections
Analysis Services Support
DEMO: Querying an OLAP Cube
The Excel Data Model
The BI Semantic Model
Data Management and Modelling: PowerPivot
Features Overview
Obtaining the Add-In, Data Import
DEMO: Data Import and Setting Relationships
Advanced Modeling
DEMO: Advanced Modeling, Querying In Excel
Data Discovery and Visualization: Power View
Overview
Creating Reports
Demo: Power View Basics
Maximize, Filters and Bubble Charts
DEMO: Filters, Bubble Charts and the Play Axis
Advanced Properties
Data Acquisition: Data Explorer
Overview, Data Sources and Tie-Ins with Excel Data Model
Data Shaping, Data Manipulation and Integrating Child Data
Demo: Importing, Shaping and Visualizing HDInsight (Hadoop) Data
Data Formulas, Scripts and the 'M' langauge
Demo: Working with Data Steps and Scripts
Mapping: GeoFlow
Overview and First Steps
Demo: Mapping the Hadoop Data
Chart Types, Controls and Visual Elements
Demo: Bubble Charts, Heat Maps, Panning, Zooming, and Themes
Layers, Scenes and Tours
Demo: Working with Layers, Building Scenes and Tours
How SharePoint Ties In
Overview and Excel Services/Excel Web App
Demo: Excel Analytics in the Excel Web App on Office 365
PowerPivot and Power View
PerformancePoint/Reporting Services, Analysis Services Clients
Wrap-Up
Review and Wrap Up