Microsoft Excel Essentials

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. The topics covered in this course can be applied to Excel 2007, 2010, 2013, 2016 & 2019.

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.

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.

FAQ

Is this an online or a live classroom training?

This class is a live classroom training in New York City.

Would I get a certificate after completing the class?

Yes you will get a certificate of completion at the end of the class.

Is the training manual included?

Yes the course fee includes a training manual.