We are in search of a proficient professional to enhance and streamline our existing Google Sheet, which serves as a tracker for our business’s subscriptions to various tools and platforms. The current sheet contains accurate data, but we need to establish template formulas to create a cohesive and standardized working document. Additionally, optimization efforts are required to improve the sheet’s efficiency and ensure the provision of precise and up-to-date information.

In addition, we aim to develop a more dynamic dashboard that provides key insights into spending patterns across our departments. While open to your recommendations, specific elements need to be incorporated into the spreadsheet as outlined below:

Comparative Analysis of Total Costs (Current vs. Previous Periods): It is imperative to conduct a thorough comparative examination against preceding periods (monthly, quarterly, annually) to comprehend trends and facilitate future expense predictions.

Calculation of Cost Changes (% Change): Precise formulas are required to compute percentage changes based on pertinent time intervals.

Awareness of Renewal Dates and Types: In the context of software and subscriptions, staying informed about renewal due dates and the types of renewal agreements in effect (e.g., monthly, annual) is essential for effective cash flow planning. Can we incorporate a cell highlight formula to indicate impending expiry dates?

Evaluation of Budget Allocation vs. Actual Spending: Incorporating a comparison between the planned budget and actual spending is valuable for monitoring financial discipline and evaluating the precision of financial forecasting.

The ideal candidate should possess expertise in Google Sheets, exhibit proficiency in data cleaning, organization, and optimization, and be meticulous in following instructions. This is a brief task expected to require less than a couple of hours to complete, and an intermediate level of expertise is sought.

Skills required:

Google Sheets
Data cleaning
Data organization
Data optimization

Hourly Range: $10.00-$45.00

Posted On: January 23, 2024 03:07 UTC
Category: Scripting & Automation
Skills:Google Sheets, Automation, Google Apps Script, Scripting, API, Google Forms

Country: United States

click to apply