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.
This training session covers THREE advanced features of Excel that provide automation within the application.
Pivot Tables make building reports a breeze. You will be introduced to the basic task of building, formatting, and refreshing PivotTables.
They say that a picture is worth a thousand words. Using Excel’s Chart tools to visually display complex Excel data communicates the data’s message much more effectively to your target audience.
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.
Pivot Tables 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.
Charts and graphs are visual representations of your data. Viewing the data graphically makes the data less confusing and increases comprehension. It is easier to spot trends and patterns in your data sets. Excel charts update automatically when the data is modified, so charts are always current. Become more productive and efficient at communicating data to others.
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 Excel Automation Boot Camp, advanced excel training, Analyzing Data with Pivot Tables, Basics Macros, Cathy Horwitz, Create a Simple Pivot Table, Create Column, Define the Components of a Chart, Edit the macro, Excel Boot Camp, Excel Formulas, Excel Functions, Excel Insightful Reports, excel training, Excel Workbooks, Format a Chart, Line and Pie Charts, Macro Recorder, Mastering Excel Charts, Microsoft Excel Automation, Microsoft Excel Course, Modify a Chart, Pivot Tables, Recording Basics Excel Macros with an Introduction to VBA, Run a macro, SHRM, vba