Learn to use the latest version of Microsoft Excel! This class provides a thorough introduction to using Excel. You will learn how to create, edit, and print a simple spreadsheet with simple formulas, move quickly within a spreadsheet, change the appearance of text and numbers; and unlock the magic of correctly copying formulas. Prerequisite: Familiarity with Windows operating system and software. (0.60 CEUs)
In this course you will expand on your understanding of working with spreadsheets. You will learn how to use multiple worksheets, work with advanced functions and formatting features, use AutoFilters, use special format and print options, protect worksheet data, manipulate the screen display, import and export data, and create simple charts. (0.6 CEUs)
Prerequisite: Excel Introduction or equivalent knowledge.
In this course you will learn how use the powerful database functions and features that help you solve problems. Topics include: creating a database, sorting data, extracting data, using advanced filters, using database functions, using automatic subtotals, creating and using look-up and pivot tables, and using Goal Seek and Solver. (0.6 CEUs)
Prerequisite: Intermediate Excel or equivalent knowledge.