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 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 using Microsoft Excel, Power BI, and artificial intelligence (AI) tools is employed for data analysis, data visualization, modeling, and creating dashboards with direct connectivity to data sources. Students will explore how AI enhances business intelligence through predictive insights and automation within analytics workflows.

This course introduces students to generative artificial intelligence technologies and their applications in business analytics. Students will explore tools such as ChatGPT, Microsoft Copilot, and other AI platforms to create content, automate workflows, and generate predictive insights. Emphasis is placed on ethical use, prompt engineering, and integrating generative AI into data analysis and visualization processes.