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
Excel for Data Analysis: Formulas That Matter
The Excel formulas that do most of the work in data analysis, shown as patterns on a sales table: looking up values with XLOOKUP, conditional totals with SUMIFS and COUNTIFS, cleaning text properly, handling errors without hiding problems, dynamic arrays with UNIQUE and FILTER, and readable formulas with LET.
Google Sheets for Data Analysis: Underrated Power Tools
Google Sheets features that turn it into a serious analysis tool: the QUERY function for SQL-like summaries inside a spreadsheet, ARRAYFORMULA for whole-column calculations, FILTER, REGEXEXTRACT for messy text, IMPORTRANGE for combining files, pivot tables, and where Sheets stops being the right tool.