Onsite Excel Training for Companies

BostonExcel provides onsite Microsoft Excel training to companies of all sizes in the Boston area. Our extremely engaging and customizable Excel courses were designed to quickly get your team the skills they need to demolish any Excel spreadsheet or analysis thrown at them!

What Makes Our Courses Special?

Our customizable courses are fun, engaging, and interactive. The most common comment we receive after a training is, “Wow, I didn’t know Excel could be so much fun!”

Custom ROI Report

At the end of each training, we provide the company with a custom ROI report. Based on a pre and post quiz and a survey we give participants, we show you how much time and money our training will save your company.

Corporate Excel Bootcamp

An Excel training one of the best ways to improve the effectiveness of your team. This 6-hr training will cover intermediate and advanced topics in Excel. By the end, participants are usually 15%+ more efficient in Excel.

Topics Covered

  • Keyboard shortcuts
  • IF and nested IF statements
  • Reference formulas: VLOOKUP, INDEX/MATCH
  • Summation formulas: SUMPRODUCT, SUMIF(S), COUNTIF(S)
  • Date formulas: EOMONTH, EDATE, etc.
  • Text-to-Columns
  • PivotTables
  • Advanced Conditional Formatting
  • And more!

Data Analytics Bootcamp

In this Big Data age, it is imperative your team has the skills necessary to analyze, interpret, and present large quantities of data. This intro course to data analytics teaches these essential skills.

Topics Covered

  • Introduction to data and data analytics
  • Asking the right questions
  • Statistical tools for single and multi-variable data
  • How to clean and organize your data
  • PivotTables and Slicers
  • Regression Analysis
  • Utilizing Data Analysis to summarize data
  • PivotCharts and Slicers
  • And more!

Dynamic Dashboards Bootcamp

This course was designed to quickly teach you how to create beautiful, dynamic dashboards and how to utilize your data for forecasting. You will learn how to use different techniques to analyze and visually represent your data.

Topics Covered

  • Absolute cell references
  • IF Statements and IFERROR
  • Summation formulas: SUMIF, COUNTIF
  • Reference formulas: VLOOKUP
  • PivotTables, PivotCharts, and Slicers
  • Form controls
  • Forecasting techniques
  • And more!

VBA (Macros) Bootcamp

This course will introduce you to programming Excel using VBA macros. You will learn how you can save hours of work by automating routine or complicated tasks in Excel. NO prior programming experience required!

Topics Covered

  • Prepare your workbook to accept VBA code
  • Create sub routines to segment your code
  • Declare and call variables
  • Create For and Do Until loops
  • Create If/Then and If/Then/Else logical tests
  • Reference, open, and pull data from other workbooks
  • And more!

Our Training Clients Include:

Thank you so much! The training was super helpful and actually very enjoyable as well!

This training was awesome! The instructors were fantastic, gave great explanations, and kept the class involved and interested.

The instructors made the material fun and very engaging. The training was very interactive and helpful!

Pricing

Please fill out the information below to receive a free quote and get more information about our training program.