Microsoft Excel Expert Training Course
Small Class Size
This will allow for great personal training experience with our instructor.
Flexible Schedules
We offer our courses weekdays, weekends and evenings.
Great Instructors
Our instructors have over 10 years of experience working in the medical field.
Microsoft Excel Expert
We are offering a Microsoft Excel Expert Course. The class will teach you how to create Marco's, conditional formatting, securing your workbooks, expert functions, auditing worksheets, analyzing data, and importing, exporting data.
This course is perfect for someone who uses Microsoft Excel already, or took our Excel essentials course and wants to become an expert user.
- How to macros to automate our spreadsheets.
- Using conditional formatting to formats specific cells in a range.
- Protecting workbooks and sheets. If you share your workbooks with others, protecting certain sheets or range will ensure the integrity of the sheets stays intact.
- How to use a combo IF and Vlookup to lookup values base on certain conditions and criteria.
- When you would use the ISBLANK or ISERROR functions. Ever had a function return error because a cell was blank? We will show how to stop this.
- Using SUMIF, AVERAGEIF, COUNTIF. These will allow us to sum, count and average base on certain criteria.
- Inputting financial functions.
- Tracing errors in functions using formula auditing. Excel has a great set of tools to help us troubleshoot errors in formulas.
- Working with scenarios. what are they, and how they help us save time.
- Inserting a trendline on a chart and having Excel forecast your next quarter or months finance.
- How to import and export data into excel. Also includes using web data. Have a web page you constantly monitor, to update excel? Have excel update itself when the web page changes.
- Small class
- 100% hands on training. Every student gets their own computer to follow along
- Full day of training or 2 evening. 8 hours of total training time
- Convenient location in Midtown Manhattan. 2 blocks from Penn Station.
- Expert instructor with more than 10 years of financial experience using and teaching Excel
- A free retake if needed
- We are a Microsoft Office Specialist (MOS) Certified testing center. Take this course along with our Excel Expert class and you will be ready to ace your Excel certification exam. Call us to learn more about our Excel certification course and exam package.
- The course will include a customize manual with step by step directions and a certificate at the end, showing that you attended the class.
Other Training Companies | ||
---|---|---|
Microsoft Learning Solutions Partners | (Non Authorized training) | |
Better Business Bureau Accredited Business. | (Not an Accredited Business. No assurance if they are a real company) | |
Ultra Fast 4/6-Core Desktops with 19'-24' monitors | (old outdated computers) | |
Easy Refund Policy. Cancel before the course starts and receive a full 100% refund the same day. Reschedule at any time with our no fee rescheduling policy. | (Most companies charged a cancellation fee of up to $400 and take more than 20 days to issue refunds. Please check before you sign up) | |
Flexible Schedule (Weekday, Evening, and Weekend). | (Just Weekday classes) | |
Instructor with real world Experience. | (Instructors with no real world Experience) | |
Live instructor-led training. | ||
Great Location. A few blocks from Penn Station and Port Authority. | (Have to take additional trains and buses to get there) | |
American owned and operated company. | (Non-American company) | |
New York State Licensed Regulated School. | (Non-licensed illegal school) | |
One (1) free retakes of the course for up to six months. | (no retakes allowed) | |
Luxurious facilities. | (Poorly maintained spaces) |