Banner Image

All Services

Other

Microsoft Excel

$15/hr Starting at $100

  • Task automation using macros and VBA
  • Creating dynamic reports with PivotTables
  • Building formulas
  • Cell formatting
  • Managing large datasets with functions: IF, SUM, INDEX, MATCH, VLOOKUP
  • Task automation
  • Manipulate date, time, text, and arrays
  • Building charts and graphs
  • Pivot tables and reporting
  • Data recording
  • VLOOKUP and XLOOKUP
  • INDEX MATCH
  • Advanced conditional formatting
  • Data simulations
  • Data validation
  • Charts and graphs creation

About

$15/hr Ongoing

Download Resume

  • Task automation using macros and VBA
  • Creating dynamic reports with PivotTables
  • Building formulas
  • Cell formatting
  • Managing large datasets with functions: IF, SUM, INDEX, MATCH, VLOOKUP
  • Task automation
  • Manipulate date, time, text, and arrays
  • Building charts and graphs
  • Pivot tables and reporting
  • Data recording
  • VLOOKUP and XLOOKUP
  • INDEX MATCH
  • Advanced conditional formatting
  • Data simulations
  • Data validation
  • Charts and graphs creation

Skills & Expertise

GraphsMacroMicrosoft ExcelOLE AutomationReportsTable Design

0 Reviews

This Freelancer has not received any feedback.