The Complete Excel Bootcamp: From Beginner to Expert

Learn essential Excel skills with a beginner's guide, including formulas, spreadsheets, charts, pivot tables, dashboards

Created by: Dee Naidoo
Data Engineer, Tableau Enthusiast, Data Analyst, Python Dev

What Will I Learn?

• Master Excel's interface and gain a comprehensive understanding of its essential tools and features.
• Develop proficiency in cell referencing and spreadsheet navigation, ensuring smooth and efficient data handling.
• Learn to create powerful formulas and functions in Excel, including popular functions like VLOOKUP, XLOOKUP, and HLOOKUP.
• Acquire the skills to clean, organize, merge, and join data in Excel effectively, making data management a breeze.
• Discover how to create insightful charts and pivot tables that represent data in a clear and visually appealing manner.
• Use pivot charts to analyze data trends and patterns, enabling data-driven decision-making.
• Build compelling dashboards to present data in a clear, concise, and visually appealing way, perfect for business professionals and analysts.
• Master printing and formatting techniques to ensure that your work in Excel is polished and professional.
• Learn to use the search and find function to locate and edit data quickly and efficiently.
• Freeze panes to make data navigation easier, allowing you to work with large datasets effortlessly.
• Unlock advanced tips and tricks to enhance your productivity in Excel, enabling you to work faster and more efficiently than ever before.

Requirements

• No Prior Excel Knowledge Required
• Microsoft Excel (Preferably 2013 onwards)

Target audience

• Beginners who are new to Excel and want to gain a comprehensive understanding of the software and learn essential tools and techniques to manage and analyze data.
• Professionals who work with data and want to improve their Excel skills to become more efficient and productive in their roles.