185 Madison Ave. at 34th St., Suite 1104, New York, NY 10016 • 212-684-5151
Microsoft Excel Level 1 2016
Microsoft Excel Level 1 2016

Price: $229.00

Course Code: 6F | Hours: 8

Microsoft Excel Training Course Overview - Level 1

The Career Center, hands on, instructor-led, Beginner Excel training class in New York City will teach you to organize, calculate, analyze, revise, and present your data. Our basic Excel training course is classroom based instruction, with a live instructor, to introduce the basic look and feel of Excel. You will learn how cells relate to each other to create basic formulas. You will set up a spreadsheet, perform basic calculations, format the cells in the worksheet, and print a workbook. The Career Center Classroom Excel Training Course is conducted at our facility in Midtown Manhattan NYC. We also provide Onsite Excel Training Courses, Offsite Excel Training Classes or 1:1 Private Excel Lessons.

Upon successful completion of this course, students will be able to:

  • Get started with Microsoft Office Excel 2016
  • Perform calculations
  • Modify a worksheet
  • Format a worksheet
  • Print workbooks
  • Manage workbooks

Prerequisites:

Students should have a basic understanding of Windows, including how to use files and folders.

Next Classes:

Related Classes:

See Also:

Microsoft Excel Training Course Outline - Level 1:

Lesson 1: Getting Started with Microsoft Office Excel 2016

• Topic A: Navigate the Excel User Interface
• Topic B: Use Excel Commands
• Topic C: Create and Save a Basic Workbook
• Topic D: Enter Cell Data
• Topic E: Use Excel Help

Lesson 2: Performing Calculations

• Topic A: Create Worksheet Formulas
• Topic B: Insert Functions
• Topic C: Reuse Formulas and Functions

Lesson 3: Modifying a Worksheet

• Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
• Topic B: Search for and Replace Data
• Topic C: Use Proofing and Research Tools

Lesson 4: Formatting a Worksheet

• Topic A: Apply Text Formats
• Topic B: Apply Number Formats
• Topic C: Align Cell Contents
• Topic D: Apply Styles and Themes
• Topic E: Apply Basic Conditional Formatting
• Topic F: Create and Use Templates

Lesson 5: Printing Workbooks

• Topic A: Preview and Print a Workbook
• Topic B: Set Up the Page Layout
• Topic C: Configure Headers and Footers

Lesson 6: Managing Workbooks

• Topic A: Manage Worksheets
• Topic B: Manage Workbook and Worksheet Views
• Topic C: Manage Workbook Properties