3 Hour Excel Automation Boot Camp: Pivot Tables, Top 10 Function & Formulas, Basics Macros and VBA



Key Take Away:
This training session covers THREE advanced features of Excel that provide automation within the application.

 

PivotTables make building reports a breeze. You will be introduced to the basic task of building, formatting, and refreshing PivotTables.

 

Formulas are equations that can perform calculations, return information, manipulate the contents of other cells, test conditions, and more. Explore what is considered the top 10 functions.

 

Being able to create and edit macros is one of the must-have skills for Excel Power Users. Having this knowledge will save you hours of time by allowing you to automate any Excel-based task or process. If you’ve never created macros or used VBA before, this webinar is for you.

 

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’ll get tips on the easiest way to group your data. Most importantly, when you use the power of PivotTables, you’ll 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 and Presenter Information

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.

Relevant Government Agencies

Federal Government, State & Local Government


Event Type
Webcast


This event has no exhibitor/sponsor opportunities


When
Tue, Aug 4, 2020, 1:00pm - 4:00pm ET


Cost

GW - 7575:  $239.00
GovEvents Member Price: $200.00


More GovEvents Member Deals

Website
Click here to visit event website


Organizer
Global Wizdom


Contact Event Organizer



Return to search results