CCI Tech Tip Tuesdays

When creating a document that pulls in text from different places, getting all the text to match in terms of formatting (like font size, and type, if it's bolded, color) can be frustrating.  The Format Painter function can help with this.  Format painter lets you easily take the format for one section of text and apply it to another section of text in a document.  You can use Format Painter in Microsoft Word, Excel, Google Docs, and Outlook, among other programs. Simply highlight the text whose format you would like to use, click the Format painter icon, and then select the text that you would like to change.  The Format Painter tool is located near the Paste, Copy and Cut functions in the program.  See screenshots below for where to locate the Format Painter tool. In Outlook: ​ In Microsoft Word: ​ In Google Docs: ​Happy pasting!

Did you know you can delay delivery of your e-mail messages?  In Outlook, you can schedule individual messages to be sent at a later time, or even set-up a rule so that all of your e-mails are delayed a few minutes before they're sent.    Learn more here .   Note: you must have your computer turned on and Outlook open at the time you want to send the message. If you are a Gmail  user,   Boomerang   allows you to schedule your e-mails for the future and more. The free version has a limit of 10 e-mails per month.

Foxit PhantomPDF - available on most of our Windows 10 machines - easily allows you to combine multiple files into one PDF file.   You can read more about how to easily combine multiple files here. And as a bonus, here's a shortcut: select all the files you want to combine in the File Explorer window, right-click, and select to combine files in Foxit Phantom PDF.

Excel is great for recording data, but how can you quickly analyze all that information?  Sometimes a pivot table is the answer to help you summarize, explore and present data.  Using Excel's visual interface, you can quickly summarize information by categories, creating easy to manipulate tables, and even view them as charts. Initial data: Quick and easy pivot table: Click here for an overview on what pivot tables are. Click here for a free tutorial on using pivot tables .