Key Information
SQL Bootcamp
Tableau Bootcamp (OLD)
Excel Bootcamp
$975 18 Hours
$499 14 Hours
$549 18 Hours
Learn to extract info from databases by writing SQL queries, joining tables, aggregating data, and filtering results. You’ll learn PostgreSQL in this class, but the concepts apply equally to other databases such as SQL Server and MySQL
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.
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.
Open to Beginners
Open to Beginners
Open to Beginners
185 Madison Ave, NYC or Live Online
185 Madison Ave, NYC or Live Online
185 Madison Ave, NYC or Live Online
Next start date: December 5–21, Mondays & Wednesdays, 6–9pm
Other scheduling options Weeknights or weekdays
View full schedule
Not currently scheduled
Next start date: Nov 28–30, Weekdays
Other scheduling options: Weekdays, weekends, or weeknights
View full schedule
Receive a Certificate of Completion
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 & packages only)
  • 6 HoursExcel Level I: Fundamentals
  • 6 HoursExcel Level II: Intermediate
  • 6 HoursExcel Level III: Advanced
Payment Plan See our payment plan FAQ for more details
Financing See our Leif FAQ for more details
Target Audience
  • 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

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
What You’ll Learn
  • Explore information stored in a database (tables, columns, rows, etc.) using the graphical interface of DBeaver (a popular free database app)
  • Write SQL queries to retrieve data from tables in a database
  • Combine information from multiple tables with JOIN statements
  • Filter data, group it, and sort it to extract the specific info you need
  • Advanced techniques like Subqueries, String Functions, and IF‑Else logic with CASE
  • When to use Views and User-Defined Functions instead of directly querying tables
  • Understanding Data
  • Creating Your First visualization
  • Tableau Calculations
  • Formatting Visualizations
  • Manipulating Data in Tableau
  • Advanced Visualization Tools
  • Creating Dashboards & Stories
  • Distributing & Publishing Your Visualization
  • 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