Banner Image

All Services

Other

Microsoft Excel

$8/hr Starting at $25

Expertise in Microsoft excel and capable of providing all kinds of excel services such as • Working with data • Formatting Text • Merging and Centering Text • Formatting Numbers • Using and Testing Formulae • Displaying and Printing Formulae • Absolute and Relative Referencing • Using Functions • Preparing Conversion Table • Adding Header and Footer • Defining and naming cells • Logical and Conditional Functions • Adding Clip Art • Enhancing page appearance • Removing Gridlines • Using Color • Locking and Unlocking worksheet • Protecting Worksheet • Adding Password to Unprotect worksheet • Correlation • Regression • Creating Table • Copy and Transpose in Paste Special • Wrapping Text • Orientation • Coloring • Borders • Naming cell ranges • Viewing and deleting cell names • Using range names in formulae • Using Count if function • Editing Formulae in Formula Bar • Sorting • Building a spreadsheet • Moving and Renaming sheets • Designing the users screen • Adding Validation to cells • Testing the Validation • Using Lookup function • Redefining the named range • Using format painter • Creating a drop down list • Using If..Then..Else function • Creating Menu Screen • Adding Clip Art • Creating and Using Macros • Creating and Using Buttons with Macros • Protecting Cells • Testing Formulae • Presenting Test Results • Using fill handle • Using shortcut to absolute referencing • Creating Line Column on two Axis Chart • Creating Pie Chart • Creating Histogram • Changing Chart Scales • Adding Value Labels • Adding a Trend Line • Z-test • T- test • Chi-square test • ANOVA

About

$8/hr Ongoing

Download Resume

Expertise in Microsoft excel and capable of providing all kinds of excel services such as • Working with data • Formatting Text • Merging and Centering Text • Formatting Numbers • Using and Testing Formulae • Displaying and Printing Formulae • Absolute and Relative Referencing • Using Functions • Preparing Conversion Table • Adding Header and Footer • Defining and naming cells • Logical and Conditional Functions • Adding Clip Art • Enhancing page appearance • Removing Gridlines • Using Color • Locking and Unlocking worksheet • Protecting Worksheet • Adding Password to Unprotect worksheet • Correlation • Regression • Creating Table • Copy and Transpose in Paste Special • Wrapping Text • Orientation • Coloring • Borders • Naming cell ranges • Viewing and deleting cell names • Using range names in formulae • Using Count if function • Editing Formulae in Formula Bar • Sorting • Building a spreadsheet • Moving and Renaming sheets • Designing the users screen • Adding Validation to cells • Testing the Validation • Using Lookup function • Redefining the named range • Using format painter • Creating a drop down list • Using If..Then..Else function • Creating Menu Screen • Adding Clip Art • Creating and Using Macros • Creating and Using Buttons with Macros • Protecting Cells • Testing Formulae • Presenting Test Results • Using fill handle • Using shortcut to absolute referencing • Creating Line Column on two Axis Chart • Creating Pie Chart • Creating Histogram • Changing Chart Scales • Adding Value Labels • Adding a Trend Line • Z-test • T- test • Chi-square test • ANOVA

Skills & Expertise

ClipartCopy and PasteFormulaGraphsHeader DesignLayout DesignMenu DesignMicrosoftMicrosoft ExcelPrintingValidation Engineering

0 Reviews

This Freelancer has not received any feedback.