Excel dashboard for bank transaction
$10-30 CAD
Bezahlt bei Lieferung
I need an Excel dashboard created to track transaction categories for my bank transactions.
Specific Data to Track:
- Transaction categories (groceries, fuel, bills: electricity, internet, phone..) based on keywords matching with a categories list.
- Vendors extract based on key words from the description
- consolidation in one worksheet from multiple worksheets (from multiple bank accounts)
- formatting dates, amounts, merged cells, and setting macros to repeat it each time new data is added
- insert charts and graphs
- use slicers by vendors and timeline
- if formulas are to be used, always use new columns (do not alter the initial columns distribution to avoid errors when adding new data having same orders of columns)
Preferred Layout or Style:
- No preferred layout or style, open to suggestions
Required Features:
- Interactive features such as filters, drop-down menus, and interactive charts
Ideal Skills and Experience:
- Proficiency in Excel and data analysis
- Experience in creating interactive dashboards
- Strong attention to detail and ability to organize data effectively
Projekt-ID: #37168193
Über das Projekt
40 Freelancer bieten im Durchschnitt $67 für diesen Job
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look Mehr
Hi There Nice to know your requirement. I have delivered more than Two Hundred Excel Automation Projects in the past five years. Can discuss and work with you to get this task done. Thank you. Durai
Subject: Proposal for Custom Excel Transaction Category Dashboard Dear Client, I'm excited to offer my expertise in crafting a tailored Excel dashboard to streamline and categorize your bank transactions effectively. Mehr
Hi, I have gone through the Job details and am interested in taking it up. I need you to share more details with me, and I will deliver the required tasks fast and accurately. We will negotiate my fees depending on how Mehr
I understand your need for an Excel dashboard created to track transaction categories for your bank transactions. Specifically, you need an Excel dashboard created to track transaction categories based on keywords matc Mehr
I understand that you are looking for an Excel dashboard created to track transaction categories for your bank transactions. Specifically, you need an Excel dashboard created to track transaction categories based on ke Mehr
I understand you are looking for an Excel dashboard created to track transaction categories for your bank transactions. Specifically, you need an Excel dashboard created to track transaction categories based on keyword Mehr
I understand that you are looking for a VBA and Excel Expert. I am Karan Talwar, I have worked as MIS Executive, my expertise includes , VBA forms and scripts, analyzing data, creating reports and performing sales & m Mehr
Hello, I am interested in your project and i can complete it within required time. I have appropriate experience in Microsoft Office Products(Word, Excel, PowerPoint, Visio, Project as well as VBA etc) of more than 10 Mehr
Hi I'm interested in your project please send me a message so that we can discuss more about your project over chat. Thanks
I read carefully your job description and understood. I have experienced in research, excel , data entry, analytics, data processing copy typing and virtual assistant. Please message me to discuss further details. I am Mehr
Hello, Greetings of the day!! I'm interested in taking up your Expert Data Entry project. I have the required skills and experience same filed. I am committed to completing the project on Time.
I 'm New on freelancer but not for data entry and copy past sir/mam just give me one chance to show my talent Thanks watiing for your responce
Hello, i think your project need time to work rather than deep knowledge about in excel. So, here i am do satisfactory work to your job. I am professionally banker. So, i can suggest you more ways for your project. Ple Mehr
myself kalpesh sawant. i have done my bachlor of mangament study in marketing . I have also done office assistant cource. my typing speed is 28 and also 95% accuracy. i have ready to work .
"I'm confident that I have the skills and experience necessary. I have a lot of enthusiasm. I'm also very motivated to get the job.
Hi Mohammad Anas This Side Had an 3 Years of Experience in Field of Ms Office Like Excel , Ms Word, & Many More . I have an ability to work With You as Per Your Requirements
