How Excel Helps You Land a Cloud Engineer Job Faster

Assumptions (fill prices from the official pricing page; note the date):
  B2 Instances          2
  B3 HoursPerMonth      730
  B4 HourlyPrice        ____   (source + date)
  B5 StorageGB          100
  B6 StoragePricePerGB  ____   (source + date)

Calculations:
  B8  Compute  =B2*B3*B4
  B9  Storage  =B5*B6
  B10 Total    =B8+B9

Scenario table (Data > What-If Analysis > Data Table):
  vary B2 across 1, 2, 4 and show B10 for each

def monthly_cost(instances, hourly_price, storage_gb, storage_price, hours=730):
    compute = instances * hours * hourly_price
    storage = storage_gb * storage_price
    return round(compute + storage, 2)

# Prices are placeholders; use the provider's official pricing page.
HOURLY, STORAGE = 0.0, 0.0
for n in (1, 2, 4):
    print(f"{n} instance(s): {monthly_cost(n, HOURLY, 100, STORAGE)}")

Name             Zone          CIDR           Purpose
public-a         ap-south-1a   10.0.1.0/24    load balancers
public-b         ap-south-1b   10.0.2.0/24    load balancers
private-app-a    ap-south-1a   10.0.11.0/24   app servers
private-app-b    ap-south-1b   10.0.12.0/24   app servers
private-db-a     ap-south-1a   10.0.21.0/24   databases
private-db-b     ap-south-1b   10.0.22.0/24   databases

VPC: 10.0.0.0/16. Reserved for future: 10.0.100.0/22

import ipaddress
from itertools import combinations

vpc = ipaddress.ip_network("10.0.0.0/16")
subnets = {
    "public-a": "10.0.1.0/24", "public-b": "10.0.2.0/24",
    "private-app-a": "10.0.11.0/24", "private-app-b": "10.0.12.0/24",
    "private-db-a": "10.0.21.0/24", "private-db-b": "10.0.22.0/24",
}
nets = {k: ipaddress.ip_network(v) for k, v in subnets.items()}
for name, net in nets.items():
    assert net.subnet_of(vpc), f"{name} is outside the VPC"
    print(f"{name:14} {net}  addresses: {net.num_addresses}")
for (a, na), (b, nb) in combinations(nets.items(), 2):
    if na.overlaps(nb):
        print("OVERLAP:", a, b)
print("check complete")

#!/usr/bin/env bash
# Export EC2 inventory to CSV for an Excel pivot table
set -euo pipefail
{
  echo "InstanceId,Type,State,AZ,Team,Env"
  aws ec2 describe-instances --region ap-south-1 \
    --query 'Reservations[].Instances[].[InstanceId,InstanceType,State.Name,Placement.AvailabilityZone,Tags[?Key==`team`]|[0].Value,Tags[?Key==`env`]|[0].Value]' \
    --output text | tr '\t' ','
} > inventory.csv
echo "rows: $(($(wc -l < inventory.csv) - 1))"

Migration tracker (Format as Table: Mig)
Columns: App | Owner | Wave | DependsOn | Status | TargetDate | Notes

Validation:
  Wave    List: Wave 1,Wave 2,Wave 3
  Status  List: Planned,In progress,Testing,Done,Blocked

Summary:
  Done in Wave 1   =COUNTIFS(Mig[Wave], "Wave 1", Mig[Status], "Done")
  Blocked items    =COUNTIF(Mig[Status], "Blocked")
  Overdue          =COUNTIFS(Mig[TargetDate], "<"&TODAY(), Mig[Status], "<>Done")

Conditional formatting: Status = "Blocked" -> red fill

Sheet 1  Cost estimate: assumptions, calculations, scenarios, sources
Sheet 2  Subnet plan: name, zone, CIDR, purpose, reserved ranges
Sheet 3  Inventory: exported CSV + pivot by env, type and team
Sheet 4  Migration tracker: waves, owners, dependencies, status
Sheet 5  Summary: key numbers and open risks

Use sample or free-tier data only.

Week 1  Tables, SUMIFS/COUNTIFS, data validation, pivots
Week 2  Cost estimate with scenarios; subnet plan with overlap check
Week 3  Inventory export and pivots; migration tracker; summary sheet

Situation: practice migration of three apps to the cloud
Task: plan cost, network and order of moves
Action:
  - cost sheet with sourced prices and scenarios
  - subnet plan checked for overlaps
  - tracker with waves and dependencies
Result: a clear plan I can walk through in five minutes