Excel Tricks for InDesign Users

Wednesday, 2:15 pm – 3:00 pm

Every so often, you have a task in InDesign that could handled easily using the powerful Data tools in Microsoft Excel. Join “MrExcel” (Bill Jelen) as he covers some of his favorite Excel tricks.

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.
Check out the new Power Query tools (Windows only) for pulling in a list of all images unembedded from InDesign. Sort and Filter by File Size. Massage data from hundreds of text files into a single list.

Back to Agenda

Keep Me Informed

From Previous Attendees

“I truly can't put a price tag on how invaluable this conference was to my professional development, but also to my soul. Thank you x 3000!”

Janelle Thomas

Arizona Marketing Lead, DPR Construction

2019-10-02T12:42:59+00:00

Arizona Marketing Lead, DPR Construction

“I truly can't put a price tag on how invaluable this conference was to my professional development, but also to my soul. Thank you x 3000!” 6.2.6

https://creativeproweek.com/testimonial/janelle-thomas/

“The presenters were top notch, and the skills taught were far reaching in scope but very pertinent to my daily work.”

Jill Walker

Senior Graphic Artist, UC Davis

2019-10-02T12:52:44+00:00

Senior Graphic Artist, UC Davis

“The presenters were top notch, and the skills taught were far reaching in scope but very pertinent to my daily work.” 6.2.6

https://creativeproweek.com/testimonial/jill-walker/

“With owning a small business - the big thing is cost and value for the money. This conference is hands-down the best of the best for all of the above and more. The networking was rewarding since you had all of these passionate visual engineers in one room feeding off of each other.”

Gary K. Laughlin

Principal - Owner, Norgar Creative Solutions

2019-10-02T12:51:25+00:00

Principal - Owner, Norgar Creative Solutions

https://creativeproweek.com/testimonial/gary-k-laughlin/

“Where else can you find so much about inDesign, digital publishing, and presentations all in one place?”

Mike Bain

President, CMC Pension Professionals

2019-10-02T12:50:15+00:00

President, CMC Pension Professionals

“Where else can you find so much about inDesign, digital publishing, and presentations all in one place?” 6.2.6

https://creativeproweek.com/testimonial/mike-bain/

“As a graphic designer in a fast-paced, evolving and creative industry, I always want to sharpen by skills and stay on top of trends and techniques. This conference is so hands-on and practical. I always come back with a list of things I can implement into my workflows immediately, as well as some ideas to keep my creative juices flowing until next year!”

Jordan Hill

Graphic Designer, Schaefer

2019-10-02T12:48:55+00:00

Graphic Designer, Schaefer

https://creativeproweek.com/testimonial/jordan-hill/

“I learned more in the first two days than in the past 8 years… this was the single greatest learning event I have ever been a part of.”

Sean Lee

Wide Format Graphic Designer, The H&H Group

2019-10-02T12:47:47+00:00

Wide Format Graphic Designer, The H&H Group

“I learned more in the first two days than in the past 8 years… this was the single greatest learning event I have ever been a part of.” 6.2.6

https://creativeproweek.com/testimonial/sean-lee/

“Genuinely well thought out conference, delivering a fire-hose of useful information that somehow was always challenging and fresh but wasn't overwhelming!”

Andrea Gates Sanford

Owner, She Can Do It, LLC

2019-10-02T12:46:56+00:00

Owner, She Can Do It, LLC

“Genuinely well thought out conference, delivering a fire-hose of useful information that somehow was always challenging and fresh but wasn't overwhelming!” 6.2.6

https://creativeproweek.com/testimonial/andrea-gates-sanford/

“This was without a doubt (no hyperbole here) the BEST conference/training I have ever attended.”

Marisa Worden

Recreation Marketing Specialist, Tumwater Parks and Recreation

2019-10-02T12:45:36+00:00

Recreation Marketing Specialist, Tumwater Parks and Recreation

“This was without a doubt (no hyperbole here) the BEST conference/training I have ever attended.” 6.2.6

https://creativeproweek.com/testimonial/marisa-worden/

“I wanted to attend an eye-opening conference where I learn new techniques and processes while being wowed by experts in our industry …That's exactly what I received attending Creative Pro Week.”

Krissy Menkins

Graphic Designer, Innovative Interfaces

2019-10-02T12:44:53+00:00

Graphic Designer, Innovative Interfaces

https://creativeproweek.com/testimonial/krissy-menkins/

“I always learn so much that I can bring back and apply to what I'm working on immediately. My boss even comments on the noticeable change when I get back.”

Cassie Scheidecker

Graphic Design and Production Specialist, NorthWestern Energy

2019-10-02T12:44:09+00:00

Graphic Design and Production Specialist, NorthWestern Energy

“I always learn so much that I can bring back and apply to what I'm working on immediately. My boss even comments on the noticeable change when I get back.” 6.2.6

https://creativeproweek.com/testimonial/cassie-scheidecker/

“Your speakers know what they’re talking about, love what they do, and are all about sharing their knowledge…  I can’t wait for next year!”

Jay Newmarch

Owner,  CRE8 Design LLC

2018-11-11T06:12:54+00:00

Owner,  CRE8 Design LLC

“Your speakers know what they’re talking about, love what they do, and are all about sharing their knowledge…  I can’t wait for next year!”

https://creativeproweek.com/testimonial/jay-newmarch/

“This is the only conference offering the expert, trustworthy information that we learners crave.”

Avon J. Murphy

Principal, Murphy Editing and Writing Services

2019-10-02T12:41:58+00:00

Principal, Murphy Editing and Writing Services

“This is the only conference offering the expert, trustworthy information that we learners crave.” 6.2.6

https://creativeproweek.com/testimonial/avon-j-murphy/

“I was completely blown away by the conference and have been recommending it to everyone I know in the design industry! Absolutely amazing experience with so many great instructors, classes and people. I learned so many cool and new things!”

Gisela Moore

Multimedia Specialist, United States Mint

2019-10-02T12:40:14+00:00

Multimedia Specialist, United States Mint

https://creativeproweek.com/testimonial/gisela-moore/

“I really enjoyed being able to attend 4 days worth of InDesign classes. I was able to come back to work and immediately implement what I learned.”

 Will Ballard

Design and Development Coordinator, Arkansas Blue Cross and Blue Shield

2018-11-11T06:08:33+00:00

Design and Development Coordinator, Arkansas Blue Cross and Blue Shield

“I really enjoyed being able to attend 4 days worth of InDesign classes. I was able to come back to work and immediately implement what I learned.”

https://creativeproweek.com/testimonial/%e2%80%a8will-ballard/

“I’m expected to help our designers make magic… CreativePro Week is where I learn all the tricks!”

Craig Simpson

Graphic Artist, Kalamazoo College

2018-11-11T06:09:32+00:00

Graphic Artist, Kalamazoo College

“I’m expected to help our designers make magic… CreativePro Week is where I learn all the tricks!”

https://creativeproweek.com/testimonial/craig-simpson/

“I left with tons of information and the desire to keep learning more.”

Monica Crigler

Senior Designer, Heinemann

2018-11-11T06:11:03+00:00

Senior Designer, Heinemann

“I left with tons of information and the desire to keep learning more.”

https://creativeproweek.com/testimonial/monica-crigler/

“I find that the CreativePro conferences are the best way to stay on top of the ever changing world of graphics technology.”

Mary Ann Walsh

Graphic Designer, Air Line Pilots Association

2018-11-11T06:11:32+00:00

Graphic Designer, Air Line Pilots Association

“I find that the CreativePro conferences are the best way to stay on top of the ever changing world of graphics technology.”

https://creativeproweek.com/testimonial/mary-ann-walsh/

“My boss said, ‘Bring back something good, so we can justify having sent you.’ Well, I’m bringing back a tip that will save us boatloads of time—that alone was worth it!”

Marisa Carder

Graphics Specialist, McKinsey & Company

2018-11-11T06:12:02+00:00

Graphics Specialist, McKinsey & Company

“My boss said, ‘Bring back something good, so we can justify having sent you.’ Well, I’m bringing back a tip that will save us boatloads of time—that alone was worth it!”

https://creativeproweek.com/testimonial/marisa-carder/

“I learned real, tangible things that I can take and start using in my work right away. My life just got so much easier, and more efficient.”

Amanda Petersen

Senior Graphic Designer, CDM Smith

2018-11-11T06:12:21+00:00

Senior Graphic Designer, CDM Smith

“I learned real, tangible things that I can take and start using in my work right away. My life just got so much easier, and more efficient.”

https://creativeproweek.com/testimonial/amanda-petersen/

©2009-2025 — CreativePro and PePcon are registered trademarks of the CreativePro Network. CreativePro, The Photoshop Conference, The Illustrator Conference, The InDesign Conference, InDesignSecrets, PePcon: The Print & ePublishing Conference, and Click: The Presentation Design Conference are independently owned and not endorsed or authorized by Adobe Systems Incorporated. Adobe, Photoshop, Illustrator, and InDesign are either registered trademarks or trademarks of Adobe Systems Inc. PowerPoint is a registered trademark of Microsoft. Keynote is a registered trademark of Apple. CreativePro Week and its producer, the CreativePro Network, are using the logos of attendees' companies for marketing purposes only, and have no other business relationship with these companies. DUNS number: 089883509