Freelancer logo
How It Works
Browse Jobs
Log In
Sign Up
Post a Project
EXPLORE
Accounting
Database Programming
Excel
Finance
Financial Analysis
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 user.
Error unfollowing user.
You have successfully recommended
Error recommending user.
Email successfully verified.
User Avatar
Our Rate
$50 USD / hour
Flag of CYFlag of CY
limassol,
cyprus
Our Rate
$50 USD / hour
It's currently 10:31 AM here
Joined November 24, 2013
5 Recommendations

Dov Goldenberg

@dgled

annual-level-four.svgpreferred-freelancer-v2.svgverified.svg
4.9 (121 reviews)
4.9 (121 reviews)
7.6
7.6
$50 USD / hour
Flag of CYFlag of CY
limassol,
cyprus
$50 USD / hour
98%
Jobs Completed
94%
On Budget
95%
On Time
14%
Repeat Hire Rate

Business & Financial Modules in Excel and Power BI

featured review
"Dov is simply exceptional!! Furthermore he is very accessible and a delightful person to work with. He consistently delivers!! More specifically, he prepared detailed 10-year financial projections (cash flow, balance sheet and income statement), on a monthly and annual basis. Useful sensitivity analysis was also prepared. I have worked w/ Dov on a variety of projects--aquaculture farms (very complicated model); geothermal electric plant and telecom operation. He was "on point" for each of these projects!!!."
- Camille C.
I am a financial expert, a guru in Excel, VBA, and Power BI. I have extensive knowledge and expertise in extract, transform, load (ETL), advanced formulas, pivot tablesincluding preparation of graphical and visualisation reports, dynamic dashboards, and charts (by VBscript). Furthermore, I have experience in accounting, financial reports, consolidating, forecasting, budgeting, costing, cash flow, multi-currency, including collections, payments, inventory, bill of materials, taxation and bank reconciliation. With these skills, I prepare dynamic & designed reports and dashboards, for pitch decks, business plans, due diligence, financial modules, feasibility studies, and financial projections with scenarios and charts. What do I love to do? - Modules in Excel: financial projections, inventory, financial reports, Extract & Cleaning - Accounting, Consolidation & reconciliation - Databases in Excel by algorithms, VBA/Macro and Pivot Tables - Database manipulation and population reporting
Freelancer
Excel Experts
Cyprus

Contact Dov Goldenberg about your job

Log in to discuss any details over chat.

Portfolio Items

The scope of this project is to visualization KPI (Key Performance Indicator  ) rating in Power BI. The source of the data is a survey conducted on Microsoft Forms. the databased from the survey loaded into the Power BI, extruded transformed by DAX Codes to fit the data to the visual forms. each dashboard shows the rating of the KPI by Cylindrical Gauges, Matrix and Charts. The main dashboard demonstrates the overall satisfaction by country and city on a visual map.
The next proceed is to upload the file to Power BI Cloud which enable the users in the organization.
I am a financial expert and guru in Excel and Power BI with extensive knowledge and expertise in extract, transform, load (ETL), advanced formulas, pivot tables, tables, solver and visual basics including preparation of available interfaces, dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts (by VBscript). Also, I deal with exporting and importing databases and create automation
KPI rating by Power BI Visualization
The scope of this project is to visualization KPI (Key Performance Indicator  ) rating in Power BI. The source of the data is a survey conducted on Microsoft Forms. the databased from the survey loaded into the Power BI, extruded transformed by DAX Codes to fit the data to the visual forms. each dashboard shows the rating of the KPI by Cylindrical Gauges, Matrix and Charts. The main dashboard demonstrates the overall satisfaction by country and city on a visual map.
The next proceed is to upload the file to Power BI Cloud which enable the users in the organization.
I am a financial expert and guru in Excel and Power BI with extensive knowledge and expertise in extract, transform, load (ETL), advanced formulas, pivot tables, tables, solver and visual basics including preparation of available interfaces, dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts (by VBscript). Also, I deal with exporting and importing databases and create automation
KPI rating by Power BI Visualization
The scope of this project is to visualization KPI (Key Performance Indicator  ) rating in Power BI. The source of the data is a survey conducted on Microsoft Forms. the databased from the survey loaded into the Power BI, extruded transformed by DAX Codes to fit the data to the visual forms. each dashboard shows the rating of the KPI by Cylindrical Gauges, Matrix and Charts. The main dashboard demonstrates the overall satisfaction by country and city on a visual map.
The next proceed is to upload the file to Power BI Cloud which enable the users in the organization.
I am a financial expert and guru in Excel and Power BI with extensive knowledge and expertise in extract, transform, load (ETL), advanced formulas, pivot tables, tables, solver and visual basics including preparation of available interfaces, dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts (by VBscript). Also, I deal with exporting and importing databases and create automation
KPI rating by Power BI Visualization
The scope of this project is to visualization KPI (Key Performance Indicator  ) rating in Power BI. The source of the data is a survey conducted on Microsoft Forms. the databased from the survey loaded into the Power BI, extruded transformed by DAX Codes to fit the data to the visual forms. each dashboard shows the rating of the KPI by Cylindrical Gauges, Matrix and Charts. The main dashboard demonstrates the overall satisfaction by country and city on a visual map.
The next proceed is to upload the file to Power BI Cloud which enable the users in the organization.
I am a financial expert and guru in Excel and Power BI with extensive knowledge and expertise in extract, transform, load (ETL), advanced formulas, pivot tables, tables, solver and visual basics including preparation of available interfaces, dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts (by VBscript). Also, I deal with exporting and importing databases and create automation
KPI rating by Power BI Visualization
The module allows you to manage Organizational Structure Chart automatically. Just type the employee's title and positions hierarchically and by one click to get a ready chart.
Organizational Structure Chart
FinancialXLA formulated financial projections which covered the aspects of valuation, revenue, and production for 15 years. 
FinancialXLA constructed comprehensive Excel sheets depicting the breakdown of the financial forecasts from the production floor (quantities, costs, COGS and Inventory in progress ) to the distributing stage. The modules took into account the growth cycles of the fishes and the maximum production capacity.
The module generates consolidated financial statements which reflect the organization structure (HoldCo and its subsidiaries [SPVs]) including capital expenditure, long term debts repayments, CAPEX based on the constructing plan, depreciation, amortization, valuation, terminal value and the offering to the investors.
The module has consisted of flexible parameters of assumptions and drivers that could be easily changed by the client to calculate an entirely new set of data and produce the financial reports, ratios and forecasts accurately.
www.aquaharve.com
BP, Financial plan & Pitch Deck for Multi Agriculture Farms
FinancialXLA formulated financial projections which covered the aspects of valuation, revenue, and production for 15 years. 
FinancialXLA constructed comprehensive Excel sheets depicting the breakdown of the financial forecasts from the production floor (quantities, costs, COGS and Inventory in progress ) to the distributing stage. The modules took into account the growth cycles of the fishes and the maximum production capacity.
The module generates consolidated financial statements which reflect the organization structure (HoldCo and its subsidiaries [SPVs]) including capital expenditure, long term debts repayments, CAPEX based on the constructing plan, depreciation, amortization, valuation, terminal value and the offering to the investors.
The module has consisted of flexible parameters of assumptions and drivers that could be easily changed by the client to calculate an entirely new set of data and produce the financial reports, ratios and forecasts accurately.
www.aquaharve.com
BP, Financial plan & Pitch Deck for Multi Agriculture Farms
FinancialXLA formulated financial projections which covered the aspects of valuation, revenue, and production for 15 years. 
FinancialXLA constructed comprehensive Excel sheets depicting the breakdown of the financial forecasts from the production floor (quantities, costs, COGS and Inventory in progress ) to the distributing stage. The modules took into account the growth cycles of the fishes and the maximum production capacity.
The module generates consolidated financial statements which reflect the organization structure (HoldCo and its subsidiaries [SPVs]) including capital expenditure, long term debts repayments, CAPEX based on the constructing plan, depreciation, amortization, valuation, terminal value and the offering to the investors.
The module has consisted of flexible parameters of assumptions and drivers that could be easily changed by the client to calculate an entirely new set of data and produce the financial reports, ratios and forecasts accurately.
www.aquaharve.com
BP, Financial plan & Pitch Deck for Multi Agriculture Farms
FinancialXLA formulated financial projections which covered the aspects of valuation, revenue, and production for 15 years. 
FinancialXLA constructed comprehensive Excel sheets depicting the breakdown of the financial forecasts from the production floor (quantities, costs, COGS and Inventory in progress ) to the distributing stage. The modules took into account the growth cycles of the fishes and the maximum production capacity.
The module generates consolidated financial statements which reflect the organization structure (HoldCo and its subsidiaries [SPVs]) including capital expenditure, long term debts repayments, CAPEX based on the constructing plan, depreciation, amortization, valuation, terminal value and the offering to the investors.
The module has consisted of flexible parameters of assumptions and drivers that could be easily changed by the client to calculate an entirely new set of data and produce the financial reports, ratios and forecasts accurately.
www.aquaharve.com
BP, Financial plan & Pitch Deck for Multi Agriculture Farms
FinancialXLA formulated financial projections which covered the aspects of valuation, revenue, and production for 15 years. 
FinancialXLA constructed comprehensive Excel sheets depicting the breakdown of the financial forecasts from the production floor (quantities, costs, COGS and Inventory in progress ) to the distributing stage. The modules took into account the growth cycles of the fishes and the maximum production capacity.
The module generates consolidated financial statements which reflect the organization structure (HoldCo and its subsidiaries [SPVs]) including capital expenditure, long term debts repayments, CAPEX based on the constructing plan, depreciation, amortization, valuation, terminal value and the offering to the investors.
The module has consisted of flexible parameters of assumptions and drivers that could be easily changed by the client to calculate an entirely new set of data and produce the financial reports, ratios and forecasts accurately.
www.aquaharve.com
BP, Financial plan & Pitch Deck for Multi Agriculture Farms
This project was done for the Institute for a presentation which shows the relationship between different satisfaction factors by using graphs in Excel.
About me:
I am a financial expert and guru in Excel/VBA/Macro. I  have extensive knowledge and expertise in advanced formulas, Pivot Tables, spreadsheet manipulation, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts (script for charts). 
I come up with creative and sophisticated financial & statistical modules in a simplified and logical manner including business valuation & terminal valuation methodology & ratios.
With these skills, I develop financial modules including depreciation schedule, long-term debt, business valuation methodology & ratios. The modules incorporate complex components of business in a simplified and logical manner.
Statistic Dynamic Module With Complicated Graphs
The module calculates realized & unrealized Investment gain by IRR NPV TWR and ROI.
1. Excel reads symbol info (date, price, high low) from CSV file
2. Excel manipulates the information into a structured database.
3. Excel populates the algorithms and the formulas into the report.
Tools: VBA, Pivot Table and Formulas.

I develop monitoring apps by algorithms formulas and API script for traders and stockbrokers in Microsoft Excel. The modules manage their trading process and analyse the symbols (including Forex instrument & Relative wealth) based on trading ratios (ranges, returns, TWR, VAR) and personal algorithms. The modules read (by API's) selected historical tickers information (Price, Open, High, Low, etc.) from trading platforms (like investing.com), update the historical database and show the statistic result automatically.  Also, there is an ability to read a Real-Time (stream) Ticker List from specific websites like eSignal.
Valuation by IRR NPV TWR and ROI
The university has commissioned this project as an educational tool for students to show the relationship between different marketing factors using graphs in Excel.

Need a similar project done? I have extensive knowledge in advanced formulas, Pivot Tables, Visual Basic for Application (automation), including preparation of dynamic dashboards, screen layouts (UserForms), drop-down boxes, report generators and charts (script for charts). 

Please don't hesitate to contact me via 'hire me' button to discuss your needs.
Graphs in Excel as Educational Tool

Reviews

Changes saved
Showing 1 - 5 out of 50+ reviews
Filter reviews by:
5.0
$12,118.99 USD
great work and excellent professional
Accounting
Excel
Insurance
Finance
+1 more
User Avatar
Flag of KW Abdulrahman A. @darscrubs
4 months ago
5.0
$770.40 USD
Very knowledgable, skilled, easy to communicate with. [18 January, 2021] This is a very late review. Job was done very well. Would hire again.
C
Flag of US Chari G. @cgrahamcpa
7 months ago
4.8
$60.00 USD
Definitely well skilled in financial modeling.
Accounting
Financial Research
Finance
Financial Analysis
D
Flag of US David E. @DENTLERCFO
7 months ago
5.0
$75.00 USD
Dov is patient and has excellent work altitude.
Data Processing
Excel
Power BI
User Avatar
Flag of CA Kaiyu D. @dengkaiy
1 year ago
5.0
$323.30 USD
Dov definitely had the expertise in the areas I was looking for and has helped me deliver exactly what I was after.
Excel
Microsoft Office
Power BI
M
Flag of AU Michael S. @msavage71
1 year ago

Experience

Entrepreneur and Financial Consultant

FinancialXLA Ltd
Sep 2013 - Present
* CFO, Chief Accountant, a specialist in managing cash flow and liquidity solutions for the multi-currency environment and globally including collections, payments, inventory, and taxation. * Extensive experience in corporate information concisely effective management reporting, budget control, and costing reports Financial Statements. * Expert in Microsoft Excel and VBA programming. * Developing of consolidated financial statements, financial plans. * Budget Development & Management

Chief Financial officer

Far East Land Bridge Ltd.
Jan 2007 - Aug 2013 (6 years, 7 months)
• Managing of daily LT/ST financial planning • Managing of all aspects of daily finance, accounting, and treasury operations • Individual treatment of the significant customers and suppliers • Preparation of the business plan, cash flow and the budget • Assist management in analysing cash requirements and related financing needs according to the strategic and operational targets • Review / analyse business flow and related

Chief accountant, Financial Reporting Manager

Venture Capital Firm
Jan 1996 - Dec 2005 (9 years, 11 months)
• Managed the reporting requirements, processes, and procedures for the valuation of the portfolio and the capital • Provided input into business rationalization plans in order to reduce cash burn of the portfolio • Designed the finance system infrastructure to assure accurate and timely data extraction and report submission • Managed the IT department to keep the flow of the

Education

BA and MBA

University of Derby, United Kingdom 1999 - 2006
(7 years)

Qualifications

Power BI

Microsoft
2020

MBA Marketing

University of Derby
2006

Contact Dov Goldenberg about your job

Log in to discuss any details over chat.

Verifications

Preferred Freelancer
Identity Verified
Payment Verified
Phone Verified
Email Verified
Facebook Connected

Certifications

us_eng_1.png US English 1 95% preferredfreelancer-1.png Preferred Freelancer Program SLA 1 94% data_entry_1.png Data Entry 1 80%

Top Skills

Excel
110
Accounting
68
Finance
66
Financial Analysis
57
Database Programming
5

Browse Similar Freelancers

Excel Experts in Cyprus
Excel Experts
Accountants
Financial Experts

Browse Similar Showcases

Excel
Accounting
Finance
Financial Analysis
Previous User
Next User
Invite sent successfully!
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2021 Freelancer Technology Pty Limited (ACN 142 189 759)
There is no internet connection