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.
This session includes:
- 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