02/07/2020 Microsoft Excel 2019 Level 1 - Beginner

Location:

Collaboration Studio (HCS) at HCC

1602 N. 15th St. (Corner of 15th St. and 5th Ave.)

Tampa, Fl 33605 Map

Parking: Parking is available next to the building.

Room: HCS 132

Day: February 7, 2019

Time: 8:30 AM to 4:30 PM 

Note: The book will be given by the instructor. 

Course Description:

Microsoft Excel 2019 Level 1 is the first and foundation class of a three part series. The delivery method involves hands-on experience in a computer center using Excel spreadsheets to create basic data reports. 

Excel 2019 Level 1 provides the basic concepts and skills to start being productive with Microsoft Excel 2019: how to create, save, share, and print worksheets that contain various kinds of calculations and formatting. This course, and the two that come after, map to the objectives of the Microsoft Office Specialist and Expert exams for Excel 2019. Objective coverage is marked throughout the course.

Students will benefit most from this course if they want to accomplish basic workplace tasks in Excel 2019, or if they want to have a solid foundation for continuing on to become an Excel Expert. If they intend to take a Microsoft Office Specialist or Expert exam for Excel, this course is a good place to start their preparation, but they will need to continue on to other courses in the series to be fully prepared for either exam.

Prerequisites:

The course assumes students know how to use a computer, and that they're familiar with Microsoft Windows. It does not assume that they've used a different version of Excel or another spreadsheet program before. Suggested course: Computer Basics & Introduction to Microsoft Office.

Who should attend? 

Office professionals, small business owners and anyone with no excel skills and/or experience, or who wants to improve their Excel skills.  

Instructor: Joel Ericson

Other Courses in the Series:

• • Excel 2019: Level 2
  • Excel 2019: Level 3

Outline:

Chapter 1: Fundamentals

• Module A: Getting around
• Module B: Workbook basics

Chapter 2: Creating worksheets

• Module A: Entering data
• Module B: Formulas
• Module C: Functions
• Module D: Moving and copying data
• Module E: Reference types

Chapter 3: Formatting

• Module A: Text formatting
• Module B: Number formatting
• Module C: Alignment
• Module D: Borders and highlighting
• Module E: Styles and themes

Chapter 4: Manipulating data

• Module A: Data entry shortcuts
• Module B: Paste options
• Module C: Inserting, deleting, and hiding

Chapter 5: Charts

• Module A: Creating charts
• Module B: Chart types and elements

Chapter 6: Output

• Module A: Managing worksheet windows
• Module B: Printing worksheets
• Module C: Sharing workbooks

Chapter 7: Settings and templates

• Module A: Workbook options and properties
• Module B: Templates