Spreadsheets
SPREADSHEET CLASSES
S1- Excel Level 1, 9am-12pm, $225
Learn the basics of entering labels, numbers and formulas into a spreadsheet. Many useful tips and tricks, even if you are already using Excel. Create simple charts and graphs. Print out all or part of your worksheet, including headers and footers. Formatting and function formulas are also covered. Everything you need for creating spreadsheets is in this class.
Mar 03, Apr 07, May 05, Jun 02, Jul 07, Aug 04, Sep 01, Oct 06, Nov 03, Dec 01
S2- Excel Level 2, 9am-12pm, $225
Covers the database features of Excel including sorting, filters, subtotals and pivot tables and how to link sheets and workbooks together. More complex formulas using absolute references are introduced ,along with cell and worksheet protection. Great class for anyone using excel to make financial or business decisions.
Mar 11, Apr 08, May 13, Jun 10, Jul 15, Aug 12, Sep 16, Oct 14, Nov 11, Dec 09
S3- Excel Charts & Graphs, 9am-11am, $150
Create more complex line, bar and pie charts, use the chart sub system to rotate, annotate and enhance Excel charts. Lots of tips and tricks in this class.
Mar 18, Apr 15, May 20, Jun 17, Jul 22, Aug 19, Sep 23, Oct 21, Nov 18, Dec 16
S4- Excel Formulas & Functions, 11am-1pm, $150
Explores different Excel operators such as arithmetic, comparison, logical and text. More complex functions are covered for statistical, financial, date and logical information. An advanced class for the experienced user.
Mar 25, Apr 22, May 27, Jun 24, Jul 29, Aug 26, Sep 30, Oct 28, Nov 25, Dec 23
S5- Excel Macros Visual Basic Level 1, 1pm-3pm, $150
Learn the basics of Macros, including relative and absolute macros. You will record a variety of macros and then learn how to decode the Visual Basic code that is generated through the recorder. No need to be a programmer to take this class.
Mar 18, Apr 15, May 20, Jun 17, Jul 22, Aug 19, Sep 23, Oct 21, Nov 18, Dec 16
S6- Excel Macros Visual Basic Level 2, 3pm-5pm, $150
Learn how to write macros in Visual Basic Code in this class. Basic programming constructs are covered including literal values, variables, decisions, case statements, loops and subroutines. This class is the equivalent of an introduction to basic computer programming.
Mar 18, Apr 15, May 20, Jun 17, Jul 22, Aug 19, Sep 23, Oct 21, Nov 18, Dec 16