IT Career Guides & Free Resources
Expert roadmaps, tutorials, salary guides and interview prep across Data Science, Generative AI, Python, Cloud & Analytics — written by GloryTecks trainers in Hyderabad.
All articles
Pivot Tables in Excel: A Complete Tutorial
A complete Excel pivot table tutorial: preparing data so pivots work, building a first summary, choosing between sum, count and average, showing values as percentages and running totals, grouping dates into months and quarters, filtering with slicers, refreshing correctly, and the mistakes that produce wrong totals.
Excel Interview Questions for Data Analysts
Excel interviews rarely ask what a function does; they ask why a formula gave the wrong answer. Seven questions are answered with formulas calculated by Microsoft Excel itself on New York's taxi zone table: an approximate VLOOKUP that was wrong 18 times in 20, an ID stored as text, and a date that depends on settings.