Catalog/Programs
| Budgets & Cash Flow With Excel | Clock Hours: 3.00 | CEUS: 0.30 |
Don't fall into the trap of setting up a detailed budget and then forgetting to track it! Use Excel to track your spending daily, weekly, monthly, etc. Prerequisites: Creating a Simple Excel Spreadsheet and/or Financial Analysis using Excel.Course ID
and Fee | Meeting Information | Instructor |
|
| Excel 2007, Advanced | Clock Hours: 12.00 | CEUS: 1.20 |
Discover the value of scenarios, goal seeking, solver, data tables and more advanced functions, such as VLOOKUP. Export and import text and XML files, record and run marcos, create user functions and work with PivotTables and PivotCharts.Course ID
and Fee | Meeting Information | Instructor |
|
| Excel 2007, Intermediate | Clock Hours: 12.00 | CEUS: 1.20 |
Design top-notch workbooks using outlines, templates, custom formats, charting and linking. Data management is discussed in detail to include filtering lists and using autofilter.Course ID
and Fee | Meeting Information | Instructor |
|
| Excel 2007, Introduction | Clock Hours: 12.00 | CEUS: 1.20 |
Build worksheets using formatting, printing, formulas, common functions, and charts. It is recommended that you have previous training or experience in Windows.Course ID
and Fee | Meeting Information | Instructor |
|
| Excel Formulas & Functions | Clock Hours: 6.00 | CEUS: 0.60 |
We'll start with basic math formulas and progress to conditional, lookups, date and time, financial, statistical, and conversion examples. You will also learn how to protect and hide your formulas and how to create user-defined functions.Course ID
and Fee | Meeting Information | Instructor |
|
| Excel Pivot Tables | Clock Hours: 3.00 | CEUS: 0.30 |
Learn to use PivotTables to summarize large amounts of data and analyze it in a variety of ways.Course ID
and Fee | Meeting Information | Instructor |
|
| Excel Power User | Clock Hours: 6.00 | CEUS: 0.60 |
Advanced users of Excel will learn more about complex formulas, functions, and arrays, and advanced editing and formatting options. Learn about various analysis tools such as Wizards, problem models, and methods for correlating data. In addition, the course includes advanced customization techniques by changing default settings and automating features.Course ID
and Fee | Meeting Information | Instructor |
|
| Excel VBA Programming | Clock Hours: 6.00 | CEUS: 0.60 |
Experienced Excel users gain proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.Course ID
and Fee | Meeting Information | Instructor |
|
| Excel, Introduction for Seniors | Clock Hours: 6.00 | CEUS: 0.60 |
Learn the basics of Microsoft Excel, including building worksheets, formatting, formulas, editing, printing and more! Prerequisite: Computer Basics for Seniors.Course ID
and Fee | Meeting Information | Instructor |
|
| Financial Analysis Using Excel | Clock Hours: 3.00 | CEUS: 0.30 |
Let Excel do as much of the work for you as possible! Learn about the tools in Excel that will help you analyze numbers so that formulas in one worksheet can reference data on another worksheet. Prerequisites: Creating a Simple Excel Spreadsheet.Course ID
and Fee | Meeting Information | Instructor |
|
| Time Value of Money With Excel | Clock Hours: 3.00 | CEUS: 0.30 |
Does the concept of the time value of money confuse or intrigue you? Use Excel to understand monetary present value, future value and differentiating between the alternative compounding periods. Prerequisites: Creating a Simple Excel Spreadsheet and/or Financial Analysis using ExcelCourse ID
and Fee | Meeting Information | Instructor |
|
