Skip to content

Sumit0ubey/Excel_BootCamp

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

85 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

📊 Excel for Data Analytics - Excel BootCamp

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

Table of Contents

  • Worksheets
  • Workbooks
  • Ribbon
  • Menu
  • Keyboard Shortcuts
  • Formulas
  • Functions
  • Logical Functions
  • Text Functions
  • Date Functions
  • Lookup Functions
  • Math Functions
  • Statistical Functions
  • Chart Types
  • Chart Elements
  • Chart Styles
  • Chart Axes
  • Chart Layouts
  • Chart Templates
  • Tables
  • Conditional Formatting
  • Formatting
  • Collaboration
  • Pivot Tables
  • Pivot Charts
  • Pivot Tables Advanced
  • Analysis Add-ins
  • Solver
  • Scenario Manager
  • Goal Seek
  • Data Tables
  • Power Query
  • Power Query Editor
  • Power Query M Language
  • Power Query Advanced
  • Power Pivot
  • Power Pivot DAX
  • Power Pivot Data Models
  • 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

About

"Excel BootCamp: A comprehensive guide covering essential Excel functions, formulas, data analysis, and automation techniques. Perfect for beginners and professionals looking to enhance their Excel skills!"

Topics

Resources

Stars

Watchers

Forks

Contributors