LCT0100 - Excel for Data & Decision-Making Badge
Course Description
Take your Excel skills to the next level and learn how to turn data into meaningful insights. In this intermediate-level course, you’ll build on your existing knowledge to organize, analyze, and visualize data more effectively for real-world decision-making.
Through hands-on practice, you’ll work with formulas and functions, tables, charts, and PivotTables to uncover trends, streamline workflows, and solve common workplace challenges. You’ll also be introduced to basic forecasting tools to help interpret data and support planning.
Designed for individuals with prior Excel experience, this course emphasizes practical application—giving you the confidence to use Excel as a powerful tool for analyzing information and making informed decisions in professional settings.
Learner Outcomes
- Use advanced formulas and functions to analyze and solve real-world data problems
- Organize and manage datasets using tables, sorting, and filtering techniques
- Apply logical, text, and date functions to transform and clean data
- Create and customize charts to clearly communicate insights
- Use data validation and conditional formatting to control and highlight key information
- Work across multiple worksheets and use external references to connect data
- Analyze and summarize data using PivotTables and PivotCharts
- Apply basic forecasting and what-if analysis tools to support decision-making
- Automate repetitive tasks using simple macros
Prerequisites
Familiarity with basic Excel tasks, including entering data, formatting cells, and using simple formulas such as SUM.
Scholarship Opportunity
This digital badge program is part of a scholarship program through the Strengthening Workforce Skills program, funded by the Illinois Community College Board (ICCB)'s Noncredit Strategies at Work grant.
Apply here to find out if you are eligible for a scholarship. Funding is limited.
Applies Towards the Following Digital Badges
- Excel for Data & Decision-Making Badge : Excel for Data & Decision-Making Badge