SDCE Class Information

In the Beginner class, you’ll be introduced to Excel, and its many features, including:

• The Ribbon bar
• The grid, including cells, rows, columns and sheets
• Inserting and deleting cells, rows, columns and sheets
• Data types, including numbers, text and dates
• Basic formulas and how to use Excel as a fancy calculator
• Navigating around the grid, using the mouse and keyboard
• Shortcuts on entering large amounts of pattern-based data such as sequences and weekdays
• Aligning data within cells, including merging and splitting cells

PRE-REQUISITES: None

In the Formulas and More I and Formulas and More II classes, you’ll learn some of the common ways that people use Excel, and many of the things that Employers look for in their employees, including:

• Formulas with cell referencing, including Relative, Absolute and Mixed references
• Referencing data on other sheets or workbooks
• Named cells and ranges, allowing you to add custom names to cells and ranges
• Important functions including SUM, IF, VLOOKUP
• Other useful functions to manage numbers, text and dates
• Filtering columns of data
• Pivot tables, a way to group and filter large amounts of numbers
• Charts, to graphically represent data
• Conditionally formatting your data so it shows formatting depending on values
• Managing sheets for printing
• Formula auditing and troubleshooting errant formulas
• Importing data from text files and other sources
• Adding pop-out comments to cells
• Protecting cells from being changed and formulas from being seen
• Adding sheet “headers” and splitting into multiple views
• Data validation and limiting cell data based on specific requirements; this will lead into the Forms class

PRE-REQUISITES: Intermediate knowledge of Microsoft Excel

In the Excel Forms class, you will learn how to turn Excel into a true data-entry application, including:

• Hiding the grid to make the sheet look like a data entry page
• Adding non-editable labels
• Adding data validation, including limiting entry to lists or numeric ranges
• Adding typical form-based controls “above” the sheet in two ways: Excel Form Controls, ActiveX controls, including:
• Checkboxes
• Radio buttons
• Spin controls
• Listboxes
• Images
• Buttons (Control buttons)
• Getting controls to interact with the cells and applying functions to work them
• Introduction to macros to enhance the controls

PRE-REQUISITES: Intermediate knowledge of Microsoft Excel

In the Excel Macros class, you will learn how to customize Excel, including:

• Recording a macro to capture a series of actions you perform
• Playing back a macro
• Managing macro security
• Customizing a macro
• Introduction to the Visual Basic language and how to use it with Excel or Word
• Creating custom functions that can be used in formulas
• Adding custom pop-up forms that can be used to interact with the spreadsheet or act independently
• Adding ActiveX controls to a form that include things like a date-picker dropdown and web browser component

PRE-REQUISITES: Intermediate knowledge of Microsoft Excel

In this class, you’ll learn how to design and modify a database using Microsoft Access, including:

• The Access application
• Tables, Rows/Records, Columns/Fields
• Data types
• Table Relationships
• Table types:
  • Data tables
  • Lookup tables
  • Cross-reference (XREF) tables
• Keys:
  • Primary
  • Foreign
  • Alternate/Candidate
• Indexes

PRE-REQUISITES: None

In this class, learn about the SQL language and how to use the most common functions within the Access application, including:

• SELECTing record data:
  • condition clauses
  • sorting clauses
  • calculated fields
  • joining tables
  • grouping records
• INSERTing records
• UPDATing records
• DELETing records
• Using alternate table and field names

PRE-REQUISITES: Microsoft Access or another tool that supports SQL

In this class, learn about the basics of web page design, creating context for a web page and formatting it, including:

• How to mark up a document to turn it into a web page
• Some of the common mark-up codes (elements)
• Working with element attributes
• How to organize your document to effectively manage it
• Using a tool for managing web page and website creation and maintenance
• Data entry forms
• How to enhance/format your pages in several ways

PRE-REQUISITES: None

In this class, learn about the basics of web page design, creating context for a web page and formatting it, including:

• Cascading style sheet (CSS) basics:
  • local styling
  • page-level styling
  • site-level styling
• Group formatting:
  • by element
  • by id
  • by class
• Page animations (via CSS)
• JavaScript basics:
  • common commands
  • variables
  • functions
• JavaScript-web page interactions:
  • data validation
  • searching for page elements
  • creating new page elements

PRE-REQUISITES: Web Page Design Introduction or a decent understanding of HTML elements