Microsoft Excel, Advanced

EN provides training, information, and guidance to help its members recruit, train, engage and retain associates in workplaces that value sound management practices and enlightened employer-employee relations programs.Our training services include leadership skills, team-building, service excellence, human resources issues, and computer software.

Employers Network

This class is designed for experienced Excel users who would like to advance their skills.

This hands-on class covers the skills and information needed to make complex worksheets more robust, perform advanced data analysis &amp; formula auditing, automate workbook functionality, and tap into the power of dynamic array formulas &amp; functions. It is designed for experienced Excel users who would like to advance their skills. Emphasis will be given to fully mastering Excel’s new dynamic array capabilities.Class format will provide time for the instructor to recommend best practices, explain new concepts, introduce shortcuts, and answer questions. Participants will have time to apply new skills to real world scenarios. Topics include:Prerequisite: Intermediate Excel as taught by same provider•	Using cell links to pull in data from other cells/worksheets/workbooks•	Creating formulas and functions that reference external data•	Using 3-D references to summarize ranges of data across sheets•	Collecting, compiling &amp; consolidating data from multiple locations•	Collaborating more effectively on shared workbooks•	Protecting worksheets and workbooks from unauthorized actions•	Searching for and removing potentially sensitive metadata•	Applying validation to facilitate easier and more accurate data entry•	Searching for and resolving invalid data and formula errors•	Recording simple macros to automate workbook functionality•	Selecting and implementing various lookup functions•	Retrieving related data from reference tables interactively•	Utilizing reference arrays, resultant arrays &amp; array constants•	Understanding dynamic arrays and spilled array behavior•	Understanding single &amp; multi cell array formula syntax•	Using Excel’s new dynamic array functions to work with datasets•	Tracing formula precedents and cell dependencies•	Auditing and troubleshooting formulas and functions•	Determining potential outcomes with data tables•	Using data scenarios to quickly switch between datasets •	Using goal seek to identify input needed for desired outcome•	Forecasting future data trends from existing datasets•	Micro charting individual data series with sparklines•	Visualizing geographic data over time with 3d Maps

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Microsoft Excel, Advanced

More events from Employers Network

Discover more events from Employers Network, from Business to other experiences you might love.

Microsoft Excel, Advanced

More events from Employers Network

Discover more events from Employers Network, from Business to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.