Logo ya Freelancer
Ingia Jisajili
Chapisha Mradi
TALII
Data Processing
Excel
Excel Macros
Finance
Visual Basic
Picha ya jalada la wasifu
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.
Picha ya Mtumiaji

Viktoriia Z.

@hopkovictoria

5.0
5
5.1
5.1
100%

Automated Excel Tools for Business Analysis

$15 USD / Saa
・
Bedera ya
Ukraine (2:56 AM)
・
Alijiunga mnamo Agosti 1, 2018
$15 USD / Saa
・
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!
Uthibitishaji
Kwa wakati
100%
Kwa bajeti
100%
Kubali kiwango
100%
Freelancer Excel Experts Ukraine
Angalia woteExcel 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
Mabadiliko yamehifathiwa
5.0 · 5 Reviews
Ukaguzi
Picha ya Mtumiaji
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
•
Bedera ya
brandon, United States
•
5 years ago
Shiriki
Picha ya Mtumiaji
Excel SUMIFS and VLookup for multiple columns and two sheets • $30 USD
Excellent Excel Skills
Jason S.
@jasonsetzer81
•
Bedera ya
brandon, United States
•
6 years ago
Shiriki
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
•
Bedera ya
Warsaw, Poland
•
6 years ago
Shiriki
Picha ya Mtumiaji
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
•
Bedera ya
Richmond, Australia
•
6 years ago
Shiriki
U
Formula for MS Excel needed to round up or down timings into a banding • $25 USD
very good and quick
Harry S.
@uksikh
•
Bedera ya
Huddersfield, United Kingdom
•
6 years ago
Shiriki
Uzoefu
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
Okt, 2017 - Mei, 2018
•
7 months
PJSC "MEGABANK"
Okt, 2017 - Mei, 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.
Okt, 2017 - Mei, 2018
•
7 months
Elimu
Kharkiv State Economics University
2011 - 2017
•
6 years
Master's Degree
Bedera ya
Ukraine
2011 - 2017
•
6 years
Vyeti
MicroStrategy Analyst
2020
MicroStrategy
https://www.credential.net/6970fca2-a5ff-4d11-82df-446503e4c5ac#gs.uaazmj (my last name has changed)
2020
Vyeti
US English - Level 1
US English
Mwaliko umetumwa kwa mafanikio
Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Logo ya Freelancer Kenya / Kiswahili
Huduma na Usaidizi
 Mfanyakazi Huru
Kategoria Miradi Mashindano Wafanyakazi Huru Enterprise Maendeleo ya AI Uanachama Mpango wa Mfanyakazi Huru Anayependelewa Usimamizi wa Mradi Kazi Mtaani Photo Anywhere Maonyesho API ya Wasanidi Programu Thibitishwa Programu ya Kompyuta
Kuhusu
Kutuhusu Inavyofanya Kazi Usalama Mwekezaji Ramani ya tovuti Hadithi Habari Timu Tuzo Matoleo kwa Vyombo vya Habari Kazi
Sheria
Sera ya Faragha Sheria na Masharti Sera ya Hakimiliki Kanuni ya Maadili Malipo na Ada
Washirika
Escrow.comLoadshiftWarrior Forum
 Vitufe
Nembo ya Programu ya Duka la AppleLogo ya Google Play
Imeshindwa kunakili kwenye ubao wa kunakili, tafadhali jaribu tena baada ya kurekebisha ruhusa zako.
Imenakiliwa kwenye ubao wa kunakili.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2025 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.