Data-savvy analysts are in demand. Want to get started? Learn Excel.
This series of posts is everything I wish I knew when applying for my first analyst job. Focusing on two commonly used Excel tools, the series covers what analysts do to why many use Excel to how to find a job.
Let me know if it helps! Thanks so much for reading.
Introduction
Vlookups: the Duct Tape of Excel
An even better Vlookup: IFERROR
#Vlookupproblems: The Zoolander Problem
#VlookupProblems: Cells Formatted as Text
A Better Vlookup: Anchored Cell Reference
PivotTables: the WD-40 of Excel
#PivotTableProblems: Always be Refreshing
#PivotTableProblems: Avoid GETPIVOTDATA
#PivotTableProblems: Tweak Your View
PivotTables: Add a Calculated Field
The Interview and Beyond
No More Blast Invites! LinkedIn for Aspiring Analysts
Leave a Reply