Category Microsoft Office

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

Surface Pro

ms_surface_proThe Surface by Microsoft is a crossover between a laptop and a tablet. The Surface Pro is a business tablet that has a detachable keyboard, stylus and a kickstand. Putting the Surface Pro above other tablets is the aptitude to run Microsoft Office programs including Word, Excel and PowerPoint.

Microsoft released a television commercial for the Surface Pro, “The Vibe”, starring Daniel ‘Cloud’ Campos from the original Surface Commercial.  This enthusiastic campaign includes professional dancers as “business people” showing the capabilities of the Surface Pro. Similar to Windows 8, Metro “Modern” UI; the commercial has the same ambiance.

According to IDC, Microsoft has finally made its way to the Top 5 for Tablets. In the first quarter of 2013, Microsoft has 1.8% Market Share. Unlike the first quarter of 2013, Microsoft has 0% Market Share. Also, ASUS moved up from #4 to #3, knocking Amazon down a space.

TopFiveTabletVendors

 

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

 

Ten Top Microsoft Office Tips

The ten most popular Microsoft Office tips

Takeaway:  Susan Harkins lists ten most popular Office tips published in the Windows and Office Blog, and the now inactive Office Blog.MS_Office_2007_Logo.svg

When considering tips to share, think about ease-of-use and efficiency. A few naturally rise to the top as your favorites. For your commemoration, here are 10 of 2012’s most popular posts from both the Office Blog, which was deactivated in mid-2012, and the current Windows and Office Blog. Thank you for reading, and thank you for sharing your thoughts and enhancements with one another throughout the year.

1: A quick Word trick for typing text into a scanned document

The response to this limited technique surprised me. It’s something only a few will use, but if you’re one of those few, it can be a big help! I was pleasantly surprised at the positive response it received and the way readers enhanced the technique.

2: Use Word macros to save your place in a document

These two short macros make quick work of bookmarking work areas in a Word document. When the built-in navigation techniques just don’t get the job done for you, consider these macros or one of the alternative methods that readers shared.

3: A quick and dirty way to compare columns of Excel data

This quick Go To comparison solution is great for a one-time task. Comparing Excel data is a common task, and I receive frequent questions for solutions. This solution is a great one to add to your bag of tricks.

4: Demystify Excel’s PivotTable feature with this simple method

Sometimes a great tip doesn’t offer a specific solution, but rather guides you to using a feature more efficiently and effectively. Users tend to ignore Excel’s pivot table feature because they don’t really understand it – hence this blog post offers some quick insight into how to use this feature without mind-bending tricks.

5: Create a dynamic Excel chart and make your own dashboard

This blog post is one of my favorites. I enjoyed sharing the technique, but more than that, I loved the way the readers jumped in to help one another with a step I accidentally omitted in the instructions. TechRepublic readers rock!

6: A quick Excel keyboard trick for selecting large ranges

This technique uses Go To ([F5]) in an unusual way – to anchor two cells, creating a range. The ensuing conversation shared a number of great selection tips!

7: Three tips for rounding Excel time values

Using the right function can help you round up your rounding woes. Excel offers three rounding functions and knowing them all will round out your skills nicely. (Okay, I promise to stop that.)

8: Three things you must do when you inherit an Excel workbook

I review a lot of workbooks, so this blog was one of my favorites to write. In my experience, performing these three quick tasks when inheriting a workbook can speed up your troubleshooting time. Fortunately, it sparked some insightful conversation into what others do.

9: Launch Word with the most recently used document

Reader response sometimes surprises me, as it did for this easy technique. I hadn’t expected so many great alternatives from the readers.

10: Run a list of rolling credits at the end of your PowerPoint presentation

I’m glad a PowerPoint technique made the top list, but it wasn’t because the readers loved my technique. Mostly, the conversation centered on the typo I missed, and then my lack of proper contrition for said typo. It was fun while it lasted.

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.

Microsoft Office Coming to Android and Apple

Microsoft Office coming to Android and Apple devices in early 2013

Summary: A Microsoft executive let slip in the Czech Republic that the long-rumored Microsoft Office for Android smartphones and tablets and Apple iPad and iPhones will be arriving in early 2013. Microsoft now denies that their executive was speaking accurately.

We’ve known for months that Microsoft was bringing a version of Microsoft Office 2013 to Android tablets and Apple’s iPad family. Now, according to the Czech tech news site, IHNED, Microsoft product manager Petr Bobek has said that Microsoft is planning to release native iOS and Android versions of Microsoft Office 2013 in the first quarter of 2013

Bobek, a Microsoft Office portfolio manager in the Czech Republic, said that these new versions of Office will be available to larger companies and Microsoft partners In December 2012. small-office/home-office (SOHO) and household users will have to wait until at least February. The online version of Office 365 edition for mobile devices and tablets will appear in early 2013.

In an e-mail, the author of the INHED story clarified that the release would be after March 2013. “We had a slight miscommunication with the MS guys and the timeline for Office for iOS and Android is not a March release, but release sometime after March.”

Officially, the only thing Microsoft had to say at first was that “As we shared previously, Office Mobile will work across Windows Phones, Android phones and iOS, and we have nothing additional to announce today about retail availability of the new Office.”

Later the same day, Microsoft’s head of corporate communications, Frank X. Shaw, denied the whole story. Shaw tweeted, “The information shared by our Czech Republic subsidiary is not accurate. We have nothing further to share.”

No matter when Microsoft delivers the Android and iOS goods, Microsoft’s support of any version of Office on a non-Windows smartphone or tablet strikes me as an odd move. In a shareholder letter, Microsoft CEO Steve Ballmer said that Microsoft is shifting its model to focus on devices and services. This is a radical and dangerous shift for a company that’s always made it money from software licensing. And, now, instead of using Office as a crowbar to pry users from iPads and Android tablets to its Surface tablets, Microsoft is going to offer Microsoft Office 2013 on its device rivals? Odd. Very odd.

Historically, Microsoft has locked its customers into its software ecosystem. Since Microsoft is a non-starter in the mobile space, I find it surprising that they’re not trying to exploit its Office suite in a similar manner in this new market.

That said, given the early reports of Office 2013, which didn’t even have touch enabled for its tablet versions by default, I don’t see Google, with Google Docs and QuickOffice, being worried about Microsoft being a rival on either devices or services anytime soon.