Computer Literacy Courses

Courses Description
Computer Fundamentals Level 1 How to use a personal computer to save files, create folders, renaming files and folders, Knowledge of how to use Windows, and how to copy and paste files. Using a word processor to create a file. Become familiar with the keyboard and enter text into a document.
 
Prerequisite/Recommended Knowledge: This is the first class of the series. No required knowledge, though, it is recommendable to have some familiarity with computers and email. 
Computer Fundamentals Level 2 How to use a personal computer to save files, create folders, renaming files and folders, Knowledge of how to use multiple windows for multitasking. Copying files from a digital camera and doing a manual backup of files
 
Prerequisite/Recommended Knowledge: Computer Fundamentals Level 1 or equivalent
Computer Fundamentals Series This course includes Computer Fundamentals Level 1 and 2 described above.
 
Prerequisite/Recommended Knowledge: Computer Fundamentals Level 1 or equivalent
Fundamentals of Word Level 1 Learn the basics of navigating Microsoft Word, create documents, enter text, revise, format, and save files. This is an excellent class before taking Excel Level 1, as it helps learning the Microsoft menu structure and to apply formats.
 
Prerequisite/Recommended Knowledge: Computer Fundamentals Level 1 & 2
PowerPoint Level 1 Learn the fundamentals of creating a basic presentation. Apply slide layouts, graphics, formatting, charts and more. Apply themes to make a professional-looking presentation quickly. Learn some tips for giving a presentation. This is an excellent class before taking Excel Level 1, as it helps learning the Microsoft menu structure and to apply formats.
 
Prerequisite/Recommended Knowledge: Computer Fundamentals Level 1 & 2.  It is recommended to learn Word 2013 or Word 2016 prior to taking Excel 2016.
Excel 2016 Level 1 Create and edit spreadsheets, enter values and locate cell references. Create formulas, charts and trendlines. Understand relative, absolute, and mixed cell references in formulas.

Enter and formatting data, Apply number and date formats, Enter a series of related data, Perform simple calculations, Create cell references and use cell references in formulas.

Rearrange data on a worksheet, Manage multiple worksheets, Use functions to perform calculations, Use relative and absolute cell references in formulas.

Creating and modifying charts, Move and size charts, Edit chart data, Start a workbook from a template, Import and export data, Change worksheet view options, Sort and filter data, Create IF functions. Create Excel tables. Apply data validation rules.

 
Prerequisite/Recommended Knowledge: Computer Fundamentals Level 1 & 2. It is recommended to learn Word 2013 or Word 2016 prior to taking Excel 2016.

Excel 2016 Level 2 Apply and customize themes, Create and use cell styles, Apply cell borders and fill, Create custom number formats, Customize the page setup, Add images to a worksheet, Apply conditional formatting, Edit document properties, Identify date serial numbers, Apply custom date formatting, Enter times in Excel, Create functions using dates, Perform date and time calculations, Create customized conditional formatting rules, Edit rules using the conditional formatting, Use functions to format text, Create conditional functions using IF and IFS, Create formulas using nested functions, Find and correct errors in formulas, Use 3-D cell references in formulas, Create formulas using lookup functions, Use the Outline feature.
 
Prerequisite/Recommended Knowledge: Computer Fundamentals Level 1 & 2 and Excel Level 1. It is recommended to learn Word 2013 or Word 2016 prior to taking Excel 2016.
Excel 2016 Level 3 Learn to create Excel tables, the basics of how to create and use pivot tables and charts. Learn to apply and customize conditional formatting, create and use data valuation rules, and explore advanced formula techniques to nest several formulas to work together in one operation.
 
Prerequisite/Recommended Knowledge: Computer Fundamentals Level 1 & 2 and Excel Level 1 and 2. It is recommended to learn Word 2013 or Word 2016 prior to taking Excel 2016.
Mastering Excel Pivot Tables In this course we cover one of advanced skills in Excel Pivot Tables. What are they, how do they work? We walk you through all the steps to create a pivot table, how to work with pivot charts, using Excel tables effectively with Pivot Tables, how to create calculations in Pivot Tables, and more.
 
Prerequisite/Recommended Knowledge: Knowledge of the basics of Pivot Tables and Pivot Charts is recommended as well as the knowledge gained in Fundamentals of Excel, Level 1, Level 2 and Level 3.