Details Curriculum of Microsoft Excel/Google Sheet for Data Analyst In today’s data-driven world, mastering spreadsheet applications like Microsoft Excel and Google Sheets is essential for any aspiring data analyst. Both tools offer powerful functionalities that allow analysts to organize, analyze, and visualize data efficiently. This curriculum covers essential Excel/Google Sheets skills, organized into fundamental, intermediate, and advanced levels to build a comprehensive understanding. 1. Basic Excel/Google Sheets Skills for Data Analysts Cell Referencing Understand relative, absolute, and mixed references to streamline formulas. Differentiate between relative references (e.g., A1) and absolute references (e.g., $A$1) to control cell behavior during formula replication. Formatting Learn basic formatting (font size, color, borders) for better readability. Format numbers, dates, and conditional formatting for dynamic data visualization. Basic Functions: SUM, MIN, MAX, COUNTA, A...
Data Analyst, Power BI, MS Excel, Google Sheet, SQL, Tableau