Data analytics by Saloni KushwahData analytics by Saloni Kushwah
Data analyticsSaloni Kushwah
Cover image for Data analytics
Basic skills include entering data, formatting cells, using rows, columns, tables, and creating simple formulas like SUM, AVERAGE, MIN, and MAX. Intermediate skills include using functions such as IF, VLOOKUP, HLOOKUP, INDEX, MATCH, COUNTIF, SUMIF, and conditional formatting. You should also know how to sort and filter data, remove duplicates, create charts, use Pivot Tables, and manage large datasets. Advanced Excel skills include using Power Query, Power Pivot, macros, VBA automation, data validation, dashboards, and complex formulas. For data analyst jobs, Excel skills like lookup formulas, Pivot Tables, charts, cleaning data, text functions, logical functions, and report creation are especially important. Good Excel users also have problem-solving skills, attention to detail, speed, accuracy, and the ability to organize and analyze data clearly.
Starting at$20
Duration1 week
Tags
Microsoft Excel
Microsoft Power BI
Microsoft PowerPoint
Microsoft Word
Data Analyst
Data Entry Specialist
dashboard
Data cleaning
data formatting
Service provided by
Saloni Kushwah Mumbai, India
Data analyticsSaloni Kushwah
Starting at$20
Duration1 week
Tags
Microsoft Excel
Microsoft Power BI
Microsoft PowerPoint
Microsoft Word
Data Analyst
Data Entry Specialist
dashboard
Data cleaning
data formatting
Cover image for Data analytics
Basic skills include entering data, formatting cells, using rows, columns, tables, and creating simple formulas like SUM, AVERAGE, MIN, and MAX. Intermediate skills include using functions such as IF, VLOOKUP, HLOOKUP, INDEX, MATCH, COUNTIF, SUMIF, and conditional formatting. You should also know how to sort and filter data, remove duplicates, create charts, use Pivot Tables, and manage large datasets. Advanced Excel skills include using Power Query, Power Pivot, macros, VBA automation, data validation, dashboards, and complex formulas. For data analyst jobs, Excel skills like lookup formulas, Pivot Tables, charts, cleaning data, text functions, logical functions, and report creation are especially important. Good Excel users also have problem-solving skills, attention to detail, speed, accuracy, and the ability to organize and analyze data clearly.
$20