TCS 211 - Intermediate Microsoft Excel
1019742
Delivery Options
Live: Zoom
Loading...
Description
This Intermediate Excel training is designed for individuals with a basic understanding of Excel who want to enhance their data management and analysis skills. Participants will learn to use the Data Analysis ToolPak, perform What-If analysis, and apply sorting and filtering techniques to organize and interpret data. The training also covers implementing data validation to ensure accuracy and building PivotTables and PivotCharts to effectively summarize and visualize information. This session is ideal for professionals looking to strengthen their ability to work with data using Excel’s more advanced features.
Program Objectives
By the end of this training, participants will be able to:
- Utilize the Data Analysis ToolPak to perform data analysis
- Create and apply What-If statements to support decision-making
- Sort and filter data to identify trends and isolate relevant information
- Apply data validation techniques to ensure accuracy and consistency
- Build and customize PivotTables and PivotCharts to summarize and visualize data effectively
Notes
Learners should have access to a PC computer with access to the most recent version of Microsoft Excel. While MS Excel is supported by Mac, instructions in this session will be provided in PC format.Loading...
Register Now
Required fields are indicated by .
Dr. Rachel Dolechek is an Assistant Professor of Business Communication at Fort Hays State University. She teaches courses in business, corporate, and managerial communication, professional development, and business education. Her research interests involve employability, business communication, and strategies for teaching and learning. Dr. Dolechek has fifteen years of teaching and advising experience across various roles in higher education. She is the recipient of the 2023-2024 Robbins College of Business and Entrepreneurship Faculty of the Year, 2023-2024 Service-Learning Faculty Fellow, and the 2023 Edmund Shearer Advisor of the Year. She previously served on the Steering Committee for the Kansas Academic Advising Network and is a member of the Association for Business Communication, Management & Organizational Behavior Teaching Society, and Phi Kappa Phi.