Business Analyst Classes Chicago, IL

In this 1-day beginner course, students will learn the basics of Microsoft Excel. Through face-to-face instruction, students will learn how to navigate Excel, create worksheets and workbooks, format numbers, and other forms of data, generate charts, and manipulate data. This course uses hands-on learning to allow students to practice as they learn. Students will be able to create reports, worksheets, and workbooks after completing this course.

This 1-day course teaches students intermediate skills in Microsoft Excel. Through hands-on learning, students will learn how to use PivotTables, SmartArt, and advanced charts to display data. Students will also learn strategies for creating, filtering, and sorting data tables and collaborating with others. This class is face-to-face with experienced instructors.

In this 1-day course, students will gain advanced skills in Microsoft Excel. This class teaches logical and lookup functions, advanced formulas, and special functions. Students will learn how to import and export, create and run macros, and analyze data. Face-to-face instructors provide real-time support and guidance.

This 1-day introduction to Microsoft Excel teaches participants how to create, manage and work with spreadsheets. Throughout this experience, students will learn how to use Microsoft Excel to organize and analyze data. They will gain practice with writing formulas, creating tables, and presenting data in charts and reports.

Intermediate Microsoft Excel users can improve their skills with this 1-day program. This program explores the advanced editing tools of Excel, such as text-wrapping, borders, and effects. Students will learn how to adjust page layouts, insert page and section breaks, and handle multiple window views.

This 1-day program teaches experienced Microsoft Excel users how to leverage more advanced tools. This course teaches students how to use PivotTables to analyze data, trace precedents to understand cause and effect within the data, audit worksheets, and convert text. They will learn how to use macros to automate scripts and integrate Excel spreadsheets with other Microsoft Office tools.

In this course, students will learn basic skills in Microsoft Powerpoint. The class begins with an overview of the software’s interface and features. Students then learn how to create and format presentations, insert shapes and images, design charts and tables, and import content. This course features hands-on learning in a face-to-face environment.

This course teaches intermediate skills in Microsoft PowerPoint. Students learn advanced formatting techniques, including the use of SmartArt, charts, and slide masters. With face-to-face support from experienced instructors, students will learn how to work with animation, time effects, media, and custom slide show controls. They will also gain experience with the technical aspects of using the software, such as tracking changes and collaborating with others.

This 1-day Excel course is crafted to introduce beginners to the fundamentals of Excel in order to enable them to feel comfortable working with spreadsheets. This course covers the basics of spreadsheets, the layout of Excel, entering data, using common formulas and functions, and a variety of other helpful tips and tricks.

This 1-day Excel course is designed for individuals familiar with Excel but who are looking to bolster their knowledge of building professional looking charts. This course covers a lot of broad chart-related content, including creating and working with charts, incorporating various styles and themes, using print options, and best practices around using excel data in other office applications, like Word or PowerPoint.