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.
S2- Excel Level 2
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.
S3- Excel Charts & Graphs
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.
S4- Excel Formulas & Functions
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.
S5- Excel Macros Visual Basic Level 1
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.
S6- Excel Macros Visual Basic Level 2
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.