Discover Classes. Earn Rewards.

Data Analyst Training Chicago

Upcoming schedule view

Learn the skills and tools you need to become a data analyst with hands-on classes in big data and data analysis. Gain practical knowledge in Python, SQL, data visualization, and more, and unlock new career opportunities in the growing field of data analysis.

29 classes have spots left

Excel Bootcamp: Functions & Formulas

General Assembly @ 444 N Wabash Ave, Chicago, IL

Sky rocket your Excel expertise with this comprehensive hands-on workshop exploring financial functions, date functions, sum formulas, string-manipulation functions, and other useful topics, such as: VLOOKUP, logical operators, Goal Seek Tool, and text manipulation formulas. Designed for beginner to intermediate level MS Excel program knowledge and proficiency. Takeaways Differentiate between Excel formulas and functions Use relative and absolute...

(2637) Beginner 18 and older

Mastering Excel Pivot Tables

General Assembly @ 444 N Wabash Ave, Chicago, IL

Pivot tables are one of the hidden Excel gems that intimidate most users. It is a surprisingly easy way to quickly summarize and analyze large amounts of data organized in rows or columns. Mastering this tool will help you stand out from approximately 85% of all other Excel users. Overcome your fears and become the de-facto Excel guru in your office! Designed for beginner to intermediate level MS Excel program knowledge and proficiency. Takeaways...

(2637) All levels 18 and older

Excel Practice Lab

Computer Training Source, Inc.

This class is specially designed for students who have completed our Excel Introduction, Intermediate, and Advanced classes, but don’t have much on-the-job experience using Excel. You will work on Excel assignments at your own pace, with the instructor available to help assist with questions.  Assignments may include sheet formatting, basic formulas, charts and graphs, pivot tables, using VLOOKUP and IF functions.

(21) All levels 18 and older
No upcoming schedules
Discover Classes. Earn Rewards.

Data Analyst Classes Gift Card

Thousands of classes & experiences. No expiration. Gift an experience this holiday season and make it a memorable one. Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Excel PowerPivot

Computer Training Source, Inc.

Students will learn how to import and refresh data from various sources, format tables, create calculated columns and will be working with Pivot Tables more in-depth. This course will also show how to manipulate PowerPivot data using DAX functions.

(21) All levels 18 and older
No upcoming schedules

Excel 2007 Introduction

ONLC Training Centers @ 233 S Wacker Dr, Chicago, IL

Prerequisites Knowledge of the appropriate Windows operating system. Must be familiar with the mouse, menus, dialog boxes, scroll bars, the Start menu and the taskbar. Proficiency with minimizing, maximizing and restoring windows is required. Getting Started Starting Excel Understanding the Display Screen Working with the Ribbon Working with the Quick Access Toolbar Exploring the Office Menu Opening a Workbook Managing Open Workbooks Using...

(7) Beginner 18 and older
No upcoming schedules
$345
Gift it!

Moving to Microsoft Office 2010 Course

ONLC Training Centers

This course will introduce you to the components of the Office 2010 user interface as well as the new features in Word, Excel, and PowerPoint. Getting Started with the User Interface Introducing the 2010 Microsoft Office User Interface Exploring Backstage View - The File Tab Working with the Ribbon Customizing the Ribbon Customizing the Quick Access Toolbar Working with the Status Bar Using the Mini Toolbar Working with Galleries and Live...

(7) Beginner 18 and older
No upcoming schedules

After Hours: Excel 2010/2013 Level 1 Course

ONLC Training Centers

Although this class will be taught using Microsoft Excel 2013 and ONLC's "Excel 2013 Introduction" manual, this class is relevant for individuals using either the 2010 or 2013 versions of the software. The instructor will note where there are differences in features and functions between the two versions. For the most part, those differences will be minor related to the topics taught in this class. Prerequisites: Knowledge of the appropriate...

(7) Beginner 18 and older
No upcoming schedules

Excel 2007 Intermediate

ONLC Training Centers @ 233 S Wacker Dr, Chicago, IL

Prerequisites Excel 2007 Introduction or equivalent skills. Must be able to create, open, save, format and print a worksheet. Should be able to use formulas and the SUM function. The ability to copy, move and delete values and formulas is required. Working with Worksheets Viewing, Renaming, and Color-coding Worksheets Editing a Group Manipulating Worksheets Creating Linked Formulas Using 3-D References Working with Functions...

(7) Intermediate 18 and older
No upcoming schedules
$345
Gift it!

2-Day Intermediate SQL & Database Management Bootcamp

General Assembly @ 444 N Wabash Ave, Chicago, IL

This workshop will enable analysts to advance their SQL skills to retrieve and manipulate data from multiple sources with precision, integrate SQL queries with reporting tools to create automated reports and visualizations, and database management principles/best practices. Takeaways Database architecture and creation Database management functions CREATE, INSERT, UPDATE, DROP, DELETE NULL values and working with bad data Complex JOINs with multiple...

(2637) All levels 18 and older
$300

2 sessions

Gift it!

Excel 2013 Introduction

ONLC Training Centers @ 1320 Tower Rd, Chicago, IL

In today's work environment, proficiency with spreadsheets is expected. In this course, you will work with Microsoft® Office Excel® 2013 create a new spreadsheet. You will learn to enter data in the most efficient way. You will create formulas to summarize and analyze data and learn the proper technique to copy and paste formulas. You will also learn to format for emphasis and readability and use print preview and page setup to print worksheets. ...

(7) Beginner 18 and older
No upcoming schedules
$295
Gift it!

Excel 2010 Introduction

ONLC Training Centers @ 1320 Tower Rd, Chicago, IL

In today's work environment, proficiency with spreadsheets is expected. In this course, you will work with Microsoft® Office Excel® 2010 create a new spreadsheet. You will learn to enter data in the most efficient way. You will create formulas to summarize and analyze data and learn the proper technique to copy and paste formulas.  You will also learn to format for emphasis and readability and use print preview and page setup to print worksheets....

(7) Beginner 18 and older
No upcoming schedules
$295
Gift it!

Excel Training for Beginners

General Assembly

Students will gain an understanding of the application designed for the user whom is typically intimidated by spreadsheets. They will understand it's unique function from Word and appreciate it's ability to manage data, from the simple to complex. Using their new found confidence, students will begin to explore the formatting and data capabilities in Excel. Takeaways Understand why Excel is the preferred data management tool. Comfort and confidence...

(2637) Beginner 18 and older

Excel at Excel: Getting Down the Basics Remote Bootcamp

General Assembly @ Online Class Livestream, Chicago, IL

The Excel at Excel workshop is designed for students who are relatively familiar with other office productivity software, for example, Microsoft Word. (The students who succeed the most are comfortable using a computer and navigating around desktop programs on their own). It introduces a range of Excel topics giving students a taste of the potential that can be achieved with Excel and touches briefly on everything from navigation and layout to using...

(2637) Beginner 18 and older

Excel at Excel: Getting Down to the Basics

General Assembly @ 150 N Wacker, Chicago, IL

Due to the current health concerns, all GA programs will temporarily be held online - including this one. Registered participants will be notified 24 hours in advance with information on how to log in to the Zoom meeting room and other tools needed for the workshop. Registration will close 2 hours prior to the start time in order to allow participants ample opportunity to have the technology enabled. The Excel at Excel workshop is designed for...

(2637) Beginner 18 and older

Excel Forecasting and What-If Analysis

ONLC Training Centers @ 1320 Tower Rd, Chicago, IL

Excel has many built-in features and add-ons that will make it easier to develop complex models that incorporate What-If Analysis (using either Scenarios, Solver, or Data Tables). In addition, forecasts and trend lines can be easily projected and customized using Excel’s Forecast functions. Finally, the Excel Data Model is reviewed. This advanced feature allow you to access huge data sets within Excel. Target Student The course is for individuals...

(7) Intermediate 18 and older
No upcoming schedules
$395
Gift it!

Microsoft Excel Training

Sprintzeal Americas Inc @ 73 W Monroe St, Chicago, IL

Enhance your productivity and efficiency at work by mastering the essential features of MS Excel. Join Sprintzeal Americas Inc.'s comprehensive training program to gain the necessary skills for simplifying calculations, designing spreadsheets, analyzing data, and more. Don't miss out on this opportunity to become an Excel expert and add value to any organization you work for.

(2) Advanced 18 and older
No upcoming schedules
$4,975

3 sessions

Gift it!

Moving to Microsoft Office 2013 Course

ONLC Training Centers

You’ve used Office 2007 or Office 2010 to create various types of business materials from documents in Microsoft® Word to spreadsheets in Excel® to presentations in PowerPoint®. However you use Office, the fact is the Office suite of applications is the de-facto standard for business productivity software. Each new release of Office builds upon the successes of the previous generations. This course builds upon the foundational Microsoft®...

(7) Intermediate 18 and older
No upcoming schedules

After Hours: Excel 2010/2013 Level 3 Course

ONLC Training Centers @ 1363 Shermer Rd, Chicago, IL

Although this class will be taught using Microsoft Excel 2013 and ONLC's "Excel 2013 Advanced" manual, this class is relevant for individuals using either the 2010 or 2013 versions of the software. The instructor will note where there are differences in features and functions between the two versions. For the most part, those differences will be minor related to the topics taught in this class. Prerequisites Excel 2013 Intermediate or equivalent...

(7) Advanced 18 and older
No upcoming schedules
$295
Gift it!

After Hours: Excel 2010/2013 Level 2 Course

ONLC Training Centers

Although this class will be taught using Microsoft Excel 2013 and ONLC's "Excel 2013 Intermediate" manual, this class is relevant for individuals using either the 2010 or 2013 versions of the software. The instructor will note where there are differences in features and functions between the two versions. For the most part, those differences will be minor related to the topics taught in this class. Prerequisites Excel 2013 Introduction or equivalent...

(7) Intermediate 18 and older
No upcoming schedules

Excel 2013 Exam Prep - Specialist

ONLC Training Centers

This Class is for Individuals Seeking Excel Certification This live, instructor-led course is delivered by having the class complete a series of practice exams which mirror the format that you will see when taking the actual exams. Instructor-Guided Exam Review Although the Excel concepts tested on the exam will be reviewed in this class, those concepts will not be "taught" as in the traditional classes. In this Excel Exam Prep Class will be focusing...

(7) Advanced 18 and older
No upcoming schedules
Reset all filters.

No results found

Try removing some filters.

Data Analyst Training in Chicago are rated 4.3 stars based on 2,667 verified reviews from actual CourseHorse.com purchasers.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...