Microsoft Excel Advanced
Expand your Excel skills and learn how to use advanced tools for analyzing data, managing complex workbooks, and improving efficiency. This seminar is designed for participants who are ready to work with more advanced Excel functions and features.
Participants will explore techniques for auditing and protecting workbooks, working with conditional lookup and text-based functions, automating repetitive tasks with macros, and using What-If tools to evaluate different scenarios.
Available Sessions
November 20, 2026
8:30 AM–11:30 AM
Class Number
63934
Session Fee
$75.00
Location
Lakeshore College Cleveland Campus, Cedar Building
Room Number
C1336
Instructor
Jon Swanson
March 26, 2027
8:30 AM–11:30 AM
Class Number
24311
Session Fee
$75.00
Location
Lakeshore College Cleveland Campus, Cedar Building
Room Number
C1336
Instructor
Jon Swanson
Learning Outcomes
- Audit worksheets and workbooks to review formulas and identify potential issues.
- Apply workbook and worksheet protection features to help safeguard Excel files.
- Use conditional lookup functions to retrieve and analyze information.
- Apply text-based functions to work with and organize data.
- Use macros to automate repetitive Excel tasks.
- Apply What-If tools to explore different data scenarios and outcomes.
Requirements
*Participants should be comfortable with basic Excel navigation, entering and formatting data, and using basic formulas and functions. This seminar is ideal for those who have completed an introductory and intermediate Excel course or have equivalent experience.
Registration Information
Register online using your company’s billing information, or register by phone with a credit card at 920.693.1366.
For questions or additional information, contact Workforce Solutions at 920.693.1675 or email workforce.solutions@lakeshore.edu.
