Emerald Green Software

My mother has wanted to put together a slide show for her blog, the ones where she has a lot of pictures she wants to upload anyway.  After a little checking I found the site authorSTREAM which offers free streaming of uploaded powerpoint slideshows, a function which seems perfect for this sort of application, since they not only allow pictures but voiceover as well.

So as a test, I?ve signed up, made a powerpoint slideshow of a few hardware pictures I?ve took a while back, and I?ve just uploaded it.

Now the site takes a few minutes to process the uploaded files for viewing, at which point I?ll confirm that the embedding process actually is as simple as it seems by trying the embed here.  If it works, that means I?ll have a complete set of simple options to go over with mom.

Ok, let?s try it now:

OldPCSlideshow

See more presentations by BNavigator | Upload your own PowerPoint presentations

Now it?s just upload, and make sure it plays right.

Ok, had to mess with a few permissions, but it it seems to have embedded just fine.  It seems to be loading really slowly though, I?ll have to check to see if that?s the network or something else.

Curious, on chrome it isn?t finishing loading, but firefox loads it just fine.  Same with Internet Explorer.  Well, I?ll just delete and redo the upload and see if that changes things

Excel, Open Office Calc, Google Docs.  There are other spreadsheets of course, though the differences between them are either cosmetic, or involve things that only power users would really think about.  Excel is the Microsoft Office spreadsheet, which is the industry standard, and is part of every Office suite sold by MS.  Open Office is an alternate free office suite developed as an alternative to MS office.  And Google Docs are a ?Cloud based? program, designed to run all the programs on Google?s servers and let you use them from any web browser on any internet connected computer.

All three programs work very similarly.  At heart, spreadsheets are all about the cells.  Since it?s tax time, one example would be to create a column, B for instance, where you would specifically record income received, or several columns for recording multiple types of income that might be seen differently when it?s time to calculate your taxes.  I?m leaving Column A unmentioned, because that?s almost always used to record the extra information- The month, the specific date, etc.

The real magic of spreadsheets however is functions.  You can use them to work pretty much any sort of mathematical calculation on the data in the various cells.  Indeed, in smaller countries, most of the economic analysis is done with spreadsheet programs.  But for most people, the Sum and Product functions are all you need.

To put a function in a cell, click the cell to select it, then click the in excel or open office, or in google docs for the function wizard where you can work out you?re full equations.Sum is the function that will add up all the numbers in a group of cells.  You can also subtract either static numbers or the contents of other cells by typing ??? in front of what you want subtracted.  The example here is excel which add the contents of cell B11 to 42, then add the contents of Cells C9 ?C15.  I?m using a blank sheet to make the example, so naturally the result is 42.  If I wanted to subtract B11, or 42, or the group of cells, clicking in front of the number.

You can click any cell in the spreadsheet to add it to the numbers, to select a range, click the start, then click the end while holding down shift.  If you want to add up everything in a column, click the column?s letter at the top of the screen.  If there are a few cells in a column you want excluded, hold down CTRL while clicking those cells.

The product function works the same, except in multiplies numbers together.  You can also put functions inside other functions, but that?s something to pick up over time.

One other thing to remember about functions, when you cut and paste one, it will automatically adjust itself to it?s new position.  For instance, if you?ve set up your spreadsheet so row 4 lists one type of data, and you put a function in cell B4 to sum up the totals in cells D4, F4, H4, J4, and so on however far, if you?ve got a similar set up on row 6, instead of repeating the setup for the function, if you select cell B4 and use Ctrl C to copy it, you can then click cell B6, and use Ctrl v to paste the function, and it will automatically adjust to sum up D6, F6, H6, J6, etc.

So, for tax season you can maintain a spreadsheet where you maintain predesigned column?s and rows for specific income, expenses, deductions and other information.  When it?s time to figure out the numbers for your forms, you can use the sum function to rapidly add up everything , and the product function to work out all the percentages and fractions at play.  Though if you do a bit of searching on your spreadsheets support site, you?ll probably find a template that?s already designed to have all the labeling and calculations worked out in advance for you.

A few other spreadsheet tips.  Odds are you?ve already had some advice on how you can adjust the size of columns by hovering your mouse cursor over the line between cells until it changes to a double headed arrow pointing to both sides, then clicking and dragging the mouse out to the size you want.  But if you want to resize a bunch of cells to the same size, you can select them by clicking the first then holding shift while clicking the last.  Then when you click and drag to resize one column, every selected column will resize the same way.

Also, if you consider the Sheet listing in the lower left, multiple sheets is a very useful way to separate many different types of data, like different types of income, or specific car or medical expenses.  And because functions work across sheets, you can create a summary sheet where you set up cells to maintain the totals of the data in the other sheets.  In the sheet where you want to gather all the information, click the cell where you?ll want that total, Click the Function button, and select Sum.  Then after clicking a box for numbers, click the name of the sheet where the data is in the lower left, select the cells with the data in that sheet, and either click OK, or select another number box if you want more numbers.

You can individually name each sheet by right clicking it?s tab and selecting Rename from the pop up list it generates.

There are a lot of ways to slip up and find your computer infested with Malware.  Well, whatever the circumstances, you?ll want to get rid of it once you know it?s there.

First off, you will want to figure out what?s on your machine.  Here?s a few of the online virus detection resources:BitDefender?s Online Malware Scanner, Kaspersky?s Online Malware Scanner, TrendMicro's Housecall, Mcafee?s Online Malware Scanner, Symatec?s Online Security Scanner.  You might want to use more than one of them, though not at the same time.

The first thing to do is download and install a legitimate antivirus-antimalware program with the latest updates.  After installation it will immediately run a scan of your system, give it time to work, and with luck it will find and with your permission remove all the malware.  Some good free antivirus programs with antimalware features too include AVG Free, Avira Antivir personal, and Avast Home edition.  There are also some standalone antimalware programs that can effectively supliment these, including Spybot ?Search and Destroy, Malwarebytes, and Ad-Aware Free.  The last two only have proactive functionality for their paid versions, but the free version offers plenty of power for Malware removal.

Even if your program can?t get rid of the malware, it should be able to identify it, and there?s a chance you could find a specially crafted tool to remove it with a google search.  Just double check the tool before downloading, to be sure it?s legitimate.

With a little luck, all you have to do is download the right cleaning program,and install and run it to clean out your computer.  Unfortunately, not all malware writers will make it that easy.  Many types of malware will prevent your system from installing antivirus software, or will make it crash when it tries to run, or will have been designed in a way that makes it hard for antivirus programs to get rid of them.

Time for the first escalation ? Reboot to Safe Mode.  Basically just shut down your computer, give it a few seconds to start booting up and start tapping the F8 key above your keyboard?s number keys.  This should offer the option to boot into safe mode, which boots your computer in the most bare bones almost nothing running setting as possible.  Which means that the malware you?re after is less likely to be able to interfere with your ability to install and/or run your antimalware program.

But if you can?t get rid of Malware even from Safe Mode, there?s another escalation to try ? System Restore.  There are a series of files and settings that control what programs work on your system and how they work together.  As a precaution against problems, your system periodically creates copies of these files and settings at various points.

Use the windows button to open the menu list, and go to accessories.  Then to System tools in the accessories submenu.  There you should see the icon to double click to open the System Restore option.  Open it, and assuming system restore was turned on (Which it is by default), you should have an assortment of restore points representing various moments when you installed different programs, changed settings, and generally made changes.  If you see one dated at a point when you?re pretty sure malware wasn?t installed on your system, select it and run the restoration.

After a few warning system restore will run and with luck erase all the connections the virus has to your systems.  Of course, it will also erase all the connections of any program you installed after that restore point was created so you may need to reinstall some of your programs to make them work again.  After running your antimalware program and hopefully getting rid of the now impotent malware file of course.

Sometimes though, even system restore will be compromised.  At this point, your pretty much stuck with the final option of reinstalling windows.  If possible, your goal should be to perform a Repair Install.  There?s slight differences for Windows XP and Vista.  A repair install will install the OS off the CD without getting rid of all the files on your disk.  Of course, it will remove most of the integrations between the programs and the OS and erase all the updates, so you?ll have to then invest a bit of time into updating the system and reinstalling all your programs.  I?d advise you to install your antivirus first, and let it take it?s time running it?s scans.  While the repair install should have rendered the malware impotent, it will still be there and should be eliminated promptly.

If every other option is lost, you can still run a clean install.  This will erase everything from your hard drive and reinstall the OS.  Naturally before you do this (And indeed before you try some of the earlier steps, just in case), you should download all your important documents and data off your current hard drive onto whatever sort of removable media you can use.  I myself would favor a portable hard drive, which are pretty affordable nowadays.  Just make sure not to try redownloading your data until after you?ve installed all your system?s updates and an antivirus.  And have that antivirus scan your portable drive for any virus?s that hitched a ride.

Of course, if you?re investigating Malware because it?s interfering with your systems performance, you may find it hard to extract your files and data.  Fortunately if you have any access to a clean computer with a working cd burner you?ve got a solution- Ubuntu.  I could talk a bit about Linux and Ubuntu, but all you need to know is that a Linux LiveCD is a freely available OS that can run off the cd, and can also access your disks just like your regular OS.  Just get whoever has the clean computer to download a recent Ubuntu Iso, burn it to a CD, and then you just have to load it into your PC?s optical drive and reboot.  At which point, I could go into the process of getting your data, but it?s been done with screenshots Here.

When you're browsing on the internet, even with the good popup blockers incorporated into every modern browser, a few will get through. And when you get rid of them, you have to be careful because not all popup's are benign. One favorite malevalent popup looks a lot like the standard alert window and reads "Warning, your computer is infected with Spyware! Please Run a full scan" Or "Please click here to download Spyware remover."

Naturally, clicking yes will usually INSTALL spyware on your system, and often also a "Spyware removal" Program that does nothing useful, but keeps putting up big messages of how you need to pay to set up the full version.

And the nasty thing is that some of the malware writers have mannaged to set up commands to try and interpret anything, including clicking the shutdown button in the top right corner of the popup as a command to download the malware.

Fortunately, there's a very simple way to shut down the problematic window without actually clicking it. In the toolbar at the bottom of the screen, a separate item opens for each separate window. Moving the mouse over the item and clicking it will reveal the menu.  As you can see, it not only offers a way to close the program, but also reminds you of the keyboard shortcut to do so(The Alt key is by default next to the keyboard, and the F4 key is above the number keys.  You work the shortcut by holding down the Alt key and the tapping the F4 key).  Clicking Close should shut down the popup without problem.  You can also use the keyboard shortcut to shut down the popup, but you have to first bring the popup to the front of the screen by clicking it?s button on the taskbar  (Which is why I tend to use the right button..

Either option will usually be all you need.  However sometimes, a popup can be engineered so that it's even harder to close, generating authorization requests that can disrupt the right click menu trick.  Now with a little patience and judicious use of Alt+Tab to target the bad stuff, you can use to Alt and F4 shortcut to whittle down the authorizations and popup's anyway's.  But if you can't remember the correct keyboard shortcuts (I usually have to right click to look it up myself), there's a fast alternative.  Ctrl+Alt+Del.

A lot of windows users called Ctrl+Alt+Del the three fingered salute back when it was used mainly as a shortcut to shut down the system in the earliest windows version.  In the modern operating system though it's much more versatile.  Holding down the Ctrl and Alt keys  (Which should both be on the same line as the spacebar), you then tap the Del or Delete key.  In XP this loads the Task Manager, in Vista you get a list of several options, including to load the task manager.

In any case, what you want to do is open the task manager.  It's actually a very useful program that not only let's you look at various programs running on your system, but also lets you review hidden processes, check how your system's performing and more.

But for now the goal is to kill the popup.  I'm demonstrating with a benign popup of course, but the task manager is also the best way of killing malicious popup's too.  Just click the popup so it's highlighted, then click the End Task button at the bottom of the task manager window.  If there's anything making it tricky to shut down the program it might open a message window saying that the program isn't responding and asking if you want to shut it down or wait.  Clicking Shut Down will basically override all the tricks and shut down the popup without offering any chance for other built in tricks to try to start.