Where You Could Go
Some of the courses in the Microsoft Application Certificate, particularly Microsoft Word and Microsoft Excel, can be applied toward many associate degree programs, both on-campus and online, at North Central State College.
What You Will Learn
The following courses are included in the Microsoft Applications Certificate.
Microsoft Word: Through a series of hands-on exercises, the student will create, edit, format, and print documents. Topics include creating, saving, retrieving, formatting, editing, printing, inserting graphic elements, merging, maintaining file organization, and using the help system.
Microsoft Excel: Through a series of hands-on exercises, the student will create, edit, format, and print worksheets. Topics include creating, saving, retrieving, formatting, editing, printing, creating formulas, using functions, naming cells and ranges, creating tables, creating charts, defining range names, validating data, sorting and filtering data, maintaining file organization, and using templates.
Microsoft Access: Through a series of hands-on exercises, the student will create and manage databases. Topics include creating, saving, formatting, and editing tables; designing reports; creating formulas; working with records; creating forms; writing queries; and establishing table relations.
Microsoft PowerPoint: Through a series of hands-on exercises, the student will create, edit, format, and print presentations. Topics include creating, saving, retrieving, formatting, editing, printing, and running presentations; inserting graphic elements; applying transitions and animation effects; linking and embedding; and using the Help system.
Microsoft Word Advanced: This second level course covers advanced Word features including formatting with special features, enhancing the visual display and clarity of documents, working with multiple documents, creating and merging main documents with data source documents, creating forms, linking and embedding objects, using macros, and modifying the document layout.
Microsoft Excel Advanced: This second level course covers expert Excel features, including formatting with advanced techniques, working with templates and workbooks, working with lists, using analysis tools, managing and auditing worksheets, collaborating with workgroups, and using advanced format functions.
Microsoft Office Workplace Technology: This course introduces business productivity tools for time management, collaboration, data organization and communication in today’s workplace business environment. Cloud-based productivity tools will be used to manage group collaboration, organize and share data, and communicate using real-time collaboration tools and advanced features of electronic mail.
Microsoft Excel Business Intelligence: This course introduces the concepts and application of data analytics in business. A hands-on approach of Microsoft Excel and Power BI (Business Intelligence tools) is used for data analysis, data visualization, modeling, creating dashboards with direct connectivity to data sources.