Author Archives: emilerennily

Productivity Tips For Windows Users

We live in a world where “optimization” is constantly at the top of our consciousness.  There are all kinds of devices and programs that are designed specifically to help you be more productive and more efficient.  Ideally the systems we use operate with this in mind, but there are always a few things you can do to tweak them so that they work better for you.  Here are some great things you can do to increase your productivity within your Windows operating system.

1.        Configure Your Windows Updates Settings

You know how Windows updates your computer, then you get those horribly annoying pop-ups asking you to restart your computer?  Let’s face it– you probably waste more time clicking the “restart later” button than it would take to just restart your computer.   However, restarting when prompted could cause you to lose unsaved data.  To disable the pop-up, right click on “My Computer,” go to the “Automatic Updates” tab, and select the “Download updates for me, but let me choose when to install them” option, and click okay when you’re done.

2.        Consolidate Your IM Services

How many instant messaging services do you have running on your computer right now?  Most likely, you’ve got a few.  Facebook chat, MSN, AIM, Yahoo!, Google Talk, Lync…. And on and on and on.  You can waste a lot of time simply finding the right service to you to chat with whomever you’re trying to connect with.  Luckily there is a service called Digsby, which you can download onto your computer.  It most likely supports all the IM clients you use, and allows you to manage all your email and social networking accounts right from the window.  It even has tabbed conversations, how cool is that!

3.        Learn Your Keyboard Shortcuts

It is amazing how much time keyboard shortcuts can save you.  You might think it’s not that big of a deal, and that you can use that brain space for something else, but just try it out.  You’ll be glad you did.  You can get a jumpstart on shortcuts by clicking here.

 4.        Reduce Your Auto-Starting Programs

As time goes on, your PC tends to get bogged down with auto-starting programs.  Even if you use these programs a lot, you probably don’t need them to be started every time you boot up your PC.  You can remove unnecessary programs from starting up automatically with an app like RevoUninstaller.  Such a program is great because not only does it help you uninstall, it will tell you whether or not the application is critical to the system, and make sure that it is safe to disable.

5.        Organize Your Programs and Folders in the Start Menu

Put you most visited programs in the Start Menu.  You can also change the number of frequently visited programs Windows automatically displays in the Start Menu to zero.  Do this by right clicking the Start button, making sure the radio box beside ‘Start Menu’ is selected, and click ‘customize.’  The setting will be under ‘programs.’  This will de-clutter your start menu and give you faster access to the programs you want and need to use most.  Happy computing!!!

Five Great Phone Apps To Boost Productivity

One of the best things about having a smart phone is that you can find an app for just about anything.  One of the worst things is that the world of applications is so large it can be overwhelming.  If you don’t know what you’re looking for, you can waste a lot of time browsing for apps to do what you need to get done.  To avoid conterproductivity, here are five applications available  for Android and iPhone that will help boost your productivity and ability to organize your life!

1.       Dropbox

Dropbox is an online backup service that lets you access important files on your phone, on top of other things.  It’s one of the leading services in cloud computing and file sharing, and is incredibly versatile and compatible across devices.

2.        Evernote

Evernote is an organizational and note-taking solution.  It is free, it integrates perfectly with your online Evernote account, and is virtually hassle-free to operate. It allows you to take notes, save ideas, bookmark things you like, and search quickly through your account to find what you need.

3.        Bump

Bump is available for iPhone and Android and works across the two platforms.  It is an app that allows you to share information by literally bumping your phone against someone elses.  It can be used to transfer contacts, photos, and videos.  Very convenient for updating your phone lists.

4.        Google Latitude

This app, while not necessarily an organizational service, has great value for helping you keep “track” of your people.  It allows you to find your friends and family on a map, as well as share where you are with the people you choose.  You can check in to places to let your friends and family know you have arrived safely, and find friends who are near you.  An excellent app for families.

5.        Gcal

Google Calendar is a great app for your phone because of its versatility.  No matter what calendar you’re using on your desktop, Google allows you to sync and share that calendar on your phone, as well as sync up calendars that you need to share with others.  If you already use Google Calendar, you can import a shared calendar with someone who is using Outlook, Thunderbird, or iCal, making calendar sharing relatively easy, regardless of the platform.

Taking A Break From The Digital World

The world we live in is highly digitized.  More than likely, your work involves some level of emailing, reading, documenting, or something else that requires you to use a computer.  Computers drive our free time as well… from reading online news articles, to using social media, to watching videos.  We are plugged in, whether we like it or not.  This constant access to information, via the web, email, etc. can be a wonderful thing, but it can also be overwhelming, overpowering… and cause us to waste a lot of time.  Here are some tips for giving yourself a break from the web.

  • Disconnect when you are done with your work.  That’s right—go offline.  This will force you to focus on work that needs to be done, and it will keep you from checking your email, Twitter account, Facebook profile, and other websites every five minutes.  Don’t worry, you can always reconnect, and the internet will still be there, waiting for you!  If you have it really bad, there are even applications that will allow you to “turn off” sites such as facebook for a certain amount of time.
  • Get away from your desk if you can.  This may give you the opportunity to refresh your brain. The change in environment can do wonders for you.  Is there a park near your office?  A coffee shop by where you work?  Sometimes even slipping away to a conference room for a while will help rejuvenate your interest and investment in the work at hand.
  • Make an Action Plan for Going Online.  If you’re working on a presentation, know what kind of research you’ll need to do.  Set aside a specific amount of time for reading and responding to emails.  Create a task list and stick to it.  The list can be very helpful in realizing how much you have accomplished and when you are getting off task.
  • Work On Your Priorities Offline.    Have an action plan for your offline work as well.  Maybe there is a report you have put off reading.  Set aside time for that.  Create a task list of things you might not normally get to because you’re online.  Your offline time is a great opportunity to knock them out.  Maybe you need to request off for vacation or schedule a doctor’s appointment, or have a conference with your coworkers for brainstorming.  There are tons of things you can get done without being on a computer!
  • Enjoy Your Time Offline!  Some of your best brainstorming ideas may come while you are offline.  Don’t be surprised—you’re giving your brain a chance to concentrate without distraction!  Use your break to do some creative problem solving, finish up writing, and lay out plans for your next projects.  You’ll be surprised what you can come up with and how quickly you can tackle it when you allow yourself a small break from the digital world!

A Basic Intro to Excel Formulas

Excel offers a slew of basic formulas you can use to make compiling data easier.  These formulas can be easily accessed in the “Formulas” tab and are a simple way to do everything from adding totals to formatting dates.  If you are new to Excel and just learning, or need a refresher on what to do, here are some common formulas you can use to create effective spreadsheets.

An Example: Adding Numbers In Different Cells

To add two cells together so the answer appears in a third cell:

  • Type an equal sign in the third cell (let’s call this cell C1).
  • Click on the first cell (let’s say A1) with the mouse pointer.
  • Type the plus sign (+) in the third cell.
  • Click on the second cell (let’s call this B1) with the mouse pointer.
  • Press the ENTER key on the keyboard.
  • The sum should be present in C1.
  • Even though you see the answer in C1, if you click on that cell you will see our formula in the formula bar above the work area.

You can also do this manually.  Either way, the formula should look like this =(A1+B1)

You can do this for any number of cells.  If you are working with more than two cells in a column or row, you can accomplish the same task by typing in a formula using a colon.  That formula looks like this =SUM(A1:A9) or =SUM(A1:D1)

There are several other formulas that operate the same way, and you can create them by substituting the following characters for the addition (+) sign.

  • – (minus sign)
Subtraction
Negation
3–1
–1
  • * (asterisk)
Multiplication 3*3
  • / (forward slash)
Division 3/3
  • % (percent sign)
Percent 20%
  • ^ (caret)
Exponentiation) 3^2

These are the most basic variants on common excel formulas.  As time goes on and you become more familiar with Excel, you will be able to manipulate data in several different and exciting ways.  Once you become accustomed to working with formulas, you’ll find out how much easier they make your work!

Still Using Windows XP?

You’re probably very comfortable with whatever version of Windows you’re using.  Once you’ve come to know and love your operating system, you might fear upgrading to a different version.   If you’re using Windows XP, you’ve probably become comfortable with it and are hesitant to change.  Here are a few good reasons to upgrade from Windows XP.

1. Better Applications!

This is a huge one.  Most of the programs that are being written by Microsoft, from games to utilities, are being written for the Vista/Windows 7 platform.   Upgrading your computer system will give you access to all the cool stuff you wish you had on your computer.

2.   Microsoft Support

You can no longer get free support from Microsoft for Windows XP.  If you need help, you’ll be shelling out some cash.  The only fixes you can get for free are security patches, and in a couple of years those will no longer be available.  All support for Windows XP is scheduled to end in 2014. 

3.  Security

Viruses are a big issues on Windows XP, though it is far more secure than it was. However, it’s still not as secure as Windows 7 or even Mac OS X Lion. If security is one of your top priorities — and it should be — think seriously about ditching XP for something new.

4. Upgrading is Not That Hard

The biggest hurdle that many people face when changing their Operating system would have to be their files. If you have a wealth of information on the computer it is highly advised that you backup all of your personal information on an external hard drive. Windows 7 does make a portion of this easy by allowing direct installation on top of the previous Windows installation, however programs like Microsoft Outlook or QuickBooks would need to have had been backed up manually. If you have taken all the appropriate measures, then you should be comfortable knowing that transitioning to Windows shall be a relatively harmless one.

5.  YOU CAN STILL USE WINDOWS XP MODE!!

Through Windows XP Mode, you can use XP and still get the benefits of Windows 7.   Windows XP Mode is one of the neatest things about Windows 7.   It allows you to run Windows XP in a virtual environment; the old XP programs think they’re on an XP computer, and work as normal. You don’t have to give up the things you love about Windows XP to get the many benefits of Windows 7, so don’t be afraid, and upgrade to a better OS!

Exploring Excel

Excel is one of the most useful programs you have in Windows, but for many, it is also the most intimidating.  It is a great resource for compiling and organizing data quickly and efficiently.  Our next few blogs are intended to help you explore the world of Microsoft Excel, from the basics and advancing to some pretty cool stuff.  To start off, let’s go over some basic cell formatting information.

Cells are the rectangular boxes that appear when you open an Excel worksheet.  They have reference numbers and letters based on what column and row they are in, which gives you an easy point of reference.  Columns run vertically and are listed by letter at the top of the screen, while rows run horizontally and are listed on the left-hand side of your screen.

Each cell in a worksheet can be formatted with many properties. The six tabs of the “Format Cells” window contain all of the formatting options. Multiple cells can be formatted in one step by first selecting the cells by highlighting the ones you wish to format.

To move cell contents, right-click in the selected cell and click Cut. To copy cell contents, click Copy. Then right-click in the new location and click Paste. To paste a group of cells, right-click in the cell where the top left cell of the group should be located, and click Paste. Remove the animated border around the original cell by pressing the ESC key, or start typing in a new cell.

To insert a new row in a spreadsheet, right-click on a row number, and click Insert. Excel always inserts the row ABOVE the row that was clicked on. To delete a row, right-click on the row number, and click Delete.  To insert a new column, right-click on a column letter and click Insert. Excel always inserts the column to the LEFT of the column that was clicked on. To delete a column, right-click on the column letter, and click Delete.

Each cell in a worksheet can be formatted with many properties. The six tabs of the “Format Cells” window contain all of the formatting options. Multiple cells can be formatted in one step by first selecting the cells.  The “Format Cells” window can be accessed in all versions of Excel from the right-click menu. In Excel 2007 and 2010, some formatting options are available on the Home Tab on the Font, Alignment, and Number groups. To see formatting options not displayed, click the little arrow in the lower right corner of the group and the “Format Cells” window displays.

From there, you can format the alignment, font, borders, and data from several different tabs.  You can determine many of the formatting styles for appearance in Excel the same way you would in Word or Powerpoint.  However, as Excel is built to work with numerical data, much of the formatting will deal with formulas you use to populate data in the cells.  We will be exploring data formatting—the most exciting part of Excel—in further posts.  Hopefully this basic introduction helps get you comfortable with Excel.  It’s not too different from other Microsoft applications and can do some very cool things!

Five Quick Internet Tips

We are all quite familiar with the internet by now.  However, there are always things to be aware of when surfing the web.  By knowing a few simple things, you can vastly improve your web-browsing experience.  From being aware of safety issues, to refining your search results, to using a few simple shortcuts, here are five things you can do to enhance your internet experience.

1.  Use Different Search Engines

Google is by far the most popular search engine.  However, the algorithms Google uses to predict what you want may actually prevent you from finding what you need.  Diversify your search by using different sites, such as Yahoo, Ask, and Bing.  Each search engine comes with its own benefits, and you may get better results just by trying your query on a different website.

2.  Be Aware of Your Browser

Internet Explorer, Google Chrome, Safari, and Mozilla Firefox are four examples of popular web browsers.  Just like search engines, each browser has its advantages.  If you use Microsoft Office to manage your email and calendar, there are definite advantages to using Internet Explorer.  Same goes with Google Chrome, if you use Gmail and Google calendar.  Each browser can offer you different things as far as add-ons, speed, and privacy.

3.  Know Your Shortcuts

Here is a quick breakdown of different keyboard shortcuts that will make your browsing go more smoothly:

  • Ctrl-T: Open a new tab in your browser
  • Ctrl-N: Open a new window
  • Ctrl-W: Close the current tab
  • F5: Refresh the current page
  • Ctrl-L: Highlight the URL bar
  • Ctrl and +: Zoom in
  • Ctrl and -: Zoom out
  • Ctrl-0: Return to the default zoom level

4.   Know How To Clear Your Browser History

Clearing your web browser’s cache will save space and time in the long run, and help prevent against viruses and other nasty things nesting in your computer.  How to do this differs for each browser, but typically you can go to the “Tools” menu and click “internet options,” “delete browser history,” “delete cookies,” or “clear cache.”  If you see any of these, you are on the right track.  Automatic settings will usually prevent you from deleting anything you might need, such as downloads, settings, and bookmarks.

5.  Be Aware of Safety Issues

This is really a whole topic in and of itself.    You can protect your personal information by installing anti-virus software, anti-spyware, having a personal firewall,  updating your operating system regularly, and by securing your WiFi.  When it comes to internet browsing, don’t click on pop-ups, never send personal information to a website you don’t fully trust or that doesn’t have authentication, and don’t open any questionable emails.  Use strong passwords with eight to ten characters consisting of numbers and letters, and do not keep those passwords stored on your computer.  If in doubt, don’t check it out!!! Leave any links, pop-ups, or websites alone if they seem fishy.