In-House Training.
Unlock the Full Potential of Your Data: Become an Excel Data Analysis with Akademi PowerPoint Malaysia. (MVP Training Resources)
| ADVANCE POWER PIVOT DATA ANALYSIS & VISUALIZATION |
Day 1:
- Introduction to Power Pivot: What is Power Pivot, and how is it different from regular Excel?
- Data Modeling with Power Pivot: Understanding data tables, relationships, and hierarchies.
- Working with Data: Importing and manipulating data, creating calculated columns and measures, and using DAX formulas.
- Data Analysis: Analyzing data with PivotTables and PivotCharts, creating custom visualizations, and using slicers and timelines.
- Advanced Techniques: Introduction to Power Query, creating and using Key Performance Indicators (KPIs), and using advanced DAX formulas.
|
Day 2:
- Advanced Data Modeling: Creating complex relationships, using many-to-many relationships, and working with time intelligence functions.
- Advanced Data Analysis: Using advanced PivotTable techniques, creating hierarchies and drill-down reports, and creating dynamic reports with PivotTables and slicers.
- Advanced Techniques: Creating and using Dynamic Arrays, working with data models in multiple workbooks, and advanced DAX formulas.
- Data Visualization: Creating dashboards with Power View and Power Map, using Power BI to create interactive reports, and creating custom templates and themes.
|
| ADVANCE PIVOT TABLE, POWER QUERY & DASHBOARD REPORTING. |
Day 1:
- Introduction to Pivot Tables: Understanding Pivot Tables, how they work, and their benefits.
- Pivot Table Basics: Creating a Pivot Table, filtering, sorting, and grouping data, and creating simple calculations.
- Advanced Pivot Table Techniques: Using Pivot Table styles and formats, creating calculated fields, using GETPIVOTDATA function, and summarizing data by date or time.
- Introduction to Power Query: Understanding Power Query and how it can help you clean and transform data before creating Pivot Tables.
- Power Query Basics: Connecting to data sources, filtering and sorting data, removing duplicates, and grouping data.
- Advanced Power Query Techniques: Combining data from multiple sources, using formulas to transform data, splitting and merging columns, and unpivoting data.
|
Day 2:
- Introduction to Dashboards: Understanding dashboards, how they work, and their benefits.
- Creating Interactive Dashboards: Creating slicers and timelines, using conditional formatting, and filtering data in Pivot Tables and charts.
- Visualizing Data: Creating charts and graphs, using sparklines and data bars, and customizing chart formats and styles.
- Interactive Dashboard Design: Designing and formatting dashboards, creating dynamic charts and tables, and using interactive controls.
- Advanced Techniques: Using macros to automate tasks, creating drill-down reports, and working with external data sources.
- Final Project: Participants will work on a final project to apply the skills and techniques learned during the training.
|
| ADVANCE EXCEL DASHBOARD REPORTING. |
Day 1:
-
Introduction to Dashboard Design: Understanding the purpose and benefits of dashboards, different types of dashboards, and how to use them effectively.
- Planning and Research: Understanding the audience, defining the message, and gathering data and information.
- Data Modeling with Power Pivot: Understanding data tables, relationships, and hierarchies.
- Data Analysis: Analyzing data with PivotTables and PivotCharts, creating custom visualizations, and using slicers and timelines.
- Dashboard Creation: Designing and creating the dashboard layout, inserting and formatting charts and tables, and adding interactive controls.
- Advanced Techniques: Using conditional formatting, creating custom formulas and calculations, and using Excel add-ins for advanced analysis.
|
Day 2:
- Advanced Data Modeling: Creating complex relationships, using many-to-many relationships, and working with time intelligence functions.
- Advanced Data Analysis: Using advanced PivotTable techniques, creating hierarchies and drill-down reports, and creating dynamic reports with PivotTables and slicers.
- Interactive Dashboards: Adding interactivity to dashboards, creating hover effects and animations, and using hyperlinks and action buttons.
- Advanced Techniques: Creating macros to automate tasks, using Power Query for data cleaning and transformation, and creating custom templates and themes.
- Final Project: Participants will work on a final project to apply the skills and techniques learned during the training.
|
| BASIC TO INTERMEDIATE MICROSOFT EXCEL 365. |
Day 1:
- Introduction to Excel: Understanding the interface, navigating Excel, and using basic functions and formulas.
- Working with Data: Entering and editing data, formatting cells and data, using AutoFill and Flash Fill, and using comments and notes.
- Basic Functions: Using basic functions such as SUM, AVERAGE, COUNT, and MAX/MIN, and using the formula bar and cell references.
- Formatting and Printing: Formatting worksheets, applying cell styles and themes, using conditional formatting, and printing worksheets.
- Basic Charts and Graphs: Creating and formatting charts and graphs, using chart elements and styles, and customizing chart types.
|
Day 2:
- Intermediate Functions: Using advanced functions such as IF, VLOOKUP, and CONCATENATE, and creating named ranges and tables.
- Data Analysis: Sorting and filtering data, using subtotals and outlining, and creating PivotTables and PivotCharts.
- What-If Analysis: Using Goal Seek, Scenario Manager, and Data Tables to perform what-if analysis.
- Advanced Formatting: Creating custom number formats, using conditional formatting with formulas, and creating custom cell styles.
- Advanced Charts and Graphs: Creating and formatting advanced charts and graphs such as histograms and heat maps.
- Final Project: Participants will work on a final project to apply the skills and techniques learned during the training.
|
| INTERMEDIATE MICROSOFT EXCEL 365. |
Day 1:
- Advanced Formulas and Functions: Using advanced functions such as IFERROR, INDEX/MATCH, and SUMIFS/COUNTIFS, and creating nested functions.
- Data Validation: Creating drop-down lists, input messages, and error alerts, and using data validation for data entry.
- Working with Large Data Sets: Filtering data, using advanced sorting techniques, using subtotals and outlining, and using conditional formatting with data bars and icon sets.
- Advanced Charting: Creating advanced charts and graphs such as scatter plots, bubble charts, and combination charts, and customizing chart types.
- Data Tables: Creating and using one- and two-variable data tables to perform sensitivity analysis and what-if analysis.
|
Day 2:
- PivotTables: Creating and formatting PivotTables, using PivotTable slicers and timelines, and creating PivotTable calculations and fields.
- PivotCharts: Creating and formatting PivotCharts, using PivotChart filters and slicers, and creating PivotChart combinations.
- Advanced Data Analysis: Using advanced conditional formatting with formulas, creating custom views and scenarios, and using data analysis add-ins such as Solver and Analysis ToolPak.
- Macros: Recording and editing macros to automate repetitive tasks, and using Visual Basic for Applications (VBA) to create custom macros.
- Final Project: Participants will work on a final project to apply the skills and techniques learned during the training.
|
|