🖇️ PivotTables, Charts & Dashboards

61. What is a PivotTable and when do you use it?
62. How do you create a PivotTable from a flat table?
63. How do you group by month, quarter, or year in a PivotTable?
64. How do you add “Calculated Fields” and “Calculated Items”?
65. How do you create a PivotChart?
66. How do you use slicers and timelines to filter PivotTables?
67. How do you “refresh” a PivotTable when data changes?
68. How do you design a dashboard using tables, charts, and PivotTables?
69. How do you format axes, legends, and data labels?
70. How do you create dynamic charts that update with new data?

🚀 Advanced Excel (Power‑User / Analyst Level)

71. How do you use FILTER, SORT, and UNIQUE (if you have dynamic arrays)?
72. How do you use SUMIFS / COUNTIFS with multiple criteria?
73. How do you use SUMPRODUCT for 2D‑style lookups and weighted averages?
74. How do you build reusable templates with named ranges and formulas?
75. How do you link multiple sheets and workbooks?
76. How do you avoid and fix circular references?
77. How do you optimize large Excel files for performance?
78. How do you use Data Validation to create dropdown lists?
79. How do you use “What‑If Analysis” (Goal Seek, Data Tables, Scenario Manager)?
80. How do you connect Excel to external data (CSV, text, web, or databases)?

🤖 Power Query / Automation & VBA‑Lite

81. What is Power Query and how do you use it for data cleaning?
82. How do you import and transform data (filter, group, pivot, unpivot) using Power Query?
83. How do you refresh a query that pulls from a source file?
84. How do you load cleaned data into a PivotTable or worksheet?
85. What is Power Pivot and DAX (high‑level overview)?
86. How do you use tables and structured references in formulas?
87. How do you protect and share an Excel file for multiple users?
88. How do you create dynamic dashboards with slicers and linked PivotTables?
89. How do you export Excel reports to PDF or CSV?
90. How do you automate repetitive tasks (e.g., formatting, validation, data loading)?

🧠 Scenario‑Based / Behavioral (Excel for Work)

91. How would you build a monthly sales report from raw transaction data?
92. How would you design a budget or expense tracker?
93. How would you analyze customer retention or RFM‑style data?
94. How would you create an attendance or performance tracking sheet?
95. How would you handle a messy Excel file shared by your team?
96. How do you ensure your formulas and tables are easy to understand and maintain?
97. How do you explain Excel insights to a non‑technical person?
98. How do you share and protect an Excel file for multiple users?
99. How do you validate your analysis before sharing it with stakeholders?
100. What are your top 5 Excel shortcuts and which ones do you use daily?

🚀 Double Tap ❤️ For Detailed Answers!