How To Create Secure PDF Documents In Two Different Ways

Here at Investintech, we care about your document productivity and we know that working with multiple documents can be a dreadful uphill battle. Because digital documents and PDFs are an essential part of your day to day work, your document processing routine and PDF tools always need to be updated. They need to be flexible and powerful enough to keep up with you.

This is why we included the features we did in Able2Extract 9. Though you know the PDF tool as Able2Extract PDF Converter, it has gone above and beyond that in this latest version. It can do a whole lot more now—and more conveniently.

Case in point: PDF creation. You may have given the main feature a  quick try, but there’s more to this feature than meets the eye. It can get the job of creating secure PDFs done in more ways than one.

Let’s take a closer look.

Method 1: Create PDF Files With Able2Extract 9

PDF creation within Able2Extract is just as simple as converting a PDF document. So if you’ve ever converted a PDF file with Able2Extract, then you already have a good idea of how to create one.

In other words, you get a new feature with a familiar set up, eliminating any high learning curves that can waste a good chunk of your time. From the command toolbar:

1. Click on the create PDF icon.

Creating PDF Files2. Open your file.

Opening File In Able2Extract

3. Go into the PDF Creation Options… menu and add your PDF security options. Here you can choose a number of settings for your PDF content. Click on OK.

PDF Creation Security Options
4. Then click on Save to complete the process.

Saving PDF In Able2Extract

 

Method 2: Create Secure PDFs From Your Everyday Applications

That’s just one method. However, if, like me, you prefer to stay in the application you’re working in, Able2Extract still has you covered. With the virtual printer, you can turn any application into a PDF creator.

Just print up your document as usual with the Print functionality, but choose Able2Extract 9.0 Printer instead:

Able2Extract Virtual Print Driver

Yet because you don’t need to open Able2Extract to create PDFs, you may be thinking that you’ll miss out on all the PDF creation options built into this latest version. Not so. This is where the print dispatcher comes into play.

Adjust Settings With The Print Dispatcher

Accessing Able2Extract Print DispatcherYou may have seen this icon lurking around on your system tray after installing Able2Extract.

The Print Dispatcher allows you to control all of your out-of-Able2Extract  PDF creation options.

When combined with the virtual print driver, you can create the same secure PDF just as easily.

On opening the Print Dispatcher, you get everything you need to stay on top of the PDF creation process:

Print Dispatcher Interface

By clicking on the Options… button, you can change the PDF creation settings for all PDF files created through the Able2Extract Print Driver, including the Security settings for each file.  

Selecting PDF Security Options

After your security options are set and your PDF is created, you can check in on your new file from the Print Dispatcher and interact with the file as needed.

Options For Opening PDF

Give the PDF creation feature a good spin if you haven’t already. This is just one of many new Able2Extract 9 features that let you get up close and personal with your PDF documents.

Get Ready For The Oscars With PDF Screenplays Of Your Favourite Movies

Excited about the Oscars? We’re right there with you. It’s always fun to watch and find out which actors and movies will form the 2015 Oscar-winning roster.

So in honour of the 87th Academy Awards and movies in general, we thought you’d enjoy a quick and highly related PDF resource. And we spotted out a great one for PDF movie scripts from Gointothesotry.blckst.com.

PDF Movie Scripts

Gointothestory.blckst.com is the official blog for The Blacklist, a network where script writers, buyers and representatives can connect. The blog was created by screenplay writer and script writing instructor, Scott Myers, whose credentials include the movies K-9 and Trojan War. He teaches script writing courses online, using the blog as a resource for his students and anyone who loves the art of movies and writing.

Go Into The Story has one webpage in particular dedicated to featuring a great selection of more than 80 PDF screenplays online, which, according to the site, are legal and free to download.

The screenplays are from recently acclaimed movies you’ve watched, if not, heard about. For instance, you’ll find the 2014 Oscars Best Picture winner 12 Years A Slave, the popular hit Frozen, and movies that featured Oscar winning actors such as Dallas Buyers Club.

Moreover, there are screenplays fromthis year’s Oscar nominations for 2015. You can get a good look at the Oscar movie you’re vouching for in detail, line by line. Those already posted include, Into The Woods, The Theory of Everything, Still Alice, and Birdman. So be sure to check them out before the big day!

Enjoy.

 

Work With Excel Data Like A Pro With 9 Simple Tips

Excel Spreadsheet DiagramWithout doubt, an Excel spreadsheet is one of the most advanced tools for working with raw data—and one of the most feared.  The application looks complicated, way too advanced, and like something that would take hours to figure out.

I wouldn’t be surprised if upon hearing that you had to start using MS Excel, your heart started to pound. Is there any way to make Microsoft Excel less scary and intimidating? Yes.

By learning a few spreadsheet tricks, you can bring Excel down to your level and start looking at the application in a different light.  We rounded up some of the simplest yet powerful MS Excel spreadsheet tips you can start using on your data.

1. Use MS Excel Format Painter

To start you off, get yourself familiar with formatting your spreadsheet cells. A visually organized spreadsheet is highly appreciated by others as it can help them follow your data and calculations easily. To quickly apply your formatting across hundreds of cells, use the Format Painter:

  1. Select the cell with the formatting you wish to replicate
  2. Go to the Home menu and click on the Format Painter. Excel will display a paintbrush next to the cursor.
  3. Using Excel Format PainterWhile that paintbrush is visible, click to apply all of the attributes from that cell to any other.

To format a range of cells, double-click the Format Painter during step 1. This will keep the formatting active indefinitely. Use the ESC button to deactivate it when you’re done.

2. Select Entire Spreadsheet Columns or Rows

Another quick tip– use the CTRL and SHIFT buttons to select entire rows and columns.

  1. Click on the first cell of the data sequence you want to select.
  2. Hold down CTRL + SHIFT
  3. Then use the arrow keys to get all the data either above, below or adjacent to the cell you’re in.

You can also use CTRL + SHIFT + *   to select your entire data set.

3. Import Data Into Excel Correctly

The benefit of using is Excel is that you can combine different types of data from all kinds of sources.  The trick is importing that data properly so you can create Excel drop down lists or pivot tables from it.

Don’t copy-paste complex data sets. Instead, use the options from the Get External Data option under the Data tab. There are specific options for different sources. So use the appropriate option for your data:

Importing Data to Excel

4. Enter The Same Data Into Multiple Cells

At one point, you may find yourself needing to enter the same data into a number of different cells. Your natural instinct would be to copy-paste over and over again. But there’s a quicker way:

  1. Select all the cells where you need the same data filled in (use CTRL + click to select individual cells that are spread across the worksheet)
  2. In the very last cell you select, type in your data
  3. Use CTRL+ENTER.  The data will be filled in for each cell you selected.

5. Display Excel Spreadsheet Formulas

Viewing Spreadsheet Formulas

Jumping into a spreadsheet created by someone else? Don’t worry. You can easily orient yourself and find out which formulas were used. To do this, use the Show Formulas button. Or you can use CTRL + `  on your keyboard. This will give you a view of all formulas used in the workbook.

6. Freeze Excel Rows And Columns

This is a personal favourite of mine when it comes to viewing lengthy spreadsheets. Once you scroll past the first 20 rows, the first row with the column labels annoyingly disappear from view and you begin to lose track of how the data was organized.

Freezing Excel Columns Rows

To keep them visible, use the Freeze Panes feature under the View menu. You can opt to freeze the top row or, if you have a spreadsheet with numerous columns, you can opt to freeze the first column.

7. Enter Data Patterns Instantly

One great feature in Excel is that it can automatically recognize data patterns. But what’s even better is that Excel will let you enter those data patterns to other cells.

  1. Simply enter your information in two cells to establish your pattern.
  2. Highlight the cells. There will be a small square in the bottom right hand corner of the last cell. Excel Data Patterns
  3. Place your cursor over this square until it becomes a black cross. 
  4. Then click and drag it with your mouse down to populate the cells within a columnEntering Spreadsheet Data Patterns

8. Hide Spreadsheet Rows and Columns

In some cases, you may have information in rows or columns that are for your eyes only and no one else’s. Isolate these cells from your work area (and prying eyes) by hiding them:

  1. Select the first column or row in the range you want to hide.
  2. Go to Format under the Home menu.
  3. Select Hide & Unhide>Hide Rows or Hide ColumnsHiding Excel Rows Columns

To unhide them, click on the first row or column that occur just before and after the hidden range. Repeat steps 2 and 3, but select Unhide Rows or Unhide Columns.

9.  Copy Formulas Or Data Between Worksheets

Another helpful tip to know is how to copy formulas and data to a separate worksheet. This is handy when you’re dealing with data that’s spread across different worksheets and requires repetitive calculations.

  1. With the worksheet containing the formula or data you wish to copy opened, CTRL + click on the tab of the worksheet you want to copy it to.
  2. Click on or navigate to the cell with the formula or data you need (in the opened worksheet).
  3. Press F2 to activate the cell.
  4. Press Enter.  This will re-enter the formula or data, and it will also enter it into the same corresponding cell in the other selected worksheet as well.

These general tips won’t turn you into an Excel guru overnight. But they can help you take that first step towards becoming one! Are you a well-seasoned Excel user? Which of your spreadsheet tricks would you add?

 

How To Manage Your Next Super Bowl Pool With 5 Everyday Office Tools

Classic-Leather-FootballPhoto Credit: Tom Newby Photography via photopin cc

Super Bowl Sunday. Two teams. One winner. An entire season of playoffs leading up to one championship game. Who do you have pegged to win?

If you’re a football fan, chances are that your choice is already locked down in an office pool. After all, nothing adds excitement to a game like a small pool among you and your colleagues—especially when you win and get all the bragging rights!

That’s the fun part. But if you’ve ever managed a pool yourself, then you’ll know that as fun as it can be, it can also be stressful. From trying to get your football squares filled to updating your bracket sheets, every pool manager hustles to get everything organized and recorded properly.

Don’t worry if things didn’t go smoothly this year.  We found that no matter what kind of pool you’re running, there are a few tricks that can make things go easier.  So while the Super Bowl marks the beginning of the end of tracking sheets and football statistics (at least for a while), we thought a short list of tips and tools would go a long way to helping you with your next football pool. Check them out.

Use Excel Templates

First thing’s first–did you create your Super Bowl sheets from scratch? If so, you should re-consider. Save yourself the time and effort next time by using a template.

You can get a variety of templates for any pooling options you and your workmates set up. Even better, you can find templates with formulas and functions pre-set so that calculating details like scores is just a matter of entering your data.  A simple search online can dig up a number of downloadable super bowl squares excel templates and tracking sheets for free.

Share your Football Squares On GoogleDocs

Whether it was your first time handling the project or if you’re a seasoned pro, you probably had a tough time filling all your football squares once the most popular numbers for super bowl squares were taken. To help combat that lull in interest, try distributing and sharing them publicly. Doing so will help spread the word around the office.

Google-Docs-View-Document

You can easily upload it to a cloud server like Google Docs and then simply add a person’s email address to share it. To keep others from modifying your bracket sheet, set up file permissions allowing only others to view the available squares while you alone can update and lock in everyone’s picks as more people join.

Keep Everything In Excel Worksheets

In any pool, you’ll want to keep track of everything involved with the game—statistics, players and standings, so you can report the calculated results to your pool members.  To make this task easier, keep track of everything in a separate worksheet within the same workbook as your pool tracking sheet.

This may seem obvious, but it’s the most overlooked yet effective way to keep others updated on statistics during the game. You can easily use an Excel formula, a macro or a function to automatically calculate points earned, highlight player data or tally up the standings.  Thus, if anyone in the pool needs to check in on how their picks are doing, they can find the updated details organized alongside the tracking spreadsheet.

Use A Microsoft PowerPoint Template

Super-Bowl-Excel-Alternative                                                                                  Image Source: Free-Power-Point-Templates.com

Now we all have our own preferences when it comes to getting things done, and if Excel isn’t your thing, don’t waste time trying to struggle with it. Instead, consider using another format like PowerPoint. Free- PowerPoint-Templates.com has a quick tutorial on how to make a football squares template within PowerPoint. It shows you how to achieve the same goal and set up without all the formulas.  Simple.

Finalize Your Pool In PDF Format

Among the many important tasks to carry out, having the pool set in stone is key. Once you have all you Super Bowl squares set, for instance, the next thing is to ensure that those squares don’t get altered when they’re distributed.

Able2Extract-Excel-to-PDF-With-Able2Extract

The most convenient way is to create PDF files of your sheet. It’s a great way to keep yourself accountable and to secure your co-workers’ picks until the end of the game. Able2Extract can do this easily from MS Excel (or PowerPoint) with all the PDF creation and security features needed.

So are you ready for Super Bowl weekend?  Share your office pool tips and tricks in the comments!

 

Merry Christmas From Investintech.com

 Merry-Christmas-StarPhoto Credit: mrmanc via photopin cc

Christmas is finally here and we just wanted to wish everyone of our customers, followers and supporters a Merry Christmas!

Whether you’re at a huge get together with the entire family, on vacation in a tropical hotspot or cozy and warm at home with a loved one—no matter how you celebrate it, we hope you all have a safe and happy holiday this year!
Cheers,
The Investintech Team