- TypeWebinar
- Location Littleton, Colorado, United States
- Date 09-12-2020
Education/Teaching/Training/Development
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.
Excel functions can greatly enhance your ability to perform tasks in day to day activities in Excel. While there are hundreds of functions is available, there are 10 functions that all Excel users should know. Whether you are an office worker, or a small business owner using Excel to keep track of your finances, or just a casual user, these Excel functions can be very important time savers and enhance your ability to create better-performing spreadsheets!
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.
Cathy teaches classes on the Microsoft suite of application software including Excel, PowerPoint, Word, Access, and Outlook. Cathy has over 30 years of experience in the classroom and virtual training and has been an instructor of Microsoft Office since 1989.
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
Global Wizdom Contact :1-720-414-3543 [email protected] https://globalwizdom.com