Excel is the spreadsheet application in the Microsoft Office suite. And it does so much more than just tally numbers – you can easily organize, visualize, and discover insights from your data with Excel. Whether you’re just learning how to create spreadsheets or you need to perform advanced data analysis with functions, our training will get you up and running comfortably.
Prerequisite: Familiarity with computers
This one-day course teaches you the basics of work books and work sheets. You will learn how to enter and format data, text, and formulas; how to use pre-defined functions for basic calculations; and how to avoid errors. You will also learn how to organize and manage lists and tables (including sorting, filtering, and analyzing).
Prerequisite: Knowledge of Excel 1
With this intermediate Excel course you’ll really ramp up your productivity. Using robust formulas and surprisingly simple techniques, you will be slicing and dicing to discover the power of data analysis. You’ll create Pivot Tables, build fully functional financial dashboards, and complete relevant exercises. At this level, Excel is an eye-opener.
Prerequisite: Knowledge of Excel 2
Are you an advanced Excel user? Do you need to consolidate data from several worksheets, work with external data, or perform What-IFs? Would you like to learn how to use macros or create rolling charts? This two-day course will teach you all that and a whole lot more with sought-after techniques and formulas. Plus, if you have Excel 365 or later, you’ll be introduced to the exciting new Dynamic Array formulas.
Prerequisite: Knowledge of Excel 1
Pivot Tables – one of the most powerful features of Excel – allow large amounts of data to be summarized and analyzed with just a few mouse clicks, and without any formulas. You'll be able to drag and drop fields directly into a Pivot Table to change your report layout to whatever you want, whenever you want. This one-day workshop culminates in building a sophisticated, yet uncomplicated dashboard that communicates financial information with power and ease you never thought possible.
Prerequisite: Knowledge of Excel 2
Dynamic Arrays are the most significant enhancement to Excel in years. Traditional array formulas (one formula, multiple results) have always been possible but they’re complicated and cumbersome to use, and usually require careful replication. Now, with Dynamic Arrays, formulas are simpler and easier to manage, and they usually require no replication at all. Dynamic Arrays are available to users of Excel 365 or later.
» Cancellations made more than 5 days before a course date qualify for a full refund minus a $25 administration fee per student.
» Cancellations made less than 5 days before a course do not qualify for a refund but the class may be rescheduled.
» We are not able to offer refunds or rescheduling for no-shows or uncompleted courses.
» There is no charge for rescheduling when you inform us at least 3 days before the course.
» An administration fee of $50 per person is charged when rescheduling 2 days or less before a course.
» Student substitutions are free. If you cannot take a course maybe your colleague can. Just let us know.
» It is rare that classes do not run as scheduled but we do reserve the right to reschedule previously confirmed classes.
© Copyright 2022 The Training Company, Inc. All rights reserved.