EXPLORE
Data Entry Excel
You're now following .
Error following user.
This user does not allow users to follow them.
You are already following this user.
Successfully unfollowed user.
Error unfollowing user.
You have successfully recommended
Error recommending user.
Email successfully verified.
\$2 USD / hour
udaipur, india
\$2 USD / hour
It's currently 5:35 AM here
Joined September 16, 2021
0 Recommendations

0.0 (0 reviews)
0.0
0.0
\$2 USD / hour
udaipur, india
\$2 USD / hour
N/A
Jobs Completed
N/A
On Budget
N/A
On Time
N/A
Repeat Hire Rate

## Data Scientist

I am working on excel from last 6 years with different formulas , on different files , sheets . Capturing and recording important data Some workplace tasks may involve recording information in an Excel spreadsheet. This can include: Taking existing data from a separate document and inputting it into Excel Creating a financial strategy or budgeting plan from scratch and typing it into Excel Transferring a schedule from an outside source and rebuilding it in Excel Many employers will require employees to perform similar tasks regularly. This is why it’s helpful to possess advanced typing skills to complete these items quickly. Using shortcuts and formula functions To calculate and record data sets efficiently, Excel has various functions and shortcuts. It can calculate data quickly and easily, making daily tasks more productive. Here are a few formula functions available in Excel: SUMIF This function adds the data in a selected range of cells and shows its final solution based on pre-defined criteria. For example, you could input numbers into two cells and program the third to produce the results of cells one and two added together. You can use text, dates and general numbers when performing this function. COUNTIF This function automatically counts the cells it’s programed to count. For example, if you’re sorting through a lengthy document with employee vacation days listed by month, you can use a COUNTIF feature to list the total July vacation days employees used. This function counts dates, general numbers and text. VLookup If you’re gathering data scattered throughout another Excel spreadsheet, this function can help you locate it and quickly transfer it to your current spreadsheet. Building charts and graphs Employers may expect you to present the information you’ve input into Excel. You can create charts and graphs to showcase this data. This can make it easier for team members to read and understand the data you have gathered. Proven knowledge of Excel’s charts and graphs can show a potential employer you have experience presenting and showcasing analytical findings. Sorting and filtering data Some jobs involve sorting through pre-existing data and determining what to keep on your current spreadsheet and which data is no longer relevant. You can use Excel to sort through data to find the information you want to report on. Once filtered, Excel can organize this data in a logical and meaningful sequence. Knowing how to utilize these features in Excel can make long spreadsheets easier to understand and analyze. It’s also helpful to know how to store data in ascending or descending order to find information quicker. Utilizing pivot tables When you need to summarize large quantities of data, you can use a pivot table to group and reorder these findings in a way that makes it easier to organize. You can categorize different number sets and list them accordingly to make it easier to sort through and find the information you’re searching for

## Reviews

Changes saved
No reviews to see here!

## Verifications

Preferred Freelancer
Identity Verified
Payment Verified
Phone Verified
Email Verified

Data Entry Excel

## Browse Similar Freelancers

Data Entry Clerks in India
Data Entry Clerks
Excel Experts

## Browse Similar Showcases

Data Entry
Excel
Previous User
Next User
Invite sent successfully!
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)