Comprehensive Guide to the IDE Innovate Live Session: Excel Online, Pivot Tables, and Data Visualization

Introduction

The session began with a roll‑call, asking participants to confirm they could hear the facilitator and to drop a comment indicating their presence. After a brief chat about traffic, battery issues, and occasional power outages (NEPA), the host welcomed everyone, reminded them to subscribe to the channel, and emphasized the importance of staying engaged in the live class.

Preparing the Workspace

• Technical setup: Participants were instructed to ensure a fully charged laptop, a stable internet connection, and a glass of water to stay focused.
• Accessing resources: All assignments, submission links, and deadlines are posted on the WhatsApp and Telegram groups. If you are not a member, you are encouraged to join both platforms.

Using Microsoft 365 Excel Online

1. Opening Excel: Navigate to the left‑hand menu, click Excel in the Microsoft 365 suite.
2. Uploading the dataset: Choose Upload a file (not Create a blank workbook) and locate the dataset posted in the comment section.
3. Viewer vs. Editor: By default the file opens in viewer mode. Switch to editing by clicking the drop‑down next to the Share button and selecting Editing.

Data Cleaning & Formatting

• Scan the sheet for empty rows, duplicate entries, and inconsistent values.
• Delete unwanted rows (e.g., Row 2) using right‑click → Delete Row.
• Apply Format as Table to give the data a clean, standardized look.

Introduction to Data Visualization

• Definition: Graphical representation of data to reveal trends, patterns, and insights.
• Purpose: Helps stakeholders make informed decisions, simplifies complex datasets, and highlights key information.
• Best practices: clarity, simplicity, relevance, accuracy, appropriate color contrast, and avoidance of misleading visuals.

Chart Types Overview

Building Pivot Tables

1. Select the data range (inside the table, not the blank area).
2. Press Ctrl + A → Insert → PivotTable.
3. Choose New Worksheet for the first pivot table; subsequent tables use Existing Worksheet placed below the previous one.
4. Drag fields to Rows, Columns, Values, and Filters as needed (e.g., Gender → Rows, Math Score → Values).
5. Change aggregation from Sum to Average for more meaningful analysis.

Creating Pivot Charts

• Click inside a pivot table, go to Insert → Recommended Charts or select a specific chart type.
• Typical choices: column chart for gender vs. scores, bar chart for parental education vs. total score, etc.
• Customize titles, axis labels, and colors to improve readability.

Assembling a Dashboard

1. Merge & Center a cell range to create a title block.
2. Apply a background color for visual appeal.
3. Insert each pivot chart, aligning them with equal spacing.
4. Use Format Painter to copy sizing and styling across charts, ensuring a uniform look.
5. Add a text box for the dashboard title (e.g., Student Performance Overview).

Closing Remarks & Next Steps

• Participants were reminded to take the test immediately after the class and to submit assignments on time.
• The facilitator thanked everyone, encouraged more comments (e.g., “I am ready”), and reiterated the value of the session.
• Final call to subscribe, like the live, and stay active in the community for future lessons.

Key Takeaways

• Mastering Excel Online, especially pivot tables and pivot charts, enables rapid data summarisation.
• Effective data visualisation turns raw numbers into clear stories that support decision‑making.
• Consistent practice—cleaning data, choosing the right chart, and designing a tidy dashboard—builds professional analytical skills.

By following the step‑by‑step workflow—from uploading data in Excel Online, cleaning and formatting it, to building pivot tables, pivot charts, and a polished dashboard—learners gain the practical ability to transform raw datasets into insightful visual stories that drive informed decisions.