Foundation Centre 119
3591 Anderson Street
Madison WI 53704
(608) 258-2301 or (855) 473-2301 option 2
Whether you are considering a job change or need to learn something new in your current role, a short hands-on computer course can be a great way to upskill and advance your career. See also graphic design and web design courses.
In this course, students will expand upon the skills learned in the introductory course and learn more about using Quickbooks to deal with physical inventory and payroll.
Do you want to turn your unwanted stuff into treasure? Conducting business online has been made relatively easy and profitable. This course provides you the opportunity to learn strategies to create a business on eBay.com and with other ecommerce channels.
Are you crafty? Interested in selling your handmade items online? Learn the ins and outs of setting up shop on Etsy. Learn how to get started, how to enter descriptions of products and your shop, choose keywords, upload photos, and present a professional online storefront.
Learn how to use mail merge to integrate information from a data source into Word documents to create custom letters, labels, envelopes and more. Add a watermark to a document or use special effects with text. Format pictures with artistic effects and text wrap. Set up headers and footers and become familiar with page numbering options. Learn how to set up columns and control column breaks and paragraph grouping. Use themes and predefined styles or create custom styles to maintain consistent formatting, improve accessibility, and to generate a Table of Contents with ease.
Get more out of your iPad or iPhone. Learn how to adjust settings, increase battery life, and use your cellular data efficiently. Learn about cloud storage, composing messages, and more. Learn how to use the iTunes and Apps Stores to download apps, music, movies, books, and more.
Already familiar with controls, settings, and downloading apps for your iPhone or iPad? This course will help you get the most out of your Apple device. Learn about advanced settings, power and data management, and advanced use of all pre-installed apps such as the Camera, Contacts, and Email. Learn more about great apps for mapping, music, weather, and more.
Get more out of your Android smartphone or tablet. Learn how to adjust settings, increase battery life, and use your cellular data efficiently. Learn about cloud storage, composing messages, and more. Learn how to use the Google Play Store to download apps, music, movies, books, and more.
Already familiar with controls, settings, and downloading apps for your Android smartphone or tablet? This course will help you get the most out of your Android device. Learn about advanced settings, power and data management, and advanced use of all pre-installed apps such as the Camera, Contacts, and Email. Learn more about great apps for mapping, music, weather, and more.
This introductory course in MS Excel spreadsheets covers working with tables and creating and navigating worksheets, including entering, editing and formatting numbers, text, and dates. Learn how to write formulas and use functions for calculations. Create and format charts to visualize data and illustrate trends. Explore sorting and filtering while learning some helpful tools for working with large data sets.
Learn how to work with Excel functions, Smart Tags, column and row adjustments, conditional formatting, rotate text in a cell, freeze and unfreeze cells, color code your worksheet tabs, and more. Review how to enter formulas in Excel and then copy them to another location.
Apply more advanced workbook formatting using themes and styles, and learn to use custom number formats and conditional formatting. Add subtotals, nested functions, date and time calculations, text modification, and conditional functions to your Excel skillset. Explore the potential of lookup functions and analysis tools.
The pivot table is one of the most useful spreadsheet tools for analyzing and summarizing data. Explore the visualization possibilities of Excel charts, pivot tables, and pivot charts.
Learn to use sorting and filtering options in MS Excel to rearrange and reorganize data to meet desired criteria without changing and moving it. Become familiar with using sort order to organize data as well as filtering to hide unneeded data.
Harnessing the power of VBA in MS Office can make you the MVP at your company! In this course, students will learn how to use macros to automate routine tasks and create custom functions in MS Excel, beginning from simple examples and working up to Visual Basic programming using dialog boxes and control structures.
Become familiar with the MS Access software and basic database concepts such as tables, data types, and key fields. Learn how to sort and filter tables, import data, and create or modify forms. Build queries to select data from one or more tables to meet desired criteria, do basic calculations and output chosen fields. The course will also introduce reports and basic report editing.
Become more familiar with table design and relationships, field property and format options, and validation. Create custom input forms with calculations. Build more powerful queries using parameter queries and crosstab queries, and use action queries to create or modify tables. Explore more advanced features for customizing reports.
Learn how to use MS Project to help manage and communicate the status of your projects. Topics covered include: navigating MS Project & overview of what’s available, how calendars work, working with tasks, developing project plans, managing & scheduling resources, developing timelines & reports, and exporting data. This course will include examples of how to use the software to increase your project management communications and skills.
Knowledge of Python can make you a rock star at work and the go-to person whenever a challenging problem arrives. Students will learn how to use the simple but powerful Python programming language to solve everyday problems through the creation of computer programs that automate tedious and sometimes complex tasks.
Python is a widely used programming language for data analysis and reporting because the language emphasizes productivity and code readability. This class expands concepts that are part of an introductory Python course and emphasizes the creation of scripts to support data analysis procedures and the automation of tasks. Students will learn procedures that can be used to interact with remote (Server) and local databases, efficiently process multiple data files, create supporting data structures, and generate reports in the form of spreadsheets, charts, or maps. During the lectures students will learn class concepts through discussions and in-class exercises that will rely on code templates provided by the instructor to complete data analysis and automation tasks. As part of the class students will have an opportunity to improve their coding skills by practicing debugging, breaking problems into small tasks, and interacting with objects and packages created by other people.
Create three-dimensional models of your designs using the free program SketchUp Make. Topics covered include creating basic geometry, understanding stickiness in SketchUp and how to use it to your advantage, using the drawing tools, creating and working with groups and components, texturing your model, creating scenes, and managing styles. The features and benefits of SketchUp Pro will be introduced along with additional resources for further study.
Learn advanced modeling techniques and presentation document creation with SketchUp Pro including Layout. Topics covered include custom template creation, keyboard shortcuts for improved workflow, utilizing the power of scenes and layers, sending your model to Layout, creating construction drawings with layout including adding dimensions, using pattern fills, using layers, and creating custom scrapbooks.
In this class we will discuss and demonstrate the process of Computer Aided Design using the industry-standard Autodesk AutoCAD. Students learn how to customize the software while incorporating AutoCAD into their design process using graphic standards. Topics include document setup, 2-dimensional drawing, modifications, dimensioning, and document layout for printing.
The Intermediate class takes up where AutoCAD Intro leaves off. The student will learn further customization of the AutoCAD and AutoCAD LT program, working with external references and raster images, developing annotated blocks and exploring simple 3-D drawing. Students will utilize and create more complex drawing functions and drawings and work with AutoCAD formulas to create property lines. Additional topics include X-Reffing (External Reference files) other AutoCAD drawings and creating modifications, Inserting and working with raster images within an AutoCAD drawing, and developing, editing and using annotated blocks.
Revit is Building Information Modeling (BIM) software that helps you effectively capture and visualize your CAD concepts and maintain your vision through the design process creating accurate and reliable results. The information-rich 3D models are highly effective throughout the process from design to documentation, and finally construction.
This course is for the beginning Mac user. Students will become familiar with Mac basics and applications such as Mail and Safari and will learn about iLife (iPhoto, iMovie, iTunes, iWeb, iDVD, and GarageBand).
In this workshop you will explore eBay, the premier online marketplace. Learn the basics of how to create accounts, browse, bid, buy and sell items at the site. Note that students are not required to make bids and are responsible for their own purchases, if any. Those who are interested only in selling should consider the Selling on eBay course instead.
Set up your free Facebook account, add information to your profile, choose your privacy settings, add photos, and start making connections online with your friends and family.
Learn how to navigate your Gmail inbox. Create customizable tabs to see what's new at a glance, learn about the search functionality, view attachments instantly, and create messages with a new composition function that is packed with features.
Learn how to use this free online word processor that lets you create and format text documents and collaborate with others in real time. Topics include how to upload and convert a Word document, adding creative formatting, inviting others to collaborate, and viewing revision history.
Learn how to navigate the Microsoft Word environment and create a variety of documents. Learn how to work with tables in a Word document. Work with shapes, WordArt, SmartArt, text boxes and pictures. Become familiar with page setup options, borders and background formatting. Learn how to control margins, tab stops and indentation. Styles, columns, captions, change tracking, and footnotes will be introduced as well.
Obtain two Hyland Software certifications in two weeks!
OnBase Certified System Administrators (OCSA) are in high demand. If you are a systems administrator, business analyst, systems analyst or other IT professional with a basic understanding of networking, database and security fundamentals who wants to gain knowledge and practical experience in OnBase software, then this is the course for you.
Becoming an OnBase Certified System Administrator can open up new career opportunities for you. This course will train you to effectively use, maintain, administer, and configure business process automation in OnBase, an enterprise information platform for managing content, processes and cases.
Once trained in OnBase, extend that training to the next level with the OnBase Certified Workflow Administrator (OCWA) certification. This course will teach you how to take business requirements from key business stakeholders and implement solutions in to those requirements using OnBase Workflow. OnBase Workflow is an automation engine and electronic routing system that enables organizations to process work faster and more efficiently.
A limited number of scholarships are available, and applications will be due on June 29, 2018. Please complete a scholarship application form if you are interested. There are a limited number of seats available; sign up soon!
To register, use the course links above to locate an upcoming section and login to add to cart, or note the 5-digit class number and phone (608) 258-2301, ext 2, for registration assistance.
No application is needed. If you have never taken a class here before, you can facilitate enrollment by creating a student account.