Business Analytics with Excel, Course 28871, Tues and Thurs, 6:30-8:30 PM

Remote-Live, 6 hours, 3 sessions     Instructor: Alyse Cutler

PREREQUISITE: Proficient/intermediate knowledge of MS Excel.
Learn how data science is applied in business. Explore concepts in correlation, regression analysis, hypothesis testing and multivariate analysis. Learn how correlation helps to understand portfolio diversification and design. ‘What If’ analysis will be covered utilizing the Solver and Goal Seek features of Excel. Students will need to save their work to their local computer or a flash drive.

Microsoft Office Excel MO-200 Certification, Course 28732, Wed

March 11, Orientation, 5:30-6:30 PM, March 18-May 6, Class, 5:30-8:30 PM

EH-229, 24 hours, 9 sessions     Instructor: Elissa DeRose-Rizzo, MA, MLIS

Microsoft Excel is one of the most sought-after skills in today’s job market. Demonstrate your knowledge of Excel 2019 by becoming MO-200 Microsoft Excel Certified. Create, modify and format worksheets, modify cells, columns and rows and print and manage workbooks. Formulas, insert functions, conditional formatting and templates will be covered, as well as charts, pivot tables. Certification preparation includes live practice with the instructor. This course includes textbooks and the exam voucher for the Microsoft Office Specialist: Excel Associate (Excel and Excel 2019), MO-200, at CCM’s state-of-the art Testing Center.