Faster way to get back and forth between different files

January 17th, 2017 No comments

A faster way to get back and forth between different files, in fact different workbooks is Ctrl+Tab back and forth. Now, when you have only two files open, that’s particularly fast. If you have a third file open, Ctrl+Tab takes us to the next one, the next one and then back to the current one and so on.

So the more files you have open, the less efficient that is. But nevertheless, it’s still a reasonable easy thing to want to get to, that idea of switching between open workbooks.

Share
Categories: Tips & Tricks

Enhance your composition by cropping with the Rule of Thirds (Photoshop CS6/CC/CC 2014/CC 2015)

January 16th, 2017 No comments

Oftentimes a less-than-stellar composition can be made better simply by cropping the image! And, there is a built-in feature to the Crop tool that allows you to see the Rule of Thirds grid overlay on your image while you crop. The general concept behind the Rule of Thirds is that if you visually separate your image into nine equal parts with a grid, your main point of interest should lie on one of the intersecting grid lines, because that’s where the viewer’s eye is likely to be drawn. To crop using the Rule of Thirds grid overlay, choose the Crop tool from the Tools panel, and choose Rule of Thirds from the overlay options pop-up menu on the tool options bar. Click and drag a marquee on your image in the size you want to crop, then click and drag to move the crop box until a focal point of your image sits beneath one of the intersecting lines. Double-click to commit the crop, and enjoy your more pleasing composition!

Share
Categories: Tips & Tricks

Authenticate digital signatures with PGP

January 15th, 2017 No comments

Electronic documents and email messages are becoming a commonplace way to conduct business transactions, but it’s important to be able to verify that the author of a document or message is really the person he or she claims to be.

You can use digital signatures to verify identity. This is easy to do with programs such as Pretty Good Privacy (PGP). PGP is based on a public/private key pair; you sign the document by encrypting it with your private key, to which only you have access. The recipient uses your public key to decrypt it. Note that this doesn’t provide data confidentiality because the public key is available to everyone. It does, however, ensure that it was really you who signed it, because no one but you has the private key that’s paired with that public key.

PGP is available in both freeware and commercial versions. You can get the commercial version at http://www.pgp.com or the free version at http://www.pgpi.org/products/.

Share
Categories: Tips & Tricks

Assign Categories To Calendar Entries For Easy Reading

January 15th, 2017 No comments

If your calendar is filled with not only your work tasks, but also your personal appointments and your boss’s meetings, you may look at it and wonder what you’re supposed to do next.

If you’re using Microsoft Outlook, you can assign categories to your appointments and then choose to view only one category at a time.

To add a category to a calendar item in Microsoft Outlook:

  1. Click on the Calendar icon in the Navigation Pane (click on the Calendar folder in the Folder List in 2000 and 2002).
  2. Launch a new Meeting or Appointment form, or double-click on an existing event to open it.
  3. Click the Categories button at the bottom of the form.
  4. Select the appropriate check box from the Available Categories list box, or enter a custom category in the Item(s) Belong To These Categories list box, and then click the Add To List button.
  5. Click OK to close the Categories dialog box.

To display your calendar by a category:

  1. Click on the Calendar icon in the Navigation Pane (click on the Calendar folder in the Folder List in 2000 and 2002).
  2. Choose View | Arrange By | Current View | Customize Current View from the Outlook menu bar (View | Current View | Customize Current View in 2000 and 2002).
  3. In the Customize View dialog box (View Summary in 2000 and 2002), click the Filter button.
  4. Click on the More Choices tab in the Filter dialog box.
  5. Click the Categories button. Then, select the category that you’d like to print from the Available Categories list box.
  6. Click OK three times to return to the Calendar.
Share
Categories: Tips & Tricks

Make The Best Use Of Worksheet Hyperlinks

January 15th, 2017 No comments

When you think of worksheet hyperlinks, you probably think of website links. There’s another great use for hyperlinks in your workbook that you might not use to its full potential: internal links. You can create a hyperlink that takes you to another location within the same workbook when you click on it.

For example, if your workbook contains an Overview worksheet, which refers to more detailed data in other worksheets within the same workbook, you might want to allow users to quickly jump to that data.

To create an internal hyperlink:

  1. Launch Excel and open the workbook to which you want to add an internal hyperlink.
  2. Select the cell you want to make your hyperlink.
  3. Choose Insert | Hyperlink from the menu bar or press [Ctrl][K] to open the Insert Hyperlink dialog box.
  4. Click the Place In This Document icon on the left.
  5. Specify the text you want the linked cell to display in the Text To Display text box.
  6. Enter a cell reference for your hyperlink destination in the Type The Cell Reference text box and choose a worksheet from the list box. Note that any named ranges in the workbook are also available as hyperlink destinations.
  7. Click OK to create the hyperlink.

Now when a user clicks on the cell that contains the specified text, the active cell jumps to your specified destination.

Share
Categories: Tips & Tricks

Keep your PowerPoint presentation from holding on to useless data (2000/2002/2003/2004)

January 15th, 2017 No comments

One way to avoid a large file size is to never edit your file once you’ve created it. Don’t worry; we know this isn’t a practical solution. However, you can trick PowerPoint into treating your old file as if it’s a brand new file. When you accomplish this, PowerPoint deletes all of the digital clutter that gathers throughout your edits and your file size can shrink dramatically.

The reasons for all of this digital clutter are murky and technically complicated. So, for the purposes of this tip, we won’t bog you down by digging too deep into what causes the problem. Suffice it to say that your file size is often inflated due to an abundance of unnecessary information. To rectify this situation, simply open your presentation, choose File | Save As and save your presentation with a new name. If you want, you can delete the file with the original name, then open up your newly named presentation and rename it again with the original name. (It won’t shrink a second time, but this additional step can help you out if you need to stick with a particular filename.)

Now, compare the size of your new file with the size the file was prior to being renamed. In many cases, you’ll find that even though the presentation contains the same information and looks exactly the same, its size is smaller.

 

Here’s a way to reduce your file’s clutter behind the scenes.

To help keep PowerPoint from accumulating unnecessary temporary data in the future, choose Tools | Options (Edit | Preferences on the Mac) and click on the Save tab. Then, deselect the Allow Fast Saves check box and click OK. Even after you’ve deselected this option, you can still try the renaming trick to see if you can scrub your file even further. File size isn’t the only thing that benefits from this kind of digital cleaning — files that are free of digital clutter are also less apt to freeze up and get caught on other unforeseen technical snags.

Share
Categories: Tips & Tricks

Avoid a security fiasco with configuration auditing

January 15th, 2017 No comments

When a system is compromised, there are a number of best practices for investigating the breach properly. But what if you don’t know the system has been compromised? For every Target story, there may be many other businesses with stolen data or other security breaches, but they just don’t know it. One way to avoid being one of them is to comprehensively audit your systems.

There are a few different products that can help you audit the configurations of your IT infrastructure and alert you so you know if anything got changed and who changed it. Generally, these products can help you monitor changes in Active Directory, SharePoint, Microsoft Exchange Server, VMware, and other software. Some of the companies in this space also offer free auditing tools in addition to their full-fledged software. Here are three of the major players for auditing in a Windows environment:

Whichever product you go choose, the important thing is having (1) a solution in place to alert you to any possible security problems, and (2) a viable plan of action for when an alert occurs.

Share
Categories: Tips & Tricks

Don’t let drive encryption risk losing your files

January 15th, 2017 No comments

Drive encryption can help prevent sensitive data in laptops from being stolen. However, if a user forgets his or her password for a computer whose drive is encrypted with a tool such as BitLocker, the prospects for recovering files are much worse than otherwise. Without drive encryption, there are many hacks to recover files without a password, such as booting from an Ubuntu disk. But if the drive is encrypted, you won’t be able to see much once you get in.

To avoid this scenario, it’s wise back up BitLocker recovery information to Active Directory Domain Services (AD DS). That way, as an administrator, you can recover the drive when necessary. This is also helpful in cases where users leave the company suddenly.

To back up BitLocker recovery information with AD DS, your domain controllers must be running at least Windows Server 2003 SP1 or later. The configuration procedures differ depending on the operating system and whether AD DS was set up before or after enabling BitLocker. To read about backing up BitLocker recovery information for Windows 2007 and Windows Server 2008 or earlier, go to this link:

http://technet.microsoft.com/en-us/library/dd875529%28v=ws.10%29.aspx

For Windows 8 and Windows Server 2012, follow these instructions:

http://technet.microsoft.com/en-us/library/dn466534.aspx

Share
Categories: Tips & Tricks

Retrieve wireless password information through the Windows command line

January 15th, 2017 No comments

While Windows automatically saves wireless security keys for you, you may sometimes want to check what the security key is. This can be helpful if you need the password in order to connect another device to the same wireless network. Using the command line to do this is particularly helpful, since it works the same way in most Windows versions, including both Windows 7 and Windows 8. Just run cmd.exe as administrator and enter the following command (replacing in the actual SSID name of the network):

netsh wlan show profile name=”SSID name” key=clear

The password will show up to the right of “Key Content.” Note that if you’re not running cmd.exe as administrator, you may not see this entry, even though you’ve included “key=clear.” If you’re not sure what the SSID name is, you can first enter the following command to retrieve a list of network profiles stored on the computer:

netsh wlan show profiles

Share
Categories: Tips & Tricks

Explore Python, Ruby, and JavaScript variants online

January 15th, 2017 No comments

With the proliferation of languages used for web development, it helps to have an easy way to try them out. Repl.it is one online emulator that allows you to explore different languages for free without having to install them locally. In addition to JavaScript and various extensions to it (such as Kaffeine and CoffeScript), repl.it emulates some popular server-side languages such as Python and Ruby. To get a menu of the different languages the site supports and launch the one that interests you, go to the following page:

http://repl.it/languages

Share
Categories: Tips & Tricks
Истёк срок регистрации доменаmega-rating.ru