Key Information
Excel Bootcamp
SQL Bootcamp
Tableau Bootcamp
$549 21 Hours
$975 18 Hours
$499 14 Hours
Learn More
Learn More
Learn More
Download Syllabus
Overview
Learn functions, formulas, Pivot Tables, Macros, and time-saving techniques in this hands-on Excel Bootcamp. You'll conquer all the keys skills to become proficient in Microsoft Excel.
In this SQL Bootcamp, you'll learn everything from foundational concepts such as data types and basic queries to more advanced topics like aggregating and joining.
Tableau is a powerful tool, giving you full control of the look and feel of your visualizations, and helping compile your charts in the form of stories and dashboards. In this course, students are introduced to the field of data visualization and the various tools Tableau Public offers.
Prerequisite
Open to Beginners
Open to Beginners
Open to Beginners
Location
185 Madison Ave, NYC or Live Online
185 Madison Ave, NYC or Live Online
185 Madison Ave, NYC or Live Online
Scheduling Options
Weekdays, weeknights, or weekends
Weekdays, weeknights, or weekends
Not currently scheduled
Next Start Date
Jan 17–31, Sundays
January 19–21, Tuesday to Thursday, 10–5pm
Not currently scheduled
Certification
New York-licensed Certificate Program
Receive a Certificate of Completion
Receive a Certificate of Completion
Free Retake Within 1 Year See our class policies for more details
Workbook Included
Courses Included (Certificates only)
  • 7 HoursExcel Level 1
  • 7 HoursExcel Level 2
  • 7 HoursExcel Level 3
N/A
N/A
Discounts See our discounts policies for more details
  • This is a discounted package of classes that is 15–25% off the individual class prices. Other discounts do not apply.
  • Take 10% off this course if you’ve previously taken any 12+ hour course.
  • Take $100 off this course if you’re an individual paying for yourself (not reimbursed by a company).
  • Shorter courses such as this are already affordably priced and are not eligible for discounts.
Payment Plan See our payment plan FAQ for more details
Target Audience

Participants with limited to no experience in Excel looking to master Excel’s most common applications used by business professionals, including:

  • Those working in or seeking a position in that requires advanced analytical skills in Excel
  • College and graduate students looking to supplement academic coursework with practical applications of Excel in business-contexts 
  • Entrepreneurs of freelancers looking to work on advanced Excel projects
  • Leaders interested in making better data-driven decisions and “knowing the numbers”
  • Analysts looking to deepen their skillset beyond Excel and Tableau
  • Developers who want to be more comfortable working with databases
Anyone
What You’ll Learn
  • Calculations, basic functions, graphs, formatting, printing
  • Functions such as VLOOKUP and SUMIFs
  • Summarize data with Pivot Tables
  • Sort & Filter databases
  • Working with text: split & join text, dropdown menus
  • Advanced database functions such as INDEX and MATCH
  • Create basic macros
  • Use What-If Analysis for Goal Seek and Data Tables
  • Explore and alter data using a graphical user interface
  • Write queries to search through tables programmatically
  • Understand different data types and converting between them
  • Combine information across tables with join statements
  • Advanced techniques like subqueries and timestamp functions
  • Understanding Data
  • Creating Your First visualization
  • Tableau Calculations
  • Formatting Visualizations
  • Manipulating Data in Tableau
  • Advanced Visualization Tools
  • Creating Dashboards & Stories
  • Distributing & Publishing Your Visualization