Microsoft Excel Level 1 / Intro (2013, 2016, 2019) (AA-EXCL1-Level-1)

This course is intended to help users get up to speed with Excel quickly. We will cover different features of the interface, the basics of formatting and editing, the basics of building formulas and functions and show users how to print.

Getting Started with Microsoft Excel

• Identity the Elements of Excel Interface
• Create a Basic Worksheet
• Use the Help System

Modifying a Worksheet

• Manipulate Data
• Search for the Replace Data
• Spell Check a Worksheet

Formatting a Worksheet

• Modify Fonts
• Add Borders and Colors to Cells
• Apply Number Formats
• Align Cell Contents
• Apple Styles

Performing Calculations

• Create Formulas in a worksheet
• Insert Functions in a Worksheet
• Reuse Formulas

VisualizingData with Charts

• Create Charts
• Modify and Format Charts

Printing Workbook Contents

• Refine the Page Layout and Apply Print Options

Refine the Page Layout and Apply Print Options

• Format Worksheet Tabs
• Manage Worksheets
• Manage the View of Worksheets and Workbooks

Customizing the Excel Environment

• Customize Proofing and Save Options
• Customize the Ribbon and Quick Access Toolbar
• Customize the Advanced and Trust Center Options

Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization. You will:

• Modifying a Worksheet
• Formatting a Worksheet
• Performing Calculations
• Basic Charts
• Printing Workbook Contents
• Refine the Page Layout and Apply Print Options
• Customizing the Excel Environment

The prerequisites for this course are an introductory course to Windows or a solid working knowledge of Windows.

Do you have more questions? We're delighted to assist you!

• Formatting Rows and Columns
• Search and Replace
• Borders and Colors
• Align Contents
• Functions
• Format Tabs
• Manage Multiple Workbooks
• Custom the Excel Environment

This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel that is necessary to create and work with electronic spreadsheets.