A Highly Skilled and Top Rated Data Entry, Web Scrapping & Excel Expert for the past 4 years at Upwork. I have more than 4 years of experience in Advanced MS Excel.
I have worked for several companies where my major responsibility were:
✔) Building Simple and Complex Financial Models Using Excel for Startup Businesses, Existing Private Companies and Public Listed companies
✔) Designing PowerPoint Presentations to support the models developed
✔) Other day to day tasks like financial statements conversion from PDF to Excel, Consolidating existing financial models
I have also transformed large sets of data into meaningful and insightful information by using excel functions. I have more than 7 years of professional Experience in Advanced MS Excel. I have full command over MS Excel functions and features, can perform the following tasks with ease.
✔) Data Analysis (Sales, Financial, Marketing and HR Data Analysis)
✔) Dashboard Development
✔) Inserting Excel Formulas ( V-Lookup, H-Lookup, Simple Lookup, If Condition, Logical Tests, Sum-if, Count-if, Array, Index, IRR, NPV, PV, FV, Concatenation and many other functions )
✔) Inserting Pivot Tables
✔) Interactive Charts Development ( Bar Chart, Thermometer Chart, Speedometer Chart, Line chart, Pie Chart, Area Chart, Waterfall Chart and many Other as per requirement )
✔) Data Sorting, Splitting and Merging
✔) Duplicate Entries Removal and Highlighting
✔) Advanced data Filtration
✔) Macros Inserting
✔) Validating Data
✔) Locking and protecting cells
✔) Automating the excel sheet
✔) Use of Developer Tools
✔) Conditional Formatting
I am not limited to perform the above mention tasks, can perform many other complex tasks as well, through the combination of different functions in MS Excel.
I pursue problem solving & Analytical Skills, always try to find innovative solutions to problems that can be helpful in future as well, I am a quick learner have urge to learn new things, very good with numbers & numerical analysis, ability to find required data through internet research.
I have previously worked on a number of freelancing platforms and look forward to delivering top-notch quality accounting services here on Upwork.
Please send me a message to discuss your project needs.
Thanks