In this course, students learn to create and manage Excel worksheets and workbook files, enter data, and create basic formulas to perform calculations. They learn to format cell content, view and format work-sheets, and practice preparing, previewing, and printing workbooks.
Students accomplish the learning objectives for each module through a series of hands-on activities, and there are frequent opportunities to practice, apply, and develop the skills covered in the course.
Introduction to Windows course or equivalent.
The course consists of 10 graded, end-of-module quizzes and a final exam, which consists of practical and online test components.
The course includes a digital Student Reference Guide and Let Me Try workbook. Printed versions of these may be purchased separately.
Module 1: Introduction to Excel
The Excel Window; Mouse Basics in Excel; Backstage View
Module 2: Creating Workbooks
Entering Text and Numbers; Creating Basic Formulas; Relative References; Order of Operations; Working with Ranges
Module 3: Saving and Sharing Workbooks
Saving a Workbook; File Extension, Sharing, Exporting, and Publishing Files
Module 4: Navigating Workbooks
Opening Files; Working with Larger Files; Creating Freeze Panes; Split Screen
Module 5: Page Setup and Print Options
Headers and Footers; Print Titles; Working with Comments; Page Setup Options; Printing Workbooks
Module 6: Working with Rows, Columns, and Cells
Adding and Deleting Rows, Columns and Cells; Changing Column Width and Row Height
Module 7: Moving Data
Cut, Copy, and Paste; Copying Formulas
Module 8: Formulas and Functions
Overview of Formulas; Creating Formulas Using Functions; Using Absolute Values
Module 9: Working with Sheets
Adding, Deleting, Renaming and Grouping Sheets; Additional Sheet Tab Options; 3-Dimensional Formulas
Module 10: Formatting Worksheets
Formatting Cells; Formatting Numbers; Borders and Shading; Formatting a Range of Cells as a Table; Using Styles and the Format Painter; Protecting Sheets; Using the Fill Handle and Creating Custom Lists
Students may continue with Microsoft Excel Level 2.
Program: Business Programs
Course Aim: To provide an overview and introduction to Microsoft Excel for creating and managing spreadsheets.
Of interest to: Those interested in preparing and maintaining financial statements and other kinds of reports in an up-to-date office spreadsheet environment.
Method of Delivery: Integrated Learning System training facilitated by Academy of Learning Career College Learning Coaches.
Contact us for more information
And we'll get back to you within 48 hours.