Microsoft Applications Certificate

This course is an introductory course in word processing using Microsoft Word for Windows. 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. 

This course is an introductory course in spreadsheets using Microsoft Excel for Windows. 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. 

This course is an introductory course in databases using Microsoft Access for Windows. 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. 

This course is an introductory course in presentation software using Microsoft PowerPoint for Windows. 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. 

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.

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. 

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. 

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.