|
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
|
