Microsoft Excel, Intermediate

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 covers skills and information needed to create complex worksheets and to effectively analyze, extract and present information.

It is designed for anyone who already has a strong foundational knowledge of Excel and wishes to develop greater proficiency and mastery. Emphasis will be given to the use of advanced functions and PivotTables.
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: Excel Fundamentals or equivalent knowledge
•	Using defined names to map data &amp; simplify formulas/functions
•	Identifying &amp; utilizing specialized functions on an as-needed basis
•	Decoding complex function syntax &amp; arguments
•	Using logical functions to embed decision making into calculations
•	Transitioning from standard to conditional summary functions
•	Using functions to pass argument information via nesting
•	Calculating data and time information in Excel
•	Manipulating text strings with formulas/functions
•	Sorting, filtering and subtotaling datasets
•	Converting ordinary data ranges to Table Objects
•	Using the Table Object functionality to quickly transform data
•	Leveraging dynamic ranges to minimize ongoing maintenance
•	Using formula-based conditional formatting to highlight related data
•	Selecting, creating, modifying and formatting charts
•	Creating dual-axis combo charts with forecasting &amp; trend lines
•	Determining when to Use Table Objects vs. Pivot Tables
•	Summarizing large datasets with PivotTables and PivotCharts
•	Analyzing and refining PivotTable reports
•	Switching between cross tabulation and nested outline reports
•	Redefining how summary values are calculated &amp; displayed
•	Creating interactive filters with Slicers &amp; Timelines
•	Extracting PivotTable supporting data on the fly

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, Intermediate

More events from Employers Network

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

Microsoft Excel, Intermediate

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.