✅ Excel Basics Part 7 – Sorting, Filtering & Conditional Formatting 📊✨

These tools help you analyze and highlight data quickly without writing formulas.

1️⃣ Sorting Data
• Sort A to Z (ascending) or Z to A (descending)
• Sort by one or multiple columns (e.g., by Marks, then Name)

📌 How:
→ Select data → Data tab → Sort

2️⃣ Filtering Data
• Show only rows that match certain criteria
• Example: Show only “Yes” in Attendance

📌 How:
→ Select headers → Data tab → Filter → Use dropdowns

3️⃣ Conditional Formatting
• Visually highlight values based on rules
• Useful for spotting high/low scores, duplicates, trends

📌 Examples:
🔹 Highlight cells > 80:
→ Select range → Home → Conditional Formatting → Highlight Cell Rules → Greater Than

🔹 Color scale for Marks:
→ Green for high, red for low

🔹 Highlight duplicates:
→ Conditional Formatting → Highlight Cell Rules → Duplicate Values

📊 Practice Task:
Use this table:

✔️ Sort by Marks (highest to lowest)
✔️ Filter Attendance = "Yes"
✔️ Highlight Marks > 80 in green

💬 Tap ❤️ for more Excel tips!

𝐏𝐚𝐲 𝐀𝐟𝐭𝐞𝐫 𝐏𝐥𝐚𝐜𝐞𝐦𝐞𝐧𝐭 - 𝐆𝐞𝐭 𝐏𝐥𝐚𝐜𝐞𝐝 𝐈𝐧 𝐓𝐨𝐩 𝐌𝐍𝐂'𝐬 😍

Learn Coding From Scratch - Lectures Taught By IIT Alumni

60+ Hiring Drives Every Month

𝐇𝐢𝐠𝐡𝐥𝐢𝐠𝐡𝐭𝐬:- 

🌟 Trusted by 7500+ Students
🤝 500+ Hiring Partners
💼 Avg. Rs. 7.4 LPA
🚀 41 LPA Highest Package

Eligibility: BTech / BCA / BSc / MCA / MSc

𝐑𝐞𝐠𝐢𝐬𝐭𝐞𝐫 𝐍𝐨𝐰👇 :- 

https://pdlink.in/4hO7rWY

Hurry, limited seats available!

Excel Basics Part 8: Charts

Charts are a great way to turn numbers into decisions. They are essential for interviews and daily reporting!

1. Column Chart
Best for comparison. 
Use when: 
• Compare sales by product
• Compare marks by student
Example: 
Products A B C 
Sales 40 65 30 
Insert: Select data → Insert → Column Chart 
Tip: Keep categories short. Sort values.

2. Bar Chart
Horizontal layout, same as column. 
Use when: 
• Long category names
• Ranking data
Example: Departments vs Headcount 
Tip: Great for dashboards with many labels.

3. Line Chart
Shows trend over time. 
Use when: 
• Monthly revenue
• Daily website traffic
Example: Jan to Dec sales trend 
Tip: Avoid too many lines. Two or three max.

4. Pie Chart
Shows proportion. 
Use when: 
• Market share
• Expense split
Example: Rent 40%, Food 30%, Travel 20%, Other 10% 
Rule: Use only if parts add to 100%.

5. Area Chart
Trend with volume emphasis. 
Use when: 
• Cumulative growth
• Capacity usage
Tip: Line chart first. Area only if volume matters.

6. Combo Chart
Two metrics, one view. 
Use when: 
• Revenue vs Profit
• Sales vs Growth rate
Example: Bars for sales, line for growth.

Interview Tips: 
• Know when to use which chart.
• Never use pie for trends.
• Label axes clearly.
• Remove gridlines if not needed.

Real-world Example: 
Sales dashboard: 
• Column for product comparison.
• Line for monthly trend.
• Bar for region ranking.

Double Tap ♥️ For More

𝗕𝗲𝗰𝗼𝗺𝗲 𝗮 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗲𝗱 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 𝗜𝗻 𝗧𝗼𝗽 𝗠𝗡𝗖𝘀😍

Learn Data Analytics, Data Science & AI From Top Data Experts 

𝗛𝗶𝗴𝗵𝗹𝗶𝗴𝗵𝘁𝗲𝘀:- 

- 12.65 Lakhs Highest Salary
- 500+ Partner Companies
- 100% Job Assistance
- 5.7 LPA Average Salary

𝗕𝗼𝗼𝗸 𝗮 𝗙𝗥𝗘𝗘 𝗗𝗲𝗺𝗼👇:-

𝗢𝗻𝗹𝗶𝗻𝗲:- https://pdlink.in/4fdWxJB

🔹 Hyderabad :- https://pdlink.in/4kFhjn3

🔹 Pune:-  https://pdlink.in/45p4GrC

🔹 Noida :-  https://linkpd.in/DaNoida

( Hurry Up 🏃‍♂️Limited Slots )

✅ Excel Basics Part 9: Pivot Tables and Pivot Charts

Think of a pivot table as a summary machine. You give raw data. It gives answers.

Start with raw data
Imagine this table has 5,000 rows.
Date | Region | Product | Sales
Jan | North | Laptop | 50000
Jan | South | Mobile | 30000
Feb | North | Mobile | 20000
…and more rows

Looking at this data directly wastes time.

What a Pivot Table does
• Groups similar data
• Adds numbers automatically
• Shows summary in seconds

Example 1. Total sales by region
Question How much sales happened in each region?
Steps
• Select the data
• Insert → Pivot Table
• Drag Region to Rows
• Drag Sales to Values
Result
North → 70,000
South → 30,000
No formula used.

Example 2. Sales by product
Question Which product sells more?
Steps
• Rows → Product
• Values → Sum of Sales
Result
Laptop → total sales
Mobile → total sales

Example 3. Monthly sales trend
Question How does sales change month by month?
Steps
• Rows → Date
• Values → Sum of Sales
Now you see Jan, Feb, Mar totals clearly.

Values area. Important part
This decides what calculation happens.
Common options
• Sum. Total sales
• Count. Number of records
• Average. Mean score
• Percentage of total. Share comparison
Example Region sales as percent of total sales.

Filters and slicers. Easy control
Filters
• Drop-down inside pivot
• Select one region or one product
Slicers
• Big buttons
• One click filtering
• Used in dashboards
Example Click North. Entire pivot updates.

Pivot Chart. Visual version
A pivot chart is a chart linked to a pivot table.
Key rule Change pivot. Chart updates automatically.
Example
• Pivot shows sales by month
• Pivot chart shows line trend
How to create
• Click pivot table
• Insert → Pivot Chart
• Choose Column or Line
Best uses
• Column chart for comparison
• Line chart for trends
• Bar chart for ranking

Real-life example
Sales dashboard
• Pivot table for calculations
• Slicers for year and region
• Pivot chart for management view

Common mistakes
• Blank column headers in data
• Merged cells
• Editing pivot numbers manually

Interview tip
Say this clearly Pivot tables summarize large data without formulas and update instantly when data changes.

Double Tap ♥️ For More

𝗧𝗵𝗲 𝟯 𝗦𝗸𝗶𝗹𝗹𝘀 𝗧𝗵𝗮𝘁 𝗪𝗶𝗹𝗹 𝗠𝗮𝗸𝗲 𝗬𝗼𝘂 𝗨𝗻𝘀𝘁𝗼𝗽𝗽𝗮𝗯𝗹𝗲 𝗶𝗻 𝟮𝟬𝟮𝟲😍

Start learning for FREE and earn a certification that adds real value to your resume.

𝗖𝗹𝗼𝘂𝗱 𝗖𝗼𝗺𝗽𝘂𝘁𝗶𝗻𝗴:- https://pdlink.in/3LoutZd

𝗖𝘆𝗯𝗲𝗿 𝗦𝗲𝗰𝘂𝗿𝗶𝘁𝘆:- https://pdlink.in/3N9VOyW

𝗕𝗶𝗴 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀:- https://pdlink.in/497MMLw

👉 Enroll today & future-proof your career!

📗 Excel mistakes beginners should avoid:

1. Merging Cells
- Breaks sorting and filtering
- Causes errors in formulas
- Use Center Across Selection instead
- Keeps data structure clean

2. Hardcoding Values in Formulas
- Makes spreadsheets static
- Hard to update later
- Use cell references (e.g., =A1×B1)
- Change one cell to update everything

3. Not Using Excel Tables (Ctrl + T)
- Manual ranges don't expand
- Formulas don't auto-fill
- Tables provide dynamic ranges
- Makes Pivot Tables easier to update

4. Manual Data Cleaning
- Slow and prone to human error
- Use Power Query for repetitive tasks
- Use Find & Replace or Flash Fill
- Automate the boring stuff

5. Ignoring Absolute References ($)
- Formulas break when dragged
- Use $A$1 to lock a cell
- Press F4 to toggle references
- Essential for tax rates or constants

6. Overusing VLOOKUP
- Slow on large datasets
- Breaks if you insert a column
- Learn XLOOKUP or INDEX/MATCH
- More flexible and powerful

7. Not Handling Errors
- Sheets look messy with #N/A or #DIV/0!
- Confuses the end-user
- Wrap formulas in IFERROR
- Example: =IFERROR(A1/B1, 0)

8. Merging Data Manually
- Copy-pasting from different sheets
- High risk of misalignment
- Use Power Query to merge/append
- Keep a "Single Source of Truth"

9. Poor Formatting & Alignment
- Using too many colors and borders
- Numbers aligned as text
- Keep it professional and clean
- Use Conditional Formatting to highlight trends

10. Not Using Pivot Tables
- Calculating summaries with manual math
- Taking hours to do what takes seconds
- Pivot Tables are the heart of analysis
- Drag and drop to get instant insights

Double Tap ♥️ For More

𝗙𝘂𝗹𝗹𝘀𝘁𝗮𝗰𝗸 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁 𝗵𝗶𝗴𝗵-𝗱𝗲𝗺𝗮𝗻𝗱 𝘀𝗸𝗶𝗹𝗹 𝗜𝗻 𝟮𝟬𝟮𝟲😍

Join FREE Masterclass In Hyderabad/Pune/Noida Cities 

𝗛𝗶𝗴𝗵𝗹𝗶𝗴𝗵𝘁𝗲𝘀:- 
- 500+ Hiring Partners 
- 60+ Hiring Drives
- 100% Placement Assistance

𝗕𝗼𝗼𝗸 𝗮 𝗙𝗥𝗘𝗘 𝗱𝗲𝗺𝗼👇:-

🔹 Hyderabad :- https://pdlink.in/4cJUWtx

🔹 Pune :-  https://pdlink.in/3YA32zi

🔹 Noida :-  https://linkpd.in/NoidaFSD

Hurry Up 🏃‍♂️! Limited seats are available

💡 𝗠𝗮𝗰𝗵𝗶𝗻𝗲 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗶𝘀 𝗼𝗻𝗲 𝗼𝗳 𝘁𝗵𝗲 𝗺𝗼𝘀𝘁 𝗶𝗻-𝗱𝗲𝗺𝗮𝗻𝗱 𝘀𝗸𝗶𝗹𝗹𝘀 𝗶𝗻 𝟮𝟬𝟮𝟲!

Start learning ML for FREE and boost your resume with a certification 🏆

📊 Hands-on learning
🎓 Certificate included
🚀 Career-ready skills

🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘 👇:-

https://pdlink.in/4bhetTu

👉 Don’t miss this opportunity

Complete step-by-step syllabus of #Excel for Data Analytics

Introduction to Excel for Data Analytics:
Overview of Excel's capabilities for data analysis
Introduction to Excel's interface: ribbons, worksheets, cells, etc.
Differences between Excel desktop version and Excel Online (web version)

Data Import and Preparation:
Importing data from various sources: CSV, text files, databases, web queries, etc.
Data cleaning and manipulation techniques: sorting, filtering, removing duplicates, etc.
Data types and formatting in Excel
Data validation and error handling

Data Analysis Techniques in Excel:
Basic formulas and functions: SUM, AVERAGE, COUNT, IF, VLOOKUP, etc.
Advanced functions for data analysis: INDEX-MATCH, SUMIFS, COUNTIFS, etc.
PivotTables and PivotCharts for summarizing and analyzing data
Advanced data analysis tools: Goal Seek, Solver, What-If Analysis, etc.

Data Visualization in Excel:
Creating basic charts: column, bar, line, pie, scatter, etc.
Formatting and customizing charts for better visualization
Using sparklines for visualizing trends in data
Creating interactive dashboards with slicers and timelines

Advanced Data Analysis Features:
Data modeling with Excel Tables and Relationships
Using Power Query for data transformation and cleaning
Introduction to Power Pivot for data modeling and DAX calculations
Advanced charting techniques: combination charts, waterfall charts, etc.

Statistical Analysis in Excel:
Denoscriptive statistics: mean, median, mode, standard deviation, etc.
Hypothesis testing: t-tests, chi-square tests, ANOVA, etc.
Regression analysis and correlation
Forecasting techniques: moving averages, exponential smoothing, etc.

Data Visualization Tools in Excel:
Introduction to Excel add-ins for enhanced visualization (e.g., Power Map, Power View)
Creating interactive reports with Excel add-ins
Introduction to Excel Data Model for handling large datasets

Real-world Projects and Case Studies:
Analyzing real-world datasets
Solving business problems with Excel
Portfolio development showcasing Excel skills

Free Resources: https://news.1rj.ru/str/excel_data

Hope this helps you 😊

✅ Advanced Excel Part 1: Data Validation, Dropdowns, Named Ranges

These features control input and prevent mistakes, making them essential for clean dashboards.

1. Data Validation
- Restricts what users enter in a cell
- Allows only specific values
- Stops wrong data entry
- Standardizes inputs

Example: Marks column - Only allow numbers between 0 and 100.
Steps:
- Select cells
- Data → Data Validation
- Allow → Whole number
- Min 0, Max 100

Result: Wrong values get blocked.

2. Dropdown List
- Data validation with a list
- Example: Attendance column - Allowed values Yes, No
Steps:
- Type Yes and No in cells E1 and E2
- Select target cells
- Data → Data Validation
- Allow → List
- Source → E1:E2

Result: Users pick from a dropdown, reducing errors.

3. Dropdown using Direct Values
- No helper cells needed
- Source: Yes,No,Pending
- Use for small lists only

Result: Quick and easy dropdown for short lists.

4. Named Ranges
- Gives a name to cells
- Example: DepartmentList (A1:A5 - HR, IT, Sales, Finance, Admin)
Steps:
- Select A1:A5
- Name Box → type DepartmentList → Enter

Result: Easy reference to a range of cells.

5. Dropdown using Named Range
- Best practice
Steps:
- Create named range DepartmentList
- Select target cell
- Data → Data Validation
- Allow → List
- Source → =DepartmentList

Result: Dynamic and easy-to-manage dropdowns.

6. Real-world Use Case
Employee form:
- Department dropdown
- Status dropdown
- Rating limited to 1–5

Result: Managers enter data safely and accurately.

7. Common Mistakes
- Extra spaces in list values
- Blank cells inside named ranges
- Hardcoding values everywhere

Interview tip: Data Validation improves data quality. Named ranges make dropdowns scalable and easy to maintain.

Excel Roadmap: https://whatsapp.com/channel/0029VaifY548qIzv0u1AHz3i/677

Double Tap ♥️ For More

𝗙𝗥𝗘𝗘 𝗖𝗮𝗿𝗲𝗲𝗿 𝗖𝗮𝗿𝗻𝗶𝘃𝗮𝗹 𝗯𝘆 𝗛𝗖𝗟 𝗚𝗨𝗩𝗜😍

Prove your skills in an online hackathon, clear tech interviews, and get hired faster

Highlightes:- 

- 21+ Hiring Companies & 100+ Open Positions to Grab
- Get hired for roles in AI, Full Stack, & more

Experience the biggest online job fair with Career Carnival by HCL GUVI

𝗥𝗲𝗴𝗶𝘀𝘁𝗲𝗿 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:- 

https://pdlink.in/4bQP5Ee

Hurry Up🏃‍♂️.....Limited Slots Available

✅ Advanced Excel Part 2: What-If Analysis, Goal Seek & Scenario Manager

1. What-If Analysis
Big picture: Shows how changing inputs affects results. Used for:
- Profit planning
- Budgeting
- Target setting
Excel tools inside it:
- Goal Seek
- Scenario Manager
- Data Tables

2. Goal Seek
One target, one variable. Goal Seek works backward.
You know: Final result
You change: One input value
Example: You want profit = 50,000. Profit formula: Profit = Revenue − Cost
Question: What revenue is needed?
Steps:
- Go to Data → What-If Analysis → Goal Seek
- Set cell: Profit cell
- To value: 50000
- By changing cell: Revenue cell
Result: Excel calculates required revenue.
Best use:
- Break-even analysis
- Sales target planning
- EMI or margin calculations
Limit: Works with only one changing cell, no multiple scenarios together

3. Scenario Manager
Multiple situations. Scenario Manager compares different cases.
You define: Multiple inputs, one result
Example: Sales forecast
Inputs: Price, Quantity, Cost
Scenarios: Best case, Normal case, Worst case
Steps:
- Data → What-If Analysis → Scenario Manager
- Add scenario
- Enter values for input cells
- Show summary
Result: Excel creates a comparison table.
Best use:
- Business planning
- Risk analysis
- Management presentations

4. Goal Seek vs Scenario Manager
Goal Seek:
- One target value
- One changing input
- Fast calculation
Scenario Manager:
- Multiple inputs
- Multiple cases
- Comparison view

5. Real-world example
Startup revenue planning:
- Goal Seek to find required sales
- Scenario Manager to compare optimistic vs pessimistic plans

6. Common mistakes
- Wrong formula cell selected
- Hardcoded values in formulas
- Too many changing cells in Goal Seek

Interview tip: Say this clearly. Goal Seek finds the input needed for a target result. Scenario Manager compares multiple business scenarios side by side.

Double Tap ♥️ For More

𝗧𝗼𝗽 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀 𝗧𝗼 𝗚𝗲𝘁 𝗛𝗶𝗴𝗵 𝗣𝗮𝘆𝗶𝗻𝗴 𝗝𝗼𝗯 𝗜𝗻 𝟮𝟬𝟮𝟲😍

Opportunities With 500+ Hiring Partners 

𝗙𝘂𝗹𝗹𝘀𝘁𝗮𝗰𝗸:- https://pdlink.in/4hO7rWY

𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀:- https://pdlink.in/4fdWxJB

📈 Start learning today, build job-ready skills, and get placed in leading tech companies.

✅ Advanced Excel Part 3: Macros and VBA Basics

1. What a Macro is
A macro records actions and replays them. You use it to
• Save time
• Reduce manual work
• Avoid repetitive clicks
Example
• Bold headers
• Apply borders
• Set number format
Run once. Excel repeats it exactly.

2. Macro Recorder. Best starting point
You do not write code. Excel writes it for you.
Steps
• View → Macros → Record Macro
• Perform actions
• Stop Recording
Result
A macro is created.
Example actions
• Format cells
• Insert rows
• Apply filters
Good for beginners. Limit
Recorded macros are not flexible.

3. Where macro code lives
Macros are written in VBA.
To open VBA editor
• Press Alt + F11
What you see
• Code window
• Modules
• Procedures
Each macro is a VBA procedure.

4. Simple VBA macro example
Sub FormatReport()
Range("A1:D1").Font.Bold = True
Range("A1:D1").Interior.Color = RGB(200,200,200)
End Sub
What this does
• Bolds header row
• Adds background color
You can run it anytime.

5. Running a macro
Ways to run
• Alt + F8 → Run
• Assign macro to a button
• Run from VBA editor
Button example
Click button → Report formats instantly.

6. When to use VBA
Use VBA when
• Logic is needed
• Conditions exist
• Loops are required
Example
• Highlight sales above target
• Send email for low stock
• Clean data automatically

7. Common beginner mistakes
• Forgetting to save file as .xlsm
• Disabling macros
• Hardcoding cell references

8. Safety note
Only enable macros from trusted files.

Interview tip
Say this clearly.
Macros automate repetitive tasks. VBA gives control using logic, conditions, and loops.

Double Tap ♥️ For More

𝗧𝗼𝗽 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀 𝗢𝗳𝗳𝗲𝗿𝗲𝗱 𝗕𝘆 𝗜𝗜𝗧 𝗥𝗼𝗼𝗿𝗸𝗲𝗲 & 𝗜𝗜𝗠 𝗠𝘂𝗺𝗯𝗮𝗶😍

Placement Assistance With 5000+ Companies 

Deadline: 25th January 2026

𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 & 𝗔𝗜 :- https://pdlink.in/49UZfkX

𝗦𝗼𝗳𝘁𝘄𝗮𝗿𝗲 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝗶𝗻𝗴:- https://pdlink.in/4pYWCEK

𝗗𝗶𝗴𝗶𝘁𝗮𝗹 𝗠𝗮𝗿𝗸𝗲𝘁𝗶𝗻𝗴 & 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 :- https://pdlink.in/4tcUPia

Hurry..Up Only Limited Seats Available

✅ Advanced Excel Part 4: Dashboard Project

This is where skills come together. This is what recruiters expect.

What an Excel Dashboard Is
A single screen that shows key metrics. No scrolling. No clutter. Clear decisions. Used for:
- Sales tracking
- Performance review
- Management reporting

Data You Need
Always start with clean data. Example sales data:
Date | Region | Product | Sales | Target
Rules:
- No blank headers
- No merged cells
- One row equals one record

Tools Used in a Dashboard
You combine these features:
- Pivot Tables for calculations
- Pivot Charts for visuals
- Slicers for filtering
- Data Validation for inputs
- Conditional Formatting for highlights

Step 1. Create Pivot Tables
Create separate pivots for:
- Total sales
- Sales by region
- Sales by product
- Monthly trend

Tip:
Keep all pivots on a hidden sheet.

Step 2. Create Pivot Charts
Best choices:
- Column chart: Product comparison
- Bar chart: Region ranking
- Line chart: Monthly trend
Remove:
- Gridlines
- Chart borders
- Extra legends

Step 3. Add Slicers
Slicers control the dashboard. Common slicers:
- Year
- Region
- Product
Connect slicers to all pivot tables. Now one click updates everything.

Step 4. KPI Cards
Show key numbers clearly. Examples:
- Total Sales
- Target
- Achievement percent
Use:
- Large font
- Simple colors
- Conditional formatting

Step 5. Layout and Design
Rules:
- Keep charts aligned
- Use one font
- Use 2–3 colors max
- White space is good
Top section: KPIs
Middle: Charts
Side: Slicers

Real-World Dashboard Example
Sales dashboard:
- KPI: Total Sales, Target, Growth
- Column chart: Product sales
- Bar chart: Region ranking
- Line chart: Monthly trend
- Slicers: Year, Region

Common Mistakes
- Too many charts
- Too many colors
- Mixing raw data with dashboard
- Hardcoded values

Interview Tip
Say this clearly: "I build Excel dashboards using pivot tables, pivot charts, slicers, and clean layouts to help management track KPIs quickly."

Next post: Excel dashboard interview questions with answers.

Want to practice building a dashboard or need help with a specific step? 😊

Double Tap ♥️ For More

𝗜𝗻𝗱𝗶𝗮’𝘀 𝗕𝗶𝗴𝗴𝗲𝘀𝘁 𝗛𝗮𝗰𝗸𝗮𝘁𝗵𝗼𝗻 | 𝗔𝗜 𝗜𝗺𝗽𝗮𝗰𝘁 𝗕𝘂𝗶𝗹𝗱𝗮𝘁𝗵𝗼𝗻😍

Participate in the national AI hackathon under the India AI Impact Summit 2026

Submission deadline: 5th February 2026

Grand Finale: 16th February 2026, New Delhi

𝗥𝗲𝗴𝗶𝘀𝘁𝗲𝗿 𝗡𝗼𝘄👇:- 

https://pdlink.in/4qQfAOM

a flagship initiative of the Government of India 🇮🇳

15 Excel Shortcut Keys

1. Select All → Ctrl + A
2. Bold → Ctrl + B
3. Copy → Ctrl + C
4. Fill Down → Ctrl + D
5. Flash Fill→ Ctrl + E
6. Find → Ctrl + F
7. Go To → Ctrl + G
8. Replace → Ctrl + H
9. Italic → Ctrl + I
10. Insert Hyperlink → Ctrl + K
11. Create Table → Ctrl + L
12. New Workbook → Ctrl + N
13. Open File → Ctrl + O
14. Print → Ctrl + P
15. Quit/Close → Ctrl + Q (atau Ctrl + W)