College of the Ouachitas Workforce Development Department offers the following computer classes for business and industry and for professional development, and community education.
Office Essentials - (Available upon request)
Learn what Windows 10 can do to improve your efficiency. We will spend the morning discovering the new ways Windows 10 organizes your files, arranges your desktop, and we’ll pick up some shortcuts and tricks. We will spend the afternoon learning what’s new in Office 2016 and Office 365, including a new tab in Word, new data management options in Excel, and the fabulous new look of PowerPoint presentations, with the added convenience of cloud technology and integration with mobile devices.
Word in a Day - (Available upon request)
Microsoft Word is not just for typing letters anymore! You can publish newsletters, greeting cards, business logos, and many other things from your desktop using Word. Learn formatting shortcuts, layout designs, customizing images, and much more. You need only be comfortable with a computer and mouse.
Excel 1 - March 6
Learn the basics of Excel. This course covers entering and formatting numbers and text; ranges; copying and moving data; basic formulas; data entry short-cuts like filling in a range, auto sum, auto complete and auto fill; relative and absolute cell references; formatting; charts; comments, hyperlinks; and printing.
Excel 2 - March 13
This course covers large workbooks with multiple worksheets; 3D formulas; Paste Special with calculations; consolidating; more advanced formulas for financial, logical and date questions; Excel as a database table, including sorting and filtering; data validation; and conditional formatting. Excel Levels 2 and 3 can be taken in any order.
Excel 3 - March 20
This course covers how to use Excel for a variety of problem-solving tasks. Included are using Excel as a database, the Data Table; outlining and subtotaling; programmatic formulas including VLOOKUP, HLOOKUP, ISERROR, and nested IF statements with AND and OR; Pivot Tables; and Scenarios. Excel Levels 2 and 3 can be taken in any order.
PowerPoint - (Available upon request)
This course covers all PowerPoint has to offer for creating, designing, delivering, and creating handouts for presentations. Students will learn slide layout and design; inserting content on slides; normal, slide sorter and slide show views; slide transition; content animation; inserting tables, charts and creating photo albums; using sound and recordings; preparing for a wide audience using presentation media and video; and printing handouts.
Access Fundamentals - (Available upon request)
Learn the basics of Access from a user perspective, and how it can be used as an additional tool to Excel. This course covers the fundamentals of data management and database design. We will also explore basic querying – asking questions of the data; basic form design; basic report design; and printing.
Classes are located at the College’s Center for Applied Science Technology (CAST) building at 829 Martin Luther King Blvd, Malvern, AR 72104. Each class is six hours in length, with one hour for lunch and costs $99 per student per class; registering more than one student is $89 each. Register here; for more information please contact Laurie Hawthorne at 501.332.0236 or email lhawthorne [at] coto.edu.
Space is limited, so please register early to reserve your seat! Payment may be invoiced to the company (business and industry only) or paid to the business office before each class.