|
Our monthly newsletter to help you succeed. Index of Topics.
Find helpful tips and hints on using Excel, Word, PowerPoint, and print. See the index of issues below and subscribe today to get your monthly email copy of the Digital Tips e-newsletter.
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
|
