Microsoft Excel 2016 Bootcamp - Zero to Hero Training

Unlock the Power of Excel: A Beginner-Friendly BootCamp

This comprehensive Microsoft Excel BootCamp is designed for beginners with no prior Excel experience. Discover how Excel can significantly enhance your professional life! We focus on practical, built-in Excel features, avoiding complex coding and confusing formulas. This project-based training will equip you with essential skills to manage and analyze data effectively.

Here's what you'll learn:

• Invoice Creation & Calculations: Start with a practical project – creating a company-branded invoice and mastering total and tax calculations in Excel.
• Data Cleaning & Formatting: Learn to efficiently clean up messy spreadsheets using Excel's automatic features, transforming raw data into usable information.
• Pivot Tables for Data Analysis: Transform complex data into easily understandable tables and graphs with powerful pivot tables. Visualize trends and insights effortlessly.
• Dropdown Menus: Create helpful dropdown menus to streamline data entry and improve data accuracy in your financial data spreadsheets.
• Professional Document Design: Learn to convert uninspiring profit and loss statements into visually appealing and user-friendly documents.
• Hands-on Projects: Apply your new skills through practical projects, including:
  • Quote & Invoicing Form: Design professional forms for generating quotes and invoices.
  • Data Cleaning & Formatting: Master techniques for cleaning and formatting imported data.
  • Inventory Spreadsheet: Create and manage an effective inventory spreadsheet.
  • Regional Sales Report: Generate insightful regional sales reports using Excel.
  • Profit & Loss Spreadsheet: Build a comprehensive profit and loss spreadsheet.
  • GST & Tax Calculations: Learn to accurately calculate GST and taxes within Excel.
  • Data Visualization: Create compelling graphs for use in Word, PowerPoint, InDesign & Illustrator.
  • Excel Integration with Word: Create spreadsheets that seamlessly integrate within Word documents.

Important Note: Please be aware that the Mac version of Excel has some differences from the PC version. Specifically, features like Flash Fill are not available on Mac. We recommend considering this if you're primarily a Mac user.