Freelancer

Looking for quick and easy automated solutions with top most quality in 21st century?

SARCS provides accurate and timely solutions tailored and vetted, by the world class experts in the field. Team at SARCS is reliable and have proven in displaying great communication skills with clients all over the world. A quick and accurate work turnaround, while paying great attention to details is our key to success. Great work ethics, exceptional organization skills , and positive attitude towards work positioned us among the top class performers list. Our focus is to outperform in the highly demanding sectors and produce incredible results. Our Testimonials showcase the driving force to work seamlessly with clients in any corner of the world.

  • Excel
  • Google Sheets
  • PDF
  • Python
  • Web Scraping
  • Virtual Assistant

freelancer_sarcscoin

Microsoft Excel

Basic to Advanced Formulae

I can work on basic to advanced formulas in Excel . I have good command over 2010, 2013, and 2016 versions

Most of the challenging formulas are based on these: Indirect, index+match, vlookupsumproduct, array formulas, date and time,etc.

  Vlookup/Hlookup, Index + Match

  Countif/Countifs

  Sumif/Sumifs

  Data Validation

  Conditioning Formatting with formulas

  Data Validation: Drop down

  Named Ranges

  Pivot Table with calculated columns

  Apply formulas/Advance Filter 

  Text to columns

  Split text/data into different cells

  Sum product

  Removing duplicates

  Powerpivot

[tailor_gallery ids=”705,706,707,708,709″ layout=”slideshow” items_per_row=”2″ autoplay_speed=”3000″ arrows=”1″ dots=”1″ thumbnails=”0″ image_link=”none” image_size=”large” class=”tailor-5aa3c9d9b3a97″][/tailor_gallery]

Advanced VBA Macros

I can work on basic to advanced formulas in Excel . I have good command over 2010, 2013, and 2016 versions

MAC is Plus.

I can work on Basic Events to automation of regular tasks using excel vba.

I can create basic coding in short span based on the instructions given.

  User forms

  Pivot tables

  FilteringGraph

  Buttons

  Data Transfer to word

  Mail merge

[tailor_gallery ids=”710,711,712″ layout=”slideshow” items_per_row=”2″ autoplay=”1″ autoplay_speed=”3000″ arrows=”1″ dots=”1″ thumbnails=”0″ image_link=”none” image_size=”large” class=”tailor-5aa3c9d9b3a93″][/tailor_gallery]

freelancer_sarcscoin

Google Sheets

Basic to Advanced Formulas

I can work on basic to advanced formulas in google sheets. There are more similarities between Excel and Google Sheets. However, one will dominate another in few functions.  

I can write google scripts basic to advanced (based on the level of difficulty). 

  Vlookup/Hlookup, Index + Match

  Countif/Countifs

  Sumif/Sumifs

  Data Validation

  Conditioning Formatting with formulas

  Data Validation: Drop down

  Named Ranges

  Pivot Table with calculated columns

  Apply formulas/Advance Filter 

  Text to columns

  Split text/data into different cells

  Sum product

  Removing duplicates

  Handling Queries

[tailor_gallery ids=”714,715″ layout=”slideshow” items_per_row=”2″ autoplay=”1″ autoplay_speed=”3000″ arrows=”1″ dots=”1″ thumbnails=”0″ image_link=”none” image_size=”large” class=”tailor-5aa3c9d9b3a94″][/tailor_gallery]

Scripts

I can work on basic to advanced formulas in google sheets. There are more similarities between Excel and Google Sheets. However, one will dominate another in few functions.  

I can write google scripts basic to advanced (based on the level of difficulty). 

[tailor_gallery ids=”716,717,718″ layout=”slideshow” items_per_row=”2″ autoplay=”1″ autoplay_speed=”3000″ arrows=”1″ dots=”1″ thumbnails=”0″ image_link=”none” image_size=”large” class=”tailor-5aa3c9d9b3a92″][/tailor_gallery]

freelancer_sarcscoin

Adobe PDF

PDF Editing

Editing PDF documents using Adobe Pro DC Software. 

  • Creation of PDF documents from word and scanned documents
  • Titles, Page Numbers
  • Layout Editing

[tailor_gallery ids=”719″ layout=”slideshow” items_per_row=”2″ autoplay=”1″ autoplay_speed=”3000″ arrows=”1″ dots=”1″ thumbnails=”0″ image_link=”none” image_size=”large” class=”tailor-5aa3c9d9b3a91″][/tailor_gallery]

PDF Fillable Forms

Creation of PDF Fillable Forms

  • Text boxes
  • Radio buttons
  • Check boxes
  • Image additions
  • Signature
  • Calculations

[tailor_gallery ids=”720,721,722,723″ layout=”slideshow” items_per_row=”2″ autoplay=”1″ autoplay_speed=”3000″ arrows=”1″ dots=”1″ thumbnails=”0″ image_link=”none” image_size=”large” class=”tailor-5aa3c9d9b3a90″][/tailor_gallery]

PDF Scripting

Java Script coding is required

  • Internal Calculations
  • Emailing document

[tailor_gallery ids=”724″ layout=”slideshow” items_per_row=”2″ autoplay=”1″ autoplay_speed=”3000″ arrows=”1″ dots=”1″ thumbnails=”0″ image_link=”none” image_size=”large” class=”tailor-5aa3c9d9b3a95″][/tailor_gallery]

Experience in Python 2 and 3 version. 

Web scraping

  • Using Beautiful Soup

Data to CSV and image extraction using IMacros, Python, C#, .Net, VBA Macros, Java Selenium

Web Scraping

Zillow

  • Zestimate
  • Property details
  • Images

Yellow Pages

  • Property/shop Details
  • Images
  • Email
  • Phone numbers based on the availability

Yelp

  • Property/shop Details
  • Images
  • Email
  • Phone numbers based on the availability
  • Reviews

Houzz

  • Property/shop Details
  • Images
  • Email
  • Phone numbers based on the availability

Historical Data of Stocks

  • Stock symbol Info
  • Yahoo Finance / Google Finance  Info Extraction
  • Historical Data based on the date ranges specified

Extraction of Web Info

  • HTML table content
  • Image link extraction from E-Commerce site
  • Extraction of Product info from E-commerce sites

[tailor_gallery ids=”725,726,727,728,729″ layout=”slideshow” items_per_row=”2″ autoplay=”1″ autoplay_speed=”3000″ arrows=”1″ dots=”1″ thumbnails=”0″ image_link=”none” image_size=”large” class=”tailor-5aa3c9d9b3a96″][/tailor_gallery]

Can Perform various tasks in remote control based on the instructions provided.

  • Data Entry
  • Image Uploading
  • Product Data Entry in customized E-commerce platforms
  • Various other activities based on the instructions provided
  • Remote assistant
  • Long term commitment

freelancer_sarcscoin

Hire Me @

Employer Enquiry Form

If you like SARCS intention, please leave us a ★★★★★ rating. A huge thanks in advance!

Student Enquiry Form

If you like SARCS intention, please leave us a ★★★★★ rating. A huge thanks in advance!

Contact Form

[tailor_form_cf7 form=”68″ class=”tailor-5aa3c9d9b3a09″][/tailor_form_cf7]

This is a demo store for testing purposes — no orders shall be fulfilled. Dismiss