MICROSOFT EXCEL 2019 BASIC & INTERMEDIATE

COURSE DESCRIPTION

The course empowers the trainee to understand the basic concepts of spreadsheets and to demonstrate the ability to use a spreadsheet application on a personal computer. He or she will understand and be able to accomplish basic operations associated with developing, formatting and using a spreadsheet. Additionally, trainee will be able to accomplish standard mathematical operations using basic formulas and functions. The trainee will be able to demonstrate competence in using some of the features Excel such as filtering, managing data and creating charts.

COURSE OUTLINE

Module 1. Exploring Microsoft Excel 2019

• Starting Excel 2019
• The User Interface
• The Backstage View
• Excel Options
• Working with Worksheets
• Using the Ribbon
• Hiding the Ribbon
• Customizing the Quick Access Toolbar
• Customizing Tabs
• Customizing the Ribbon
• Customizing the Status Bar
• Exiting Excel
• Practice – Exploring Microsoft Excel 2019

Module 2. Getting Help

• Using Microsoft Excel Tell Me featureces
• Practice – Getting Help

Module 3. Basic Workbook Skills

• Using the Keyboard to Select Cells
• Using KeyTips
• Using the Mouse to Scroll
• Using the Scroll Bar Shortcut Menu
• Using GoTo
• Entering Text
• Entering Numbers
• Saving the Workbook

Please contact us for the full course outline, schedules and for booking a private class.

Inquire Now