About:
This gig is for those who require different levels of tasks to be done on Microsoft Excel such as advanced functions & filters, PivotTables, application of tables, charts (bar chart, pie chart, line chart etc.), graphs, data analysis (using Excel's integrated Analysis Tools), ratio analysis, formatting, data organization, data cleanup and more.
I can help you in any excel related tasks including the following:
- Cell functions
- Advanced filters
- Drop downs
- Complex formulas such as IF, IFS, SUMIF, SUMIFS, SUMPRODUCT, XLOOKUP, RIGHT, LEFT, LEN, CONCATENATE, FIND, REPLACE, SUBTOTAL, MIN, MAX, INDEX, MATCH, VARIANCE, STANDARD DEVIATION, and many more)
- Conditional formatting
- Data validation
- Goal seek
- Data analysis (e.g. Anova, Correlation, Covariance, F-Test Two-Sample for Variances, Histogram, Moving Average, Regression, Sampling etc.
- Graphs such as pie chart, line chart, column chart, bar chart
- Sparklines
Reviews
: : : : :
No comments:
Post a Comment