All Courses Excel Tutorials

Excel data analysis bootcamp

Excel data analysis bootcamp
Excel data analysis bootcamp

Excel data analysis Bootcamp

Microsoft Excel Course.Learn Microsoft Excel

What you’ll learn

Excel data analysis Bootcamp

  • Create dynamic reports by mastering one of the most popular tools, PivotTables
  • Maintain large sets of Excel data in a list or table
  • Learn the most common Excel functions used in the Office
  • Master Microsoft Excel from Beginner to Advanced
  • Build a solid understanding of the Basics of Microsoft Excel
  • Become an expert in excel


  • No prior knowledge is required


This course will deepen your understanding of the advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool.

While most Excel courses focus on simply what each formula does, I teach through hands-on, contextual examples designed to showcase why these formulas are fantastic and how they can be applied in several ways for the analysis of data I will teach you how to THINK like Excel. This course is a hands-on tutorial where sample Excel sheets are provided for practice.

  • Quickly build dynamic tools & Excel dashboards to filter, display and analyze your data
  • Create your own formula-based Excel formatting rules
  • Join datasets from multiple sources with LOOKUP, INDEX & MATCH functions
  • Manipulate dates, times, text, and arrays
  • Automate tedious and time-consuming tasks using cell formulas and functions in Excel (no VBA required!)
  • Pull real-time data from APIs directly into Excel (weather, stock quotes, directions, etc.)
  • Plotting charts
  • Learn how to manipulate and analyze data
  • After this course, you will have mastered the most popular Excel tools and be confident to complete any Excel tasks efficiently and gracefully. Below are just a few of the topics that you will master:
    • Creating effective spreadsheets
    • Managing large sets of data
    • Mastering the use of some of Excel’s most popular and highly sought-after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH, and many more…)
    • Create dynamic report with Excel PivotTables
    • Unlock the power and versatility of Microsoft Excel’s Add-In, PowerPivot
    • Audit Excel Worksheet formulas to ensure clean formulas
    • Automate your day-to-day Excel tasks by mastering the power of Macros and VBA
    • How to do data analysis
    • How to plot beautiful charts

Who this course is for:

  • Those who want to learn excel
  • Those who want to master excel
  • Those who want to learn data analysis using excel

Learn MS Excel and Data Analysis

Get Course Now