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.
Loading...
Enroll Now - Select a Section
Section Title
Advanced Excel for Data Analytics
Type
Workshop
Days
Sa
Time
9:00AM to 12:00PM
Dates
Jan 29, 2022 to Feb 05, 2022
Schedule and Location
Contact Hours
6.0
Location
  • TBD
Delivery Options
Course Fee(s)
DA Registration Fee - $395 non-credit $395.00
Instructors
Section Notes
  • Students must have computers equipped with MS Excel (2010 or later), a webcam with a microphone, and strong internet connectivity to participate in this workshop.
  • You will receive additional information, including Zoom credentials, in a course reminder email prior to the class start date.
Required fields are indicated by .