3 Hour Excel Automation Boot Camp

Loading Purplepass...

Presented By Global Wizdom

Wednesday, December 9th at 1:00pm EST

Online sale ends: 12/09/20 at 12:00pm EST

Live -Webinar

Kellogg Center 26 West Dry Creek Circle, Suite 600

Littleton, CO 80120

Select Date

-= series =-

Buy Tickets

Description

Global Wizdom is recognized by SHRM to offer Professional Development Credits (PDCs) for SHRM-CP or SHRM-SCP. This program is valid for 3 PDCs for the SHRM-CP or SHRM-SCP.

Overview:
PivotTables can help you sort and sift through large data sets to focus quickly on just the data elements that matter most to your specific needs. In addition, you will get tips on the easiest way to group your data. Most importantly, when you use the power of PivotTables, you will be saving time and making your job easier.

Areas Covered in the Session:
• Create a simple pivot table
• Change the way data is calculated in a PivotTable
• Group date data by month, year, or quarter
• Learn about slicers – the new visual way to filter PivotTables
• Format a PivotTable report for greater appeal

Speaker: Cathy Horwitz
Cathy Horwitz believes that when your employees know the capabilities of the software they use, they will demonstrate improved productivity, will be more efficient, and will be able to problem-solve more easily.

Tags: 3 Hour Boot Camp, advanced excel training, AVERAGE, COUNT, Edit the macro, Enhance your ability to perform tasks, Excel dates, Excel Formulas, Excel Functions, Excel Macros, Excel manipulative functions, excel training, Excel Workbooks, hlookup, IF statements, IFNA, INDEX, Intro to VBA, Learn statistical functions in excel, Macro Recorder, MATCH, MAX, Microsoft Excel Course, Microsoft Excel Training, MIN, Recording Excel Macros, Run a macro, SHRM, SUM, Top 10 Excel Functions, Use the macro recorder to create a macro, vba, View the recorded macro in VBA, vlookup

Presented By

Time

1:00pm to 3:00pm
Doors open at 12:30pm

Price

General Admission: $239.00

Age

21+

Venue

Live -Webinar<br> Kellogg Center 26 West Dry Creek Circle, Suite 600<br> Littleton, 80120

Capacity

100

Info Line

1-720-414-3543

Areas Covered in the Session: • Create a simple pivot table • Change the way data is calculated in a PivotTable • Group date data by month, year, or quarter • Learn about slicers – the new visual way to filter PivotTables • Format a PivotTable report for greater appeal

Speaker: Cathy Horwitz Cathy Horwitz believes that when your employees know the capabilities of the software they use, they will demonstrate improved productivity, will be more efficient, and will be able to problem-solve more easily.

Areas Covered in the Session:
• Create a simple pivot table
• Change the way data is calculated in a PivotTable
• Group date data by month, year, or quarter
• Learn about slicers – the new visual way to filter PivotTables
• Format a PivotTable report for greater appeal

Speaker: Cathy Horwitz
Cathy Horwitz believes that when your employees know the capabilities of the software they use, they will demonstrate improved productivity, will be more efficient, and will be able to problem-solve more easily.