Skip to Content Skip to Footer

Career & Professional Development

Continuing Education

Mastering Excel Formulas and Functions and PivotTables

Dates:January 7-16, 2025
Meets:10:00 AM to 1:00 PM
Location:CE Main Campus 331
Cost: $199.00

There are still openings remaining at this time.

OR

Unlock the full potential of Excel with our comprehensive "Mastering Excel Formulas and Functions with PivotTables" course. Designed for professionals and enthusiasts alike, this course delves into the core features that make Excel an indispensable tool for data analysis, financial modeling, and everyday problem-solving.
Fundamentals of Excel Formulas: Understand the basic structure of formulas, including operators, cell references, and formula syntax.
Essential Functions: Learn to apply key functions such as SUM, AVERAGE, COUNT, MIN, and MAX to streamline calculations.
Advanced Functions: Explore more complex functions like VLOOKUP, HLOOKUP, for dynamic data retrieval and analysis.
Logical Functions: Utilize IF, AND, OR, and NOT functions to perform conditional evaluations and decision-making.
Text Functions: Master functions such as CONCATENATE, LEFT, RIGHT, MID, and TEXT to manipulate and format text data effectively.
Date and Time Functions: Use DATE, TIME, YEAR, MONTH, DAY, and related functions to handle and analyze temporal data.
Data Validation and Conditional Formatting: Apply formulas to validate data and format cells based on specific conditions.
Advanced Pivot Table Techniques: Delve into sophisticated Pivot Table features such as custom grouping, calculated fields, and advanced sorting and filtering.
Pivot Table Analysis: Learn to use multiple consolidation ranges, handle hierarchical data, and create multi-dimensional reports for deeper insights.
Pivot Charts: Create and customize Pivot Charts to visually represent data, including advanced chart types and dynamic chart updating.
Slicers and Timelines: Use Slicers and Timelines to filter Pivot Table data dynamically and enhance interactive data exploration.
The course is available in both instructor-led and self-paced formats, with interactive exercises, real-world examples, and hands-on practice to reinforce learning.
Fee: $199.00

CE Main Campus 331

2000 Clayton State Blvd.
Going I-75 South or North, take exit 233 and turn left. Go to sixth light and turn right on Clayton State Blvd. Take the next right at traffic light onto North Lee Street and then left on Simpson Drive. The Harry S Downs Center for Continuing Education will be the last building on your left. You will pass Spivey Hall and the Music Education Building.

Synthia Reese

Date Day Time Location
01/07/2025Tuesday10 AM to 1 PM CE Main Campus 331
01/09/2025Thursday10 AM to 1 PM CE Main Campus 331
01/14/2025Tuesday10 AM to 1 PM CE Main Campus 331
01/16/2025Thursday10 AM to 1 PM CE Main Campus 331