top of page
20200603 - Payment Plan - Core - V1.7.9.9 YM Modified OPEN_Page_6.jpg

Portfolio of My Work

Majority of my work has been with MS Excel and Google Sheets, and that is what i will showcase here.

The reports and calculations are all based on formulas and are customisable and reactive based on certain inputs or changes made elsewhere in the workbook(s).

Note: client and private information has been redacted.

00

R - Data Analysis

Big data analysis done with R as a demonstration of capabilities.

R
20200603 - Payment Plan - Core - V1.7.9.9 YM Modified OPEN_Page_4.jpg

01

Excel- Payment Plan

How clients were automatically distributed among the sales employees and tracking their performance.

02

Excel - Auto-reports

Detailed reports of the specific project that are created with formulas and automatically update based on any changes on different sheets and/or workbooks.

reports_Redacted_Page_7.jpg
Contract Creation Process_files3.jpg

03

MS Office - Contract Creation

The methods used to create a contract. products used and the formulas.

04

Excel & PM - Project Management

Automatically calculate the duration of the project based on different aspects and scopes.

Binder2_Page_2.jpg
Web capture_17-12-2021_12527_docs.google.com.jpeg

05

SOP - CIL's & Procedures

The intricate procudes of CIL's, sending automatically written emails and recording of data.

06

SOP - Signing Brokers

The detailed process of signing a brokerage.

Brokerage Contract Procedure.drawio.png
WFM.png

07

WFM Auto-Reporting

This report was made for ANWB, it automatically refreshes every 15 minutes for multiple  departments to use and for different purposes

bottom of page