This is a one-day non-credit course offered through the Workforce Solutions department of JSCC. Non-credit courses are not eligible for financial aid, and college admission is not required.
Course Overview This course is designed for users who have a solid foundation in basic Excel functions and formulas. It will delve deeper into advanced Excel techniques, including data analysis, data visualization, and automation. Prerequisites: Basic Excel knowledge is required.
Course Outline:
Advanced Formulas and Functions
- Array Formulas
- Conditional Formatting
- Data Validation
- Lookup and Reference Functions
Data Analysis Tools
- PivotTables and PivotCharts
- Power Query:
- Power Pivot
Data Visualization
- Advanced Charting Techniques
- Power BI
Automation with VBA
- Introduction to VBA
- Automating Tasks
Cost of Course: $130
McWherter Center - 37 Alumni Drive