Unlock the full potential of Microsoft Excel with classes in Chicago. Learn everything from basic functions to advanced data analysis techniques and gain the skills that will make you stand out in the office and boost your career prospects.
10 classes have spots left
Training Connection @ 230 W Monroe St, Chicago, IL
This hands-on class is suitable for Excel 2013 and 2016, 2019 & 365 users. On this class you will learn advanced functions including LOOKUPS, Date and Time Functions, Text Functions, Statistical Functions, and Financial Functions. You will learn how to import and export data using the Power Pivot Data model and analysis data using What-If Analysis, Scenarios and Goal Seeker. Finally you will learn to automate tasks using Macros and capture...
Prerequisite Proficient knowledge of Microsoft Excel. Knowledge of PivotTables helpful but not required. Getting Started Introducing Visual Basic for Applications Displaying the Developer Tab in the Ribbon Recording a Macro Saving a Macro-Enabled Workbook Running a Macro Editing a Macro in the Visual Basic Editor Understanding the Development Environment Using Visual Basic Help Closing the Visual Basic Editor Understanding Macro...
ONLC Training Centers @ 1320 Tower Rd, Chicago, IL
Introduction to Power View Installing Power View Canvas Field List Field Well Filters Area View Area Ribbon Loading Data Report Design Titles Adding Fields Filtering, Formatting and Sizing a Visualization Using Tiles Additional Visualizations Setting the Table Including Images Creating a Matrix Report Creating a Card Report Charting Basics Creating a Chart Chart Components Enhancing a Chart Cart Icons Cart Titles Data...
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™
Explore private group events and team building activities ranging from cooking to art, escape rooms, trivia, and more
Explore Excel Private Group EventsPrerequisite Proficient knowledge of Microsoft Excel. Knowledge of PivotTables helpful but not required. Getting Started Introducing Visual Basic for Applications Displaying the Developer Tab in the Ribbon Recording a Macro Saving a Macro-Enabled Workbook Running a Macro Editing a Macro in the Visual Basic Editor Understanding the Development Environment Using Visual Basic Help Closing the Visual Basic Editor Understanding Macro...
ONLC Training Centers @ Two Mid America Plaza, Chicago, IL
Full Course Name: Data Mining, Predictive Analytics with Microsoft Analysis Services and Excel PowerPivot This three-day instructor-led course will introduce the students to the concepts of data mining, machine learning and predictive analytics utilizing the Microsoft toolsets including SQL Server Analysis Services and Excel with PowerPivot and the Data Mining Add-ins. Audience This course is intended for Power Users, IT Professionals, Report Developers,...
ONLC Training Centers @ 1000 Essington Rd, Chicago, IL
The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI. Audience profile: This course is intended for anyone responsible for analyzing data with Excel. The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data....
General Assembly @ 150 N Wacker, Chicago, IL
In this one day bootcamp, we will move beyond the basics of spreadsheet creation. We will dive into data manipulation and advanced functions to summarize and analyze data with multiple attributes. We will also introduce using slicers with PivotTables, creating interactive reports, and using advanced formulas. Interactive in-class exercises will be utilized to facilitate understanding. Agenda Review of Intermediate Functions (VLOOKUP, SUMIF, COUNTIF)...
ONLC Training Centers @ 1320 Tower Rd, Chicago, IL
Overview The new analytics tools in Excel make it easy to conduct manipulate and gain insights from big data. PowerPivot extends the use of pivot tables with a data model and offers improved data summarization and cross-tabulation and advanced calculations. Power Query retrieves data from a variety of sources can be cleaned up before being added to data model. Power View create interactive dashboards. Power Map is a 3D visualization tool to create...
This fast-paced course covers our 3 days of Excel 2013 content in only 2-days. As a result, this class is for individuals who need a quick fly-through of a broad array of Excel topics. Who Should Attend Students interested in this class will most likely come from one of these four groups: Individuals with prior Excel training on older versions of the product who want to quickly refresh their skills. Individuals with no formal Excel training who...
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...
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...
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.
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.
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...
ONLC Training Centers @ 200 S. Wacker Drive, Chicago, IL
Learn how to automate repetitive tasks in Excel and save time with the Excel Macros course at ONLC Training Centers. Master advanced Excel techniques to record and repeat steps, create dynamic macros, use functions and formulas, and work with files. This course is ideal for frequent Excel users who want to streamline their workflow.
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...
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...
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....
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...
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...
Try removing some filters.
Excel Classes in Chicago are rated 4.3 stars based on 2,823 verified reviews from actual CourseHorse.com purchasers.
Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!
Maximize your savings with every purchase. Unlock rewards on every transaction, ensuring you get the most value out of your experience!
Enjoy hassle-free transactions without worrying about additional charges. With us, what you see is what you pay - no surprises!
Discover a curated selection of courses handpicked by experts in the field. Dive into quality content that suits your learning needs and interests!
More in Microsoft Office
Get special date and rate options for your group. Submit the form below and we'll get back to you within 2 business hours with pricing and availability.