Genesis - Excel Models - PK1
This session is modular, covered in 3, 60 mins sessions, each with industry relevant exercises and real data.
These three modules can be chosen independently but the three are designed to engage the smart entry level user and quickly sharpen their ability to analyse data and chart.
It will take the user on a journey of basic SUMIF and COUNTIF to ADVANCED FILTERING, VALIDATION and finally culminates with complex IF, AND, OR and XLOOKUPS.
Module 1 [GM01]
Mastering Formulae Charting
Sum, Average, SumIf, CountIf, AverageIf, Max, Min, Application on big data
(60 mins)
Tuesdays
Module 2 [GM02]
Sorting
FIlters - Advance Filtering
Conditional Formats
Condition Formats /Formula
Validation
Charting
(60 mins)
Tuesdays
Module 3 [GM03]
Complex Conditions & Charts
IF Statements, AND Statements, OR Statements
Combined conditions
Vlookups, Xlookups
(60 mins)
Tuesdays
Exodus - Excel Models - PK2
This session is modular, covered in 3, 60 mins sessions, each with industry relevant exercises and real data.
These three modules can be chosen independently but the three are designed to engage those whose role requires them to import, clean, analyse and model data for better business projections.
It will take the user on a journey of text and date manipulation. This will include building models in the query editor, pivoting data, creating and managing data imports and connections. We will also work with connection models that include SharePoint Online and Power BI.
Module 1 [XM01]
Date Formats
Date Functions
Time Functions
Text Functions
Combined Logic
(60 mins)
Tuesday
Module 2 [XM02]
Data Imports
Data Clean up
Creating and Manipulating Pivots
Building Models
(60 mins)
Tuesday
Module 3 [XM03]
Excel and Sharepoint
Excel models and Power BI
Data connections
Refreshing/Timing
Breaking Connections
(60 mins)
Tuesday
@ 2024 SYS
We need your consent to load the translations
We use a third-party service to translate the website content that may collect data about your activity. Please review the details in the privacy policy and accept the service to view the translations.