Microsoft Excel - Level 1 (10 Hours)

COURSE OBJECTIVES:

This course empowers you to:

• Write a range of fundamental Excel commands
• Perform worksheet calculations
• Build custom formulas
• Amend elements in a worksheet
• Apply formatting changes to cells
• Manage workbook properties

 COURSE OUTLINE

1 - GETTING STARTED WITH MICROSOFT OFFICE EXCEL

• Learn Your Way Around the Excel Menu
• Understand and Apply Excel Formulas
• Create and Save a Basic Workbook
• Enter Data Into Cells
• Access Excel Help

2 - PERFORMING CALCULATIONS

• Build Custom Worksheet Formulas
• Insert Built-In Functions to Your Data
• Save and Reuse Formulas

3 - MODIFYING A WORKSHEET

• Insert, Delete and Resize Cells, Columns and Rows
• Search for and Replace Data
• Use Proofing and Research Tools

4 - FORMATTING A WORKSHEET

• Format Text and Numbers
• Align Cell Data
• Apply Styles, Themes and Basic and Conditional Formatting
• Create and Select Worksheet Templates

5 - PRINTING WORKBOOKS

• Preview and Print a Workbook
• Set Up the Page Layout
• Configure Headers and Footers

6 - MANAGING WORKBOOKS

• Manage Worksheets and Workbook Properties
• Create, Apply or Delete Workbook and Worksheet Views
  
  

  Actual course outline may vary depending on Students pace of learning.