To create a tutorial on Excel with practical working examples using actual data, I will provide step-by-
step instructions and include tables and formulas you can use. Let me know if you’d like me to also save
it in a Word document after writing.
---
Excel Tutorial with Practical Examples and Data
---
1. Entering and Formatting Data
Example 1: Employee Attendance Table
1. Input Data:
Enter the data into cells A1:D6.
2. Format:
Select the header row (A1:D1).
Go to Home > Font > Bold and apply a light fill color.
Use Center Align for numeric data.
---
2. Using Formulas
Example 2: Calculating Attendance Percentage
1. Add a new column "Attendance %" in column E.
2. Use the formula in E2:
=(B2/D2)*100
3. Drag the formula down to fill rows E2:E6.
Result:
---
3. Conditional Formatting
Example 3: Highlight Low Attendance
1. Select cells E2:E6.
2. Go to Home > Conditional Formatting > Highlight Cell Rules > Less Than.
3. Enter 75 and choose a red fill color.
---
4. Chart Creation
Example 4: Sales Data Visualization
1. Input Data:
Enter the data into cells A1:C5.
2. Insert Chart:
Select the data A1:C5.
Go to Insert > Charts > Line Chart.
3. Customize:
Add a title: "Monthly Sales Comparison."
Label axes for clarity.
---
5. Data Analysis with Pivot Tables
Example 5: Product Sales by Region
1. Create Pivot Table:
Select the data A1:C7.
Go to Insert > PivotTable.
Drag Region to Rows, Product to Columns, and Sales to Values.
2. Analyze Sales by Region:
Summarize sales in a structured table.
---
6. Advanced Data Tools
Example 6: Sorting and Filtering
1. Select the Sales Data table (Example 4).
2. Go to Data > Sort:
Sort Region A Sales in descending order.
3. Apply Filter:
Click Data > Filter to filter months with Region B Sales above 750.
---
7. Export and Share
Example 7: Save as PDF
1. Go to File > Save As.
2. Select PDF as the file format and save.
---
Let me know if you’d like this formatted into a Word document or need further customization!
