EVENT DESCRIPTION
When learning on-the-job, Excel users understandably develop familiarity with those features that impact their output and jobs. This condensed High-intensity workshop is designed to give such users a good grounding in a broad range of features and techniques that includes productivity techniques in data management, getting familiar with the various aspects of data analysis and formula building, troubleshooting data errors, conditionality and lookups, tapping into the power tools like Pivot Tables and other productivity tools. Participants will work hands-on along with the facilitator on a practice data-file with supplied examples.
KEY TAKEAWAYS:
Managing and effectively dealing with Data
Understand data types, and the options for handling dates, time, and other kinds of data, and how to use them in formulas
Learn techniques for managing data inconsistency, and functions to clean up data
Explore the concepts of dynamic data for manually entered as well as queried data
Analysis with functions and formulas
Introducing important Functions for conditional calculations in data analysis and reports
Understand the Lookups using VLOOKUP for extracting information and merging tables
Explore tips and tricks to enhance your lookup formulas
Spreadsheet Tools for effective work
- Working with PIVOT TABLES
- Maintaining Data discipline
- Creating Pivot Tables
- Manipulating Pivot Table Fields
- Pivot Table tips and tricks for effective work
- Tips and Tricks for reporting and speedy working – keyboard shortcuts, Printing techniques, and more (spread over all modules)
WHO WILL BENEFIT
Those who work with some spreadsheet tools and want to ensure they understand a broad range of tools available for undertaking more complex activities with a heightened output.