Microsoft Office

Unsure About Your Level?

If you are not sure about which Microsoft Office level to attend, click here and take the self-evaluation. It will allow you to review your skills and choose the level that is right for you. If you have questions, call Continuing Education Coordinator Dan Schmidt at 785.228.6393.

Microsoft Access 2013, Level I

This course is designed for students who wish to learn the basic operations of the Microsoft Access Database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. The Level 1 course is for the individual whose job responsibilities include designing and creating new databases, tables and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database. It also provides the fundamental knowledge and techniques needed to advance to more complex Access responsibilities such as maintaining databases and using programming techniques that enhance Access applications. Upon successful completion of this course, you will be able to: Identify the components of the Microsoft Access 2013 environment, identify the components of a database, organize data in tables, view data in tables, query a database, design forms and generate reports.

Microsoft Access 2013, Level II

Participants will improve and customize tables, queries, forms and reports, and share Access data with other applications. Upon successful completion of this course, you will be able to: streamline data entry and maintain data integrity; join tables to retrieve data from unrelated tables; create flexible queries to display specified records; allow for user-determined query criteria and modify data using queries; improve forms; customize reports to organize the displayed information and produce specific print layouts; and share data between Access and other applications.

Microsoft Access 2013, Level III

Participants will create complex Access databases by structuring existing data, writing advanced queries, working with macros and performing database maintenance. Upon successful completion of this course, you will be able to: restructure data into appropriate tables to ensure data dependency and minimize redundanc;, write advanced queries to analyze and summarize data; create and revise Access 2013 macros; customize reports by using various Access 2013 features; and maintain their databases using Access 2013 tools.

Microsoft Access 2010, Level I

This course is designed for students who wish to learn the basic operations of the Microsoft Access Database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. The Level 1 course is for the individual whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database. It also provides the fundamental knowledge and techniques needed to advance to more complex Access responsibilities such as maintaining databases and using programming techniques that enhance Access applications. Upon successful completion of this course, you will be able to: Identify the components of the Microsoft Access 2013 environment; Identify the components of a database; organize data in tables; view data in tables; query a database; design forms; and generate reports.

Microsoft Access 2010, Level II

Participants will improve and customize tables, queries, forms and reports, and share Access data with other applications. Upon successful completion of this course, you will be able to: Streamline data entry and maintain data integrity; join tables to retrieve data from unrelated tables; create flexible queries to display specified records; allow for user-determined query criteria; and modify data using queries, improve forms, customize reports to organize the displayed information and produce specific print layouts and share data between Access and other applications.

Microsoft Access 2010, Level III

Participants will create complex Access databases by structuring existing data, writing advanced queries, working with macros and performing database maintenance. Upon successful completion of this course, students will be able to: restructure data into appropriate tables to ensure data dependency and minimize redundancy; write advanced queries to analyze and summarize data; create and revise Access 2010 macros; customize reports by using various Access 2010 features; and maintain their databases using Access 2010 tools.

Microsoft Access 2007, Level I

In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Access 2007 relational database application. Upon successful completion of this course, you will be able to: examine the basic database concepts and explore the Microsoft Office Access 2007 environment; design a simple database; build a new database with related tables; manage data in a table; query a database using different methods; design forms and generate reports.

Microsoft Access 2007, Level II

In this course, participants will consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications. Participants will maintain data consistency and integrity, improve queries, forms, and reports, and also integrate Microsoft Office Access 2007 with other applications. Upon successful completion of this course, you will be able to: modify the design and field properties of a table to streamline data entry and maintain data integrity; retrieve data from tables using joins; create flexible queries to display specified records; allow for user-determined query criteria and modify data using queries; enhance the capabilities of a form by grouping form controls and making other aesthetic improvements to make forms work more efficiently and intuitively for the user; customize reports to organize the displayed information; produce specific print layouts; and share data across different applications.

Microsoft Access 2007, Level III

In this course, you will gain knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database. Participants will create complex Access databases by structuring existing data, writing advanced queries, working with macros, making effective use of forms and reports, and performing database maintenance.

Microsoft Excel 2013, Level I

In this course, you will create and edit basic Excel 2010 worksheets and workbooks. Upon successful completion of this course, you will be able to: create a basic worksheet by using Excel 2010; perform calculations in an Excel worksheet; modify an Excel worksheet; format a worksheet; print the content of an Excel workbook; and manage an Excel workbook.

Microsoft Excel 2013, Level II

In this course you will use advanced formulas and work with various tools to analyze data in spreadsheets. You also will organize table data, present data as charts and enhance the look and appeal of workbooks by adding graphical objects. Upon successful completion of this course, you will be able to: use advanced formulas; organize worksheet and table data using various techniques; create and modify charts; analyze data using PivotTables, Slicers, and Pivot Charts; insert and modify graphic objects in a worksheet; and customize and enhance workbooks and the Microsoft Office Excel environment.

Microsoft Excel 2013, Level III

This course will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications. Upon successful completion of this course, you will be able to: enhance productivity and efficiency by streamlining the workflow; collaborate with other workbook users; audit worksheets; analyze data; work with multiple workbooks; import and export data; integrate Excel data with the web; and structure workbooks with XML.

Microsoft Excel 2010, Level I

In this course, you will create and edit basic Excel 2010 worksheets and workbooks. Upon successful completion of this course, you will be able to: create a basic worksheet by using Excel 2010; perform calculations in an Excel worksheet; modify an Excel worksheet; format a worksheet; print the content of an Excel workbook; and manage an Excel workbook.

Microsoft Excel 2010, Level II

In this course you will use advanced formulas and work with various tools to analyze data in spreadsheets. You also will organize table data, present data as charts and enhance the look and appeal of workbooks by adding graphical objects. Upon successful completion of this course, you will be able to: use advanced formulas; organize worksheet and table data using various techniques; create and modify charts; analyze data using PivotTables, Slicers, and Pivot Charts; insert and modify graphic objects in a worksheet; and customize and enhance workbooks and the Microsoft Office Excel environment.

Microsoft Excel 2010, Level III

This course will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications. Upon successful completion of this course, you will be able to: enhance productivity and efficiency by streamlining the workflow; collaborate with other workbook users; audit worksheets, analyze data and work with multiple workbooks; import and export data; integrate Excel data with the web; and structure workbooks with XML.

Microsoft Excel 2007, Level I

You have basic computer skills such as using a mouse, navigating through windows and surfing the Internet. You also have used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. You will perform calculations, modify a worksheet, format a worksheet, print workbook contents and manage large workbooks.

Microsoft Excel 2007, Level II

Your training in and use of Microsoft® Office Excel 2007 has provided you with a solid foundation in the basic and intermediate skills for working in Excel. You have used Excel to perform tasks such as running calculations on data and sorting and filtering numeric data. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others and sharing Excel data with other applications.

Microsoft Excel 2007, Level III

In this course you will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others and share Excel data with other applications. Upon successful completion of this course, students will be able to: increase productivity and improve efficiency by streamlining your workflow; collaborate with others using workbooks; audit worksheets; analyze data; work with multiple workbooks; import and export data; use Excel with the web; and structure workbooks with XML.

Microsoft Outlook 2013, Level I

This beginning course will show how to use Outlook to compose and send email, schedule appointments and meetings, manage contact information, schedule tasks and create notes. Upon successful completion of this course, students will be able to: explore the Outlook interface; send mail and respond to messages; compose email messages; organize email messages into folders; manage contacts and contact information; schedule appointments, schedule a meeting and manage tasks and notes.

Microsoft Outlook 2013, Level II

This session will explain how to customize the Outlook environment, calendar and mail messages, and track, share, assign and quickly locate various Outlook items. Upon successful completion of this course, you will be able to: customize message settings; organize and locate Outlook messages; set calendar options; track activities using the Journal; assign and track tasks; share folder information; and customize the Outlook environment.

Microsoft Outlook 2010, Level I

This beginning course will show how to use Outlook to compose and send email, schedule appointments and meetings, manage contact information, schedule tasks and create notes. Upon successful completion of this course, you will be able to: explore the Outlook interface, send mail and respond to messages, compose email messages, organize email messages into folders, manage contacts and contact information, schedule appointments, schedule a meeting and manage tasks and notes.

Microsoft Outlook 2010, Level II

This session will explain how to customize the Outlook environment, calendar and mail messages, and track, share, assign and quickly locate various Outlook items. Upon successful completion of this course, you will be able to: customize message settings; organize and locate Outlook messages; set calendar options; track activities using the Journal; assign and track tasks; share folder information and customize the Outlook environment.

Microsoft PowerPoint 2013, Level I

This beginning session will explore the PowerPoint environment and how to create a presentation and format text on slides to enhance clarity. To enhance the visual appeal, you will add graphical objects to a presentation and modify them. Adding tables and charts to a presentation to present data in a structured form will also be covered. Upon successful completion of this course, you will be able to: explore the PowerPoint 2010 interface and familiarize yourself with the interface; create a presentation; format text on slides; add graphical objects to a presentation; modify graphical objects on slides; work with tables in a presentation; import charts to a presentation; and prepare to deliver a presentation.

Microsoft PowerPoint 2013, Level II

This course enhances your presentation by using features that will transform it into a powerful means of communication. Customization of the PowerPoint interface to suit your requirements and use features to create dynamic and visually appealing presentations will be discussed. Upon successful completion of this course, you will be able to: customize the PowerPoint environment; customize a design template; add SmartArt graphics to a presentation; add special effects to a presentation; customize a slide show; collaborate on a presentation; and secure and distribute a presentation.

Microsoft PowerPoint 2010, Level I

This beginning session will explore the PowerPoint environment and how to create a presentation and format text on slides to enhance clarity. To enhance the visual appeal, you will add graphical objects to a presentation and modify them. Adding tables and charts to a presentation to present data in a structured form will also be covered. Upon successful completion of this course, you will be able to: explore the PowerPoint 2010 interface and familiarize yourself with the interface; create a presentation; format text on slides; add graphical objects to a presentation; modify graphical objects on slides' work with tables in a presentation; import charts to a presentation; and prepare to deliver a presentation.

Microsoft PowerPoint 2010, Level II

This course enhances your presentation by using features that will transform it into a powerful means of communication. Customization of the PowerPoint interface to suit your requirements and use features to create dynamic and visually appealing presentations will be discussed. Upon successful completion of this course, you will be able to: customize the PowerPoint environment; customize a design template; add SmartArt graphics to a presentation; add special effects to a presentation; customize a slide show; collaborate on a presentation; and secure and distribute a presentation.

Microsoft Office Project 2013, Level I

In this beginning session you will create a project plan containing tasks, organize these tasks in a work breakdown structure containing task relationships, create and assign resources, and finalize the project to implement the project plan. Upon successful completion of this course, you will be able to: explore the Microsoft Office Project environment and the various views in which you can verify project information; create a new project plan; manage tasks by organizing them and setting task relationships; manage resources in a project plan; and finalize the project plan.

Microsoft Office Project 2013, Level II

In this session you will exchange project plan data with other applications, update project plans, create visual reports and reuse project plan information. Upon successful completion of this course, you will be able to: exchange project plan data with other applications; update a project plan; manage project costs; report project data visually; and reuse project plan information.

Microsoft Office Project 2010, Level I

In this beginning session we will create a project plan containing tasks, organize these tasks in a work breakdown structure containing task relationships, create and assign resources, and finalize the project to implement the project plan. Upon successful completion of this course, you will be able to: explore the Microsoft Office Project environment and the various views in which you can verify project information; create a new project plan; manage tasks by organizing them and setting task relationships; manage resources in a project plan; and finalize the project plan.

Microsoft Office Project 2010, Level II

In this session you will exchange project plan data with other applications, update project plans, create visual reports and reuse project plan information. Upon successful completion of this course, you will be able to: exchange project plan data with other applications; update a project plan; manage project costs; report project data visually; and reuse project plan information.

Microsoft Word 2013, Level I

In this lesson you will create, edit and enhance standard business documents using Word 2010. Upon successful completion of this course, you will be able to: create a basic Word document, edit a document, format text, format paragraphs, insert a table, insert special characters and graphical objects, control the page setup and appearance of a Word document and proofread documents for accuracy.

Microsoft Word 2013, Level II

This course will create complex documents and build personalized efficiency tools using Word 2010. Upon successful completion of this course, you will be able to: manage lists, customize tables and charts, customize the formatting of a document using styles and themes, modify pictures in a document, create customized graphic elements, insert content using Quick Parts, control text flow, use templates to automate document creation, use the mail merge function and use macros to automate common tasks.

Microsoft Word 2013, Level III

This session will address how to create, manage, revise and distribute documents. Upon successful completion of this course, you will be able to: use Word with other programs; collaborate on documents; manage document versions; add reference marks and notes; simplify the use of long documents; secure a document and create forms.

Microsoft Word 2010, Level I

In this lesson you will create, edit and enhance standard business documents using Word 2010. Upon successful completion of this course, you will be able to: create a basic Word document; edit a document; format text; format paragraphs; insert a table; insert special characters and graphical objects; control the page setup and appearance of a Word document; and proofread documents for accuracy.

Microsoft Word 2010, Level II

This course will create complex documents and build personalized efficiency tools using Word 2010. Upon successful completion of this course, you will be able to: manage lists; customize tables and charts; customize the formatting of a document using styles and themes; modify pictures in a document; create customized graphic elements; insert content using Quick Parts; control text flow; use templates to automate document creation; use the mail merge function; and use macros to automate common tasks.

Microsoft Word 2010, Level III

This session will address how to create, manage, revise and distribute documents. Upon successful completion of this course, you will be able to: use Word with other programs; collaborate on documents; manage document versions; add reference marks and notes; simplify the use of long documents; secure a document and create forms.

Microsoft Word 2007, Level I

Word processing is the use of computers to create, revise and save documents for printing and future retrieval. This course is the first in a series of three Microsoft Office Word 2007 courses. It will provide you with the basic concepts required to produce basic business documents. For example you will create, edit, format text and paragraphs, add tables and graphics, and proof a document.

Microsoft Word 2007, Level II

If you use Microsoft Word 2007 on a regular basis, then once you have mastered the basic skills, the next step is to improve your proficiency. To do so, you can customize and automate the way Microsoft Word 2007 works for you. You can also improve the quality of your work by enhancing your documents with customized Microsoft Word 2007 elements. In this course, you will create complex documents by adding components such as, customized lists, tables, charts and graphics. You will also create personalized Microsoft Word 2007 efficiency tools.

Microsoft Word 2007, Level III

You know to use Microsoft Office Word 2007 to create and format typical business documents. Now, you may need to work on more complex documents. In this course, you will use Word to create, manage, revise and distribute long documents and forms.

More Information

Click here for a calendar view of Washburn Tech's Continuing Education courses or check out our Continuing Education Course Schedule, Tuition & Fees.