Data Analysis
Learn to interpret data, identify patterns, and extract insights that support better decisions.
Excel Analytics Bootcamp
Excel Analytics and Professional Reporting Bootcamp
A practical learning path from Tharaa Training Center focused entirely on data analysis with Microsoft Excel. Learn to organize and clean data, build PivotTables, use advanced functions, create dashboards, and complete an Excel project based on real workplace needs. The bootcamp also includes a TVTC certificate, a 60% discount on the Microsoft PL-300 certification exam, and the possibility of full exam-fee coverage for top performers based on their results.
📗
Learn Excel Through Hands-On Practice, Not Just Theory.
Create dynamic reports, PivotTables, and dashboards, and master lookup and analytical functions such as VLOOKUP and XLOOKUP.
ExcelProfessional Analytics
TVTCTVTC Certificate
60%PL-300 Exam Discount
100%For Top Performers Based on Results
What This Track Covers
Turn Excel from Spreadsheets into a Tool for Analysis and Decision-Making
Focus on the skills you need for everyday reporting, performance tracking, and organizing data at work.
Data Cleaning and Organization
Remove duplicates, handle values, organize tables, and prepare datasets for analysis.
Advanced Functions
Use date and time functions, VLOOKUP, HLOOKUP, XLOOKUP, and Excel Tables in practical scenarios.
Professional Dashboards
Design interactive dashboards that present performance indicators clearly and effectively.
Why Excel?
Excel Remains One of the Most Important Analytical Tools in Business
Many everyday business decisions begin in an Excel file: sales, expenses, inventory, HR, financial reports, and performance indicators. Mastering analytical Excel gives you a practical skill you can apply in almost any role.
1
Start by Organizing Your Data
Understand tables, format data, arrange columns, and prepare your workbook for analysis.
2
Analyze Data with PivotTables
Summarize data, make comparisons, filter results, and produce quick reports.
3
Master Excel Functions
Use lookup, date and time, table, and advanced analytical functions.
4
Build a Complete Dashboard
Turn your analysis into a clear dashboard that supports decision-making.
Training Curriculum
Excel Analytics Bootcamp Modules
A hands-on curriculum focused on data analysis with Excel, from essential skills to a complete practical project.
01
Introduction to Data Analysis with Excel
- What role does Excel play in data analysis?
- Understand data and its different types.
- Read tables and turn information into decisions.
02
Organizing and Preparing Data
- Arrange your data in Excel Tables.
- Format columns and values.
- Handle errors and duplicates.
03
Data Cleaning in Excel
- Clean text and numerical data.
- Split and merge columns.
- Prepare data before analysis.
04
Advanced Analytical Functions
- Date and Time Functions.
- VLOOKUP and HLOOKUP.
- XLOOKUP and Excel Tables.
05
PivotTables
- Build a PivotTable from scratch.
- Analyze sales, expenses, and performance.
- Filtering, grouping, and comparing results.
06
Data Visualization and Dashboards
- Professional charts.
- Slicers and timelines.
- Interactive Excel dashboards.
07
Performance Indicators and Reporting
- Understand key performance indicators (KPIs).
- Design a monthly report that is easy to update.
- Connect your analysis to a real business scenario.
08
Complete Excel Project
- A realistic dataset.
- Clean and analyze data and build PivotTables.
- Produce a presentation-ready final dashboard.
Interactive Sales Report
Analyze sales by product, region, and time period, with clear indicators of performance and growth.
Financial Performance Dashboard
Organize expenses and revenue and build a report to monitor profitability, costs, and variances.
Performance Management Dashboard
Create a final dashboard with charts, KPIs, interactive filters, and PivotTables.
Portfolio
A Presentation-Ready Project
- A professionally organized Excel workbook.
- Clearly structured worksheets for data, analysis, and the final dashboard.
- A dashboard you can showcase in interviews or use at work.
Practice
Multiple Practical Exercises
- Data cleaning.
- PivotTables.
- Lookup and analytical functions.
- Charts and a final report.
What Will You Achieve by the End of the Bootcamp?
You will be able to analyze data professionally in Excel, clean datasets, use advanced functions, build PivotTables, design charts and dashboards, and complete an Excel project that demonstrates your reporting and analytical skills. The bootcamp also includes a TVTC certificate and an exam-discount benefit for the PL-300 certification.
Bootcamp Instructors
Experts Connecting Excel Skills to the Workplace
A training team bringing together consulting, financial analytics, business intelligence, and expertise in professional reports and dashboards.
Mr. Mostafa Nabieh
Training Consultant at Tharaa Training CenterA trainer certified by Microsoft, Google, and Huawei, with over seven years of experience in training, consulting, and designing practical learning programs. He has worked as a consultant and trainer with government organizations in Saudi Arabia, Egypt, and Qatar, and connects Excel and analytical skills to workplace needs.
Mr. Afifi
Financial and Data AnalystWith over five years of practical experience in financial and data analysis, he helps turn numbers into clear decisions and performance dashboards. He holds the PL-300 and FMVA certifications and has more than 40,000 followers on LinkedIn.
Dr. Mohamed
Data Analytics and Professional Dashboard ExpertAn expert in data analysis and professional dashboard design, focused on turning raw data into clear, actionable reports. He helps learners understand performance indicators, choose suitable visualizations, and build accurate dashboards that support decisions.
Bootcamp Benefits
Accredited Certificate, PL-300 Exam Discount, and Practical Excel Skills
Combine hands-on training, a TVTC certificate, a 60% discount on the Microsoft PL-300 certification exam, and a complete Excel project you can showcase at work or in interviews.
A Special Benefit for Learners
60% Discount on the Microsoft PL-300 Exam and 100% Coverage for Top Performers
Excel Analytics Bootcamp participants receive a special 60% discount on the Microsoft PL-300 certification exam, with potential full exam-fee coverage for top performers based on achievement and assessment within the bootcamp.
60%Discount on the Microsoft PL-300 Certification Exam
100%Coverage for Top Performers Based on Performance and Assessment
TVTC Certificate
Participants receive a certificate from the Technical and Vocational Training Corporation (TVTC), enhancing the value and credibility of their training outcomes.
PL-300 Exam Discount
A 60% discount on the Microsoft PL-300 certification exam, with possible full coverage for top performers based on their bootcamp performance.
Data Cleaning
Prepare tables, correct errors, and organize data before analysis.
Advanced Functions
Use lookup, date and time, and table functions to work more efficiently.
Pivot Tables
Summarize and analyze data quickly and flexibly.
Dashboards
Build an interactive dashboard that presents results professionally.
Training Format
Flexible Learning with Clear Hands-On Practice
After enrollment, the Tharaa Training Center team will contact you with access details, follow-up information, and your training materials.
Stage 1Understand tables, clean data, and prepare it for analysis.
Stage 2Advanced functions, PivotTables, and dynamic reports.
Stage 3A complete Excel project and a presentation-ready final dashboard.
Structured Learning Plan
Progress clearly from the fundamentals to your final project.
Practical Content
Step-by-step instruction you can revisit whenever needed.
Hands-On Exercises
Practice data cleaning, formulas, and PivotTables.
Support and Follow-Up
Get help understanding exercises and preparing your final project.
Bootcamp Enrollment
Reserve Your Place and Master Excel Analytics
A practical bootcamp from Tharaa Training Center that helps you transform Excel from a data-entry tool into a powerful solution for analysis, reporting, and professional dashboards.
- Learn to clean and organize data in Excel.
- Master PivotTables and advanced functions.
- Build interactive reports and dashboards.
- Complete a presentation-ready Excel project.
- A certificate from the Technical and Vocational Training Corporation (TVTC).
- A 60% discount on the Microsoft PL-300 certification exam and possible full coverage for top performers based on performance.
Frequently Asked Questions
Before Enrolling in the Excel Bootcamp
Quick answers about bootcamp level, the final project, and registration.
Yes. It begins with data organization and the fundamentals, then progresses to functions, PivotTables, and dashboards.
Yes. This version covers Excel only, without SQL or Power BI, with a focus on practical data analysis and reporting in Excel.
Yes. You will complete a full Excel project covering data cleaning, analysis, PivotTables, charts, and a final dashboard.
Yes. Participants receive a TVTC certificate and a 60% discount on the Microsoft PL-300 certification exam, with potential full coverage for top performers based on their performance and assessment.
After enrollment, your bootcamp content will be activated in your account. The team will contact you if any follow-up details need clarification.
Start Your Journey to Mastering Excel Analytics
Learn. Practice. Build your report. Design a dashboard. Earn a TVTC certificate and benefit from a PL-300 exam discount.