Skip to main content

Data Analysis with Microsoft Excel

« back to classes page
CourseGraphic

This course takes a deep dive into advanced Excel features that provide students with the tools necessary for importing, manipulating, analyzing, and presenting data to support business decision making.

Topical coverage includes:

  • Data analysis
  • Multidimensional analysis
  • Advanced visualization, Dashboards
  • Power Query
  • Power Pivot
  • Optimization modeling using Solver

Class Details

4 Sessions
Days of the Week :Multiple Days of the Week :
  Fri.  
  Sat.  
  Fri.  
  Sat.  

Location : Online

Instructor : Johnny Bhojwani 

CEUs : 1.2

 

Notice

Please read: 

Required textbook: My Educator e-text book “Prometheus Series: Microsoft Excel 2013 (Introduction through Intermediate) and Microsoft Access 2013 (Introduction)”. A link to purchase the e-book will be provided on your Canvas site. 

Students will need to have a good grasp on basic Excel concepts as outlined below:

  • Basic navigation through Workbooks, Menus and Ribbon
  • Understanding worksheets, columns, rows and cells
  • Absolute and relative cell references
  • Formulas and basic functions (such as SUM, AVG, COUNT, IF, etc.)
  • Basic Pivot Tables

Tuition: 

$699.00


Registration Closes On
Tuesday, April 6, 2021 @ 12:00 AM

Schedule Information

Date(s) Class Days Times Location Instructor(s) Instructional Method
4/9/2021 Fri 5:00 PM - 8:00 PM N/A - Online Johnny Bhojwani  Online
4/10/2021 Sat 9:00 AM - 12:00 PM N/A - Online Johnny Bhojwani  Online
4/16/2021 Fri 5:00 PM - 8:00 PM N/A - Online Johnny Bhojwani  Online
4/17/2021 Sat 9:00 AM - 12:00 PM N/A - Online Johnny Bhojwani  Online