• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Peltier Tech

Peltier Technical Services - Excel Charts and Programming

  • Peltier Tech Consulting
  • Peltier Tech Software
  • Peltier Tech Training
  • Peltier Tech Blog
  • Twitter
  • Facebook

Live Excel Training by Video

Wednesday, August 11, 2021 by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2022, All rights reserved.
 

Video Training

All of the training topics offered by Peltier Technical Services can be presented live over video. In fact, most or all of Peltier Tech’s training activities will be done remotely until the Covid-19 pandemic has been brought under control. Peltier Tech can provide training over any video platform your organization uses, or we can set up seminars on our own Zoom account.

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.

Contact Jon at Peltier Tech for more information about Live Excel Training by Video.

Seminar Topics

Five seminar topics are listed below. Generally, the first four topics are provided: Excel Formulas; Tables, Pivot Tables, and Power Pivot; Excel Charting; and Power Query. Some clients opt into an extra session on Excel Programming with VBA. The objective is to familiarize users with a broad range of features and techniques.

Formulas and Functions, New and Old

Formulas are a worksheet’s backbone. It doesn’t make sense to discuss specific functions, since everyone’s needs are unique, but there are some topics that need to be covered. Lookup formulas, including the new XLOOKUP function. Forecasting techniques. Excel’s new Dynamic Arrays.

Tables, Pivot Tables, and Power Pivot

Tables are useful tools for managing blocks of data in Excel. They include filtering and sorting controls, and when formulas link to a Table, those formulas automatically update as the Table’s size and data change. Pivot Tables are powerful analysis tools, which can slice through data in multiple ways quickly. Power Pivot and the Data Model enable more powerful analysis.

Charting in Excel

Data visualization is an integral part of data analytics. We will cover best practices for chart source data, and techniques for working with chart data. We will discuss proper chart types for different kinds of data, and how to format charts effectively. We will learn techniques for achieving any chart feature and appearance.

An Introduction to Power Query

Data comes from a variety of different sources, in various file formats, boxed into numerous unhelpful layouts. Power Query is a set of tools for importing data and transforming it into the layout and format you need. We will build queries for cleaning up data that already exists in Excel, as well as importing and combining data from external files. Finally we will build a dashboard, using Power Query to get the data, Pivot Tables to analyze the data, Charts to display the data, and Slicers to make the data interactive.

VBA (Visual Basic for Applications)

Excel makes data analysis and manipulation easier, but many Excel tasks are slow and tedious. VBA can be used to automate many tasks, reducing time and errors. This unit will look at VBA starting with simple recorded macros, then examine the programming environment (the VBA editor), and introduce valuable concepts, such as variables, procedures, syntax, objects, and more.

Custom Topics

If your organization has specific Excel topics that you’d like covered, we can modify any existing seminars or create new ones.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Tumblr (Opens in new window)
  • Click to share on Pinterest (Opens in new window)
  • Click to share on Reddit (Opens in new window)
  • Click to print (Opens in new window)
  • Click to email a link to a friend (Opens in new window)

Posted: Wednesday, August 11th, 2021 under .
Tags: .
Comments: none

Peltier Tech Charts for Excel

Primary Sidebar

  • Peltier Tech Software
  • Peltier Tech Consulting
  • Peltier Tech Training
  • Peltier Tech Blog
  • About Peltier Tech
  • About Jon Peltier
  • Copyright and Licensing
  • Blog Comment Policy
  • Blog Privacy Policy
  • Guest Post Policy

Peltier Technical Services, Inc. Copyright © 2022 – All rights reserved.

Admin