All Courses Excel Tutorials

Excel data analysis bootcamp – FreeCourseSite

Excel data analysis bootcamp - FreeCourseSite
Excel data analysis bootcamp - FreeCourseSite

Excel data analysis bootcamp – FreeCourseSite

Microsoft Excel Course.Learn Microsoft Excel

What you’ll learn

Excel data analysis bootcamp – FreeCourseSite

  • 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

MS Excel – From 0 to Working Professional in 1 hour

Get Course Now