Banner Image

All Services

Other

Excel

$10/hr Starting at $30

I have good excel. I can create useful excel macro, MIS reports and can manage excel based database. Use Pivot Tables to recognize and make sense of data. Add more than one row or column. Use filters to simplify your data. Remove duplicate data points or sets. Transpose rows into columns. Split up text information between columns. Use these formulas for simple calculations. Get the average of numbers in your cells. Use conditional formatting to make cells automatically change color based on data. Use IF THEN Excel formula to automate certain Excel functions. Use dollar signs to keep one cell's formula the same regardless of where it moves. Use VLOOKUP function pull data from one area of a sheet to another. Use INDEX MATCH formulas to pull data from horizontal columns. Use COUNTIF function to make Excel count words or numbers in any range of cells. Combine cells using andpersand. Add checkboxes. Hyperlink a cell to a website. Add drop-down menus

About

$10/hr Ongoing

Download Resume

I have good excel. I can create useful excel macro, MIS reports and can manage excel based database. Use Pivot Tables to recognize and make sense of data. Add more than one row or column. Use filters to simplify your data. Remove duplicate data points or sets. Transpose rows into columns. Split up text information between columns. Use these formulas for simple calculations. Get the average of numbers in your cells. Use conditional formatting to make cells automatically change color based on data. Use IF THEN Excel formula to automate certain Excel functions. Use dollar signs to keep one cell's formula the same regardless of where it moves. Use VLOOKUP function pull data from one area of a sheet to another. Use INDEX MATCH formulas to pull data from horizontal columns. Use COUNTIF function to make Excel count words or numbers in any range of cells. Combine cells using andpersand. Add checkboxes. Hyperlink a cell to a website. Add drop-down menus

Skills & Expertise

Color CorrectionCreativeData ManagementMacroMicrosoft ExcelMicrosoft WordReportsTable Design

0 Reviews

This Freelancer has not received any feedback.