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.
- 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
Location: IQ 917/2444
Instructor: Jermique Hopkins (iTrainem)
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
Location: IQ 2444
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
Instructor: J. Bryant
Location: West Campus Room 27
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
Location: IQ 2444
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
Location: IQ 2444