|
Our tips newsletter to help you succeed. Index of Topics.
Excel Word PowerPoint
General Computer Hints Print Hints
Excel:
Adding Page Breaks for Printing http://www.univgraph.com/Newsletter_Design_Tips_AUGUST_09.pdf
Excel – Adjusting Column Widths/Row Heights http://www.univgraph.com/html/digital_tips_april_2010.html
Combining Text Fields http://www.univgraph.com/Newsletter_Design_Tips_August_07.pdf
Counting http://www.univgraph.com/Newsletter_Design_Tips_Novembef_07.pdf
Creating and working with charts in Excel http://www.univgraph.com/Newsletter_Design_Tips_April_08.pdf
Emailing an Excel, Word or PowerPoint File Directly from Excel, Word or PowerPoint http://www.univgraph.com/Newsletter_Design_Tips_January_09.pdf
Formatting Data Cells http://www.univgraph.com/Newsletter_Design_Tips_JUNE_09.pdf
Grid Lines, Borders and Colors http://www.univgraph.com/Newsletter_Design_Tips_December_08.pdf
How to Select Multiple Cells http://www.univgraph.com/digital_tips_feb_2010.html
Macros Made Easy http://www.univgraph.com/Newsletter_Design_Tips_December_09.pdf
Making Excel Do Your Data Entry http://www.univgraph.com/html/digital_tips_july_08.html
Paste Special http://www.univgraph.com/Newsletter_Design_Tips_February_08.pdf
Printing On Multiple Pages With Rows Or Columns Repeating http://www.univgraph.com/Newsletter_Design_Tips_September_07.pdf
Removing Hyperlinks – Excel, PowerPoint and Word http://www.univgraph.com/Newsletter_Design_Tips_JULY_09.pdf
Search and Replace - Advanced Use http://www.univgraph.com/Newsletter_Design_Tips_October_08.pdf
See the Data You Need to See – Splitting vs Freezing Panes http://www.univgraph.com/html/digital_tips_sept_09.html
Sorting Data http://www.univgraph.com/Newsletter_Design_Tips_April_09.pdf
Text to columns http://www.univgraph.com/Newsletter_Design_Tips_December_07.pdf
To See The Sum Of A List Of Numbers In A Flash http://www.univgraph.com/Newsletter_Design_Tips_June_07.pdf
Why Excel is Better Than a Calculator http://www.univgraph.com/Newsletter_Design_Tips_November_08.pdf
Word wrapping and adding a line return within a cell http://www.univgraph.com/Newsletter_Design_Tips_March_08.pdf
Word/Excel/PowerPoint – Edit Paste Special – Text http://www.univgraph.com/Newsletter_Design_Tips_November_08.pdf
Excel – Working with Formulas http://www.univgraph.com/html/digital_tips_May_2010.html
Working with Zip Codes (Numbers vs Text) http://www.univgraph.com/Newsletter_Design_Tips_November_09.pdf
Worksheet Tabs http://www.univgraph.com/Newsletter_Design_Tips_May_08.pdf
Word:
Bullets and Numbered Lists http://www.univgraph.com/html/digital_tips_May_2010.html
Compare And Merge Documents http://www.univgraph.com/Newsletter_Design_Tips_Novembef_07.pdf
Counting Characters http://www.univgraph.com/Newsletter_Design_Tips_AUGUST_09.pdf
Creating Columns http://www.univgraph.com/Newsletter_Design_Tips_August_08.pdf
Creating Envelopes http://www.univgraph.com/Newsletter_Design_Tips_October_09.pdf
Cropping graphics in Word and PowerPoint http://www.univgraph.com/Newsletter_Design_Tips_October_07.pdf
E-mail Mass Merge http://www.univgraph.com/Newsletter_Design_Tips_July_07.pdf
Emailing an Excel, Word or PowerPoint File Directly from Excel, Word or PowerPoint http://www.univgraph.com/Newsletter_Design_Tips_January_09.pdf
Managing Hyperlinks http://www.univgraph.com/Newsletter_Design_Tips_June_08.pdf
Removing Hyperlinks – Excel, PowerPoint and Word http://www.univgraph.com/Newsletter_Design_Tips_JULY_09.pdf
Search and Replace - Advanced Use http://www.univgraph.com/Newsletter_Design_Tips_October_08.pdf
Seeing Your Document From A Different Angle http://www.univgraph.com/Newsletter_Design_Tips_February_08.pdf
Taking a “Break” http://www.univgraph.com/digital_tips_march_2010.html
Text Wrapping http://www.univgraph.com/Newsletter_Design_Tips_January_08.pdf
Using charts in PowerPoint and Word http://www.univgraph.com/Newsletter_Design_Tips_April_08.pdf
Using Sort http://www.univgraph.com/DigitalTips0110/index.html
Word/Excel/PowerPoint – Edit Paste Special – Text http://www.univgraph.com/Newsletter_Design_Tips_November_08.pdf
Word/PowerPoint – Changing the Case of Text http://www.univgraph.com/Newsletter_Design_Tips_March_09.pdf
Working with Headers and Footers http://www.univgraph.com/Newsletter_Design_Tips_December_09.pdf
PowerPoint:
Adding a PowerPoint Template to Your Slide Design Library http://www.univgraph.com/html/digital_tips_april_2010.html
Cropping graphics in Word and PowerPoint http://www.univgraph.com/Newsletter_Design_Tips_October_07.pdf
Cutting file sizes in PowerPoint http://www.univgraph.com/Newsletter_Design_Tips_October_07.pdf
Emailing an Excel, Word or PowerPoint File Directly from Excel, Word or PowerPoint http://www.univgraph.com/Newsletter_Design_Tips_January_09.pdf
PowerPoint - File Types - .ppt, .pps, .pot, and htm http://www.univgraph.com/digital_tips_march_2010.html
Inserting Tables from Excel http://www.univgraph.com/Newsletter_Design_Tips_November_09.pdf
Keeping Your Notes with You http://www.univgraph.com/html/digital_tips_july_08.html
Moving Objects More Precisely http://www.univgraph.com/html/digital_tips_sept_09.html
PowerPoint Slide Transitions http://www.univgraph.com/Newsletter_Design_Tips_May_08.pdf
PowerPoint, Word and Excel: Creating Organization Charts and Diagrams http://www.univgraph.com/Newsletter_Design_Tips_February_09.pdf
Removing Hyperlinks – Excel, PowerPoint and Word http://www.univgraph.com/Newsletter_Design_Tips_JULY_09.pdf
Search and Replace - Advanced Use http://www.univgraph.com/Newsletter_Design_Tips_October_08.pdf
Slide Layouts http://www.univgraph.com/Newsletter_Design_Tips_December_07.pdf
The Task Pane (or Pain?) http://www.univgraph.com/DigitalTips0110/index.html
The Tool For Gathering Your Thoughts http://www.univgraph.com/Newsletter_Design_Tips_March_08.pdf
To Change Fonts Quickly In A Document http://www.univgraph.com/Newsletter_Design_Tips_June_07.pdf
Using Animation http://www.univgraph.com/Newsletter_Design_Tips_October_08.pdf
Using Bring to Front and Send to Back http://www.univgraph.com/Newsletter_Design_Tips_March_09.pdf
Using charts in PowerPoint and Word http://www.univgraph.com/Newsletter_Design_Tips_April_08.pdf
Using Grouping, Ungrouping and Regrouping http://www.univgraph.com/Newsletter_Design_Tips_JUNE_09.pdf
Using Master Pages http://www.univgraph.com/Newsletter_Design_Tips_July_07.pdf
Word/Changing the Case of Text http://www.univgraph.com/Newsletter_Design_Tips_March_09.pdf
Word/Excel/PowerPoint – Edit Paste Special – Text http://www.univgraph.com/Newsletter_Design_Tips_November_08.pdf
General Computer Hints:
Adobe Reader vs. Adobe Acrobat (PDFs) http://www.univgraph.com/Newsletter_Design_Tips_August_08.pdf
Blogs http://www.univgraph.com/Newsletter_Design_Tips_November_08.pdf
Changing the Text Size of a Web Site http://www.univgraph.com/Newsletter_Design_Tips_January_09.pdf
Function Keys - Explained http://www.univgraph.com/digital_tips_feb_2010.html
On-line – Typing Characters From An Image When Completing An On-line Form http://www.univgraph.com/Newsletter_Design_Tips_April_09.pdf
PDFs – Copying Text and Graphics http://www.univgraph.com/Newsletter_Design_Tips_December_08.pdf
PDFs – Extracting, Inserting, Replacing, and Deleting Pages http://www.univgraph.com/Newsletter_Design_Tips_October_09.pdf
Right Mouse Clicks http://www.univgraph.com/Newsletter_Design_Tips_January_08.pdf
Print:
Choosing the Right Fold for Your Next Project http://www.univgraph.com/Newsletter_Design_Tips_November_09.pdf
ClingZ – a New Print Material http://www.univgraph.com/Newsletter_Design_Tips_September_08.pdf
Cost–Effective Printing – On-Demand http://www.univgraph.com/Newsletter_Design_Tips_JULY_09.pdf
Create Targeted Customized Marketing Materials http://www.univgraph.com/Newsletter_Design_Tips_February_09.pdf
Creating DVDs and CDs http://www.univgraph.com/Newsletter_Design_Tips_June_08.pdf
Designing Postcards Within Postal Regulations http://www.univgraph.com/Newsletter_Design_Tips_January_09.pdf
Document Binding http://www.univgraph.com/Newsletter_Design_Tips_January_08.pdf
Going Green with Digital Printing http://www.univgraph.com/Newsletter_Design_Tips_June_08.pdf
Graphic Formats – CMYK vs RGB http://www.univgraph.com/Newsletter_Design_Tips_July_07.pdf
Graphic Formats – TIFF vs. EPS http://www.univgraph.com/Newsletter_Design_Tips_June_07.pdf
Graphic Formats – Web vs Print http://www.univgraph.com/Newsletter_Design_Tips_AUGUST_09.pdf
Graphic Resolution http://www.univgraph.com/Newsletter_Design_Tips_December_07.pdf
Holiday Gifts Ideas http://www.univgraph.com/Newsletter_Design_Tips_October_08.pdf
Mass Mailings (Fulfillment) http://www.univgraph.com/Newsletter_Design_Tips_December_08.pdf
On-demand printing http://www.univgraph.com/Newsletter_Design_Tips_September_07.pdf
One-to-one Marketing/VDP (full article) http://www.univgraph.com/Newsletter_Design_Tips_August_07.pdf
Paper sizes http://www.univgraph.com/Newsletter_Design_Tips_September_07.pdf
Paper Stock – Demystifying Paper Thickness Jargon http://www.univgraph.com/Newsletter_Design_Tips_October_09.pdf
Pocket-sized Conference Guide Books http://www.univgraph.com/Newsletter_Design_Tips_August_08.pdf
Preparing files for large format printing http://www.univgraph.com/Newsletter_Design_Tips_Novembef_07.pdf
Preparing files for printing http://www.univgraph.com/Newsletter_Design_Tips_October_07.pdf
Presentation Folders & Other New Goodies http://www.univgraph.com/Newsletter_Design_Tips_March_09.pdf
Print Quotes – what information to provide when requesting a quote http://www.univgraph.com/Newsletter_Design_Tips_March_08.pdf
Print Screen Button http://www.univgraph.com/Newsletter_Design_Tips_September_08.pdf
Printers’ Terms (bleed, die cut, kiss cut, etc) http://www.univgraph.com/html/digital_tips_july_08.html
Project Coordination - Training Binder http://www.univgraph.com/Newsletter_Design_Tips_February_08.pdf
Providing Graphics to Your Print Vendor http://www.univgraph.com/html/digital_tips_May_2010.html
pURLs – Personalized URLs http://www.univgraph.com/Newsletter_Design_Tips_February_09.pdf
Scientific Posters – Tips and Hints - Expanded http://www.univgraph.com/html/scientific_posters_feb_2010.html
Sizing Up Your Files for Print http://www.univgraph.com/digital_tips_march_2010.html
Sticking with Static - ClingZ Paper http://www.univgraph.com/DigitalTips0110/index.html
Trade show materials http://www.univgraph.com/Newsletter_Design_Tips_April_08.pdf
Turning Heads with Large Color Banners http://www.univgraph.com/Newsletter_Design_Tips_JUNE_09.pdf
Universal Graphics – Thinking Large-Format http://www.univgraph.com/Newsletter_Design_Tips_April_09.pdf
Web Browsing Tips http://www.univgraph.com/Newsletter_Design_Tips_September_08.pdf
What is a bleed? http://www.univgraph.com/Newsletter_Design_Tips_August_07.pdf
What is a BtoB (BtoC) Digital StoreFront? http://www.univgraph.com/Newsletter_Design_Tips_December_09.pdf
What is a Die-Cut? http://www.univgraph.com/html/digital_tips_sept_09.htm
What is a UV coating? http://www.univgraph.com/html/digital_tips_april_2010.html
|