PC Remote App with Windows Mobile 8 Phone

pcremoteappTakeaway:  How to use PC Remote App & Server software to control your PC with a Windows 8 Phone.

PC Remote App is an easy and secure way to remote into your PC from a Windows 8 Phone.  Two versions are available, PC Remote (free) and PC Remote Pro ($2.99).  

Step 1 – Install PC Remote Server

1.  Download the PC Remote Server from http://www.pcremoteserver.com/PCRemoteSetup.msi
2.  Run PCRemoteSetup.msi file
3.  After install, you can setup a password.  Select “Password” Tab.

pcremoteapp_server

5.  Check “Enable”
6.  Enter the password
7.  Select the “General” Tab and then Click “Update Server”.

pcremoteapp_server2

Step 2 – Download PC Remote Mobile Client

1.  Open Windows Phone Store App.
2.  Search for “PCRemote” (Select Free version) and tap “Install”.
3.  Select “+” to add the IP address of the server machine.

pcremoteapp_mobile

4.  Insert the IP address of the server machine and password you selected in Step 1.
5.  Return to the main screen and select your machine.
6.  From the control menu you can choose multiple control options.

pcremoteapp_mobile2

 

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 .  

 

 

Tips for Troubleshooting Outlook

outlook-logo-vector2

Takeaway:   The most significant means of communication in the office is email.  Even though Outlook is the most used mail client for businesses, it can develop problems. Using these ten tips will quickly resolve issues that can impact communication.

1.  Scan PST file

When Outlook becomes troubling, you can use the Inbox Repair Tool provided by Microsoft.  This tool will backup, scan and repair your Personal Folder files (.pst).  The entire process could take more than a few minutes to complete.

2.  Archive Data

Archiving your data will prevent common problems that large PST files create.  Archived data will be moved to a different PST to alleviate the size and space of you primary PST.  After an archive is done, running scanpst.exe will be a safe way to check the file. 

3.  Rename OST

Some problems can be resolved by simply renaming the OST file and allowing Outlook to create a new one.  The OST file saves your e-mails, calendar entries, contacts and other items.  Outlook will open like new after renaming an OST file.

4.  Delete/Rebuild Profile

When deleting or rebuilding an Outlook Profile taking precaution is a necessary step; open Control Panel, select Mail option, select Show Profiles and then select Delete.  For POP accounts, you must save the user’s data by exporting a data file from Outlook.  For Exchange and IMAP accounts, you can delete and re-create the account.  

5.  Disable Add-Ons

Another simple fix is to disable add-ons.  To check the speed of Outlook, use outlook.exe /safe command will allow you to open Outlook in Safe Mode (no-add-ons running).  After testing the speed, you can disable add-ons that may be slowing your system down.

6.  Disable Virus Scan

Popular Anti-Virus tools have a feature that will scan all e-mails to and from your system.  Temporarily disabling this feature is a work-around but not a solution.  Outlook will be defenseless when this feature is disabled.

7.  Run in Safe-Mode

Another temporary fix is to open Outlook in Safe Mode.  Use outlook.exe /safe command will allow you to open Outlook in Safe Mode (no-add-ons running).  This is a work-around but not a temporary fix.

8.  Resetnav

Users can arrange their navigation bar according to their needs which sometimes causes Outlook not to work properly.  A fast way to rest the navigation bar is using outlook.exe /resetnavpane command.

9.  Migrate PSTs

 All user PST files should be stored on the C Drive of the user.  If all users are accessing a shared drive for their PST files, it will slow down Outlook and possibly your network.

10.  Adjust Permissions

To adjust user’s calendar permissions – open the calendar in Outlook, right-click the shared calendar, select Properties, and in the Permissions tab you can adjust user’s calendar permissions.

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

 

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)

 

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).

 

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

 

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.

 

 

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.

Save Your Place In Word With Macros

Save your place in word a document using macros!

Takeaway: Use these two simple Word macros to temporarily bookmark a spot you want to return to later.

Large documents offer a few navigating challenges, especially when you need to jump back and forth between two areas. You could split the document, but that splits the screen and that might not be the right solution for you. Or, you could use any of the normal navigation tools and shortcuts, but it’s easy to get lost that way. Using VBA, you can insert a bookmark that acts as a placeholder. Then, when you’re ready to return, a single quick click is all that’s required.

This technique requires two quick macros, which follow:

Public Sub InsertBookmark ()

‘Insert bookmark for srz.

Call Bookmarks.Add(“srz”, Selection.Range)

End Sub

Public Sub ReturnToBookmark ()

‘Return to previously inserted bookmark.

ActiveDocument. Bookmarks(“srz”).Range.Select

End Sub

To add the macros, press [Alt]+[F11] to launch the Visual Basic Editor (VBE). In the Project Explorer, find ThisDocument for the current document. Then, enter the two sub procedures shown above.

Next, return to the document and add the macros to the Quick Access Toolbar (QAT), as follows:

  1. From the QAT dropdown, choose More Commands.
  2. From the Choose Commands From dropdown, choose Macros.
  3. In the list on the left, find InsertBookmark.
  4. Click Add to add the macro to the list of commands on the right.
  5. With the macro still selected, click Modify.
  6. In the resulting dialog, enter Mark in the Display Name control, and click OK. You could also change the macro’s display icon.
  7. Repeat steps 3 through 6 to add ReturnToBookmark to the list on the right and add the display name, Return.
  8. Click OK.
In Word 2003, drag the macros to the toolbar as follows:

 

  1. Launch the Customize dialog box by double-clicking a toolbar or menu or by choosing Customize from the Tools menu.
  2. Click the Commands tab.
  3. Choose Macros from the Categories list.
  4. Find InsertBookmark in the Commands list and drag it to the toolbar.
  5. Find Return ToBookmark and drag it to the toolbar.
  6. Click Close.
Using the macros is simple.