course | Excel & Powerpoint Advanced for Data Analysis
We turn your development needs and aspirations into powerful digital solutions that drive growth
IT-1047 | Excel & Powerpoint Advanced for Data Analysis
Course Sector : Information Technology
| Duration | Date from | Date to | Course Venue | Course fees | Book a course |
|---|---|---|---|---|---|
| 5 Days | 2025-05-19 | 2025-05-23 | Dubai | $4,250 | Book now |
| 5 Days | 2025-08-04 | 2025-08-08 | Zurich | $5,950 | Book now |
| 5 Days | 2025-12-22 | 2025-12-26 | Dubai | $4,250 | Book now |
Course Introduction
Many organizations struggle with the vast amount of data they are accumulating over the years, finding that the structure of the reports to present this data limits their use. It is why data analysis and presentation have become an emerging requirement for many businesses today. Employees are frequently asked to prepare management reports, scorecards, and dashboard charts in order to help the management in their decision-making process.
This course is designed to provide participants with the advanced levels of analysis, reporting and creating custom reports. The course will focus on topics such as tools and techniques used to perform data reporting, analysis and visualization.
Course objective
- Gain a comprehensive understanding of the principles behind data mining, power query, importing data, and organizing data.
- Use visualization techniques to improve presentation of information
- Design exceptional visualization charts, dashboards, scorecards, and flash reports
- Leverage sampling techniques from data sets using the Data Analysis command
- Learn and use techniques such as building charts, performing What-If scenarios, and using functions.
- Understand how to apply Business Intelligence tools to transform data into useful information.
- Implement multiple data parameters, particularly within Power BI
- Ensure the validity of data while locating errors or duplicates using rules and formula auditing.
Course Outline | Day 01
DATA MINING
- What is Data Mining?
- Understand Your Data
- Sources of Data
- Import External Data into Worksheet Using the Text Import Wizard
- Organizing Data
- Data Extraction using LOOKUP Functions
- Power Query
BUSINESS INTELLIGENCE (BI) TOOLS
- An Overview of BI & BI Tools
- BI Tools used by Organizations
- Using Power BI
- DATA PARAMETER
- What is parameter?
- Setting parameter
DATA QUALITY STANDARDS
- Data Validation Tool
- Validate Formulas
- Removing Duplicate Data
Course Outline | Day 02
SAMPLING TECHNIQUES
- What is Sampling?
- Loading Analysis Toolpak in Excel
- Using Analysis Toolpak to Perform Sampling
ADVANCED LISTING TECHNIQUES
- Tricks in creating dependent lists
- Dynamic selection tips
- Dynamic extraction of unique values
FACILITATING CALCULATIONS
- Dynamic and expandable named ranges
- Multi-nested functions / expandable referencing
- Structured table references / table nomenclature
- Aggregate calculation using the ‘wildcard’ technique
Course Outline | Day 03
KEY FUNCTIONS & ANALYSIS TECHNIQUES
- Math Functions SUMIFS, COUNTIFS, AVERAGEIFS
- Financial Functions using NPV, IRR, PMT, IPMT & PPMT
- What-If Analysis using Goal Seek
- What-If Analysis using Scenario Manager
- DSUM / SUMPRODUCT / SUMIFS (and building conditions)
- Advanced uses of: OFFSET / CHOOSE / INDEX / MATCH
- ROWS
- INDIRECT
FURTHER ADVANCED TECHNIQUES FOR SUMMARISING AND PRESENTING DATA
- Mini pivot table reports
- Fast calculations with data tables
- Data modelling with scenario manager
- Histogram and Pareto Charts
EXCEL DASHBOARDS (EXTRACTS)
- Creative charting techniques
- Building a visual analysis
Course Outline | Day 04
EFFECTIVE CHARTS AND VISUALIZATION
- Choosing the right chart for your message
- Customizing chart properties [a look at column charts]
- Visualize trends with line and area charts
- Show % contribution with doughnut charts
- Creating and customizing a bar chart
- Highlight lowest and highest sales month in a column chart, dynamically
- Multi-category axis (Two-Level Axis Labels)
ADDING INTERACTIVITY TO CHARTS
- Using drop-down lists for dynamic charts
- Interactive charts using combo box form controls
- Dynamic charts using option buttons
Course Outline | Day 05
VISUALLY-RICH TABLES USING CUSTOM NUMBER FORMATS AND SPECIAL FONTS
- The basics of Custom Number Formatting: The logic
- YoY growth rates using custom number formats and symbols
- Scaling numbers with CNFs e.g. 3,724,271 to 3.72M
- In-cell charts using the REPT function
- Up/Down arrows using "Wingdings 3" font
CHARTING AND VISUALISATION TECHNIQUES
- Creating dynamic labels
- Using the camera tool
- Working with formula-driven visualizations
- Using fancy fonts
- Leveraging symbols in formulas
- Working with sparklines
- Creating unconventional style charts
- Fancy thermometer charts
- Colored chart bars
BOOST’s Professional Attendance Certificate “BPAC”
BPAC is always given to the delegates after completing the training course,and depends on their attendance of the program at a rate of no less than 80%,besides their active participation and engagement during the program sessions.
Upcoming Courses In This Sector
Since 2001, we have been pioneering the training field in the Middle East, helping individuals, teams, and organizations reach their full potential with integrated solutions.
🔗 Quick Links
Sister Companies to Boost Consulting and Training
most trending
And Recommended Training Courses
We believe in progress for everyone.
We helped more than 10,000 clients over 20 countries on 4 continents in boosting their knowledge, skills, and careers.
Boost Training And Consulting All Copyrights Reserved 2025