Data Analytics with Excel Certificate

Microsoft Excel is a powerful data analysis tool that you can use to manipulate, analyze, and present data, crucial skills in today’s workplace. The use of Excel is widespread, with almost all large and small businesses using it in their daily functioning.

The Data Analytics with Excel Certificate takes you from basic operations, such as reading data into Excel using various data formats, organizing and manipulating data, to some of the more advanced functions of Excel. This six-course program is designed for those who need to use Excel for analytical purposes and reporting, planning and decision-making. Completion of the following courses are required for a certificate. Excel Introduction and Intermediate and Advanced courses must be completed first, after which the others may be completed in any order.

Course Requirements:

  • Excel Introduction – Level 1
  • Excel Intermediate – Level 2
  • Excel Advanced – Level 3
  • Data Analytics Fundamentals
  • Data Analysis with Excel Pivot Tables
  • Data Analysis with Excel Dashboards

 

Excel 2016 Introduction (Level 1) and Intermediate (Level 2)

This course will provide you with a solid working knowledge and understanding of Excel. Upon completion, you will be able to use its basic and intermediate level features, such as  setting up a worksheet/workbook, customizing the Excel environment, formatting using conditional formatting, sorting and filtering tables, creating basic and nested formulas and more. All materials included with tuition fee.

Pre-requisite: solid foundation in working with Microsoft Windows and software applications in general.

Course ID: 131949
Date/Time: 8/21  – 10/9, W, 6:00 – 9:00 PM
24 Hours
Location: IQ 917/2444
Instructor: Jermique Hopkins (iTrainem)
Fee: $499

 

Excel 2016 Level 3 Advanced

This class is for individuals who want to be “power users” and understand the advanced Excel features and functionality to link, summarize, and analyze data on a higher level. Participants will learn to use Excel’s collaboration, protection, and programming capabilities by performing data merging, using lookups, macro recording, and tweaking the Visual Basic for Applications program code. Upon completion of the course, students will be able to share and analyze data, and automate repetitive tasks. Materials included with tuition fee. Prerequisite: Excel Introduction and Intermediate.

Course ID: 131950
Date/Time: 10/30/19 – 11/20/19, W, 6:00 – 9:00 PM
12 Hours
Location: IQ 2444
Fee: $275

 

Data Analytics – the Fundamentals

New! – Data analysis is widely used to enhance business operations. Learn how to follow and detect trends in order to make optimal decisions, using tools for analysis and visualization. Manipulate and present data in a variety of ways. This course is a combination of demonstration and hands-on work to enhance the learning experience. Previous Excel experience required, version 2007 or later. Fee includes book. Bring a thumb drive for file storage.

Course ID: 133028
Date/Time: 09/03/19 – 09/24/19, T, 6:00 – 9:00 PM
12 Hours
Instructor:  J. Bryant
Location: West Campus Room 27
Fee: $185

 

Data Analysis with Excel 2016 Pivot Tables

Advances in technology have made it possible to store ever increasing amounts of data known as Big Data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. Being able to harness the power of advanced PivotTable features will help you to gain a competitive edge. You will also learn to clean up data using Power Query and to summarize large amounts of data using Power Pivot to organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.

Course ID: 133033
Date/Time: 11/04/19 – 12/02/19, M, 6:00 – 9:00 PM
12 Hours
Location: IQ 2444
Fee: $299

 

Data Analysis with Excel 2016 Dashboard

Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. After all, the world runs on data more than ever before and that’s a trend not likely to change, or even slow down, any time soon. But with so much data available and being created on a nearly constant basis, the ability to make sense of that data becomes more critical and challenging with every passing day. To gain a truly competitive edge, you need to be able to organize raw data and present it in a visual format that enables decision makers to view key trends and make conclusions at a glance. In other words, you must be able to create a visual dashboard — and that’s exactly what this course will teach you to do.

Course ID: 133030
Date/Time: 02/03/2020 – 02/24/20, M, 6:00 – 9:00 PM
12 Hours
Location: IQ 2444
Fee: $299