Microsoft Excel Level I

(versions: 2003, 2007, 2010, 2016 and 2019)*

Location: Online Format (Zoom, WebEx, Google Meet)

General Overview: Microsoft Excel is a spreadsheet program which allows users to create, edit and display data quickly and easily. It is a powerful program, beautifully designed so that you can simplify your use and analysis of vast amounts of data.

Learning Objectives: In this course, you will create, edit, display and print Excel Workbooks, using new features and custom interface tools.

You will: 

• Enter, edit, and format data to create workbooks
• Enter data using time-saving tools like Flash Fill and Autocomplete
• Use functions and formulas to calculate data
• Understand Relative and Absolute Cell References
• Format worksheets and cells
• Print workbooks
• Customize the interface by changing ribbon display options and customizing the Quick Access Toolbar

Target Student: This course is for individuals who are new to Microsoft Excel or who have not received any formal training in the Excel environment and want to gain confidence navigating the interface, using functions and formulas to calculate data, and formatting their data in order to produce quickly and present it clearly.

Course Outline: Section 1: Getting Started with Microsoft Excel

• Understanding Spreadsheet Concepts
• Getting Started
• Creating and Saving Workbooks
• Opening and Closing Workbooks
• Review Exercise 

Section 2: Modifying Worksheets

• Working with Columns and Rows
• Working with Cell Contents
• Review Exercise

Section 3: Using Formulas and Functions

• Creating and Using Formulas
• Creating and Using Functions
• Using Absolute Cell References
• Inserting Functions
• Review Exercise

Section 4: Formatting and viewing Worksheets

• Formatting Worksheets
• Viewing Worksheets
• Review Exercise

Section 5: Printing Workbook

•  Using Worksheet Views
• Changing the Page Setup
• Previewing and Printing Workbooks
• Review Exercise
• Customize General and Language Options
• Customize the Ribbon and Quick Access Toolbar

*All Classes are instructor led.
Class recording will be made available after the class.

LOOKING FOR ALTERNATIVE DATES – CONTACT US HERE