Microsoft Excel for the Web Workshop
The objective of this workshop is to equip participants with
practical skills in using Microsoft Excel for the Web, focusing on two
essential features: Data Validation and PivotTables. Participants will learn
how to create dropdown menus to control data entry and ensure consistency, as
well as how to build and manipulate PivotTables to summarize and analyze large
sets of data efficiently. By the end of the workshop, attendees will be able to
apply data validation techniques, generate interactive PivotTables, and refresh
data to reflect updates, thereby improving data accuracy and decision-making in
everyday spreadsheet tasks.
Responsible | george@ati.school |
---|---|
Last Update | 06/23/2025 |
Completion Time | 2 hours 13 minutes |
Members | 11 |
-
Welcome to Microsoft Excel for the Web Workshop2Lessons · 6 min
-
Microsoft Excel What is ExcelNew
-
Microsoft Excel for the Web Workshop ObjectiveNew
-
-
Session 1: Apply Data Validation to Cells2Lessons · 1 hr 1 min
-
ATI Apply Data Validation to CellsNew
-
Apply Data Validation to CellsNew
-
-
Session 2 Create and Insert a PivotTable2Lessons · 46 min
-
ATI Create a PivotTableNew
-
Create and Insert a PivotTableNew
-
-
Microsoft Excel for the Web Exam2Lessons · 20 min
-
Microsoft Excel for the Web Workshop ExamNew
-
Microsoft Excel for the Web WorkshopNew
-