Excel Tutorial

Chapter 1: Introduction to Excel

1.1 Overview of Spreadsheet Software

1.2 Importance of Excel in Engineering and Data Management

1.3 Excel Interface: Ribbon, Tabs, and Quick Access Toolbar

1.4 Creating, Saving, and Formatting Workbooks

1.5 Understanding Cells, Rows, Columns, and Ranges

Chapter 2: Data Entry and Basic Operations

2.1 Entering and Editing Data

2.2 Autofill and Flash Fill

2.3 Cell Referencing: Relative, Absolute, and Mixed

2.4 Basic Formatting: Fonts, Colors, Borders

2.5 Sorting and Filtering Data

Chapter 3: Formulas and Functions

3.1 Introduction to Formulas

3.2 Mathematical Functions (SUM, AVERAGE, MIN, MAX)

3.3 Logical Functions (IF, AND, OR, NOT)

3.4 Text Functions (CONCATENATE, LEFT, RIGHT, MID)

3.5 Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)

Chapter 4: Data Visualization with Charts

4.1 Creating Charts: Line, Bar, Column, Pie

4.2 Chart Customization and Design

4.3 Dynamic Charts using Named Ranges

4.4 Combo Charts

4.5 Sparklines and Conditional Formatting Charts

Chapter 5: Data Analysis and Tools

5.1 What-If Analysis (Goal Seek, Data Tables, Scenario Manager)

5.2 Conditional Formatting Rules

5.3 Data Validation and Drop-Down Lists

5.4 Using Remove Duplicates and Text-to-Columns

5.5 Flash Fill and Smart Lookup

Chapter 6: Working with Tables and Pivot Tables

6.1 Creating and Formatting Excel Tables

6.2 Table Formulas and Structured References

6.3 Pivot Table Basics

6.4 Filtering, Sorting, and Grouping in Pivot Tables

6.5 Pivot Charts and Slicers

Chapter 7: Advanced Excel Functions

7.1 Array Formulas and Dynamic Arrays

7.2 INDEX-MATCH vs VLOOKUP

7.3 INDIRECT, OFFSET, and MATCH Functions

7.4 Error Checking Functions (IFERROR, ISERROR, etc.)

7.5 Using Named Ranges and Defined Names

Chapter 8: Excel for Engineers

8.1 Using Excel for Unit Conversions and Calculations

8.2 Linear and Non-Linear Regression Analysis

8.3 Solving Equations Using Solver

8.4 Charting Engineering Data (Stress-Strain, Load Curves)

8.5 Applications in Electrical, Mechanical, and Civil Engineering

Chapter 9: Macros and Automation

9.1 Introduction to Macros

9.2 Recording and Running Macros

9.3 Introduction to VBA (Visual Basic for Applications)

9.4 Creating Simple User Forms

9.5 Automating Repetitive Tasks

Chapter 10: Integration and Case Studies

10.1 Linking Excel with Word and PowerPoint

10.2 Exporting Data to PDF, CSV

10.3 Real-World Case Studies (Budgeting, Scheduling, Engineering Design Logs)

10.4 Excel with Power BI and Python Integration

10.5 Final Project: Engineering Dashboard or Automation Tool