EXCEL FOR DATA ANALYSIS
BOOTCAMP
Heritage Bank Internal
Meet the
Facilitator
• Abdulhakeem Salaudeen is an accomplished Data
Analyst and Engineer with a passion for leveraging data
to drive strategic decision-making. With proficiency in
Excel, SQL, and Python. He has a proven track record of
delivering efficient and accurate data analysis,. His
exceptional abilities lie in formulating and addressing
critical questions using data-driven insights to fuel
business growth and optimize decision-making processes
for diverse organizations.
• Abdulhakeem eexpertise lies in extracting data from
diverse sources, analysing them into valuable insights,
and presenting them through dynamic dashboards, visual
reports, and concise written narratives.. His commitment
to knowledge transfer and skill development reflects his
unwavering dedication to making a positive impact on
others and the world at large.
• I believe that data is the key to unlocking business
success, and my goal is to help businesses leverage data
to make informed decisions. Whether you need help with
data analysis, data visualization, or reporting, I can help
you turn your data into actionable insights that drive
Why this Bootcamp is for you?
Overview of the course modules
Module 1: Excel Fundamentals
Module 2: Data Cleaning and Transformation
Module 3: Statistical Analysis
Module 4: Excel VBA
Final Projects: Show Your Mastery
Module 1: Excel Fundamentals
Introduction to Excel
Navigating the interface
Creating, saving, and opening workbooks
Managing worksheets and workbooks
Basic Formatting and Data Types
Cell formatting: font, colour, alignment
Data types and Number formats : text, numbers, dates, currency, percentages
Conditional formatting for enchanting visuals
Format painter, Ctrl + Alt + V
Module 1: Excel Fundamentals (cont’d)
Formulas and Functions
Basic arithmetic formulas and aggregation functions
Cell referencing, Trace precedents and dependents
Keyboard shortcuts
Flash Fill (transforming data with a flick of the wand)
Ctrl shortcuts (D, E, F, R, T) for fast actions
F4 to repeat any action
Data Validation, Text to column
Ensuring data accuracy with validation
Module 2: Data Cleaning and Transformation
Importance of Clean data
Techniques for data cleaning
Using Find & Replace
Text to Columns, and Removing Duplicates
Advanced Data Management
Sorting and filtering data
Conditional formatting for data visualization
Data validation and error checking
Module 3: Pivot Tables, Power Query, and
Power Pivot
Pivot Tables
What is a Pivot Table?
Creating and customizing Pivot Tables
Analysing data with Pivot Tables
Using Pivot Charts
Power Query
Introduction to Power Query
Importing and transforming data from various sources
Automating data preparation workflows
Extracting, transforming, and loading data
Cleaning and merging
Module 4: Statistical Analysis with Excel
Descriptive Statistics:
Mean, Médian, Mode
Variance, Standard Déviation
Advanced Statistics
Hypothesis Testing: T-test, F-test, Z-test
ANOVA
Correlation Analysis
Module 5: Excel VBA (Macros for
Automation)
Introduction to VBA:
Recording Macros
Editing Macros
Automation with VBA
Loops and Conditional Statements
User Forms for Interaction
Error Handling in VBA
Thank You !