CSFT-8095A Advanced Microsoft Excel 2021

Competency of Excel beginning, and intermediate skills are required. PC with Office 365 installed is recommended. Learn the concepts and tools used to analyze datasets and make informed business decisions. Students will use Excel to gather, organize, and visualize data for analysis. Students will learn advanced Excel techniques such as using decision making tools, connecting to external data, and create Data Models. Students will also become proficient at creating PivotTables, using advanced functions, statistical tools. Students will also learn how to build What If analysis, Scenarios, and forecasts on large data sets. This course covers the objectives of Microsoft Office Specialist - Excel Expert Certification.

Contact Hours: 35
Serach for Class/Register

· Upon completion of this course, students will be able to manipulate data using date, logical, lookup, database, and financial functions.

· Upon completion of this course, students will be able to employ statistical functions to analyze data for decision making.

· Upon completion of this course, students will be able to demonstrate data management within workbooks.

· Upon completion of this course, students will be able to manage data from external sources.

· Upon completion of this course, students will be able to create macros to simplify data analysis in Excel.

· Upon completion of this course, students will be able to use data validation features to improve data entry in databases.

· Upon completion of this course, students will be able to perform data analysis using advanced database queries.
Topics
· Use Logical and Nested Functions

· Work with Lookup & Reference Functions and Date and Time Calculations

· Build Financial and Text Functions

· Create Array Formulas

· Use Statistical Functions

· Create an Excel Template and Add Validation Rules

· Create a Workbook from a Template, Insert a Form Control, and Set Worksheet Protection

· Co-Author and Finalize a Workbook

· Run and Record Macros in a Workbook

· Assign a Macro to a Button and Edit a Macro

· Record a Macro with Relative References and Save a Macro-Enabled Template

· Create Scenarios and Use Goal Seek and Solver

· Build One- and TwoVariable Data Tables and Create a Forecast Sheet

· Use the Analysis ToolPak; Create a Map Chart

· Get and Transform Data using Power Query

· Merge Queries and Manipulate Data

· Build a PivotTable from the Data Model
Activities/Resources
· Presentation

· Lecture

· Demonstration

· Hands-on practice

Evaluation
Students will confidentially evaluate this course by completing the electronic Student Evaluation of Class form distributed via email after the last class session.

Successful Completion
The instructor will evaluate the student’s skills learned using attendance, participation, feedback, testing where appropriate, and projects completed.

75% attendance is required; 100% attendance is recommended, as no special arrangements will be made for missing class.

75% = 24 hours.

Upon successful completion, this course will appear on the student’s Macomb Community College non-credit transcript

Textbook
McGraw Hill, Excel Complete 2021, by Nordel, 9781266783692