Loading...

Course Description

Microsoft Excel is a powerful and widely used tool in data analysis, and digital marketing professionals must demonstrate expertise using Excel and its features. In this hands-on workshop, learn and practice the most important components of Excel.

Course Outline

  • Functions: the most useful functions to support data manipulation and analysis.
  • Formulas: essential Excel formulas that every digital analyst should know.
  • Tables: tools to organize, structure, and present data to provide informed answers and drive decisions.
  • Text to Columns: built-in tools to merge and separate data points to analyze information more effectively.
  • Data Visualization: features like graphs and other graphic elements to align with your audience and brand.
  • Forecasting: methods and tools to predict future KPI trends, including applications for metrics like traffic and revenue.
  • Camera Images: an exciting tool to support dashboards and reports.
  • Macros: features to automate processes in recurring reports for efficiency.

Prerequisites

  • Basic Excel skills required to take this class.

Applies Towards the Following Certificates

Loading...

Enroll Now - Select a Section

Section Title
Advanced Excel for Data Analytics
Type
Discussion
Days
Sa
Time
9:00AM to 4:00PM
Dates
Jan 24, 2026
Schedule and Location
View Details
Contact Hours
6.0
Location
Delivery Options
In Person  
Course Fee(s)
Registration Fee non-credit $239.00
CEUs
0.6 CEUs
Instructors

Section Notes

Students will interact with instructors and other students in-person and through SMU's Learning Management System (Canvas). 

Students will receive individualized communication with further instructions to help you prepare for class.

Section Title
Advanced Excel for Data Analytics
Section Schedule
May 30, 2026 to Jun 06, 2026
Type
Live Sessions
Days
Sa
Time
9:00AM to 12:00PM
Dates
May 30, 2026
Type
Live Sessions
Days
Sa
Time
9:00AM to 12:00PM
Dates
Jun 06, 2026
Schedule and Location
View Details
Contact Hours
6.0
Location
Delivery Options
Live Online  
Course Fee(s)
Registration Fee non-credit $239.00
CEUs
0.6 CEUs
Instructors

Section Notes

Students will interact with instructors and other students through Zoom and SMU's Learning Management System (Canvas). To maximize classroom instruction and your learning experience, we encourage the use of video and audio devices during the Zoom meeting, if available.

Students will receive individualized communication with further instructions to help you prepare for class.

Required fields are indicated by .