Excel: Using string functions to reformat data
Maybe you converted a PDF or imported a table into Excel -- or maybe an agency gave you a poorly formatted file. You can use string functions to reformat your data and get your spreadsheets working for you.
This session is good for: Anyone comfortable with using formulas in Excel.
Rachel Alexander covers education and nonprofits for Salem Reporter, an online news site in Oregon's capital. She's used spreadsheets to report on everything from nurses dying of opioid overdoses to roadkill salvaging on the state's highways. She's passionate about machine-readable document formats, crashing Excel with massive spreadsheets and #FOIAFriday. @rachelwalexande
No tipsheets have yet been uploaded for this event.