Microsoft Excel 2019 Level 1

In the introduction course to Excel 2019; it provides the basic concepts and skills students need 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.

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 courseware 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.

• N/A

• N/A

• N/A

Module 1: Fundamentals

• Getting around
• Workbook basics

Module 2: Creating Worksheets

• Entering data
• Formulas
• Functions
• Moving and copying data
• Reference types

Module 3: Formatting

• Text formatting
• Number formatting
• Alignment
• Borders and highlighting
• Styles and themes

Module 4: Manipulating data

• Data entry shortcuts
• Paste options
• Inserting, deleting, and hiding

Module 5: Charts

• Creating charts
• Chart types and elements

Module 6: Output

• Managing worksheet windows
• Printing worksheets
• Sharing worksheets

Module 7: Settings and templates

• Workbook options and properties
• Templates