Microsoft Excel 2021365 - Beginner to Advanced - Exercise 11 - work with macros

Microsoft Excel 2021365 - Beginner to Advanced - Exercise 11 - work with macros

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Hard

Created by

Quizizz Content

FREE Resource

The video tutorial guides viewers through cleaning a data set using a macro in Excel. It covers applying date formatting, converting names to proper case, applying currency formatting, removing duplicates, and formatting the data as a table. The tutorial also includes creating a button to run the macro and editing the macro in the VBA editor to change the finishing cell. Emphasis is placed on making copies of the worksheet to prevent data loss.

Read more

1 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What new insight or understanding did you gain from this video?

Evaluate responses using AI:

OFF