Peltier Technical Services, Inc.

Excel Power User Boot Camp

Excel Power User Boot Camps

In association with CFO.com, I will be leading several upcoming Excel Power User Boot Camps.

Excel Power User Boot Camps

The Excel Power User Boot Camp is a one-day workshop for intermediate and advanced Excel user, designed to boost your proficiency in a way that will yield immediate results. Learn advanced skills and concepts, effective use of functions and formulas, and how to use visualization techniques to gain better insight into your data and communicate clearly with others.

This class is a hands-on training session. Attendees are encouraged to bring a Windows (not Mac) laptop computer loaded with Microsoft Excel. Workbooks will be distributed with examples of techniques that will be demonstrated.

This is an opportunity to earn 8 CPE Credits.

The regular price per person is $595. Register now and save $200! Use discount code JP200 at checkout.

Specific Dates

Washington, DC

Tuesday, October 16, 2012

DoubleTree by Hilton
1515 Rhode Island Ave., NW
Washington,DC 20005

Visit CFO’s Washington DC Excel Power User Boot Camp page for more information or to reserve your seat.

Use discount code JP200 to save $200 at checkout.

Philadelphia, PA

Tuesday, October 23, 2012

Embassy Suites Hotel
Benjamin Franklin Pkwy
Philadelphia, PA 19103

Visit CFO’s Philadelphia Excel Power User Boot Camp page for more information or to reserve your seat.

Use discount code JP200 to save $200 at checkout.

Boston, MA

Wednesday, November 14, 2012

State Room
60 State Street, 33rd Floor
Boston, MA 02109

Visit CFO’s Boston Excel Power User Boot Camp page for more information or to reserve your seat.

Use discount code JP200 to save $200 at checkout.

Excel Power User Boot Camp Agenda

Breakfast (8:30am – 9:00am)

Power User Tips & Tricks (9:00am – 10:00am)

  • Tips for data preparation and manipulation
  • Performing spreadsheet audits to find hidden cells, bad formulas, and other structural problems
  • Advanced formula techniques

Advanced Pivot Table Techniques (10:00am – Noon)

  • Doing calculations inside pivot tables
  • Data visualization and conditional formatting
  • Formatting, layouts, filtering, and sorting

Working lunch (provided on-site) – Q&A with Jon Peltier (Noon – 1:00pm)

Advanced Techniques for Charting (1:00pm – 3:00pm)

  • Intelligent chart data layout
  • Effective chart formatting
  • Make charts dynamic and interactive
  • Advanced charting techniques

Dashboard Reports in Excel (3:00pm – 4:00pm)

  • Dashboard reports
  • Dashboard-specific charting techniques

Adjourn (4:00pm)

Each attendee will receive a free Excel book. It will be one of the following:

Pivot Table Data Crunching: Microsoft Excel 2010 (MrExcel Library)

Charts and Graphs: Microsoft Excel 2010 (MrExcel Library)

Excel Dashboards and Reports (Mr. Spreadsheet’s Bookshelf)

Peltier Technical Services, Inc.

Microsoft Most Valuable Professional
Excel Chart Add-Ins | Advanced Excel Training | Peltier Tech Blog

Peltier Technical Services, Inc., Copyright © 2013. All rights reserved.