Software Lab File
Post Graduate Diploma in Management
(PGDM)
Submitted to: Ms. Sakshi Bhatti Submitted by: Rahul Verma
Assistant Professor Roll no – 032
Section - A, Trimester I
Batch-2025-27
Jagannath International Management School
MOR, Pocket-105, Kalkaji, New Delhi-110019
(Approved by All India Council for Technical Education (AICTE) and
Accredited by NBA, SAQS and NAAC)
Table of Contents
1. Workbook & Worksheet Basics
a. Creating and renaming worksheets
b. Entering and Editing Data
c. Format cells.
2. Working with Ranges and AutoFill: Defining ranges, usage of AutoFill for series.
3. Tables and Conditional Formatting:
a. Converting data into a Table
b. Application of sorting and filtering
c. Demonstration of conditional formatting rules.
4. Basic Arithmetic Formulas: Demonstration of addition, subtraction, multiplication,
and division using formulas.
5. Data Validation: Application of rules such as: numeric-only, text-only, drop-down
list and length restrictions.
6. Functions:
a. Usage of SUM, AVERAGE, MIN, MAX, and ROUND.
b. Logical Functions- IF, SUMIF, COUNTIF, AND, OR, NOT, and nested IF to
analyze data.
7. Pivot Tables and Pivot Charts: Creating a Pivot Table and Pivot Chart to summarize
data.
8. What-if Analysis: Application of Goal Seek, Scenario Manager, and Data Tables
(one-input and two-input).
9. Charts & Visualization:
a. Create at least three different types of charts from dataset (Column, Line, Pie,
etc.).
b. Add titles, labels, and apply chart formatting options.
Workbook & Worksheet Basics
Crea1ng and renaming worksheets
To create a new worksheet, we can click on the + sign that we see at the bo4om of the sheet.
To rename a worksheet in Excel, simply double-click the sheet tab, right-click the sheet tab and
select Rename, a@er entering the new name, press Enter.
Entering and Edi1ng Data
• Click on any cell.
• Type numbers, text, or dates as required.
• Press Enter to confirm entry.
• To edit: double-click the cell or select it and edit in the formula bar.
Format Cells
• Select the cell(s).
• Right-click → choose Format Cells.
• Change font, number format, alignment, border, or fill color.
Working with Ranges and AutoFill
• Select a group of cells to define a range.
• For AutoFill:
o Enter a value (e.g., 1) in the first cell.
o Enter the next value (e.g., 2) in the second cell.
o Select both cells, drag the Fill Handle (bo4om-right corner) across the range.
o Excel will automaPcally fill the series.
Tables and Condi1onal Forma?ng
Conver1ng Data into a Table
• Select the dataset.
• Go to Insert → Table.
• Select “My table has headers” if applicable → Click OK.
Sor1ng and Filtering
• Select the table.
• Go to Data → Sort & Filter.
• Choose ascending, descending, or custom sort.
• Apply filter checkboxes to view specific data.
Condi1onal Forma?ng
• Select the data.
• Go to Home → CondiPonal FormaZng.
• Choose rules like Highlight Cell Rules, Top/Bo4om Rules, or Custom Formula.
Basic Arithme1c Formulas
Addi1on
Subtrac1on
Mul1plica1on
Division
Data Valida1on
• Select the cells where validaPon is needed.
• Go to Data → Data ValidaPon.
• Choose:
o Whole number / Decimal (numeric only).
o Text Length (limit number of characters).
o List (create drop-down list of items).
• Click OK to apply.
Func1ons
Basic Func1ons
Addi1on
Average
Minimum Value
Maximum Value
Round
Logical Func1ons
If
Sumif
Coun1f
And
Or
Not
Nested If
Pivot Tables and Pivot Chart
What-if Analysis
Goal Seek
Goal seeking profit of 6,00,000 by changing the quanPty sold.
Scenario Manager
Data Tables
One-Input
Two-Input
Charts & Visualiza1on
Column Chart
Line Chart
Pie Chart