|Online, Open Enrollment with a Personal Learning Coach
This program is designed for individual learners – it can also be customized for group delivery in your organization. Contact a learning consultant for more information.
This module covers some of the many functionalities data analysts use in Excel to query and transform data. The Extract-Load-Transform (ETL) process is covered in detail, as well as the differentiation between cleaning and transforming data. Advanced capabilities are also presented to aid statistical analysis, including correlation, rank, percentile, and probability distributions. Uses of pivot tables, charts, and geographic data will also be presented.
• Entry-level data analysis roles
• Any business role requiring fundamental statistical analysis
Data analysis skills are no longer reserved for computer scientists and statisticians. Completing basic data analysis in Excel is crucial for modern data-driven organizations because highly data-literate organizations derive the most value from their data. Organizations are looking for individuals who know how to take raw data and turn it into powerful insights that can drive success in their organization.
With more than two billion people using spreadsheet technologies worldwide, it’s no surprise that candidates with Excel experience and, more importantly, Excel analysis skills are in high demand. By the end of this 45-hour self-paced course, users will learn to use Excel to clean raw data, analyze it to gain a deeper understanding of the relationships in the data, and summarize findings with descriptive statistics and visualizations.
With the guidance of your Rutgers Personal Learning Coach, you will have the confidence and knowledge to make significant contributions to this critical, strategic function at your current employer or prospective employer.
What You Will Learn
MODULE 1: GETTING STARTED WITH EXCEL DATA ANALYSIS
• Data Organization
• Extract, Transform, Load Process
MODULE 2: IMPORTING DATA
• Importing Data from Text, Files, Web, API, and Databases
MODULE 3: INTRODUCTION TO POWER QUERY
• Power Query Basics
MODULE 4: CLEANING AND TRANSFORMING DATA
• Cleaning Data with Excel
• Transforming Data with Excel
MODULE 5: PIVOT TABLES
• Creating & Editing Pivot Tables
MODULE 6: CREATING CHARTS
• Creating & Editing Treemaps and Pivot, Scatter, Line, Column, and Bar Charts
MODULE 7: GEOGRAPHIC DATA AND DATA EXPLORATION
• Working with Geographic Data
• Exploring Data Source Types
MODULE 8: DATA ANALYSIS TOOLPAK AND CORRELATION
• Introduction to the Data Analysis ToolPak
• Descriptive Statistics
• Covariance and Correlation
MODULE 9: RANK, PERCENTILE, PROBABILITY DISTRIBUTIONS, AND HISTOGRAMS
• Rank & Percentile
• Probability Distributions
Given the busy schedules of professionals and rising executives, Rutgers has developed a powerful hybrid learning model that combines the flexible delivery of self-paced, online learning with that of a seasoned professional – a Personal Learning Coach – who serves as a learning and career guidant to mentor you through successful completion of your program and set you up for success to achieve your career aspirations.
Individualized support by industry experts: To assure your learning supports where you are and where you want to go in your career, our personalized delivery model teams you up with a learning coach who will meet with you virtually during the course of your study. In your initial meeting, you will discuss your career objectives with your personal learning coach. Over additional scheduled one-on-one virtual meetings they will discuss your questions, homework assignments, and connect your learning to your job and career to make sure you get the most from the material presented and maintain your focus on the learning goals you have set for yourself.
Project Based: You will apply the concepts you learn in a project that you can draw upon as you interview for your new role. Because the project simulates actual work duties of professionals in this field, the project offers you an opportunity to showcase the skills and competencies that employers are looking for in hiring and promoting professionals in their organizations.
Flexibility: Learn on the days of the week and times of day that fit your schedule: E-Learning is available virtually 24/7/365.
Who Should Attend
This course is designed for those who need to establish a firm foundation in data analysis skills. Whether you have a degree in a liberal arts discipline that did not rely upon and/or develop quantitative, data, and numeracy skills or have not had much experience with these skills generally, this course will introduce you to the ground level concepts and give you the confidence to leverage data in the decision-making competences required – and expected – by employers across all industries and functional areas in organizations.
This program has been approved by the New Jersey Department of Labor for workforce training grants. Funding may be available for those receiving unemployment benefits. Contact us for more information at or by completing the Request for Information.
Earn a credential to put on your resume that showcases your skills to support career success from a trusted public institution serving the people, businesses, and government agencies in the state of New Jersey for over 250 years.