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. (0.60 CEUs)
Prerequisite: Familiarity with Windows operating system and software.
13SM2300 Jul 13 (F, 9am-4pm)
13SM2301 Sep 14 (F, 9am-4pm)
13FM2300 Nov 30 (F, 9am-4pm)
$200
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: Familiarity with Windows operating system and software.
13SM0501 Jul 27 (F, 9am-4pm)
13FM0500 Sep 28 (F, 9am-4pm)
13FM0501Dec 7 (F, 9am-4pm)
$200
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
13SM0601 Aug 10 (F, 9am-4pm)
13FM0600 Oct 12 (F, 9am-4pm)
13FM0601 Dec 14 (F, 9am-4pm)
$200
Learn how to automate daily tasks. Topics include: customizing Excel interface, use collaboration features, import data, and create, edit, and troubleshoot macros. (0.6 CEUs)
Prerequisite: Excel 2010 Advanced or equivalent knowledge.
13SM0701 Aug 17 (F, 9am-4pm)
13FM0700 Oct 26 (F, 9am-4pm)
$200
The exam prep class gives you a chance to take practice exams that mimic the real exams in a classroom with an instructor to further assist your understanding of each topic. Exam prep course includes: Excel 2010 Introduction, Excel 2010 Intermediate, Excel 2010 Database Features & Advanced Functions, Excel 2010 Collaboration & Macros, and Excel 2010 Exam Prep. (3.0 CEUs)
Prerequisite: Experience using Microsoft Windows software.
13SM1900 Sep 14-Nov 9 (F, 9am-4pm)
$1,025