Learn new computer skills through our practical and interactive training courses. Courses are perfect for beginning, intermediate, and advanced computer users.
Class Information
Course availability is subject to change so check the listing of available courses for the most up-to-date comprehensive listing.
*In Person | Student must bring Flash Drive to class
Student to bring Flash Drive
In this Introduction to Microsoft Excel class, students will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print Basic Microsoft Excel worksheets.
Click here to see course outline (Opens in new window)
Target Audience: Students who have little or no experience with Microsoft Excel.
**Prerequisite: Students should have basic computer experience using the mouse and keyboard, locating their Documents folder and starting Excel.
Student to bring Flash Drive to class
In this Intermediate Level Microsoft Excel class, students will continue working with worksheets and workbooks. This course is designed for students who want to design their own workbooks — to create formulas, tables, and charts as opposed to simply entering or reviewing data.
Click here to see course outline (Opens in new window)
Target Audience: Students who have a basic understanding of entering and reviewing data in Excel and now want to learn how to create/design worksheets for their own projects.
**Prerequisite: Students should have a basic understanding of using the Ribbon, entering/formatting text and numbers, creating a simple formula and printing a worksheet.
Student to bring Flash Drive to Class
PIVOT TABLES • 6 HOURS
PRESENT YOUR DATA CLEANLY AND CONCISELY
Many large spreadsheets are useful for the person entering the data, but not for the person reviewing
the data. Learn how to create tables and charts that “pivot” with your choices on how to view the
data so you can maximize your results.
Target Audience: Students already familiar with the Excel environment who want an introduction
and in-depth overview of Pivot Tables.
Prerequisite: Excel Intermediate. This course proceeds at a professional pace. Students must have typing skills and PC knowledge. The typical student uses Excel daily.
Student to bring Flash Drive
FUNCTIONS • 6 HOURS
Excel’s functions are powerful. We build on the IF function that we learned in the Intermediate
course with nested IF functions, SumIF, CountIF, AverageIF and IF Error. Sum, Count, and
Average with a specific criteria with SumIFS, CountIFS, and AverageIFS. Expand your
knowledge of XLookups, Named Ranges, and learn to use the FILTER function to return
multiple values. Create and format functions that calculate dates and time. Find duplicates
with the EXACT function or pull only non-duplicates with the UNIQUE function.
Target Audience: Students already familiar with the Excel environment who want to expand their
knowledge of functions and formulas.
Prerequisite: Excel Intermediate. This course proceeds at a professional pace. Students must
have typing skills and PC knowledge. The typical student uses Excel daily.
Student to bring Flash Drive
MACROS • 6 HOURS
STREAMLINE REPETITIVE TASKS USING MACROS
Automate your repetitive tasks using Macros. Class includes an extensive review of keyboard shortcuts.
Target Audience: Students already familiar with the Excel environment who want an introduction and in-depth overview of Macros.
Prerequisite: Excel Intermediate. This course proceeds at a professional pace. Students must have typing skills and PC knowledge. The typical student uses Excel daily.
Need help learning to type? Typing.com (opens in new window) is free and can help
Mitchell Community College’s Continuing Education Division partners with Ed2Go to deliver quality education online. Courses are self-paced or instructor lead. Student chooses the best option.
Online computer courses
Click here for computer course list (opens in new window)
See below for a sample listing of available online courses. For a Complete list of courses Click Here (Opens in New Window)
Complete course descriptions are listed on Ed2Go. Click Here to access Ed2Go (opens in new window)
Step 1 See the variety of courses available
Step 2 Choose the course that matches the software you are using
Step 3 Carefully read the requirements for the course. Each course lists the software requirements.
Step 4 Register and begin learning
Ed2Go contains over 300 courses on various topics.
Start learning online!
Cabanna Pierce Administrative Assistant
cpierce@mitchellcc.edu
