Create business reports, import and export business data. Data searches with multiple criteria using action queries and outer join. Create easy access database by applying business macros. Improve database performance by setting passwords and changing startup options.
Students learn advanced spreadsheets formulas and formatting techniques and will concentrate on various Excel applications including formula auditing, PivotTables, PivotCharts, and troubleshooting formulas.
This course further develops electronic publishing by enhancing business office publications and making them interactive using such programs as Microsoft Publisher, Adobe InDesign, and Adobe Acrobat Professional. Students deconstruct business documents and templates, create a business office newsletter, business posters, interactive business registration forms, upload files and folders in a cloud-based drive, and import/export documents in various file formats.
This is an intermediate course to analyze and solve business-related problems using Microsoft Excel.Topics include creating and managing tables, using conditional and text functions, organizing large worksheets, inserting macros, and using pivot tables.This course helps students prepare for the Microsoft Office Specialist Excel Core and Excel Expert certification exam.
An overview course that introduces students to current business software, including, but
not limited to Windows/Mac operating systems, MS Office (word processing,
spreadsheets, databases, presentations), internet and email, cloud based business
productivity tools, computerized accounting, business graphics or desktop publishing
software, Web authoring and animation software, and business multimedia software.
Learn database design guidelines to create the structure of the business Access database, which allows users to create tables, queries, forms, and reports for business data. Build table relationships, establish query criteria, and create and customize forms and reports.
A beginning course to analyze and solve business-related problems using Microsoft Excel. Topics include set up and customize a spreadsheet; create and manage charts; create simple formulas, and use functions. This course helps students prepare for the Microsoft Office Specialist Excel certification exam.
Electronic publishing for the business office using such programs as Microsoft Publisher or Adobe InDesign. Students will create and manage business documents for print or electronic distribution including business newsletters, postcards, interactive forms, flyers, and web publications. Students develop page layouts, edit text, optimize bitmaps, correct simple spelling, punctuation, and grammar errors in the development of business documents.
Essential computer concepts and techniques for the beginning computer user, including how to use a Windows or Mac-based operating system. Introduction to the internet and email basics with an overview of business office productivity tools.
Academic support for currently enrolled Business Department students in an instructor-supervised computer lab. Students work on assignments given in other Business Department credit and noncredit classes. Instructors assist students with computer skills and assignment content to achieve academic course learning outcomes.