Shehbaz Sultan

Microsoft Excel Online Lecture Series
Online Presenter/ Tutor: Shehbaz Sultan

Session 1: Introduction to Microsoft Excel

Overview of Microsoft Excel and its importance.
Understanding the Excel interface: Ribbons, Tabs, and Quick Access Toolbar.
Navigating through worksheets and workbooks.
Basic terminology: Cells, Rows, Columns, and Ranges.

Session 2: Excel Data Entry and Formatting

Entering data into cells: Text, Numbers, Dates.
Applying cell formatting: Font, Fill color, Borders.
Using Number Formats: Currency, Percentage, Date & Time.
Introduction to Cell Styles for consistent formatting.

Session 3: Basic Formulas and Functions

Formula basics: Arithmetic operators (+, -, *, /).
Writing formulas to perform calculations.
Introduction to Excel functions (SUM, AVERAGE, COUNT).
Absolute and relative cell references.

Session 4: Working with Worksheets and Workbooks

Adding, deleting, and renaming worksheets.
Managing multiple workbooks.
Grouping and ungrouping worksheets.
Using Freeze Panes for better visibility.

Session 5: Data Visualization with Charts

Creating basic charts: Column, Line, Pie.
Formatting charts: Titles, Axes, Legends.
Modifying chart data and appearance.
Adding data labels and trendlines.

Session 6: Sorting, Filtering, and Data Manipulation

Sorting data: A-Z, Z-A, Custom.
Applying filters to data.
Using AutoFilter and Custom Filter options.
Introduction to data validation and drop-down lists.

Session 7: Conditional Formatting and Smart Art

Highlighting cells based on conditions.
Creating simple data bars and color scales.
Adding icons using Conditional Formatting.
Introduction to SmartArt graphics for visual representation.

Session 8: Collaboration and Printing Options

Sharing workbooks and collaborating online.
Tracking changes and adding comments.
Page Layout and Print settings.
Printing worksheets and workbooks.

Session 9: Advanced Formulas and Functions

Logical functions: IF, AND, OR.
Lookup functions: VLOOKUP and HLOOKUP.
Text functions: CONCATENATE, LEFT, RIGHT.
Date and time functions: TODAY, NOW, DATEDIF.

Session 10: PivotTables and Pivot-Charts

Creating PivotTables for data analysis.
Modifying PivotTables: Fields, Values, Filters.
Introduction to Pivot-Charts.
Slicers and Timelines for interactive reports.

Session 11: Macros and Automation

Recording and running macros.
Assigning macros to buttons.
Macro security and best practices.
Introduction to Visual Basic for Applications (VBA).

Session 12: Data Analysis with What-If Analysis

Goal Seek for reverse calculations.
Scenario Manager for different scenarios.
Data Tables for sensitivity analysis.
Using Solver for optimization problems.

Session 13: Advanced Data Visualization

Advanced chart types: Radar, Gantt, Waterfall.
Sparklines for compact data visualization.
Using Trendline for data forecasting.
Creating dynamic charts with OFFSET and Named Ranges.

Session 14: Power Query and Data Cleaning

Introduction to Power Query.
Importing data from various sources.
Transforming and cleaning data.
Loading data into Excel for analysis.

Session 15: Final Project and Recap

Applying all learned skills to a real-world project.
Creating a comprehensive Excel workbook.
Review of key concepts from the entire series.

Q&A and open discussion.

Note: Each session duration would vary as per the student need and grasping of the subject

This is a basic outline for your Microsoft Excel online lecture series. You can adjust the contents and duration of each session based on your preferences and the needs as being an online student. Make sure to engage with your online tutor with hands-on activities, practical examples, and interactive discussions throughout the series.