Excel Level 1
Program Description & HIGHLIGHTS
Microsoft Excel 2016 teaches the information worker how to work with different types of spreadsheet documents using a variety of core and intermediate features to create and edit professional-looking spreadsheets for a variety of purposes and situations. Some topics may appear to be basic skill sets but are discussed in more detail, exploring at a higher level different options that can be chosen or applied for that skill set.
Upon completion of this program the successful student will have reliably demonstrated the ability to use Excel to create and edit professional-looking spreadsheets for a variety of purposes and situations. As students begin to gain confidence they will create a variety of flyers and other promotional materials as well as explore different ways to share the information with internal and external customers.
After completing this course, students will be able to:
- understand and describe the concept of electronic spreadsheets
- identify the basic components of Excel
- enter data, symbols, and special characters into a worksheet
- move around in a workbook
- create, open, save and close a workbook
- save a workbook in a previous Excel version format
- select a range of cells
- change and undo changes to the contents of cells
- cut, copy, and paste data in a worksheet using the Windows and Office Clipboard
- adjust column widths and row heights
- hide and unhide rows and columns
- insert and delete rows, columns, or cells
- find and replace data in a worksheet
- use AutoFill to copy or fill data or set up a series of data
- rename, insert, delete, copy or move worksheets
- create and edit simple formulas using math operators and cell references
- use commonly-used functions and conditional functions
- use absolute and relative cell references
- display and print formulas
- format numbers and decimal places
- enhance the worksheet using fonts, alignment, lines, borders, colors or patterns Æ use the Format Painter
- clear cell contents and formatting
- apply themes, styles, and conditional formatting
- create and arrange worksheet windows
- split and freeze panes
- zoom in and out of worksheets
- print and preview worksheets
- use different workbook views
- add and preview page breaks
- change margins, orientation, or layout for printing a worksheet
- set headers and footers for a worksheet
- change Excel options
There are no requirements.
Offered at both Kelowna and Surrey campus.
Contact Focus College for pricing.
21 hours of classroom instruction plus exercises and project.