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.
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!
Without 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:
Select the cell with the formatting you wish to replicate
Go to the Home menu and click on the Format Painter. Excel will display a paintbrush next to the cursor.
While 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.
Click on the first cell of the data sequence you want to select.
Hold down CTRL + SHIFT
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. 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:
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:
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)
In the very last cell you select, type in your data
Use CTRL+ENTER. The data will be filled in for each cell you selected.
5. Display Excel 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.
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.
Simply enter your information in two cells to establish your pattern.
Highlight the cells. There will be a small square in the bottom right hand corner of the last cell.
Place your cursor over this square until it becomes a black cross.
Then click and drag it with your mouse down to populate the cells within a column
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:
Select the first column or row in the range you want to hide.
Go to Format under the Home menu.
Select Hide & Unhide>Hide Rows or Hide 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.
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.
Click on or navigate to the cell with the formula or data you need (in the opened worksheet).
Press F2 to activate the cell.
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?
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.
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.
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.
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!
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!
The Investintech Team
We have some sad news for all our Investintech users. It was a hard decision, but after a lot of careful consideration, we’ve decided to discontinue both Able2Doc PDF to Word Converter and Sonic PDF Creator.
Both these products have been with us since the very early days of Investintech.com, and we’re sorry to see them go. However, we believe in providing our users with products that add value to a workflow which includes being able to work with PDF documents without having to resort to more than one product.
You may have noticed that our PDF to Word conversion and PDF creation technology have already been integrated with Able2Extract PDF Converter. Because of this, you can benefit from an even better, more enhanced user experience. PDF conversion and PDF creation are now both within a few clicks of each other.
What Does This Mean For Existing Users?
Unfortunately, because we’re phasing these products out, we will no longer be offering any customer or technical support for them. Thus, we’ll be offering a highly discounted Able2Doc upgrade to Able2Extract 9 for $29.95 USD (to Standard version) and $49.50 USD (to Professional version).
With this discount, you’ll not only get the PDF to Word conversion and PDF creation features you’re used to, but also the added functionalities that come with Able2Extract–PDF conversion to more than 10 formats, PDF page editing, advanced PDF creation options, custom PDF to Excel conversion, and more.
We’ll be pulling out Able2Doc and Sonic every now and again for exclusive one-time giveaways. So you’ll still be able to catch the software around in the future every now and again.
To give Able2Extract 9 a try, you can download a 7-day free trial here.
Today, we’re excited to announce that we just released Able2Extract 9.0! Our flagship PDF converter has undergone some major changes in this version which we know you’ll love.
These changes go beyond what you’d consider an average product upgrade. This is because in addition to general PDF conversion improvements, Able2Extract 9 now comes with the ability to create and edit PDF documents!
Our developers have worked hard to turn Able2Extract 9 into a complete PDF solution package. And with our in-house PDF creation technology baked directly into Able2Extract, the PDF converter can accomplish a whole new set of PDF tasks from creating PDFs to editing your PDF pages.
Here’s what you’ll find in this latest version.
Create Professional PDF Documents
We made it super easy for you to create a PDF file from any document, whether it’s from within Able2Extract itself or through the brand new virtual print driver.
The process is just as easy as converting a PDF file with Able2Extract. From the Command toolbar, click on the Create PDF icon, select your file and simply save it to your computer.
New PDF Creation Options
If you’ve used our PDF creation tools before then you’ll know which creation features you have at your disposal. PDF creation options include:
Compression- Choose from LZW, JPEG, and ZIP for your images
Security-Apply passwords and file permissions
Font & Colours- Specify if you’d like to embed orsubset fontsor convert CMYK to RGB
PDF viewing- Decide how you want your PDF to display when opened
MS Office conversion- Choose from a number of Office-related options such as retaining hyperlinks, bookmarks, and comments from Office documents
PDF Creation Security Features
As part of your PDF creation options, you can also create secured PDFs. You no longer have to worry if your PDF files are being tampered with or not. You get to choose what people can or can’t do with your content.
Let users copy and paste text, print up the file, or allow them to insert, rotate and shuffle pages. As always, we leave the choice up to you!
Edit PDF Document Pages
With Able2Extract 9, you can go so far as to edit your PDF files. Able2Extract allows you to add and adjust your PDF document’s information, the file’s viewing settings, and editing PDF pages:
Able2Extract Print Dispatcher
Another new feature is the Able2Extract Print Dispatcher. This is an icon that sits in your system tray when you install Able2Extract 9 and allows you to keep track of newly created PDF files directly from your desktop.
It works in conjunction with the Able2Extract Virtual Print Driver. So when you create a PDF document from another application, you can choose how and where you want to open the file. You can also use this to adjust your PDF creation options when using the Virtual Print Driver to create PDFs.
Save Your PDF Creation Settings
Just as you can save your custom PDF to Excel conversion parameters, you can now save your PDF creation settings as a file. This means that for every PDF you create, you can apply the same file settings as required.
Improved PDF Conversion, OCR & PDF Rendering
And now that PDF creation is a part of Able2Extract 9, the PDF rendering and viewing capabilities are better than ever! You can use Able2Extract 9 to view PDFs with the even the most complex of graphical content.
Other enhancements include improved PDF conversion for complex PDF files. And for Able2Extract Professional, we included tweaks to the OCR engine, providing you with even more accurate renditions.
Test out and check out all of these newest features here. Existing Software Advantage Plan users can upgrade to Able2Extract 9 from their account dashboard.
Give it a try and don’t forget to let us know what you think of this latest version!
To help keep our customer service consistent across the board, we updated our support system a few months ago to include our Software Advantage Plan. The plan, aimed towards improving the quality of your one-on-one service, essentially gives you priority status for customer support.
But that’s not all. The Software Advantage Plan also comes with a number of membership perks–one of which is exclusive access to special builds and full product upgrades.
And if you’re an Able2Extract user on the hunt for software deals, this is the perfect perk to cash in on for Black Friday.
This is because in just a few days we’ll be releasing the all-new Able2Extract v.9.0, which will let you edit and createPDF files! No extra add-ons needed.
If you get the Software Advantage Plan now, you can get the Able2Extract 9 upgrade right before it’s released to the public!
It’s a deal you don’t want to miss out on.
Here’s what the plan includes.
Software Advantage Plan
As a Software Advantage Plan subscriber, you get:
-Own Priority Support: Get your issues to the front of the line and get support when you need it most.
-Access to the Software Advantage Plan Web Portal: Log in to the Software Advantage Plan web portal and get hands on, direct access to customer service. Submit your issues to us directly, check in on the status of open requests, and find product updates and upgrades for downloading.
-Quick Response Times To Your Issues: Get faster insights on your conversion issues and tailored solutions that can be implemented immediately.
-Annual Product Updates: We’ll send you an email notification when a new update is available so you’re constantly using the latest PDF converter technology.
-Exclusive Access To Unreleased Builds: Users get to download and test out our latest product builds. All subscribers get the first taste of our Able2Extract v.9.0, which includes PDF creation and PDF page editing! Test out the product and its newest features before its public release.
We offer the Software Advantage Plan for only $39.95/year where you will basically own Investintech support for our Able2Extract desktop products, both Standard and Professional versions.
As soon as you purchase a subscription, you are automatically registered and can take advantage of your membership right away.
You’ll receive a Software Advantage Plan code you can reference when you phone in or send us an email. It will automatically give your issue priority status, and will be immediately forwarded to and addressed by our customer support agents.
If you’re looking for a Black Friday deal, this is it. Subscribe to the Software Advantage Plan and get the Able2Extract v.9.0 upgrade free!
We’re sad to see it go, but we hope you all enjoyed it while it lasted. We appreciate all the comments and feedback you’ve given us in the past. It was great to see everyone participating and spreading the word about it.
When you need to learn about something, the Internet is the number one resource to scout out. And given the amount of information you can find online, no matter what area, industry, or topic you’re researching, a huge chunk of your time will be spent recording the research you find.
As you can imagine, combined with the web pages you have to go through, this can slow you dow big time. That’s why some users like to keep their workflow online with tools like Google Drive. But if you’re using Google Drive to quickly record data, then your biggest challenge lies in working between your research and how you use Google Drive itself.
If you’re writing for an online publication, are drafting a research paper, or are reporting on industry trends, accessing the information you record is perhaps one of your main priorities. To make things easier, try a few of the Google Drive tips below to keep your research going smoothly.
1. Perform A Google Drive Search from Chrome
Because you can need a document at any given time, it’s important to be able to pull up the right file in an instant. Google Drive Quick Search makes it easy to start a search through your Drive directly from the Chrome URL address bar. Type “drive” in the address bar, your keywords and query, then hit enter. You’ll be directed to your drive with the related results ready and waiting for you to sift through.
2. Save Your Text to Google Drive
Save Text to Google Drive does exactly what its name implies. This Chrome extension makes it super easy to export heavily dense text webpage research from the web directly to your Google Drive.
Once installed, simply highlight the text you’re interested in, activate the extension by clicking on it in your toolbar or extension menu, and click on the Save button. The extension will create a document with the text in the Drive you’re logged into.
3. Quickly Access Folders and Create Google Docs From Your Toolbar
To access folders and separate files instantly, simply bookmark the URL of the file or document on your toolbar. Open the file or folder in Google Drive and bookmark the URL you see in the address bar. Admittedly, this is a simple tip, but extremely handy if you like keeping things at your fingertips.
Moreover, this trick also works with creating new documents. Because the functionality is web based, you can bookmark the command URL to your browser. Copy these links to your Chrome toolbar by right clicking on it and selecting Add page… or via the Bookmark Manager:
Don’t waste time going back and forth between your Google Drive and Gmail. You can do both at the same time by adding the Apps Search for Gmail extension. This is handy for when you’re either exchanging emails regarding your research project or are working with colleagues.
It will let you extend your search to Google Docs to fish out the files you’re looking for. You can add the extension by going into Settings>Labs from your Gmail. Then select to enable it for your account. Don’t forget to hit the “Save Changes” button at the bottom.
5. Edit PDF Text Uploaded To Google Drive
Because a lot of research comes in the PDF format, you may want to pay attention to the “Convert Text from Uploaded PDF and image files” setting. Have you been ignoring it? Well, it’s time to start paying attention to it. This setting allows you to convert PDF to text which you can then edit within a Google Doc.
Go to the gear icon Google Drive and access the drop down menu. Then go to Upload Settings. From there, put a check mark in the “Convert Text from Uploaded PDF and image files” option by clicking on it. Select the Document language. You can have this permanently turned on, but if you want to use it selectively, keep the “Confirm settings before each upload” option checked.
6. Save Images Directly to Google Drive
Who doesn’t clip web pages when researching online? Good news is you can do it with Google Drive. Save to Google Drive can serve as a simple web clipping tool, allowing you to instantly save content from the web to a Google Drive folder. Once you have it installed, go to the page you’re interested in and activate it by clicking on its button to the right of the address bar. It will then save your content in .PNG format.
7. Access Google Drive And Other Google Services From Chrome
Here’s a great Chrome extension for pushing your research productivity to the limits. Black Menu for Google allows you to access files on your Drive and to your other Google services in a side bar right within Chrome.
Perfect for Google addicts with research spread across different services. You can get the Black Menu extension from the Chrome Web Store.
Got any Google Drive tips of your own? We’d love to hear them! Add them in the comments below and let us know how they helped you deal with your web research.
It’s Thanksgiving weekend here in Canada and we wanted to wish all of our Canadian users and followers a safe and Happy Thanksgiving holiday this year!
A lot of you may be prepping and planning for the holiday as we speak. A major holiday celebration like Thanksgiving is never complete without the festive dinner, family, and the all the fix-ins. So if you’re scrounging around for some last minute ideas to make your get together extra special this year, we’ve scouted out a few Pinterest boards where you can get some fabulous ideas and tips for your Thanksgiving soiree.
Thanksgiving: Freebies: Getting your party together with a few things you can put together for free is always a good way to go. You’ll find some nifty DIY projects for table settings, menu planning, and more.
Thanksgiving (Craft and Food): For anyone who loves giving a personal touch to his or her dinner, this board offers up a carefully curated collection of tutorials and links on handy crafts and food preparation to get things just right.
Only four Pinterest boards may seem like a short list given the size of the network, but if you’ve ever browsed a single board, then you know that one board can leave you with a ton of ideas to explore and keep you busy!