The Most Important Design App Ever is… Excel?!
Thursday, 2:45 pm – 3:30 pm Pacific
We know it sounds crazy, but every designer and production artist needs to know at least a little bit about Microsoft Excel! There is just so much you can do with this amazing tool. Join us as we cover some of our favorite Excel tricks for designers.
- Embrace VLOOKUP for matching two lists. Quickly find out which items are missing from one list or the other.
- Do a Mail Merge from Excel data to InDesign. Create a PDF file with one page per row in Excel.
- Use Flash Fill in Excel to quickly convert a column of text. Make everything Proper case, extract part numbers, or add text to each line.
- You, too, can make a pivot table with these four simple steps