Jon Peltier of Peltier Technical Services has developed and conducted numerous advanced Excel modules in various venues, including the wildly successful Excel Dashboard and Visualization Bootcamps, annual Excel User Conferences, and at third-party locations.
Live Excel Training
Peltier Tech has developed a series of two-hour seminars which can be presented in one day or over a period of weeks or months. Some organizations offer these seminars to their members on a monthly basis, and attendance may even earn CPE credits. All of the training described below can be presented in-person or live over video.
The four topics covered in the two-hour sessions include Excel Formulas; Tables, Pivot Tables, and Power Pivot; An Introduction to Power Query; and Excel Charting. A fifth topic, Excel VBA, is also available. The objective is to familiarize users with a broad range of features and techniques. See Live Excel Training for details on these seminars.
Peltier Tech Power Excel Seminars
Peltier Technical Services now provides Power Excel Seminars designed to increase your skills and efficiency in Excel. These seminars are typically comprised of two sessions, each three to four hours. In the morning we cover a lot of regular Excel features, including formulas, tables, charts, and pivot tables. In the afternoon we cover some of the newer and more advanced topics, such as Power Query, Power Pivot, forecasting, and features introduced in the latest Excel versions: map charts, Dynamic Arrays, and more.
These sessions cover what a lot of people call “tips and tricks”. We prefer to call them “techniques”, a less frivolous term, because there is no trick or shortcut to Excel excellence. One must learn many varied techniques and apply them often in daily work to become truly proficient. For each session, morning and afternoon, each attendee receives a book from the Mr Excel library that contains more techniques than I could possibly cover in a day, or even a week. Attendees can use the books as a resource long after the seminar.
Contact Jon at Peltier Tech for more information about the Excel Power Seminars.
Advanced Excel Charting Masterclass
The Advanced Excel Charting Masterclass is a live, full-day, hands-on workshop. We provide training materials (workbooks and presentations) and a facility with wifi and refreshments, while you bring your laptop, your questions, and even some of your own examples and questions. Topics include:
- Working with Data
- Formatting and Conditional Formatting of Charts
- Making Charts Dynamic
- Enabling User Interaction With Charts
- Dashboarding Techniques
- Enhancing Charts and the Charting Process with VBA
Contact Jon at Peltier Tech for more information about the Advanced Charting Masterclass.
Peltier Tech Customized Advanced Training
Peltier Technical Services provides professional training in advanced Excel topics. This training reaches far beyond the introductory “this is a row, this is a column” training which a motivated individual can self-teach online. These classes assume an intermediate level of competency in Excel, and build on this base to develop strong skills. The curriculum can be tailored to meet the requirements of your organization.
Peltier Tech classes are hands-on experiences, scheduled to take a half day or a full day. Attendees work on practical examples using their own notebook computers. Class materials include presentations and workbooks, as well as utilities chosen for each specific topic.
Peltier Tech has developed the following topics; click on links to see outlines and descriptions:
- Advanced Charting Techniques
- Excel Dashboard Reports
- Easy Data Analysis with Pivot Tables
- Integrating Excel and PowerPoint
- Advanced Excel Charting with VBA
- Intermediate Automation of Excel with VBA
- Advanced User Interfaces for Microsoft Office
These topics can be combined to create powerful courses, for example:
- Advanced Excel Reporting
- Excel Dashboard Reports
- Integrating Excel and PowerPoint
- Advanced Excel VBA Programming
- Intermediate Automation of Excel with VBA
- Advanced User Interfaces for Microsoft Office
- Advanced Excel Charting and Dashboards
- Advanced Charting Techniques
- Excel Dashboard Reports
In addition, these classes can be customized or enhanced to meet your organization’s specific needs. Contact Jon at Peltier Tech for more information about any of these training offerings.
Meetups and Conferences
Jon Peltier is available to speak at seminars, meetups, user group meetings, and conferences. Contact Jon at Peltier Tech for more information.