24 tasks, each one witnessed by the sources that watched the job — and behind every one, a prompt you can use tonight.
You spend most mornings pulling prices, costs, and sales data into Microsoft Excel to update models and forecasts. That means cleaning raw data, running formulas, and refreshing charts so numbers are ready for meetings.
Afternoons often go to meetings: presenting findings in PowerPoint, discussing with portfolio managers or sales about pricing actions, and following up via Outlook. You also prepare materials for deals and update QuickBooks or other systems for transaction records.
Start with Microsoft Excel. Pricing work uses complex models and charts in Excel every day — VLOOKUP/XLOOKUP, pivot tables, and scenario tables are core skills. Build 2–3 model files you can explain.
After Excel, learn Power BI to make dashboards that stakeholders open; and QuickBooks if your role touches invoicing or transaction records. PowerPoint and Outlook are used constantly to present and communicate.
Use AI as a drafting and checking tool: ask it to summarize market movements, suggest formulas, or spot obvious model errors. Always copy the suggested formula back into Excel and test it against real data before trusting results.
Never let AI write final reports or make trading/purchasing decisions. Keep audit trails in files and Outlook, and ensure any model used for decisions is reviewed by a senior analyst or manager.
Study finance, economics, or a quantitative field and get comfortable with Excel. Practice building at least three types of Excel models: a pricing model, a cost-plus model, and a discounted cash flow (DCF) for valuation.
Do an internship or volunteer to prepare client presentations in PowerPoint and maintain records in QuickBooks or spreadsheets. Learning basic SQL or Power BI helps, and find a mentor to review your models.
A Pricing Analyst focuses on setting or testing product and investment prices — building cost and competitor-based models and running valuations. You’ll do securities valuation, price sensitivity, and prepare deal materials.
A Financial Analyst covers broader finance tasks like forecasts, balance-sheet analysis, and working with auditors. A Sales Analyst focuses on sales data and incentives. In small firms roles blur; expect to do overlapping tasks.
Early on, aim to complete accurate updates to 2–4 key pricing models per week and deliver one client or stakeholder presentation every 1–2 weeks. Maintain daily dashboards in Power BI or weekly Excel reports.
Also keep transaction paperwork current: ensure all deal materials and QuickBooks entries are posted within 48–72 hours of execution, and respond to key stakeholder emails in Outlook within one business day.