FESTMAN

Tech Bootcamp

Advanced Excel for Data ​Analytics & Reporting

Master Advanced Data Analytics and Reporting ​Techniques with PivotTables, Charts, Formulas, and ​Power Query to Elevate Your Professional Skills!

100% online / in-person options

Live instructor-Lead industry experts

Cohort - Based Learning

FestMan

Approval

certified

Microsoft ​Excel ANALYST

PROFESSIONAL

Bauhaus Shape
Microsoft Excel 2019
Bauhaus Shape
data analytics

Data Analytics

data analytics

Data Visualization

Management Dashboard of Key Performance Indicators

Dasboard Design

Automated Industry Isometric Business Illustration Concept

Report Automation

Learning Paths and Dates

Flexible and immersive learning options, both online and on-site

Weekends cl​asses

Flexible | Weekends | Online/in-p​e​rson


Our part-time course is designed for​ busy people. If you don’t have 4 hou​rs to dedicate on a workday, then our part​-time course is for you. Classes on Week​ends.

Online

Sept 21, 2024 |⌛5 weeks

9am​ - 2pm including breaks

Goo​gle Meet

Pointer Map Location Vacations Travel
Pointer Map Location Vacations Travel

In person

Sept 21, 2024 |⌛5 weeks

9am - 2pm including breaks​

🏠 World Trade Centre, Accra​

Evening Cl​asses

Immersive| Workdays | Online​ ​Only


This accelerated full-time option​ will enable you to graduate in just 3 w​eeks. Commit to a rigorous schedule of 2 ​hours a day, Monday to Thur​sday.

Online

Sept 23, 2024 |⌛4 weeks

6​pm - 8pm (Mon - Thurs)

G​oogle Meet

Build real-world, job-ready skills

Our curriculum is challenging and it is designed to equip you with the in-demand skills you need to grow and succeed as a Data Professional.

Excel formulas ​and Functions

Laboratory Liquid Flask Composition

PivotTables ​and Charts

Online Website Table

Modern charts and graphs

Demographic Chart Icon

Report Automation with Power Query

analytics etl

Dashboard designing and reporting

Partners Working on Analysis

Learning options & Fees

Flexible and affordable learning options, both online and on-site

Video Conference Illustration
Checklist Illustration

Virtual Instructor-​Led

From the Comfort of Your H​o​me


Woman Attending a Video Conference

In person(Accra)

Small groups of ~5 to 10, for a personalized ​experience.


✨Save 25%​

Valid till Sept 14

Early Bird

GHS 990

1400

Access to premium ​courses & Live sessions

Check Mark Green Pointed Icon.
Check Mark Green Pointed Icon.
Check Mark Green Pointed Icon.
Check Mark Green Pointed Icon.

50% Self study

50% live sessions

Cohort - Based Learning

Access to live recording

FestMan for Business

Want to upskill your team? Speaker to our learning advisor →

Women using a Laptop

Get the support you need to transform your career

Why learn with FestMan?

Verifiable Certificate

Receive an accredited certificate upon course completion, enhancing your professional portfolio and career prospects.

Practical and hands-on training

Gain real-world experience and practical skills to prepare you for challenges in your future career.

Instructor support and active community

Access experienced instructors for guidance and support, while collaborating with peers and networking in an active learning community.

Career Options after your Bootcamp


  • Data Analyst
  • Data Scientist
  • Business Analyst
  • BI Analyst
  • Finance Analyst
  • Marketing Analyst
  • HR Analyst
Abstract Geometric Pattern Artwork
Bauhaus Shape

CURRICULUM

What you’ll learn in this data analytics bootcamp

Master data analytics and reporting with Microsoft Excel: from data cleaning to advanced modeling. Learn to craft powerful insights ​using functions, PivotTables, charts, and Power Pivot—transforming raw data into actionable business intelligence.

Business Intelligence and Data Analytics

  • Data analytics and Business Intelligence
  • Becoming a BI and Data Analyst - Skills required


Microsoft Excel fundamentals

  • Working with sheets and workbooks
  • Excel formulas and functions


Advanced Excel formulas and Functions

  • Using Defined names
  • Dynamic Arrays



Analyzing Data with PivotTables and Charts

  • Analyzing data with PivotTables and charts
  • Slicers and Timelines


Introduction to Power Query

  • Working with External Data sources such as Databases, folders, PDF etc


Cleaning and transforming Data

  • Data transformation
  • Merging and appending data
  • Grouping and summarizing data


Data Modeling and Power Pivot

  • Introduction to Data Modeling
    • Dimensions and fact tables
    • Primary and foreign keys
    • Creating and managing relationships


Analyzing Data with DAX

  • Analyzing Data with PivotTables with multiple tables


Designing automated reports and dashboards

KEY SKILLS

Hands-on and in-demand Excel skills

Data Analytics

Interactive Dashboard Design

Data visualization

Reporting automation

Data transformation

Data modeling

Trusted by Students working in Top Companies

I just created and designed an interactive dashboard on Power BI from the scratch using different AI/Machine Learning visualizations on Power BI.


Thanks, Thomas Festus Cudjoe, my wonderful instructor, FestMan™ Learning Hub, for the learning platform. It was awesome working with you.

LinkedIn Logo 蓝白领英社交媒体

Kafayat Bamishigbin

Maths tutor | Graphics designer

This was fun!


Thank you FestMan™ Learning Hub for a wonderful learning experience, teaching us how to prepare, organize, model, and visualize data (using excel) to answer business questions.


I cannot wait to share my HR analytics projects (in progress)

LinkedIn Logo 蓝白领英社交媒体

Rejoice Gorni

People Partner | HR Business Partner


Thank you FestMan™ Learning Hub for the Python for Data Science fundamentals training.


I learned about NumPy, pandas, concepts such as Dataframe, loops, sets & dictionaries, and functions.


This training is highly recommended. The learning continues with the Bootcamp in 2023.

LinkedIn Logo 蓝白领英社交媒体

Ayodeji Popoola

Data Analyst | Trade Finance Officer

I am so grateful to the entire FestMan™ Learning Hub for awarding me a scholarship for their new curated HR analytics course.


The course has expanded my knowledge of data visualization and how to use tooltips to create additional visually appealing insights in your reports.


I enjoyed every bit of the course and would gladly recommend it to anyone aspiring to develop skills in data analytics.

Bright Alorwoyie

Client Delivery and Analytics Manager at SumsureIQ

LinkedIn Logo 蓝白领英社交媒体

Thanks to Thomas Festus Cudjoe and FestMan™ Learning Hub for the detailed tutorial that guided me to design this Financial Analysis Report with Power BI, It was very helpful.

It's been fun and challenging learning with Festman in the second part of the year and their courses have been a huge blessing in improving my data analytics skillset as I transition into the data space through business problem case scenarios.


Thank you very much FestMan™ Learning Hub, and your team for putting this amazing contents together

Victor Ayodeji

Clinical physiologist

LinkedIn Logo 蓝白领英社交媒体

A Big thanks to FestMan™ Learning Hub for an opportunity to improve my skills in Power BI.


I also appreciate Thomas Festus Cudjoe for an insightful and wonderful session where I learned more on Data modeling, Data analysis, and Data Visualization.

Mary Titus

Financial reporting

/Accounting

LinkedIn Logo 蓝白领英社交媒体

FestMan™ Learning Hub has good guided projects and courses.


In this guided project, Thomas Festus Cudjoe gives a heuristic teaching experience on creating a financial dashboard in Power BI, highlighting some of the financial metrics and KPIs.

Victor Nyakako

Data Analyst

LinkedIn Logo 蓝白领英社交媒体

The idea of DAX calculations has always been intimidating for me.


After going through this project with aid of FestMan™ Learning Hub, I finally have an understanding of how DAX and time intelligence calculations are done.

Tafadzwa Chigwada

AWS Certified Cloud Practitioner


LinkedIn Logo 蓝白领英社交媒体
Woman with Curly Black Hair
Portrait of a Businessman on Grey Background
Young African Woman Smiling at Sunset
Smiling Doctor Portrait
African Woman

Join our growing community of 5,000+ Data professionals

Smiling African Business Woman Smiling outside
Close-up of a Young Afro Man Smiling.
Portrait of a Healthcare Professional
Happy Mature African American Man Smiling outside.
Portrait of a Man

FestMan Learning Hub is a digital learning platform that provides premium digital skills in Data Science, Business Intelligence, Data Analytics and Financial Modeling.


All rights reserved 2023

LinkedIn Logo 蓝白领英社交媒体
Simple Facebook Icon
Simple Instagram Icon
Simple Twitter Icon
Simple Viber Icon

22 Independence Avenue, Accra

1st Floor, World Trade Centre

Accra - Ghana

support@festman.io

+233 54 123 9290