BASIC BUSINESS APPLICATIONS
Prerequisite: Windows for the Desktop or Equivalent Knowledge
Textbook required, flash drive recommended
Learn the commonalities of the Microsoft Office Program and practice using the basic features of Windows Microsoft Word, Excel, and PowerPoint programs.
$420 CEUs 3.2 HRS: 32
Dates CRN Time Campus Days
02/18/22 - 3/1/22 70231 6:00 pm-10:00 pm Central TR
MOS APPLICATIONS
Prerequisite: Windows for the desktop or equivalent knowledge and type 20 wpm
Textbook required, flash drive recommended
Continued studies of intermediate topics of Microsoft Office Applications to prepare the users for taking the MOS Word and Excel Certification exams.
$950 CEUs 8.0 HRS: 80
Dates CRN Time Campus Days
1/31/22 - 4/13/22 95331 6:00 pm - 10 pm Central MW
EXCEL ADVANCED SKILLS
Prerequisite: Excel Intermediate or equivalent knowledge; Windows for the Desktop and type 20 wpm
Textbook required, flash drive recommended
As a student in this course, you will learn the most important topics of Microsoft Excel. You will first discuss how to analyze data with PivotTables and how to create a PivotChart report. You will then have an introductory unit on exchanging data with other programs like Word, PowerPoint and Access. From there you will move into the different aspects of the application such as sharing Excel files and incorporating web information. You will then go over how to customize Excel and advanced worksheet management. You will learn to audit a worksheet, create cell comments, custom autofill lists and create and apply templates. You will wrap up the course with how to program with Excel. You will be introduced to Visual Basic editor, analyze and write code, create a main procedure to then run it.
CEUs 1.6 HRS: 16
Not scheduled at this time.
EXCEL BASIC SKILLS
Prerequisite: Windows for the Desktop or Equivalent Knowledge
Textbook required, flash drive recommended
In this course, you will work with Excel, a powerful spreadsheet application. You will begin with preparing and formatting techniques. You will learn how to insert texts and formulas into cells. You will learn how to insert texts and formulas into cells. You will learn to use simple functions. You will learn the formatting and printing of selected ranges. You will learn to edit workbook properties. You will construct charts for your data. Finally you will learn to create Trendlines and Sparklines on your charts.
CEUs 1.6 HRS: 16
Not scheduled at this time.
EXCEL COMPLETE
Prerequisite: Windows for desktop or equivalent knowledge and type 20 wpm.
Textbook Required.
This course provides the concepts and skills to be productive with Microsoft Excel starting with fundamentals and working up to advanced tools and techniques. This course maps to the objectives of the Microsoft Office Specialist and Expert exams for Excel. You will benefit most from this course if you want to use Excel to perform real-world tasks, from common workplace tasks to complex operations with large amounts of data. The course assumes students know how to use a computer and that they're familiar with Microsoft Windows. It does not assume that they've used a different version of Excel or another spreadsheet program before.
CEUs4.8 HRS: 48
Not scheduled at this time.
EXCEL INTERMEDIATE SKILLS
Prerequisite: Excel Basic Skills or equivalent knowledge
Textbook required, flash drive recommended
As a student in this course, you will learn to customize your cell contents, work with conditional formatting and name cells and ranges. You will learn to manage multiple-sheet workbooks. You will apply advanced functions to create formulas using criteria IF functions, and the logical functions IF, AND, OR, and NOT. You will then learn to used advanced functions to format text, to create financial solutions and to analyze data. You will increase your skills with tables, structured references, and enhanced sorting and filtering. Finally, you will learn to use graphics, SmartArt and WordArt to create and modify your own Excel templates.
CEUs 1.6 HRS: 16
Not scheduled at this time.
MOS EXCEL
Prerequisite: Windows for the desktop or equivalent knowledge and type 20 wpm
Textbook required, flash drive recommended
MOS Excel teaches the information worker how to work with different types of documents using a variety of core and intermediate features to create and edit professional-looking spreadsheets for a variety of purposes and situations. You will learn to construct cell data, format worksheets, work with charts and graphics. This course teaches the skills you will need to successfully complete the MOS Excel Certification Core Exam.
$490 CEUs 4.0 HRS: 40
Not scheduled at this time.
MOS POWERPOINT
Prerequisite: Basic computer skills and type 20 wpm
Textbook required, flash drive recommended
MOS PowerPoint teaches the information worker how to create and manage presentations using a variety of core and advanced features. You will use PowerPoint to create and edit professional-looking presentations for a variety of purposes and situations, as well as explore different ways to share the information with internal and external customers. You will learn to work with text, illustrations, media, charts, and tables. In this course you will have reviewed all of the exam objectives necessary to prepare for the Microsoft PowerPoint Core Exam.
CEUs 2.4 HRS: 24
Not scheduled at this time.
MOS WORD
Prerequisite: Windows for the desktop or equivalent knowledge and type 20 wpm
Textbook required, flash drive recommended
MOS word teaches the information worker how to work with different types of documents using a variety of core and intermediate features to create and format business documents such as letters, forms, newsletters, memos and proposals. As you begin to build your skills, you will then create a variety of flyers and other promotional materials as well as explore different ways to share the information with internal and external customers. These are skills needed to successfully complete the MOS Word Certification Core Exam.
$440 CEUs 4.0 HRS: 40
Not scheduled at this time.
WORD BASIC SKILLS
Prerequisite: Windows for the Desktop or Equivalent Knowledge
Textbook required, flash drive recommended
In this course, you will work with Word, a powerful application to create and format documents. You will begin with preparing and editing techniques. You will learn how to format, save and print a document. You will be using fonts, keyboard shortcuts, manipulating tabs, cut, copy, and paste text. You will learn page setup - margins, page orientation, inserting page numbers, page breaks, headers, footers, date, time, symbols and other images. You will learn to create tables, populating and formatting them. You must be able to type. Begin to acquire skills and knowledge needed to pass the optional MOS Core certification exam in Word.
CEUs 1.6 HRS: 16
Not scheduled at this time.
WORD INTERMEDIATE SKILLS
Prerequisite: Word Basic Skills or equivalent knowledge and type 20 wpm
Textbook required, flash drive recommended
First, you will go over how to illustrate documents with graphics. You will learn to insert, position, size and scale a graphic. You will learn to create a text box, WordArt and draw shapes. Next, you will move onto working with themes and building blocks where you will learn to insert a sidebar and Quick Parts. Then you will learn about merging Word documents and developing multipage documents. You will understand mail merge as you create a main document, design a data source, enter, and edit records. You will add merge fields, merge data and create labels. You will wrap up the course with how to work with styles, documents, and references.
CEUs 1.6 HRS: 16
Not scheduled at this time.