Freelancer logo
Log In Sign Up
Post a Project
EXPLORE
Data Processing
Excel
Excel Macros
Finance
Visual Basic
Profile cover photo
You're now following
Error following user.
This user does not allow users to follow them.
You are already following this user.
Your membership plan only allows 0 follows. Upgrade here.
Successfully unfollowed
Error unfollowing user.
You have successfully recommended
Error recommending user.
Something went wrong. Please refresh the page and try again.
Email successfully verified.
User Avatar

Viktoriia Z.

@hopkovictoria

5.0
5
5.1
5.1
100%

Automated Excel Tools for Business Analysis

$15 USD / Hour
・
Flag of
Ukraine (3:24 PM)
・
Joined on August 1, 2018
$15 USD / Hour
・
Hi! I am a BI developer with economic background from Ukraine. I am especially interested in business analysis and automation of business processes in Excel. In order to find the solution, I use complex functions with comprehensive logic, array formulas, charting and sparklines, conditional formatting, pivot tables and slicers, data protection, basic knowledge of macros (VBA). You can find my previous works on my YouTube channel: [login to view URL] Also, I worked with big data using the program MicroStrategy connected to MS SQL Server. In the future, I am going to learn other business intelligence tools such as Power BI, Tableau etc. in order to be able to deliver clear analytics for your business needs. Have a nice day and lots of smiles!
Verifications
On time
100%
On budget
100%
Accept rate
100%
Freelancer Excel Experts Ukraine
See all Excel Experts in Ukraine

Portfolio

Portfolio

4707272
Credit Calculator
Credit Calculator
4510546
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
4373937
The task was done using conditional formatting. You can add new products and dates by copy-paste of the previous ones. See how it works: https://youtu.be/gThJEKpIOYQ
Product Lifecycle Matrix
4391486
I chose the chain substitution method for this task, because it is the most universal and is used to calculate impact of the factors in all types of determinate factor models. You just need to fill in green cells with the formula and the data and click red button.
Automated Factor Analysis in Excel
I chose the chain substitution method for this task, because it is the most universal and is used to calculate impact of the factors in all types of determinate factor models. You just need to fill in green cells with the formula and the data and click red button.
Automated Factor Analysis in Excel
4333452
The user fills the data in the table. New dates are added to the drop-down list automatically, the data source for the charts is also updated automatically.
Charts with floating dates
4707272
Credit Calculator
Credit Calculator
4510546
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
The practical tool for simplifying the everyday work of an analyst. It consists of automated tables, pivot tables and charts. Analysis of sales, returns and net sales by product family, color, height and width of products. Analysis of returns by reasons. Analysis of Ratio of Returns and Ratio of Returns corrected for the share in sales (RoR corrected). Product ranking by share in sales, returns, net sales, or by ratios — select from the drop-down list. The allocation of goods into groups depending on the level of ratios. Analysis of the dynamics, averages, plan implementation. Everything updates automatically with a minimum of effort. See how it works: https://youtu.be/KgMyxclqUB4
Automated Dashboard for the Analysis of Sales and Returns
4373937
The task was done using conditional formatting. You can add new products and dates by copy-paste of the previous ones. See how it works: https://youtu.be/gThJEKpIOYQ
Product Lifecycle Matrix
4391486
I chose the chain substitution method for this task, because it is the most universal and is used to calculate impact of the factors in all types of determinate factor models. You just need to fill in green cells with the formula and the data and click red button.
Automated Factor Analysis in Excel
I chose the chain substitution method for this task, because it is the most universal and is used to calculate impact of the factors in all types of determinate factor models. You just need to fill in green cells with the formula and the data and click red button.
Automated Factor Analysis in Excel
4333452
The user fills the data in the table. New dates are added to the drop-down list automatically, the data source for the charts is also updated automatically.
Charts with floating dates
Changes saved
5.0 · 5 Reviews
Reviews
User Avatar
Project for Victoria H. • $3,253.82 USD
Victoria worked on multiple financial and operational report projects ~400 hours - for me for well over a year and did an outstanding job. She was very meticulous and was always available when needed. If you have any Excel work she should be your go to freelancers
Jason S.
@jasonsetzer81
•
Flag of
brandon, United States
•
5 years ago
Share
User Avatar
Excel SUMIFS and VLookup for multiple columns and two sheets • $30 USD
Excellent Excel Skills
Jason S.
@jasonsetzer81
•
Flag of
brandon, United States
•
6 years ago
Share
L
Creative business name for recruitment company with free .com domain • $25 USD
Victoria invented a great name for our company. Not a straightforward connection of words but something more sophisticated!
Lukasz L.
@LukeWarsaw
•
Flag of
Warsaw, Poland
•
6 years ago
Share
User Avatar
Excell Spread Sheet to Calculate Life Insurance requirements • $100 AUD
Brilliant work from Victoria. She was presented a difficult task which included complex mathematical formulas and resolved this promptly. Her quality of work is very professional, i look forward to getting her help again. Thank you Victoria!!
Nick L.
@nick727
•
Flag of
Richmond, Australia
•
6 years ago
Share
U
Formula for MS Excel needed to round up or down timings into a banding • $25 USD
very good and quick
Harry S.
@uksikh
•
Flag of
Huddersfield, United Kingdom
•
6 years ago
Share
Experience
Business Intelligence Developer
Jun, 2019 - Nov, 2021
•
2 years, 5 months
VisiQuate Inc.
Jun, 2019 - Nov, 2021
•
2 years, 5 months
Worked with the program MicroStrategy on different big data projects in the American medical business area. Data was stored in MS SQL Server databases. Duties: • environment configuration, building of attributes, metrics, reports, cubes, dashboards, visual insights, subscriptions from scratch; • supervision of the daily ETL process; • optimization of cubes, reports and dashboards performance; • creation of new users and provision of appropriate accesses.
Jun, 2019 - Nov, 2021
•
2 years, 5 months
Economist of the Risk Management Department
Oct, 2017 - May, 2018
•
7 months
PJSC "MEGABANK"
Oct, 2017 - May, 2018
•
7 months
Duties: - identification, monitoring, analysis of the bank's risks; - control of the existing risks level and accordance of the bank's performance with economic standards; - monitoring of employees' knowledge of operational risk (data collection and analysis); - monthly reporting on risks for the top management and the National Bank of Ukraine in tabular and graphical form; - providing recommendations for minimizing risks.
Oct, 2017 - May, 2018
•
7 months
Education
Kharkiv State Economics University
2011 - 2017
•
6 years
Master's Degree
Flag of
Ukraine
2011 - 2017
•
6 years
Qualifications
MicroStrategy Analyst
2020
MicroStrategy
https://www.credential.net/6970fca2-a5ff-4d11-82df-446503e4c5ac#gs.uaazmj (my last name has changed)
2020
Certifications
US English - Level 1
US English
Invite sent successfully!
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Freelancer logo New Zealand / English
Help & Support

Freelancer

Categories Projects Contests Freelancers Enterprise Innovation Challenges AI Development Membership Preferred Freelancer Program Project Management Local Jobs Photo Anywhere Showcase API for Developers Get Verified Desktop App

About

About us How it Works Security Investor Sitemap Stories News Team Awards Press Releases Careers

Terms

Privacy Policy Terms and Conditions Copyright Policy Code of Conduct Fees and Charges

Partners

Escrow.com Loadshift Warrior Forum

Apps

Apple App Store logoGoogle Play logo
Copy to clipboard failed, please try again after adjusting your permissions.
Copied to clipboard.

Registered Users

Total Jobs Posted

Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)

Copyright © 2025 Freelancer Technology Pty Limited (ACN 142 189 759)

Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.