Excel Bootcamp

Welcome to our website! Check the latest Excel tutorials and learn how to boost your productivity.

The most powerful chart add-in for Excel is here with Sankey Diagram support. Available for Windows and Mac.

ChartEngine for Excel add-in ribbon

Excel Resources and Guides

Discover essential Excel techniques and tools with these detailed guides. From cleaning data to building dashboards and advanced charting, these articles provide clear instructions and practical examples to help you work more efficiently in Excel.

  • Excel Add-ins: Explore powerful add-ins that enhance Excel’s functionality, automate tasks, and save time for beginners and advanced users.
  • Excel Dashboard Templates: Learn how to create interactive and visually appealing dashboards that help with data tracking, visualization, and reporting.
  • Excel Chart Templates: Discover chart templates that turn raw data into insightful visuals, making it easier to communicate trends and insights.
  • Excel Formulas: Dive into a comprehensive guide on Excel formulas to simplify calculations, from basic arithmetic to advanced statistical analyses.
  • Regex Functions: Master regex functions to handle complex data manipulations, extract specific patterns, and clean data efficiently.
  • Excel Functions: A deep dive into Excel’s function library, covering everything from logical tests to lookup functions, making complex calculations easier.
  • Tutorials: Follow step-by-step tutorials for mastering Excel features and techniques tailored to beginners and power users.
  • Shortcuts: Improve productivity by learning essential Excel shortcuts, which will help you navigate, format, and analyze data with ease.
  1. How to clean data in Excel: This article is a must-read for anyone dealing with raw data. It provides a guide to removing duplicates, fixing formatting, and standardizing data for accuracy.
  2. How to create a dashboard in Excel: This guide walks through the process of building dashboards, including layout tips.
  3. XLOOKUP – The Definitive Guide: Learn how to easily use XLOOKUP, one of Excel’s most powerful lookup functions, to search for data across sheets.
  4. Conditional Formatting: Understand how to use conditional formatting to highlight trends, detect outliers, and apply rules for enhanced data analysis.
  5. Sankey Diagram: A guide on creating Sankey diagrams to visualize flow and distribution. It is perfect for understanding data movement in various fields.

Excel Bootcamp Youtube channel

Learn Excel Online – Join our YouTube channel!

We are running a fast-growing YouTube channel with 36K+ subscribers. Join the community!

You can learn more about us.