View Code? Open in Web Editor
NEW
Data analysis using google sheets - this gives a preliminary investigation about the data: Solved assignments to learn: Basic formulas, conditional statements, data validation, VLOOKUP, and Dashboard creation
data-analysis-with-google-sheets's Introduction
Data Analysis using Google Sheets (Assignments Based learning)
Basics: ranges, columns and cells, Text, number, date, Separate text, Alternating color, merge cells, Check box
Formullas: MIN, MAX, AVERAGE, Percentage
Conditional Statements: IF, nested IF, exact, switch
Inserting image, Formula to text, UNIQUE
Predefined functions, including functions for numbers, functions for strings, and functions for dates
ROUND, SQRT, SUM, MEAN,MEDIAN,MODE, RANK, LEFT, RIGHT, LEN,MID,DRAWING, CONCATENATE, WEEKDAY, UPPER, LOWER
Counta, Count, COUNTIF, SUMIF, AVERAGEIF
Create sample charts
SUMPRODUCT, OR, AND, SPLIT, FLATTEN, SORT, ARRAY FORMULA, Index Match
Bit about ranges
Data Validation
FILTER, VLOOKUP, HLOOKUP,SEARCH,
Pivot table
Slicer
Google finance
Dashboard Creation
data-analysis-with-google-sheets's People
Contributors
Stargazers
Watchers