Hello,
My name is Pamela and I am a data analyst with over 3 years of real-world experience. I have a first-class degree in computer science and I am an expert Excel user. I am conversant with data clean up in Excel i.e. removing duplicates, trimming, data validation etc. I can also work with formulas in several categories including arithmetic: - + / * SUM, COUNT etc., Conditional formulas including IF, AND, OR, SUMIFS, COUNTIFS etc. and other formulas such as VLOOKUP, CONCATENATE, IFERROR and many more.
I am very conversant with Excel Macros as well and I can do automation of processes using VB code in macros, including loops, conditional statements, filling data in forms and more.
I also specialize in data visualization and can make stunning graphs to better present your data both in Excel and Microsoft Power BI.
I am a new Freelancer and don't have many reviews but I have real-world experience and have implemented projects for many companies.
Please get in touch if you are interested in working with me and we can discuss the details of your project. The estimated time to completion is open to discussion based on your requirements.
Best
Pamela