Rana Nouman B. Profile

TALII

5.0

(1 hakiki)

Sasa unafuata

Hitilafu katika kufuata mtumiaji.

Mtumiaji huyu haruhusu watumiaji kumfuata.

Tayari unamfuata mtumiaji huyu.

Mpango wako wa uanachama unaruhusu tu ufautiliaji 0. Boresha hapa.

Umefaulu kuacha kufuata

Hitilafu wakati wa kuacha kumfuata mtumiaji.

Umefaulu kupendekeza

Hitilafu katika kumpendekeza mtumiaji

Hitilafu fulani imetokea. Tafadhali onyesha upya ukurasa na ujaribu tena.

Barua pepe imethibitishwa kwa ufanisi.

$5 USD / saa

sargodha,

pakistan

$5 USD / saa

Ni saa 8:13 PM hapa

Alijiunga Februari 8, 2021

1 Pendekezo

Rana Nouman B.

@Nomisgd

5.0

(1 hakiki)

1.4

100%

$5 USD / saa

sargodha,

pakistan

$5 USD / saa

100%

Kazi Zilizokamilika

N/A

Kwa Bajeti

N/A

Kwa wakati

25%

Kiwango cha Kuajiriwa Tena

Excel Expert| Specialist to Clean & Automate Data

I work with the toughest, messiest datasets and help make them presentable. The data is my domain. From data entry to analysis and cleaning, I can turn your data into gold. Whether you're a small business owner, a data analyst, or anyone in need of data cleaning and formatting assistance, I'm here to provide reliable, efficient, and high-quality services using Microsoft Excel. Let's transform your data into a valuable asset for your business or project. I'm a skilled and experienced professional specializing in data cleaning and formatting using Microsoft Excel. With a deep understanding of Excel's powerful features and functions, I have the expertise in transforming messy, unstructured data into clean, organized, and actionable information. Since the last 8 years, I have worked on various spreadsheet tools (Excel and Google Sheets). I have formatted, organized, Automated & cleaned data into a useful shape. Also, I've turned data into proper form so that it could be used for analysis and for decision-making. Expertise in Data Cleaning: I have a proven track record of successfully tackling complex data cleaning challenges. Whether you're dealing with inconsistent formatting, duplicate entries, missing values, or any other data quality issues, I can identify and rectify these problems efficiently. Accuracy and Customer satisfaction is my first priority., If you are looking for a professional who can deliver with authenticity and in time, you are at the right place. Top Skills: *Microsoft Excel: Advance formulas, formatting, Cleaning, Automation, Data Analysis, and Data Entry. *Google Sheets: Advance formulas, Custom Scripts, Dashboard My Services: -> Data Cleaning & Formatting -> Automation with Formula and Power Query -> Data Processing -> Data Typing -> Dashboard Designing Using Excel BI & Power BI -> Data Formatting -> Data Modelling -> Data Visualization -> Data Processing -> Data Extraction -> Accounting and Financial Tasks -> Copy-Paste, Formatting -> Any other Virtual Assistant, or Admin Support you may require. Why you should choose me: -> Timely Delivery and 100% Accuracy assured -> Work with full dedication & responsibility -> 100% Confidentiality maintained -> Unlimited revisions -> Able to perform work faster -> Attention to detail -> Proficiency in MS Excel -> Ability to work efficiently and meet tight deadlines Leave a message to hire me anytime : Thanks

Angalia woteData Entry Clerks in Pakistan

Wasiliana na Rana Nouman B. kuhusu kazi yako

Ingia ili kujadili maelezo yoyote kwenye gumzo.

Portfolio

Converted JSON format file to editable Excel format and organized the data.

json to Excel Conversion and format the data

Excel Spreadsheet Format Correction

** It is very important that you contact me and describe in detail what exactly you want done BEFORE ordering so I can tell you if I can take it on or not and if the price is appropriate. If you have an existing Excel file or Google Sheet, please share it with me so I can take a direct look. **

I love Excel Spreadsheets

I spend about 8-14 hours per day working on excel spreadsheets, improving current models for my clients, as well as creating new ones for various purposes.

I continue helping small-, mid- and large-sized businesses create Excel spreadsheets for various purposes, such as Sales reports, Inventory reports, Expense reports with budget analysis, Attendance reports, production reports, Financial Statements, and other operating activities.

What can I do in MS Excel Spreadsheet?

✅ Customized Automated Excel Spreadsheet with Formulas, Tables.

✅ Customized Automated Dashboard

✅ Creation / Correction of Simple / Complex Form

Data Cleaning & Formatting

I provide high-quality services for data automation tasks.

I have done Advance courses in MS- Excel BI and can get your job done professionally.

I have also more than 7 years of experience in preparing Excel Reports, Automating work on Excel (using various Techniques), Preparing Dashboards, handling/preparing Reports and I know how to handle any project.

I am offering the following services:

✅ Data Automation using Formulas

✅ Data Automation using Microsoft Excel Power Query

✅ Data Automation using Macros

✅ Data Modelling

✅ Data Visualization

✅ Data Processing

✅ Data Extraction

✅ Projects for FINANCE, AND SALES

✅ Uses of complex LOOKUP Formulas

✅ COMPARE 2 EXCEL files

✅ SPLIT TEXT to Rows

✅ Tricks of COUNTIFS to do VLOOKUP for duplicate values

✅ CONSOLIDATION from multiple sheets

✅ Doing FUZZY LOOKUP what VLOOKUP can't

✅ PROTECT A SHEET OR WORKBOOK

Please message me before placing an order to avoid any confusion and feel free to contact me.

Power Query: Clean Format & Automate Data

PDF to Excel

I love work on Excel spreadsheets.

I can create edit and fix any formula in Excel from Basic to Advance Level

EXCEL SPREADSHEETS | FORMULAS | FUNCTIONS | FIXING ERRORS

I can help you in any kind of tasks as follows:

✅ VLOOKUP/HLOOKUP

✅ INDEX-MATCH

✅ IF/SUMIF/SUMIFS/IFERROR/SUMPRODUCT COUNTIF/COUNTIFS

✅ DROP DOWN & DATA VALIDATION

✅ CONDITIONAL FORMATTING

✅ REMOVING DUPLICATES

✅ Formula Automation/Linking

✅ Fixing up #DIV/0, #N/A, #NAME?, #NULL!, #NUM!, #REF!, AND #VALUE!

✅ Splitting the text/data/Formula into different cells

✅ Formula related any issues as per your requirements.

I Will Create Excel Spreadsheet with Formula or Macro and Fix Error to Improve Your Current Spreadsheets Based on Your Requirements. Please Contact Me and I'll Help You Out.

I spend about 8-14 hours per day working on excel spreadsheets, improving current models for my clients, as well as creating new ones for various purposes.

Note: Feel free to details discussion before

Create & fix any excel formula or function

EXCEL SPREADSHEETS | FORMULAS | FUNCTIONS | FIXING ERRORS

I love work on Excel spreadsheets.

I can help you in any kind of tasks as follows:

✅ VLOOKUP/HLOOKUP

✅ INDEX-MATCH

✅ IF/SUMIF/SUMIFS/IFERROR/SUMPRODUCT COUNTIF/COUNTIFS

✅ DROP DOWN & DATA VALIDATION

✅ CONDITIONAL FORMATTING

✅ REMOVING DUPLICATES

✅ Formula Automation/Linking

✅ Fixing up #DIV/0, #N/A, #NAME?, #NULL!, #NUM!, #REF!, AND #VALUE!

✅ Splitting the text/data/Formula into different cells

✅ Formula related any issues as per your requirements.

I Will Create Excel Spreadsheet with Formula or Macro and Fix Error to Improve Your Current Spreadsheets Based on Your Requirements. Please Contact Me and I'll Help You Out.

I spend about 8-14 hours per day working on excel spreadsheets, improving current models for my clients, as well as creating new ones for various purposes.

Note: Feel free to details discussion before placing order so that I can provide you professional work.

Ms Excel Services

json to Excel Conversion and format the data

Data Cleaning & Formatting

Power Query: Clean Format & Automate Data

PDF to Excel

Create & fix any excel formula or function

Ms Excel Services

Kaguzi

Mabadiliko yamehifadhiwa

Inaonyesha 1 - 1 kutoka kwa 1 - hakiki

Chuja hakiki kulingana na:

5.0

$50.00 USD

Excel Spreadsheet Format Correction

Rana was very professional to work with. We will be hiring him again in the future when projects come up. Very happy with the project he just completed for me.

Data Entry

Delena C.

@Assistant143081

•

2 years ago

Uzoefu

The Punjab Provnicial Cooperative Bank Limited

Apr 2013 - Sasa

Tools used to perform Data Task: *---* Microsoft Excel Bi, *---* Ms Excel VBA Macros, *---* Ms Excel Power Query, *---* Microsoft Power BI. Job Descriptions: -> Maintaining Daily/Weekly/Monthly//Quarterly/Yearly Reports. -> Compiling Raw Data into useful information. -> Creating Dashboard Reports for Analysis and Decision making. -> Automating Routine Manual Tasks. -> Cleaning, Organizing and Formatting Data for Analysis.

Elimu

MBA (Finance)

University of the Punjab, Lahore,

Pakistan

2010 - 2012

(2 years)

Sifa

Innovinc

2020

Module 1: Business Excel with Real World Examples And Painful Areas • Tips and Tricks to EXCELerate the work • Advanced Formulas & Functions Module 2: Analyzing and Designing Reports • Conditional Formatting • Pivot Table with Slicer • Using Sparklines • Dynamic Dashboards with Form Controls Module 3: Automating Tasks and Designing Dashboards using Excel Bi • Power Query (clean, transform, merge and append) • PowerPivot (DAX language) • Understanding PowerPivot • Importing Data into PowerPivot

TEVTE Punjab

2013

This course provided me the basic skill to manage the data using various software of Microsoft i.e Microsoft Word, Microsoft Excel, Microsoft Power Point.