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:
- Microsoft Excel Level 2 2016
- Microsoft Excel Level 3 2016
- Microsoft Excel VBA Level 1
- Microsoft Excel VBA Level 2
Related Classes:
- Microsoft Excel Pivot Tables 2010
- Useful Formulas and Functions
- Create/Analyze Database in Excel
- Microsoft Excel PowerPivot
See Also:
Prerequisites:
Students should have a basic understanding of Windows, including how to use files and folders.
Next Classes:
- Microsoft Excel Level 2 2016
- Microsoft Excel Level 3 2016
- Microsoft Excel VBA Level 1
- Microsoft Excel VBA Level 2
Related Classes:
- Microsoft Excel Pivot Tables 2010
- Useful Formulas and Functions
- Create/Analyze Database in Excel
- Microsoft Excel PowerPivot
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