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