Microsoft EXCEL: Intermediate

Registration Deadline: October 18, 2019

CLASS IS SOLD OUT 

Mon, Oct 21, 2019
08:00 am -  12:00 pm
Registration options:
Ticket Name Ticket Price Qty
SOD Members
Must bring own laptop with EXCEL
$ 45.00
Non-members
Must bring own laptop with EXCEL
$ 55.00

Event description:

 

 

 

 

 

 

 

 

This course will enhance the user's prior knowledge of Microsoft Excel, creating a more efficient user.

 

Topics to be covered include:

  • Working with Multiple Worksheets and Workbooks
    • Using links and external references
    • Grouping
    • 3-D references
  • Functions and Formulas
    • Cell or range names
    • Financial
    • Logical
    • Date and time
    • Text
    • Lookups
  • Data Management
    • Sorting
    • Filtering
    • Subtotals "feature" instead of the function
    • Conditional formatting
  • Charting
    • Review of the basics
    • Chart templates
    • Sparklines

Course Materials Needed by Participants:

  • Windows or Mac OS Laptop
  • Microsoft Office Applications (i.e. Word, Excel, PowerPoint)
  • Pen/Pencil
  • Notebook
  •  

Location Map

Information

Location Details

Organizer Details