Geeks in Phoenix

Geek Blog


Creating stunning documents, spreadsheets and slide-shows with OpenOffice 4

With the cost of Microsoft Office going up, not to mention the subscription / non-subscription thing, it's nice to know there are alternatives out there. One of the best office alternatives has to be OpenOffice. And it just so happens that the Apache Software Foundation recently released a new version of their free productivity software, OpenOffice 4.

The main screen inside of OpenOffice 4
The main screen inside of OpenOffice 4

For those who are not familiar with it, OpenOffice is a suite of office productivity programs that rivals Microsoft Office. It has everything you could need for creating great-looking documents, spreadsheets, and slideshow presentations. Here's a complete list of all of the programs included in OpenOffice 4.

Program Equivalent to Program type
Writer Microsoft Word Word processor
Calc Microsoft Excel Spreadsheet
Impress Microsoft PowerPoint Multi-media slideshow presentation
Draw Microsoft Paint Graphic design
Base Microsoft Access Database
Math Design Science Mathtype Formula creation

OpenOffice 4 has some significant improvements over previous versions. A new Sidebar contains the most commonly used functions for that program, which can be docked, floating, or completely hidden. There is also much improved compatibly with Microsoft Office documents. The drawing, graphics, and gallery functions have also been enhanced, along with the copy & paste and drag & drop functionality.

The new Sidebar inside of OpenOffice 4 shown docked and floating
The new Sidebar inside of OpenOffice 4 shown docked and floating

OpenOffice does use Java, but it's not required for installation, as it can be added later on. Compatibility with other document formats is pretty impressive, but Star Office is no longer supported. OpenOffice can automatically load/convert and convert/save Microsoft Office (Word, Excel, and PowerPoint) and Design Science Mathtype documents. The only file types that it cannot save to is the Microsoft Office 2007 - 2019 .???x formats.

And since OpenOffice is open-source, there are hundreds of third-party extensions to expand on the functionality of the applications. Add in a copy of GIMP or Paint.NET, and you have a complete and free desktop publishing package.

OpenOffice 4 is available for Windows, Linux, and Mac operating systems. For more information on OpenOffice 4, just follow the links below:

Apache OpenOffice Open Source Project

Download OpenOffice 4

Sync data between your PC and smartphone with CompanionLink

Like a lot of people, I use Microsoft Outlook as a PIM (Personal Information Manager). And being in the computer repair industry, I need to keep all of my data (contacts, calendar, etc.) synchronized and up to date on both my PC and smartphone. I found I can do all of this quite easily with CompanionLink.

CompanionLink 5 for Outlook setup screen
CompanionLink 5 for Outlook setup screen

I wrote an article a while back about syncing Outlook with my Android phone using CompanionLink on my PC and DejaOffice on my Android. It works because you install CompanionLink on your PC or Mac and install DejaOffice on your Android, iPhone / iPad, Blackberry, etc. You then define what database (Outlook, ATC!, etc.) and what fields (contacts, calendar, etc.) you want to sync.

DejaOffice 2.2 main screen
DejaOffice 2.2 main screen

Recently they released a new version of both CompanionLink (V5) and DejaOffice (V2.2) with more capabilities and features. They have multiple versions for different applications (I use CompanionLink for Outlook). Here's a quote from their website on the products they offer:

Our products work with Android, iPhone, iPad, BlackBerry, HP webOS, Palm OS, and Windows devices. We also sync with Google, Gmail, Google Apps, and Windows Live (Hotmail) accounts

CompanionLink for Outlook
Sync Microsoft Outlook with Android, iPhone, iPad, BlackBerry, Windows Phone, or any Google/Gmail account. Supports two-way sync of contacts, calendar, tasks and notes.

CompanionLink for Palm Desktop
Sync Palm Desktop or Pimlical with smartphones, tablets, or any Google/Gmail account. Supports two-way sync of contacts, calendar, tasks and memos.

CompanionLink Express
Sync ACT!, Lotus Notes, HighRise, or GroupWise with smartphones, tablets, or any Google/Gmail account. Supports two-way sync of contacts, calendar, tasks and notes.

CompanionLink Professional
Sync Salesforce CRM, Goldmine, or any other supported database with smartphones, tablets, or any Google/Gmail account. Includes all the features of CompanionLink Express, plus the ability to sync to from multiple databases, sync with up to 5 devices, and advanced sync options.

CompanionLink for Google
Sync Microsoft Outlook contacts and calendar to Google Contacts, Google Calendar, and Google Tasks. Works with any Google, Gmail, or Google Apps account. Two-way sync is fully supported so you can make changes to data in Outlook or in Google.

CompanionLink for Outlook.com / Windows Live
Sync Outlook with your Windows Live Hotmail account. Supports two-way sync of contacts, calendar, and tasks.

CompanionLink for Time & Chaos
Sync Time & Chaos with smartphones, tablets, or any Google/Gmail account. Supports two-way sync of contacts, calendar, tasks and notes.

CompanionLink FA
Sync Wise Agent, Infusionsoft, SalesJunction, or Respond with smartphones, tablets, Outlook, or any Google/Gmail account. Supports two-way sync of contacts, calendar, tasks and notes.

CompanionLink for Mac
Sync Mac's Address Book and iCal with any Android device. You can also keep Outlook for Mac in sync with Android. Requires OS X Lion (10.7) or Mountain Lion (10.8).

For more information on CompanionLink and DejaOffice, follow the links below:

CompanionLink

CompanionLink FAQ's

Using the Microsoft Web Platform to create web apps and websites

When it comes to a complete set of website development tools, nobody does it better than Microsoft. From web server (IIS), database server (SQL), framework (.NET), and development tools (Visual Studio), Microsoft has quite the offering. They even created an application to install it all, the Web Platform Installer (WebPI). And best of all, they're free!

Spotlight view inside of the Microsoft Web Platform Installer v4
Spotlight view inside of the Microsoft Web Platform Installer v4

Using the WebPI application, you can download and install all of the programs you need to create and publish a website. You can even download various web apps like WordPress or DotNetNuke. The app categories range from blog and content management system (CMS) to e-commerce and galleries.

Appilcation view inside of the Microsoft Web Platform Installer v4
Application view inside of the Microsoft Web Platform Installer v4

And with the release of Windows 8 and Windows Server 2012 on the horizon, Microsoft is starting to roll out new versions of quite a few of these programs. Here's a quote from Microsoft's site:

With the Microsoft Web Platform you get more than just a powerful set of tools, servers and technologies. You get a complete eco-system of products, technologies and partners all looking to help you succeed on the web.

Powerful Framework
ASP.NET Framework ASP.NET is a free, fully supported Web application framework that helps you build standards-based Web solutions by providing a rich set of features and easy integration with databases and web services.

Flexible Web Server
IIS Web Server Internet Information Services provides a secure, easy-to-manage Web platform for reliably hosting ASP.NET and PHP web applications on the same server.

Robust Database
SQL Server SQL Server® is a complete database engine for running high performance web applications. Easily create data-enabled web applications with SQL Server's support for LINQ, Entity Data Model, and ADO.NET.

Complete Tools
Microsoft Web Design and Development Tools Visual Studio®, Expression Web® and Windows Internet Explorer® with its built-in developer tools, provide a complete environment for building standards-based web sites, applications and services.

Here's a partial list of some of the recently updated applications:

  • Visual Studio Express 2012 for Web
  • Microsoft SQL Server 2012 Express
  • IIS 8.0 Express
  • .NET Framework 4.5

For more information on the Microsoft Web Platform, follow the links below.

Microsoft Web Platform Installer

Store, access and share your files on the cloud for free with Google Drive

Updated November 23, 2020

Being in the computer repair business, I find myself going between my workstation, netbook, and smartphone quite often. I need to view/edit files on all of my devices and have the changes synchronize back. I am talking about any file, not just MP3's and JPG's. I can do just that and more for free with Google Drive.

View of Google Drive from inside of Windows Explorer
View of Google Drive from inside of Windows Explorer

Google Drive, a cloud-based storage solution, is the latest addition to Google's catalog of products. With the Google Drive application installed on your computer, smartphone, or tablet, you can view/edit files on that device using the programs installed on it. The files then sync back to the Google Drive servers when they are closed. I found it great to synchronize files/folders between my workstation, netbook, and smartphone.

View of Google Drive inside of a web browser
View of Google Drive inside of a web browser

Or you can use a web browser to view/edit files directly on the cloud with the web-based Google Docs (you get instant access when you sign up for Google Drive). Google Drive integrates into Gmail, so you can e-mail and share files with one click. You get 15 GB's of space for free, with more extensive plans (up to 16 TB) available. There are also business plans. Here's a quote from the Google Drive website:

Google Drive. Keep everything. Share anything.

Access everywhere.
Google Drive is everywhere you are on the web, in your home, at the office and on the go. So wherever you are, your stuff is just...there. Ready to go, ready to share. Get started with 15 GB free.

    Google Drive is available for:
  • PC and Mac
  • iPhone and iPad (coming soon)
  • Android devices

Store your files in a safe place.
Things happen. Your phone goes for a swim. Your laptop takes an infinite snooze. No matter what happens to your devices, your files are safely stored in Google Drive.

Go beyond storage. Collaborate.
Google Drive lets you do more than just store your files. Share files with exactly who you want and edit them together, from any device. Google Drive gives you instant access to Google Docs, a suite of editing tools that makes working together better, even when your teammates are miles away.

Work better with the products you use everyday.

Gmail
Say goodbye to bulky email attachments. Send a link from Google Drive in Gmail and everyone has the same file, same version—automatically.

For more information about Google Drive, follow the links below:

Google Drive

Google Drive Features

Clean up and optimize your computer for free with CCleaner

Updated August 20, 2023

Do you want to clean up and optimize your computer but don't know where to start? Maybe you want to clean out all of the temporary Internet files for security purposes. Or clean up all of the temporary files from other applications to free up some space on your hard drive. You can do all of this and more for free with CCleaner.

The Custom Clean tab inside of CCleaner
The Custom Clean tab inside of CCleaner

CCleaner from Piriform is a complete system optimization tool for Windows. It cleans out temporary Internet files from most browsers (Edge, Firefox, Chrome, etc.) and cleans out various Windows files (recent documents, temporary files, search autocomplete, etc.). It can also repair multiple areas of the registry.

The Registry Cleaner tab inside of CCleaner
The Registry Cleaner tab inside of CCleaner

CCleaner can also rename, delete, repair, or uninstall programs listed in the Add/Remove Programs section in the Control Panel and the Apps & features section of the Settings app. It can even manage the system restore points. Here's a quote from Piriform's website:

CCleaner is our system optimization, privacy, and cleaning tool. It removes unused files from your system - allowing Windows to run faster and freeing up valuable hard disk space. It also cleans traces of your online activities, such as your Internet history. Additionally it contains a fully featured registry cleaner. But the best part is that it's fast (normally taking less than a second to run) and contains NO Spyware or Adware! Cleans the following:

Microsoft Edge
Cache, history, cookies, download history, form history, saved passwords, recently typed URLs.

Firefox
Cache, history, cookies, download history, form history, saved passwords, recently typed URLs.

Google Chrome
Cache, history, cookies, download history, form history, saved passwords, recently typed URLs.

Opera
Temporary files, history, cookies, super cookies, download history.

Safari
Temporary files, history, cookies, super cookies, form history.

Other Supported Browsers
K-Meleon, Rockmelt, Flock, Google Chrome Canary, Chromium, SeaMonkey, Chrome Plus, SRWare Iron, Pale Moon, Phoenix, Netscape Navigator, Avant and Maxthon.

Windows
Recycle Bin, Recent Documents, Temporary files, Log files, Clipboard, DNS Cache, Error Reporting, Memory Dumps, Jump Lists.

Registry Cleaner
Advanced features to remove unused and old entries, including File Extensions, ActiveX Controls, ClassIDs, ProgIDs, Uninstallers, Shared DLLs, Fonts, Help Files, Application Paths, Icons, Invalid Shortcuts and more...

Third-party applications
Removes temp files and recent file lists (MRUs) from many apps including Windows Media Player, eMule, 7-Zip, Microsoft Office, Nero, Adobe Acrobat, WinRAR, WinAce, WinZip and many more...

100% Spyware FREE
This software does NOT contain any Spyware, Adware or Viruses.

CCleaner is available in three editions: Free (no support), Professional / Professional Plus, and CCleaner Cloud (business). For more information on CCleaner, follow the links below:

Speed up your PC with CCleaner

CCleaner Cloud for business

Free computer diagnostics

Repairing a PC can sometimes be expensive, and that is why we offer free basic in-shop diagnostics. Give one of our professional and experienced technicians a call at (602) 795-1111, and let's see what we can do for you.

Check out our reviews

Geeks In Phoenix LLC, BBB Business Review

Customer service is #1

Here at Geeks in Phoenix, we take pride in providing excellent customer service. We aim to give the highest quality of service  from computer repair, virus removal, and data recovery.

Bring your computer to us and save

Repairing a computer can be time-consuming. That is why we base our in-shop service on the time we work on your computer, not the time it takes for your computer to work! From running memory checking software to scanning for viruses, these are processes that can take some time.

Contact us

If you have any questions, please feel free to give us a call at (602) 795-1111  and talk with one of our Geeks. Or you can send us a message from our contact page , and one of our Geeks will get back to you as soon as possible. Or you can stop by and see us. Here are our hours and location.

Like Geeks in Phoenix on Facebook

Follow Geeks in Phoenix on Twitter

Watch Geeks in Phoenix on YouTube