Our Live Online course allows you to attend our great live online training from the comfort of your desk at home or at work. It's the same great course with our excellent instructors. Here a few points about our online class.
- Exactly as being in a classroom, just from the comfort of your desk at work or home.
- You will get a live camera view of our classroom, allowing you to see your instructor. Our instructors will be wearing a high quality headset, so their voice will sound crystal clear.
- The classroom will have a loudspeaker allowing you to ask questions that your instructor and the other students can hear.
- Live training class. This is not an online class where you will study on your own.
- 100% instructors led. Interact with our instructor exactly like you would do in a classroom setting.
- Same course content as our regular classroom course.
- All course material is mailed or emailed to you a week before the course starts.
- All you need is a computer with an internet connection and a telephone, or any computer with a microphone and speaker.
- Work's with any PC, MAC, Tablets, and Smartphones.
- Save time and money on travel costs.
Our one-day Excel Essentials class is the most popular Excel training course in the city. This live instructor-led hands-on course will cover basic to intermediate topics in Excel. All students will be given a computer to follow along and a custom training manual with all the steps and description of Excel functions.
When this course is over you will feel very comfortable using Microsoft Excel to create simple to complex spreadsheets with formulas, tables, objects, and charts. Students will be able to take home their files that was created in class to practice. Also, students are welcome to come back for a free retake of the course, good for up to 6 months after their first course.
If your goal is to learn Excel from great instructors without breaking the bank, this course is for you. We deliver our Live Online training using the latest technology. You will be able to see your instructor, ask questions, and follow along with them. You are required to have Microsoft Excel installed on your computer.
What students will learn in this Excel Essential course?
- How to create and modify worksheets within an Excel workbook
- Entering simple to complex formulas.
- Configuring printing options.
- Inserting objects.
- Working with tables.
- Creating Charts and graphs.
- Summarizing data using Pivot tables and Charts
This course is great for someone looking for a job that requires the use of Excel or to feel more comfortable using the program. This course will turn any Excel user into a Power Users.
All courses are live instructor-led. If you have a group of employees looking for Excel training, call us for a customized quote. We offer great discounts and onsite training for groups of two or more.
Topics Covered:
Lesson 1: Creating a Basic Worksheet
- Explore the User Interface and the Ribbon
- Navigate and Select in Excel
- Obtain Help
- Enter Data and Save a Workbook
- Customize the Quick Access Toolbar
Lesson 2: Performing Calculations
- Create Basic Formulas
- Calculate with Functions
- Copy Formulas and Functions
Lesson 3: Modifying a Worksheet
- Manipulate Data
- Insert and Delete Cells, Columns, and Rows
- Search for Data in a Worksheet
- Spell Check a Worksheet
Lesson 4: Formatting a Worksheet
- Modify Fonts
- Add Borders and Color to Cells
- Change Column Width and Row Height
- Apply Number Formats
- Position Cell Contents
- Apply Cell Styles
Lesson 5: Printing Workbook Contents
- Print Workbook Contents Using Default Print Options
- Set Print Options
- Set Page Breaks
Lesson 6: Calculating Data with Advanced Formulas
- Manage Cell and Range Names
- Calculate Data Across Worksheets
- Use Specialized Functions
- Analyze Data with Logical and Lookup Functions
Lesson 7: Organizing Worksheet and Table Data
- Create and Modify Tables
- Format Tables
- Sort or Filter Worksheet or Table Data
- Calculate Data in a Table or Worksheet
Lesson 8: Presenting Data Using Charts
- Create a Chart
- Modify Charts
- Format Charts
- Lesson 9: Analyzing Data Using PivotTables and PivotChart
- Create a PivotTable Report
- Analyze Data Using PivotCharts
What does the Excel Essential training course include?
- Course covers Excel 2007, 2010, 2013, 2016, and 2019 versions.
- This is 100% hands-on course; every student will have his or her own computer to work on.
- The most flexible schedule. We have weekday, evening and weekend courses available.
- FREE retake for up to 6 months.Come back and retake our course free of charge for up to 6 months from your original course date.
- Flat rate $169 tuition includes 8 hours of training and physical training manual.
- Full day of training or 2 evening. 8 hours of total training time
- A customized manual with step by step directions is included with the course.
- You’ll be given a Certificate upon completion of the training.
- A FREE retake is included should you ever need a refresher.
- Learn to create simple to advance formulas, from SUM functions to IF, VLOOKUP, HLOOKUP, and nested functions
- Learn to create a variety of charts and data sets
- Learn to create PIVOT Tables and Charts
- Expert instructor with more than 10 years of financial experience using and teaching Excel
- Convenient location in Midtown Manhattan. 2 blocks from Penn Station.
- The course will include a customize manual with step by step directions and a certificate at the end, showing that you completed the class.
This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.
Upon registration, the instructor will send along additional information about how to log-on and participate in the class.
