📊 Excel for Data Analytics - Excel BootCamp

This repo contains all the Excel files needed to follow along this Bootcamp.

Table of Contents

Chapter 1: Spreadsheets_Intro

• Worksheets
• Workbooks
• Ribbon
• Menu
• Keyboard Shortcuts

Chapter 2: Formulas & Functions

• Formulas
• Functions
• Logical Functions
• Text Functions
• Date Functions
• Lookup Functions
• Math Functions
• Statistical Functions

Chapter 3: Charts

• Chart Types
• Chart Elements
• Chart Styles
• Chart Axes
• Chart Layouts
• Chart Templates

Chapter 4: Spreadsheets Advanced

• Tables
• Conditional Formatting
• Formatting
• Collaboration

Chapter 5: Pivot Tables

• Pivot Tables
• Pivot Charts
• Pivot Tables Advanced

Chapter 6: Advanced Data Analysis

• Analysis Add-ins
• Solver
• Scenario Manager
• Goal Seek
• Data Tables

Chapter 7: Power Query

• Power Query
• Power Query Editor
• Power Query M Language
• Power Query Advanced

Chapter 8: Power Pivot

• Power Pivot
• Power Pivot DAX
• Power Pivot Data Models

Projects

• Salary Dashboard
• Job Insight Dashboard

Conclusion:

The Excel BootCamp repository serves as a comprehensive guide to mastering Excel for data analytics. Covering everything from basic spreadsheet operations to advanced data analysis techniques, it provides a structured learning path for users at all skill levels. With hands-on projects like the Salary Dashboard and Job Insight Dashboard, learners can apply their knowledge in real-world scenarios. Whether you're a beginner or an advanced user looking to enhance your data manipulation and visualization skills, this BootCamp equips you with the essential tools to excel in data analytics. 🚀

📧 Contact

For any queries, feel free to reach out via : 📩 Email