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: None.
This one-day course teaches you the basics of working with spreadsheets: entering numbers, creating formulas, and using predefined functions. You will learn how to change the layout of your worksheet and enhance its appearance. You will practice on multiple sheets within a file and learn how to setup and print your worksheet.
Prerequisite: None.
In this two-day course you will learn how to handle spreadsheets that are spread across multiple pages or may be too big to manage easily. We will practice using built-in functions to perform complex calculations and formulas and techniques that streamline repetitive tasks. As you know, a simple chart can say more than a sheet full of numbers and, as you’ll see, creating charts is really very easy.
Prerequisite: None.
Advanced students love this course covering the more advanced concepts and features of Microsoft Excel. You will learn how to increase your productivity with Macros and gain the skills to tackle the most complex data analysis.
Prerequisite: None.
Excel’s core strength is its ability to perform calculations, and calculations are done with formulas and functions. In this two-day workshop you will learn advanced functions and formulas. With this class you will be laying the foundation for future self-learning up to a very high level of complexity.
Prerequisite: None.
PivotTables are one of the most powerful features of Microsoft Excel. They allow large amounts of data to be analyzed and summarized in just a few mouse clicks – without the use of formulas. By moving, or pivoting, fields of data from one location to another using drag and drop we can look at the same data in a number of different ways. This one-day workshop explores the uses and versatility of Pivot Tables that make any user an instant expert.
» 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 2021 The Training Company, Inc. All rights reserved.