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.
This intermediate-level Excel course is designed to build upon foundational Excel skills and delve into more advanced techniques. Participants will learn to leverage powerful Excel functions, formulas, and tools to efficiently analyze data, create dynamic reports, and automate tasks.
Course Outline:
Advanced Formulas and Functions
- Review of Basic Formulas and Functions: SUM, AVERAGE, COUNT, IF, VLOOKUP, HLOOKUP
- Nested Functions: Creating complex formulas by combining multiple functions
- Text Functions: TEXT, CONCATENATE, LEFT, RIGHT, MID, LEN, FIND, SEARCH
- Date and Time Functions: TODAY, NOW, DATEDIF, DATE, TIME
- Logical Functions: AND, OR, NOT
- Financial Functions: PMT, FV, PV, RATE, NPER
Data Analysis Tools
- Data Analysis Toolpak:
- PivotTables and PivotCharts:
Data Validation and Conditional Formatting
- Data Validation:
- Conditional Formatting:
Power Query
- Introduction to Power Query:
Power Pivot
- Introduction to Power Pivot:
Building relationships between tables
Cost of Course: $150
McWherter Center - 37 Alumni Drive