✔️ =INDEX(C2:C4, MATCH("Tara", A2:A4, 0)) → Yes
✔️ =LEFT(A2, 2) → "Ri"
✔️ =LEN(B3) → 2 (if marks are two digits)
✔️ =UPPER(A4) → TARA
💬 Tap ❤️ for more!
✔️ =LEFT(A2, 2) → "Ri"
✔️ =LEN(B3) → 2 (if marks are two digits)
✔️ =UPPER(A4) → TARA
💬 Tap ❤️ for more!
🔥2❤1🏆1
✅ 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:
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:
🔥1😁1
✔️ Sort by Marks (highest to lowest)
✔️ Filter Attendance = "Yes"
✔️ Highlight Marks > 80 in green
💬 Tap ❤️ for more Excel tips!
✔️ Filter Attendance = "Yes"
✔️ Highlight Marks > 80 in green
💬 Tap ❤️ for more Excel tips!
❤3🤩1
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
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
❤1⚡1🔥1🥰1😁1😍1
✅ 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
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
😍2❤1👍1🔥1🏆1
📗 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
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
🔥3❤1⚡1😍1🏆1
Complete Roadmap to Master Web Development in 3 Months ✅
Month 1: Foundations
• Week 1: Web basics
– How the web works, browser, server, HTTP
– HTML structure, tags, forms, tables
– CSS basics, box model, colors, fonts
Outcome: You build simple static pages.
• Week 2: CSS and layouts
– Flexbox and Grid
– Responsive design with media queries
– Basic animations and transitions
Outcome: Your pages look clean on all screens.
• Week 3: JavaScript fundamentals
– Variables, data types, operators
– Conditions and loops
– Functions and scope
Outcome: You add logic to pages.
• Week 4: DOM and events
– DOM selection and manipulation
– Click, input, submit events
– Form validation
Outcome: Your pages become interactive.
Month 2: Frontend and Backend
• Week 5: Advanced JavaScript
– Arrays and objects
– Map, filter, reduce
– Async JavaScript, promises, fetch API
Outcome: You handle real data flows.
• Week 6: Frontend framework basics
– React basics, components, props, state
– JSX and folder structure
– Simple CRUD UI
Outcome: You build modern UI apps.
• Week 7: Backend fundamentals
– Node.js and Express basics
– REST APIs, routes, controllers
– JSON and API testing
Outcome: You create backend services.
• Week 8: Database integration
– SQL or MongoDB basics
– CRUD operations
– Connect backend to database
Outcome: Your app stores real data.
Month 3: Real World and Job Prep
• Week 9: Full stack integration
– Connect frontend with backend APIs
– Authentication basics
– Error handling
Outcome: One working full stack app.
• Week 10: Project development
– Choose project, blog, ecommerce, dashboard
– Build features step by step
– Deploy on Netlify or Render
Outcome: One solid portfolio project.
• Week 11: Interview preparation
– JavaScript interview questions
– React basics and concepts
– API and project explanation
Outcome: You explain your work with clarity.
• Week 12: Resume and practice
– Web developer focused resume
– GitHub with clean repos
– Daily coding practice
Outcome: You are job ready.
Practice platforms: Frontend Mentor, LeetCode JS, CodePen
Double Tap ♥️ for more
Month 1: Foundations
• Week 1: Web basics
– How the web works, browser, server, HTTP
– HTML structure, tags, forms, tables
– CSS basics, box model, colors, fonts
Outcome: You build simple static pages.
• Week 2: CSS and layouts
– Flexbox and Grid
– Responsive design with media queries
– Basic animations and transitions
Outcome: Your pages look clean on all screens.
• Week 3: JavaScript fundamentals
– Variables, data types, operators
– Conditions and loops
– Functions and scope
Outcome: You add logic to pages.
• Week 4: DOM and events
– DOM selection and manipulation
– Click, input, submit events
– Form validation
Outcome: Your pages become interactive.
Month 2: Frontend and Backend
• Week 5: Advanced JavaScript
– Arrays and objects
– Map, filter, reduce
– Async JavaScript, promises, fetch API
Outcome: You handle real data flows.
• Week 6: Frontend framework basics
– React basics, components, props, state
– JSX and folder structure
– Simple CRUD UI
Outcome: You build modern UI apps.
• Week 7: Backend fundamentals
– Node.js and Express basics
– REST APIs, routes, controllers
– JSON and API testing
Outcome: You create backend services.
• Week 8: Database integration
– SQL or MongoDB basics
– CRUD operations
– Connect backend to database
Outcome: Your app stores real data.
Month 3: Real World and Job Prep
• Week 9: Full stack integration
– Connect frontend with backend APIs
– Authentication basics
– Error handling
Outcome: One working full stack app.
• Week 10: Project development
– Choose project, blog, ecommerce, dashboard
– Build features step by step
– Deploy on Netlify or Render
Outcome: One solid portfolio project.
• Week 11: Interview preparation
– JavaScript interview questions
– React basics and concepts
– API and project explanation
Outcome: You explain your work with clarity.
• Week 12: Resume and practice
– Web developer focused resume
– GitHub with clean repos
– Daily coding practice
Outcome: You are job ready.
Practice platforms: Frontend Mentor, LeetCode JS, CodePen
Double Tap ♥️ for more
❤1😍1🏆1😎1
17 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)
16. Save~ comment
17. Paste ~
i) Ctrl + S ❤️
ii) Ctrl + V 😍
iii) Ctrl + P ❤️🔥
iv) Ctrl + B🙏
Reaction 👆
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)
16. Save~ comment
17. Paste ~
i) Ctrl + S ❤️
ii) Ctrl + V 😍
iii) Ctrl + P ❤️🔥
iv) Ctrl + B🙏
Reaction 👆
😍3❤1🆒1
26 जनवरी, 2026 को भारत अपना 77 वां गणतंत्र दिवस मना रहा है, जो उस दिन की याद दिलाता है जब 1950 में भारत का संविधान लागू हुआ था।
मुख्य कार्यक्रम में नई दिल्ली के कर्तव्य पथ पर एक भव्य परेड होगी, जो देश की लोकतांत्रिक, सैन्य और सांस्कृतिक विविधता को उजागर करेगी। एंटोनियो कोस्टा और उर्सुला वॉन डेर लेयेन मुख्य अतिथि होंगे
।
77वें गणतंत्र दिवस 2026 के प्रमुख विवरणों में निम्नलिखित शामिल हैं:
महत्वः यह 26 जनवरी, 1950 को संविधान को अपनाने के बाद भारत के एक संप्रभु, लोकतांत्रिक गणराज्य बनने की 77वीं वर्षगांठ का प्रतीक है।
विषयवस्तुः 2026 के समारोह 'वंदे मातरम के 150 वर्ष' विषय पर केंद्रित हैं।
समारोहः इस आयोजन में नई दिल्ली के कर्तव्य पथ पर पारंपरिक परेड शामिल है, जिसमें सैन्य शक्ति, राजकीय झांकियों के माध्यम से सांस्कृतिक विविधता और राष्ट्रीय ध्वज का प्रदर्शन किया जाता है
मुख्य कार्यक्रम में नई दिल्ली के कर्तव्य पथ पर एक भव्य परेड होगी, जो देश की लोकतांत्रिक, सैन्य और सांस्कृतिक विविधता को उजागर करेगी। एंटोनियो कोस्टा और उर्सुला वॉन डेर लेयेन मुख्य अतिथि होंगे
।
77वें गणतंत्र दिवस 2026 के प्रमुख विवरणों में निम्नलिखित शामिल हैं:
महत्वः यह 26 जनवरी, 1950 को संविधान को अपनाने के बाद भारत के एक संप्रभु, लोकतांत्रिक गणराज्य बनने की 77वीं वर्षगांठ का प्रतीक है।
विषयवस्तुः 2026 के समारोह 'वंदे मातरम के 150 वर्ष' विषय पर केंद्रित हैं।
समारोहः इस आयोजन में नई दिल्ली के कर्तव्य पथ पर पारंपरिक परेड शामिल है, जिसमें सैन्य शक्ति, राजकीय झांकियों के माध्यम से सांस्कृतिक विविधता और राष्ट्रीय ध्वज का प्रदर्शन किया जाता है
❤2🔥1🤩1😍1🏆1
Excel Shortcut Keys You Should Know!
1. Save file → Ctrl + S
2. Undo last action → Ctrl + Z
3. Redo action → Ctrl + Y
4. Cut selection → Ctrl + X
5. Paste → Ctrl + V
6. Select entire row → Shift + Space
7. Select entire column → Ctrl + Space
8. Insert new worksheet → Shift + F11
9. Rename sheet → Alt + H, O, R
10. AutoSum → Alt + =
11. Edit active cell → F2
12. Lock cell reference → F4
13. Apply filter → Ctrl + Shift + L
14. Insert current date → Ctrl + ;
15. Insert current time → Ctrl + Shift + :
Double Tap ♥️ For More
1. Save file → Ctrl + S
2. Undo last action → Ctrl + Z
3. Redo action → Ctrl + Y
4. Cut selection → Ctrl + X
5. Paste → Ctrl + V
6. Select entire row → Shift + Space
7. Select entire column → Ctrl + Space
8. Insert new worksheet → Shift + F11
9. Rename sheet → Alt + H, O, R
10. AutoSum → Alt + =
11. Edit active cell → F2
12. Lock cell reference → F4
13. Apply filter → Ctrl + Shift + L
14. Insert current date → Ctrl + ;
15. Insert current time → Ctrl + Shift + :
Double Tap ♥️ For More
❤1👍1🤩1🏆1🫡1
15 Advanced Excel Shortcut Keys
• Navigation
1. Move to last used cell → Ctrl + End
2. Move to first cell → Ctrl + Home
3. Select to last used cell → Ctrl + Shift + End
4. Select to first cell → Ctrl + Shift + Home
• Rows Columns
5. Insert entire row → Ctrl + Shift + +
6. Delete entire row → Ctrl + -
7. Hide selected rows → Ctrl + 9
8. Unhide rows → Ctrl + Shift + 9
9. Hide selected columns → Ctrl + 0
10. Unhide columns → Ctrl + Shift + 0
• Formatting
11. Open Format Cells → Ctrl + 1
12. Apply General format → Ctrl + Shift + ~
13. Apply Number format → Ctrl + Shift + !
14. Apply Percentage format → Ctrl + Shift + %
15. Apply Currency format → Ctrl + Shift + $
Double Tap ♥️ For More
• Navigation
1. Move to last used cell → Ctrl + End
2. Move to first cell → Ctrl + Home
3. Select to last used cell → Ctrl + Shift + End
4. Select to first cell → Ctrl + Shift + Home
• Rows Columns
5. Insert entire row → Ctrl + Shift + +
6. Delete entire row → Ctrl + -
7. Hide selected rows → Ctrl + 9
8. Unhide rows → Ctrl + Shift + 9
9. Hide selected columns → Ctrl + 0
10. Unhide columns → Ctrl + Shift + 0
• Formatting
11. Open Format Cells → Ctrl + 1
12. Apply General format → Ctrl + Shift + ~
13. Apply Number format → Ctrl + Shift + !
14. Apply Percentage format → Ctrl + Shift + %
15. Apply Currency format → Ctrl + Shift + $
Double Tap ♥️ For More
❤1🔥1😁1🤩1😎1
15 Excel Formula Shortcuts You Must Know
1. Start a formula →Type =
2. Insert function dialog → Shift + F3
3. AutoSum selected cells → Alt + =
4. Toggle absolute reference → F4
5. Edit formula in cell → F2
6. Accept formula and move down → Enter
7. Accept formula and move right → Tab
8. Insert line break in formula bar → Alt + Enter
9. Select formula range → Shift + Arrow keys
10. Copy formula down → Ctrl + D
11. Copy formula right → Ctrl + R
12. Show all formulas → Ctrl + `
13. Calculate active sheet → Shift + F9
14. Calculate all workbooks → Ctrl + Alt + F9
15. Recalculate formulas manually → F9
Double Tap ♥️ For More
1. Start a formula →Type =
2. Insert function dialog → Shift + F3
3. AutoSum selected cells → Alt + =
4. Toggle absolute reference → F4
5. Edit formula in cell → F2
6. Accept formula and move down → Enter
7. Accept formula and move right → Tab
8. Insert line break in formula bar → Alt + Enter
9. Select formula range → Shift + Arrow keys
10. Copy formula down → Ctrl + D
11. Copy formula right → Ctrl + R
12. Show all formulas → Ctrl + `
13. Calculate active sheet → Shift + F9
14. Calculate all workbooks → Ctrl + Alt + F9
15. Recalculate formulas manually → F9
Double Tap ♥️ For More
❤1🔥1😍1🏆1😘1
Roadmap to become a data analyst
1. Foundation Skills:
•Strengthen Mathematics: Focus on statistics relevant to data analysis.
•Excel Basics: Master fundamental Excel functions and formulas.
2. SQL Proficiency:
•Learn SQL Basics: Understand SELECT statements, JOINs, and filtering.
•Practice Database Queries: Work with databases to retrieve and manipulate data.
3. Excel Advanced Techniques:
•Data Cleaning in Excel: Learn to handle missing data and outliers.
•PivotTables and PivotCharts: Master these powerful tools for data summarization.
4. Data Visualization with Excel:
•Create Visualizations: Learn to build charts and graphs in Excel.
•Dashboard Creation: Understand how to design effective dashboards.
5. Power BI Introduction:
•Install and Explore Power BI: Familiarize yourself with the interface.
•Import Data: Learn to import and transform data using Power BI.
6. Power BI Data Modeling:
•Relationships: Understand and establish relationships between tables.
•DAX (Data Analysis Expressions): Learn the basics of DAX for calculations.
7. Advanced Power BI Features:
•Advanced Visualizations: Explore complex visualizations in Power BI.
•Custom Measures and Columns: Utilize DAX for customized data calculations.
8. Integration of Excel, SQL, and Power BI:
•Importing Data from SQL to Power BI: Practice connecting and importing data.
•Excel and Power BI Integration: Learn how to use Excel data in Power BI.
9. Business Intelligence Best Practices:
•Data Storytelling: Develop skills in presenting insights effectively.
•Performance Optimization: Optimize reports and dashboards for efficiency.
10. Build a Portfolio:
•Showcase Excel Projects: Highlight your data analysis skills using Excel.
•Power BI Projects: Feature Power BI dashboards and reports in your portfolio.
11. Continuous Learning and Certification:
•Stay Updated: Keep track of new features in Excel, SQL, and Power BI.
•Consider Certifications: Obtain relevant certifications to validate your skills.
1. Foundation Skills:
•Strengthen Mathematics: Focus on statistics relevant to data analysis.
•Excel Basics: Master fundamental Excel functions and formulas.
2. SQL Proficiency:
•Learn SQL Basics: Understand SELECT statements, JOINs, and filtering.
•Practice Database Queries: Work with databases to retrieve and manipulate data.
3. Excel Advanced Techniques:
•Data Cleaning in Excel: Learn to handle missing data and outliers.
•PivotTables and PivotCharts: Master these powerful tools for data summarization.
4. Data Visualization with Excel:
•Create Visualizations: Learn to build charts and graphs in Excel.
•Dashboard Creation: Understand how to design effective dashboards.
5. Power BI Introduction:
•Install and Explore Power BI: Familiarize yourself with the interface.
•Import Data: Learn to import and transform data using Power BI.
6. Power BI Data Modeling:
•Relationships: Understand and establish relationships between tables.
•DAX (Data Analysis Expressions): Learn the basics of DAX for calculations.
7. Advanced Power BI Features:
•Advanced Visualizations: Explore complex visualizations in Power BI.
•Custom Measures and Columns: Utilize DAX for customized data calculations.
8. Integration of Excel, SQL, and Power BI:
•Importing Data from SQL to Power BI: Practice connecting and importing data.
•Excel and Power BI Integration: Learn how to use Excel data in Power BI.
9. Business Intelligence Best Practices:
•Data Storytelling: Develop skills in presenting insights effectively.
•Performance Optimization: Optimize reports and dashboards for efficiency.
10. Build a Portfolio:
•Showcase Excel Projects: Highlight your data analysis skills using Excel.
•Power BI Projects: Feature Power BI dashboards and reports in your portfolio.
11. Continuous Learning and Certification:
•Stay Updated: Keep track of new features in Excel, SQL, and Power BI.
•Consider Certifications: Obtain relevant certifications to validate your skills.
❤1👍1🔥1😍1🏆1🤗1
15 Excel Shortcuts for Data Analysis
1. Select current data region → Ctrl + *
2. Turn filter on or off → Ctrl + Shift + L
3. Open PivotTable dialog → Alt + N, V
4. Refresh PivotTable → Alt + F5
5. Insert PivotTable from ribbon → Alt + N, V, T
6. Fill right → Ctrl + R
7. Copy formula down → Ctrl + D
8. Show formulas → Ctrl + `
9. Calculate active sheet → Shift + F9
10. Calculate all sheets → F9
11. Create chart → Alt + F1
12. Create chart on new sheet → F11
13. Group rows or columns → Alt + Shift + →
14. Ungroup rows or columns → Alt + Shift + ←
15. Toggle outline symbols → Ctrl + 8
Double Tap ♥️ For More
1. Select current data region → Ctrl + *
2. Turn filter on or off → Ctrl + Shift + L
3. Open PivotTable dialog → Alt + N, V
4. Refresh PivotTable → Alt + F5
5. Insert PivotTable from ribbon → Alt + N, V, T
6. Fill right → Ctrl + R
7. Copy formula down → Ctrl + D
8. Show formulas → Ctrl + `
9. Calculate active sheet → Shift + F9
10. Calculate all sheets → F9
11. Create chart → Alt + F1
12. Create chart on new sheet → F11
13. Group rows or columns → Alt + Shift + →
14. Ungroup rows or columns → Alt + Shift + ←
15. Toggle outline symbols → Ctrl + 8
Double Tap ♥️ For More
❤1👍1🔥1😍1🏆1
📈 Want to Excel at Data Analytics? Master These Essential Skills! ☑️
Core Concepts:
• Statistics & Probability – Understand distributions, hypothesis testing
• Excel – Pivot tables, formulas, dashboards
Programming:
• Python – NumPy, Pandas, Matplotlib, Seaborn
• R – Data analysis & visualization
• SQL – Joins, filtering, aggregation
Data Cleaning & Wrangling:
• Handle missing values, duplicates
• Normalize and transform data
Visualization:
• Power BI, Tableau – Dashboards
• Plotly, Seaborn – Python visualizations
• Data Storytelling – Present insights clearly
Advanced Analytics:
• Regression, Classification, Clustering
• Time Series Forecasting
• A/B Testing & Hypothesis Testing
ETL & Automation:
• Web Scraping – BeautifulSoup, Scrapy
• APIs – Fetch and process real-world data
• Build ETL Pipelines
Tools & Deployment:
• Jupyter Notebook / Colab
• Git & GitHub
• Cloud Platforms – AWS, GCP, Azure
• Google BigQuery, Snowflake
Core Concepts:
• Statistics & Probability – Understand distributions, hypothesis testing
• Excel – Pivot tables, formulas, dashboards
Programming:
• Python – NumPy, Pandas, Matplotlib, Seaborn
• R – Data analysis & visualization
• SQL – Joins, filtering, aggregation
Data Cleaning & Wrangling:
• Handle missing values, duplicates
• Normalize and transform data
Visualization:
• Power BI, Tableau – Dashboards
• Plotly, Seaborn – Python visualizations
• Data Storytelling – Present insights clearly
Advanced Analytics:
• Regression, Classification, Clustering
• Time Series Forecasting
• A/B Testing & Hypothesis Testing
ETL & Automation:
• Web Scraping – BeautifulSoup, Scrapy
• APIs – Fetch and process real-world data
• Build ETL Pipelines
Tools & Deployment:
• Jupyter Notebook / Colab
• Git & GitHub
• Cloud Platforms – AWS, GCP, Azure
• Google BigQuery, Snowflake
❤1👍1🔥1😍1🏆1