Back to Top

Tech, Web, Cloud & Cabling Services

Category: Microsoft Office

Software / Microsoft Office Category

Alternatives to Microsoft Office

Takeaway: Microsoft Office is not the only game in town; South Jersey Techies suggests some suitable alternatives for Microsoft Office.

Although Microsoft Office is one of the most popular productivity suites available, it is far from being the only choice available. Here are five alternatives to Microsoft Office that you might consider the next time you are looking to purchase an office suite.

1. Google Docs

Google Docs is a cloud based productivity suite that lets you create word processing documents, spreadsheets, presentations, and drawings. Because Google Docs is a browser based application, it isn’t quite as full featured as some of the other productivity suites. Even so, Google Docs is free, and there is nothing to install on your computer. The interface is completely intuitive and Google Docs can be used to create and edit Microsoft Office documents.

2. LibreOffice

LibreOffice is a free productivity suite that is designed to act as an alternative to Microsoft Office.  Like Apache Open Office, Libre Office offers a word processor, a spreadsheet, a presentation application, a drawing tool, and a database application. In fact, the launch screen is nearly identical to that of Apache Open Office. The reason for this is that in 2010 some of the OpenOffice developers broke away from OpenOffice and created LibreOffice. As such, there are a lot of similarities between the two suites. LibreOffice even supports the use of OpenOffice documents.

3. Kingsoft Office Suite Free 2012

Kingsoft Office Suite Free 2012 is, as the name implies, a free office suite. The free version includes a word processor, a spreadsheet, and a presentation application. These applications look and feel like Office 2010 applications, and the software fully supports the use of Office documents in addition to its own native file format. Also supported are standard file types such as RTF, TXT, and HTML.

4. Apache Open Office

Apache Open Office is a free office suite that can trace its roots back for well over a decade. This open source suite contains utilities for creating text documents, spreadsheets, presentations, drawings, and formulas. Open Office should be easy to use for anyone who is familiar with Office 2010. The word processor and spreadsheet look a lot like Word and Excel. The presentation application looks different than PowerPoint, but contains familiar controls. The suite is capable of opening (and saving) Microsoft Office documents and other common file formats.

5. Office Web App

The Microsoft Office Web Apps are an alternative to an on-premise Microsoft Office deployment. This free suite of cloud apps includes Word, Excel, PowerPoint, and OneNote. Furthermore, you get 7 GB of free storage space on SkyDrive, which is useful for storing your Office Web App documents. Office Web App that isn’t quite as full featured as Office 2010 or Office 2013, but Microsoft does have the basics covered. Besides, it is hard to argue with the price, which is free.

Alternatives to Outlook

Takeaway:  Alternative options for mail client’s that are not as costly as Outlook but offer the same features.

Outlook is one of the most widely used email clients in the business world.  For smaller companies, there are email clients that provide cost-effective solutions.  Other email clients offer a variety of features that are comparable to Outlook.  The most significant means of communication in the office is email; communication will suffer if the email client does not work well with the organizations requirements. 

Opera Mail

BLOG_OperaMail2Opera Mail is free and offered for Windows, Mac and Linux.  This e-mail client supports POP, IMAP (no Exchange support), newsgroups, RSS, and Atom feed.  Opera mail has a fast and simple user interface, thread views, spam protection and allows you to browse websites.

Dreammail

BLOG_Dreammail2Dreammail is free and offered for Windows XP/Vista/7.  This e-mail client supports POP3, RSS, and ESMTP/Google/Yahoo.  Dreammail has multiple accounts and multiple-users setup, templates, signature options, anti-spam, address book, message filtering and a web-mail tool.

iScribe

BLOG_iScribe2iScribe is free and offered for Windows and Linux.  This e-mail client supports POP3 and IMAP, as well as international standards.  iScribe has built-in baysian span filter, frequent updates and can be used from a portable drive.

Postbox

Blog_PostBox2Postbox is $9.95 per license and offered for Windows and Mac.  This e-mail client is best for Gmail but it also supports POP and IMAP.  Postbox has native Gmail label support, fast access to your favorite accounts, social networking integration and you can add Dropbox services.

Evolution Mail

BLOG_EvolutionMail2Evolution is free and offered for Linux (open source).  This e-mail client supports POP, IMAP and Exchange.  Evolution has calendar, tasks, contacts, memos, LDAP compatibility, folder search, encryption, multiple accounts, server support, default plugins, as well as, additional plugins.

 

 

Doomsday – Windows XP End of Life

 

XP

Takeaway:  Risks with staying with Windows XP after April 8, 2014.

Since being release worldwide on October 25, 2001, Windows XP has become one of the most popular versions of Windows.  OEM and retail sales of Windows XP ended in June 2008, while smaller OEMs continued to sell the Operating System until January of 2009.

On April 10, 2012, Microsoft officially announced that as of April 8, 2014 they will end extended support for Windows XP and Office 2003, after which no new bug fixes or patches will be issued.

Organizations may be taking a spontaneous risk and assume that Window’s XP’s prolonged life means major vulnerabilities have been acknowledged and dealt with.  If XP were secure, there still might be application-level vulnerabilities.  Even the ranges of security breaches are inadequate to persuade some organizations that are still using Windows XP to upgrade.  The dynamics that have safeguarded XP’s success are now working against the organizations that stuck by the operating system.

A major aspect attackers assess during their investigation is the operating system and the applications used within an organization.  With Microsoft ending their support, the vendors for applications running on it will most likely end support.

On the other hand, those preparing to continue using XP after the cut-off date, are going to be in a unpleasant situation trying to protect their intellectual property, but can take certain steps to limit exposure to risk.  There are specific technologies you could deploy that will permit you to remain using legacy systems.  Mitigating technologies like Host-Based Intrusion Protection will be able to identify that a vulnerability exists and make that vulnerability difficult/impossible to exploit by applying a virtual patch to those non-supported environments.

However, XP’s acceptance is down to the technology itself and an operating system format that people are content with.  The significant changes with Windows Vista, Windows 7 and especially Windows 8 are the reason people are resistant to change.

To protect and upgrade your home or business

 please contact us 856-745-9990 or click here.

 

Microsoft Word Formatting Tips

Takeaway:  Save time formatting documents in Microsoft Word by using quick tools and tips.

Copy & Paste Methods:

When copying to Microsoft Word, the original formatting is automatically inserted with text and pictures.

1. Copy the content to the Clipboard: [CTRL]+[C] or Highlight content, right click on highlighted content, and select “Copy”.
2. Paste the content into a Word document: [CTRL]+[V] or Home Tab, Paste and then select from the three options (see picture below)

–  Keep Source Formatting (K) – Original Formatting
–  Merge Formatting (M) – New content changed to format already in use
–  Keep Text Only (T) – Generic Format and will only Paste text, no pictures

Paste_Blog041013

Changing the default, as follows might be more efficient:

  1. Click the File tab, Help button, Options button and select the Advanced button.
  2. In the Cut, Copy, and Paste section, choose the appropriate option. (Example, you might want to keep formatting when copying from other Word documents but not from any other source)
  3. Click OK.

CCP_Blog041013

In Word 2003, select Tool menu, Options button and Edit Tab, uncheck the “Smart Cut And Paste” option or click the Settings button to customize your settings.

Section Breaks:

Separating a document with Section Breaks allows you to format each “section” differently.  Also, you can copy a previous Section Break

–  Next Page – Insert a section break and start the new section on the next page
–  Continuous – Insert a section break and start the new section on the same page.
–  Even Page – Insert a section break and start the new section on the next even-numbered page.
–  Odd Page – Insert a section break and start the new section on the next odd-numbered page.

SB_Blog041013

 In Word 2003, you can insert a Section Break from the Insert Menu.

Keeping Words Together:

Whether the word is hyphenated or simply two words you do not want to split up , a proper noun or a date, you can keep them together!

–  Hyphenated Words:  When typing the hyphen between use [CTRL]+[SHIFT]+[-]
–  Non-hyphenated Words:  When typing the space between use [CTRL]+[SHIFT]+[SPACEBAR]

Editing Number/Bullet Styles:

When formatting a list (bullets or numbers) you can simply edit the format of one or multiple bullets or numbers.

1. Select the Home tab, click Show/Hide in the Paragraph section.

SH_Blog041013

2. Highlight the Paragraph mark(s) at the end of each line you would like to re-format.  For more than one number or bullet, hold [CTRL] while highlighting.
3. Apply format using Style section.

Removing Formats:

You can highlight the entire document or only sections to remove formatting.  If you are trying to remove formatting from a few different sections, hold [CTRL] while selecting the sections.

–  Remove all formatting:  [CTRL]+[SPACEBAR]
–  Remove Paragraph formatting:  [CTRL]+[Q]

Automatically Updating Styles:

When adding a format to text, Word will let you update a style, this can be difficult.

1.  Select the Home tab.
2.  Open the Styles Dialog.
3.  Find the Style from the drop-down list.
4.  Select Modify button.
5.  Uncheck Automatically Update.

Default Line Spacing:

LS_Blog041013

The default line spacing in Word 2007 and 2010 is set for 1.15, commonly used for Web publishing.  You can set your default to 0 or 1 using a few steps.

1.  Select the Home tab.

2.  Right-click Normal in Styles section and select Modify.

3.  Choose Paragraph from the Format list.

4.  In the Spacing section, change the At: setting from 1.15 to 1, Click OK.

5.  You now have the option to set this as your default template for all new documents by selecting “Set As Default” button.

6.  Click OK.

 

Paragraph Spacing:

PS_Blog041013

 

Newest versions of Microsoft Word have increased the spacing between paragraphs.  If you do not want extra space between paragraphs, you can modify it using a few steps.

1.  Select the Home tab.

2.  Open Paragraph Dialog.

3.  Check “Don’t Add Space Between Paragraphs Of the Same Style Option”.

4.  You now have the option to set this as your default template for all new documents by selecting “Set As Default” button

5.  Click OK.

 

Save Formatted text as AutoCorrect:

AC_Blog041013

Using AutoCorrect saves time and prevents mistakes.  It can also save the text previously formatted.

1.  Highlight the content you would like to save in AutoCorrect that is pre-formatted.
2.  Open the File tab.
3.  Choose Options and then select Proofing button.
4.  Click AutoCorrect Options button.
5.  Uncheck Automatically Update.
6.  Select the option you would like to use:
–  Plain text (not formatted)
–  Formatted text (keep the format you have already applied)
7.  Enter short key in the Replace control.  (Example:  We use sjt for South Jersey Techies)
8.  Click Add button.
9.  Click OK, twice.

 

Find and Replace to Edit Format:

Microsoft Word’s Find and Replace tools can be used for more than replacing characters or multiple words, you can also change the format of text.

1.  Copy the text or word you would like to format.
2.  Press [CTRL]+[H] to open tool.
3.  Select More button.
3.  Paste the text or word you previously copied into Find What control.
4.  If the text you paste into Find What is formatted, select the Format button and adjust accordingly.
5.  Paste the same text into Replace With control.
6.  Select the Format button and change to the new format or remove the current Format by leaving the Format Option blank.
7.  You can either, Replace (first instance of the text or word you selected) or you can Replace All (replaces all text or words that are identical).

“Sticky Borders”:

A Sticky Border is when you type three hyphens and press enter directly below text.  This border attaches the the paragraph format or to the bottom of a page.  To easily remove this border follow these steps:

1.  Select the Home tab.
2.  Click inside the paragraph.
3.  In the Paragraph section, choose “No Border” (usually seen with editing tables).

 

Microsoft Excel 2013 Flash Fill

excel2Takeaway:  New Tool for Excel 2013 is Flash Fill that identifies formatting and applies it to your spreadsheet.

Flash Fill identifies and adapts to basic formatting to automatically input your data.  It does not identify changes in source data.  This tool performs several tasks such as merging information from multiple columns, adding formatting to current column and fixing anomalies with data.

To use Flash Fill:

  • From the Menu Screen: FF3
    1. Select the Home Tab
    2. In the Editing
    3. Section, select Fill Button
    4. Select Flash Fill
  • Using the keyboard:
    1. [CTRL] + [E]

 

Formatting

Flash Fill will recognize and apply the selected format to your data.  To use this tool, all information must be added to previous columns.  Flash fill is not perfect.  If data differs from row to row, it will not format correctly (Example:  All phone numbers must have an Area Code or none at all).  After all information is added, move to the next column and enter an example of what you would like done to the data.  Move down to the next row and Flash Fill will initiate when you start typing, press [Enter] to fill column.  Opting out of Flash Fill is just as simple, pressing [Esc] will allow you to continue to enter your data manually. 

EFF1
Above is an example of concatenation; joining two columns of information.

When to use Flash Fill

    1. Formatting
    2. Lists
    3. Concatenation (Joining)
    4. Parsing (Break Down)

 

Tips for Outlook Calendar

Takeaway:  Tips to change defaults for Outlook Calendar.

outlook-logo-vector2

Work Week View:

Default “Work Week” is Monday through Friday, 8AM to 5PM.

  1. Select File tab.
  2. Click Options button.
  3. On the left side of the window, click Calendar button (3rd down).WorkWeekView
  4. Under Work Time Section, enter your Start and End time.
  5. Check the days of your Work Week.
  6. Select the First Day of week.
  7. Select the First week of year.
  8. Click OK.

WorkWeekView2

Reminder Alerts:

ReminderAlertsAfter creating or accepting an appointment, a “Default Reminder” is automatically set to 15 minutes.  

  1. Select File tab.
  2. Click Options button.
  3. On the left side of the window, click Calendar button (3rd down).
  4.  Under Calendar Options Section, select your reminder times.
  5. Click OK.

Calendar Time Slots:

CalendarTimeSlotsTime slots for Calendar Appointments are defaulted to 30 minutes.

  1. Select Calendar View.
  2. Right-Click on Timeline.
  3. Select the interval you prefer.
  4. Outlook will automatically update.
    • 5 minutes:  Most space for details.
    • 60 minutes:  Least space for details

 

Surface vs Surface Pro

final

Surface RT

Surface RT was released on October 26, 2012.  Running Windows RT Operating System on a Quad-Core NVIDIA Tegra 3 Processor.  Storage options are 32 GB or 64 GB.  According to recent news, only 16 GB available for the 32 GB hard drive and 46 GB available for 64 GB hard drive.  Bundled with the Surface RT is Office Home & Student 2013 RT Preview.

Office Home & Student 2013 RT includes Word, Excel, PowerPoint and OneNote.  Surface RT does not support Outlook.

The price for the Surface RT is $499.00.

Surface Pro

Surface Pro was release on February 9, 2013.  Running Windows 8 Pro Operating System on Dual-Core Intel i5 Processor.  Storage options are 64 GB or 128 GB.  According to recent news, only 23 GB available for the 64GB hard drive and 83 GB for the 128 GB hard drive.  Bundled with the Surface Pro is Full Office Suite Preview.

Surface Pro is a Business tablet that includes a pen and the pen digitizer.  The stylus helps make taking notes, drawing and marking up documents easy.  The price for the Surface Pen is $29.99.

The price for the Surface Pro is $899.00.

table2

Not included with the purchase of the Surface RT or the Surface Pro is a keyboard.  Microsoft offers two options, Touch cover and Type Cover.  The Touch Cover is a pressure-sensitive keyboard and tablet cover; available in Red, Black, Cyan, White and Magenta.  The price of the Touch Cover is $119.99.  The Type Cover is thin “classic” keyboard and tablet cover; only available in Black.  The price of the Type Cover is $129.99.

typetouchcover2

Type Cover and Touch Cover

10 Changes to Office 2013

o13Takeaway: Ten popular tools and options that are unseen or removed from Office 2013.

Office 2013 has made minor adjustments and changes to the new cloud-based suite.

Creating from Existing

nfeIn previous versions of Office it was simple to create a new document from an existing one.  This would allow changes without changing the original.

Using Office 2013, the button “New From Existing” is gone;  there is a section under the File Tab for Recent Documents.

Outlook – Activities

aThere was an option to add a Contact’s Activities in older versions of Office.  For Office 2013, Activities option is replaced by Outlook Social Connection.

Word – Show Mark-Up

smFor Office 2013, the Show Markup drop-down, located in the Review Tab and Tracking Section for older versions, is removed but you can add it to your Quick Access Toolbar.

Backstage Exit

cawIn previous versions, “Exit” on the File Tab would allow you to exit all open documents in one click.  In Office 2013, you can right click the program on your task bar and select “Close all windows” or add “Exit” to your Quick Access Toolbar.

Picture Manager

pmcaUnlike previous versions of Office, Clip Art Organizer and Picture Manager are no longer available.  Clip Art Organizer is replaced with Insert Media Dialog Box.  Picture Manager is replaced with Windows Photo Gallery.

Access – PivotTables & PivotCharts

pcv ptvFor Office 2013, PivotTable and PivotChart are no longer tools in Access;  only Excel 2013 provides the PivotTable and PivotChart. 

Access – Upsizing Wizard

ssutIn previous versions of Access, it was simple to add an Access database to SQL Servers.

Using The Upsizing Wizard to migrate all or some objects to SQL Servers is no longer available with Access in Office 2013.

Excel – Workspace

swsWorkspace files save the layout you have selected.  When you open a saved Workspace Files they are displayed in that layout.

Excel 2013 you can open a Workspace file but you can not save layouts as Workspace files or add it to the Quick Access Toolbar. 

Outlook – Journal

ojJournal tool in Outlook helps you manage your productivity and time spent on projects.  This tool will no longer be available for Office 2013 and will not be replaced by another tool.

Outlook – To-Do Bar

tobThe Pinned Peek feature is replacing the traditional To-Do Bar in Outlook for Office 2013.  The Pinned Peak feature is not as detailed as the To-Do Bar, for example you can only view appointments for one day .  

 

 

10 Missing Features from Outlook 2013

Takeaway:  Ten popular features that are missing from Outlook 2013.
outlook

Right-click Lookup

Outlook 2013 does not include ‘Lookup’ when right-clicking a word.  This feature is still available:

            1. Open a new e-mail message.
            2. Click inside the message body.
            3. Select the Review tab.
            4. Select ‘Research’ in the Proofing section.
            5. Press [ALT] and select the word or phrase that you would like to look up.  Also, you can type the word or phrase in the ‘Search For:’ box.

Right-click AutoCorrect

Outlook 2013 does not include ‘AutoCorrect’ when right-clicking a word. This feature is still available but will have to be entered manually.  (Right-click Add to Dictionary is still available using a right-click.)

Import/Export Formats

Outlook 2013 only allows .pst (Outlook’s data file format) and comma-delimited data as import formats.  Previous versions allowed many file formats to be imported and exported.

Meeting Workspace

Outlook 2013 does not include Meeting Workplace.  Also, this feature cannot be added to the Quick Acces Toolbar.  Meeting Workplace was a website that supplied Attendees, Date, Time and Location for meetings.

Outlook Mobile Service

Outlook 2013 does not support Outlook Mobile Service (OMS).  OMS let you create and send text/multimedia messages to a mobile device from Outlook, similar to e-mail(s).

Windows Search

Windows 8 does not support using Windows Search to search Outlook e-mail. Previously, you could using Windows Search without opening Outlook to search for e-mail(s).

Calendar Publishing

Outlook 2013 does not support Calendar Publishing; the replacement is Office.com.  Microsoft cut service for previous versions on April 5, 2014.

Drag-and-Drop

Office 2013 does not support “dragging-and-dropping” e-mail(s) in the To-Do bar to create a calendar entry.  You can “drag-and-drop” an e-mail to a shortcut to create a calendar or task entry.

Notes and Journal

Office 2013 supports ‘Notes’ but ‘Journal’ is no longer available.

Suggested Contacts

Office 2013 does not support Suggested Contacts.  Suggested contacts gathers contacts that are not in your list and suggests them.

 

Microsoft Word – Undo Automatic Indents Tip

word

Takeaway:  Creating numbered or bulleted lists would be simple with the ability to adjust or remove automatic indents.

 

Simple Solution

This simple solutions works with the current list only. If you add to this list, Word will remember the indent. When you start a new list later in the document, it won’t.

  1. Create an numbered or bulleted list.
  2. Double-click any number or bullet in the list to select all.
  3. To change the indent position:
    • Select the Decrease option in the Paragraph group (Aligning all items to the left margin)
    • Select the Increase option in the Paragraph group. (Aligning all items to the right margin)

1

Entire Document Solution

3

The entire document solution will adjust the settings for all numbered/bulleted lists in the document.  Instructions below will default the list to be aligned at the left margin (0), you can adjust accordingly.

  1. Create an numbered or bulleted list.
  2. Double-click any number or bullet in the list to select all.
  3. Right-click the selection; select Adjust List Indents.2a
  4. The Adjust List Indents window opens.
    • Number Position:  0 (Where the numbers / bullets will align.)
    • Text Indent:  .25 (Space between numbers/bullets and text.) 

 

CALL US NOW!