Excel Training Questionnaire | trainingdynamics

top of page

Home
Meet Peggy Ward
Custom Computer Training
Soft Skills
Coaching
Contact
Class Evaluation
More...

Use tab to navigate through the menu items.

Home
Meet Peggy Ward
Custom Computer Training
Soft Skills
Coaching
Contact
Class Evaluation
More...

Use tab to navigate through the menu items.

Excel Training Questionnaire

From the list below, please select all the areas that you would like training on.

Excel Fundamentals

Navigating and Selecting data in Excel

Creating a new Workbook

Entering and Deleting Data

Cut, Copy, and Paste Cells

Using Undo, Redo, and Repeat

Saving a Workbook

Work with mulitple sheets

Calculate across Worksheets

Use Basic Functions like AutoSum

Create basic arithmetic calculations

Absolute and Relative Cell References

Inserting and Deleting Cells, Rows and Columns

Changing the size of Rows and Columns

Adding colors and borders

Adjusting Cell Alignment

Rotating Text

Working with Number and Date Formats

Basic Conditional Formatting

Cell Merging

Freeze Panes

Prepare the workbook for printing

Excel Intermediate

Create and use Excel tables

Sort and Filter Data

Separate or combine data in columns

Remove Duplicates

Restructure data with TEXT functions like CONCATENATE

Use logical functions such as IF and SUMIF

Use VLOOKUP and IFERROR

Create simple charts and graphs

Create complex charts and graphs

Add data to a chart

Create a Pivot Table

Arrange and filter data in a Pivot Table

Create a chart from a Pivot Table

Use Slicers to create interactive Pivot Charts

Excel Advanced

Create nested IFs

Use VLOOKUP and IFERROR together

Use INDEX and MATCH for a 2D look up

Use formula auditing tools to locate and resolve errors

Use a formula for custom conditional formatting

Create scenarios using the Scenario Manager

Use Goal Seek and Solver to solve data problems

Use Data Tables

Create an interactive dashboard using pivot charts and slicers

Apply a password to open or modify a workbook

Share a workbook so it can be edited by more than one user at a time

Protect cells within a worksheet

Prevent worksheets from being deleted or modified

Record, Save and Run a Macro

Create buttons and keyboard shortcuts to trigger a macro

Make simple changes to a macro in VB editor

Edit macro code in VB Editor

Thanks for submitting!

Home
Meet Peggy Ward
Custom Computer Training
Soft Skills
Coaching
Contact
Class Evaluation
More...

Use tab to navigate through the menu items.

bottom of page