General Microsoft

Download Microsoft Office for iPad and Android Phones : First Thoughts

Microsoft today announced several new and updated applications and services including Microsoft Office for iPad and free Office Mobile apps for iPhone and Android phones. Microsoft also announced the Enterprise Mobility Suite, a comprehensive set of cloud services to help businesses manage corporate data and services on the devices people use at work and at home. In addition, the company announced the upcoming availability of Microsoft Azure Active Directory Premium and enhancements to Windows Intune.

The new Windows Intune features and Azure Active Directory Premium will be available in April, and the Enterprise Mobility Suite will be available via Microsoft Volume Licensing channels on May 1.

Office 365 for iPad

Office for iPad brings full file fidelity across Office on PC, Mac, tablet and phone, and along with cloud storage from OneDrive or OneDrive for Business your files are up to date, wherever you need them on whatever device you want to use. Office for iPad apps have a familiar look and feel that are unmistakably Office but are built from the ground up for iPad, factoring in the unique nature of touch and functionality native to iPad along with what people most commonly want to do on a tablet.

“Microsoft is focused on delivering the cloud for everyone, on every device. It’s a unique approach that centers on people — enabling the devices you love, work with the services you love, and in a way that works for IT and developers,” said Satya Nadella, chief executive officer for Microsoft.

Starting today, Office 365 subscribers can simply add an iPad as one of their chosen devices included in their subscription benefits, and can create and edit documents with Word for iPad, PowerPoint for iPad and Excel for iPad. These apps are available as free downloads from the App Store, enabling people to read and present documents, spreadsheets and presentations. Office 365 subscription not only gets you the Office for iPad apps installed on up to 5 tablets, but also 5 copies across Office for your PCs and Macs. With one subscription all of your devices are covered, so you can work the way you want.

Microsoft Office for iPadThe apps have the robust capabilities and familiar look and feel that is unmistakably Office, while offering a fantastic touch experience built from the ground up for iPad.  With the free versions of the apps, you can read your Word documents, view your Excel data and present with PowerPoint. Your documents will look as good as they do on your PC and Mac®, and better than ever on your iPad.  With an Office 365 subscription, you can edit and create new documents with the iPad.

Word for iPadWhen you edit a document, you can be sure that content and formatting will be maintained across Office on PC, Mac, tablet and phone. And, you always have access to your up-to-date documents in OneDrive and OneDrive for Business. In Word, images, tables, SmartArt, footnotes, equations are all there, perfectly formatted. Formulas, charts, sparklines, conditional formatting, and filters in Excel help you make better decisions.

Excel for iPad

PowerPoint presentations pack a punch with transitions, animations, speaker notes and much more. When presenting, you can even use a built-in laser pointer, pens and highlighters to get your point across. The Ribbon layout and experience is familiar, with the most common commands under Home, and Chart commands automatically show up when you select a chart.

Powerpoint for iPad

At the same time, these apps were created from the ground up for iPad. The large touch areas on the Ribbon and in overlay menus make it simple to create, edit and format documents using only touch. Resize and rotate objects like pictures with touch-friendly handles. When you hold and move the objects, text flows smoothly around them. No keyboard and mouse required. You can even use iPad features like voice dictation to draft a Word document or AirPlay® to project a presentation wirelessly on a TV screen. In addition, the apps make it easy to work together. Simply share your content with others thanks to OneDrive and then work simultaneously with multiple people on the same document or presentation.  And, reviewing documents is now great on the iPad.  Word documents can track changes, have threaded comments and easily accept or reject edits all right on the iPad.

Note: You need an iPad running iOS 7.0 or later. You can download the Office apps for free and read, view and present documents, spreadsheets and presentations.  To get the full editing and creation experience, you need an Office 365 subscription

Starting today, Office Mobile for iPhone and Android phones is free for everyone. With Office Mobile, you have the ability to view and edit your Office content on the go.  Office Mobile is available in the App Store and Google Play.

Microsoft Office Mobile for Android

This is definitely a good thing, if you (or your company) has an Office 365 subscription. However, if I have to recommend the same to an Individual, I would definitely recommend Google Drive which offers both Editing and Viewing capabilities on an iPad with neither any cost nor ads. Its just that, when Pages, Keynote, Numbers and iCloud (Apple proprietory software) are already available free on iPad, it would take a very strong case, if someone would like to use Office on an iPad just as an individual case. However, if your enterprise or company has an active office 365 subscription and use SharePoint really well, this software would work like a cake for you.

General Microsoft

Now Available: Microsoft Office for Mac 2011 Service Pack 2 (14.2.0)

If you are using Microsoft Office on Mac, this message is for you! Microsoft has released an update for Microsoft Office for Mac 2011. As always, this update provides the latest fixes to Office for Mac 2011. Additionally, it also contains stability and reliability improvements..!

Before you install the Office for Mac 2011 14.2 update, make sure that the computer is running Mac OS X v10.5.8 or a later version of the Mac OS X operating system.

Download the Microsoft Office for Mac 2011 Service Pack 2 (14.2.0) here

Key Improvements from this Update –  

  • Enables users to view and access documents that are located in the root level of a SkyDrive folder.
  • Adds a drag-and-drop feature for files in Document Connection in Mac OS X 10.7.
  • Fixes an issue in which you receive the following error message when you upload a file to a SharePoint site  – Upload Failed You must sign in to save your changes to the server.
  • Fixes an issue in which the Italian grammar checker does not check a complete document.
  • Fixes an issue in which the German grammar checker does not check a complete document when the document contains certain German sentences.
  • Includes fixes that increase the robustness of the database and that improve the effectiveness of the rebuild utility. Outlook for Mac uses the Office database to store personal information, such as messages and contacts. This update fixes issues that cause database corruptions, instability, and crashes. This update also improves database transactions and the ability to recover from certain errors. If there is a problem within the database, Outlook for Mac starts the Database Utility, which tries to rebuild the database. After you install this update, the Database Utility recovers additional account information, such as shared resources and categories, and recovers from corruption scenarios. This update also adds the ability to cancel a database rebuild in Outlook for Mac.
  • Once you install this update, Outlook for Mac updates new messages in IMAP folders regularly. Additionally, Outlook for Mac users who use Gmail accounts can map folders, such as Drafts, Deleted Items, Sent Items, and Junk E-Mail, automatically.
  • This update introduces a new sync model for Exchange. The new model enables Outlook for Mac to download an email message in parts. For example, Outlook for Mac first downloads and displays message text and then downloads large images and attachments. Downloading messages in parts reduces the load on the Exchange server and improves performance for the user.
  • This update improves support for calendar scheduling resources and for free/busy comparison functionality in the Scheduling Assistant.
  • This update enables you to expand distribution lists into individual members when you add a distribution list in the To field or rest the mouse pointer on a distribution list.
  • This update introduces functionality that enables you to paste special hyperlinks in PowerPoint.
  • This update supports Full Screen View in PowerPoint. Additionally, when you close slide show mode in PowerPoint, edit mode opens.

For the complete list of fixes that are included in the Office for Mac 14.2 update, download this .xls file.

General Microsoft

Outlook Social Connector (OSC) Provider Development – Hands on Lab

The Outlook Social Connector (OSC) is a set of new features that help you keep track of friends and colleagues while enabling you to grow your professional network. The OSC brings social views of your networks right to your inbox in a region known as the People Pane. As you read your email, you can view information in the People Pane such as the picture, name, and title of the sender along with a rich aggregated collection of status updates and activities related to the sender.

Because the OSC utilizes an open provider model, you can build providers that work with the OSC to display social network data. In addition to public social network sites, you can also use the OSC provider extensibility to build providers for line-of-business applications or internal corporate web sites and to integrate their services into Outlook.

In this Hands-On Lab, you will gain experience by learning about the basics of OSC provider development.

Click here for the OSC Provider Development Hands on Lab.


Courtesy: Microsoft

General Microsoft

Service Pack 1 for Office 2010 and SharePoint 2010

SP1 releases for both Office client suites and SharePoint server products will be made available. All language versions of SP1 will release simultaneously. Initially, Service Pack 1 will be offered as a manual download from the Download Center and from Microsoft Update, and no sooner than 90 days after release, will be made available as an Automatic Update.

SP1 will include many interesting changes. Across the client suites and server products, SP1 offers a sprinkling of improvements to make a strong 2010 release wave even stronger. During TechEd and beyond, teams on will update their blogs with more specific details of 2010 Service Pack 1 contents.

There are far too many changes in SP1 to list here, but the list below is a sample of SP1 highlights to get things started. This is a list of things that you can do now that you couldn’t before, or things that are just better than they were with the original release:

  • Outlook fixes an issue where “Snooze Time” would not reset between appointments.
  • The default behavior for PowerPoint “Use Presenter View” option changed to display the slide show on the secondary monitor.
  • Integrated community content in the Access Application Part Gallery.
  • Better alignment between Project Server and SharePoint Server browser support.
  • Improved backup / restore functionality for SharePoint Server
  • The Word Web Application extends printing support to “Edit Mode.”
  • Project Professional now synchronizes scheduled tasks with SharePoint task lists.
  • Internet Explorer 9 “Native” support for Office Web Applications and SharePoint
  • Office Web Applications Support for Chrome
  • Inserting Charts into Excel Workbooks using Excel Web Application
  • Support for searching PPSX files in Search Server
  • Visio Fixes scaling issues and arrowhead rendering errors with SVG export
  • Proofing Tools improve spelling suggestions in Canadian English, French, Swedish and European Portuguese.
  • Outlook Web Application Attachment Preview (with Exchange Online only)
  • Office client suites using “Add Remove Programs” Control Panel, building on our work from Office 2007 SP2

Each product in Office and each Server capability area will have changes in SP1. Specific changes will be detailed on TechNet and in KB Articles. On release day, the MS team will publish all associated KB articles. SP1 will also roll-up our Public Update and Cumulative Update releases to date.

Source: Office Engineering Blog

Interested in office 2010? Read these Tips, which would help you use this tool better:

Microsoft Tools Windows Installer, Application Compatibility and Deployments

Download Office Migration Planning Manager (OMPM) 2010

The much-anticipated 2010 version of Office Migration Planning Manager (OMPM) is now available for download on the Microsoft Download Center. OMPM helps IT Pros discover and assess the compatibility of existing Office documents for conversion from the binary document formats (Office 97-2003: .doc, .xls, etc.) to OpenXML formats (Office 2007 and beyond: .docx, .xlsx, etc.). Additionally, OMPM 2010 adds features that assess macro compatibility with Office 2010 and 64-bit Office compatibility.  The toolkit also contains the Office File Converter (OFC), which enables bulk document conversions from binary to OpenXML formats. OMPM 2010 includes the following new features and improvements:

  • Bulk Macro Compatibility Scanning – incorporates logic from the Office Code Compatibility Inspector (OCCI) tool to produce count of potential number of VBA issues due to changes in object model.  A new option in the offscan.ini file enables activation of this scan.
  • Bulk 64-bit compatibility scanning – incorporates logic from the OCCI tool to produce a count of the potential number of 64-bit (declare) VBA issues that are due to use of 64-bit Office.  A new option in the offscan.ini file enables activation of this scan.
  • Pre-defined date filtering for scans – provides new configuration options in the Offscan.ini file to allow exclusion of files based on last accessed or last modified dates.  Files that are skipped can be logged.
  • SQL 2008/SQL 2008 R2 support – Support for SQL Server 2008 and 2008 R2 has been added. OMPM remains compatible with SQL 2005.

You can find the OMPM documentation in the Office 2010 Resource Kit.

The Environment scanning tool (OEAT) assists a customer in the assessment phase of deployment. It identifies:

  • Currently installed applications and installation environment
  • Add-ins currently in use by Office clients
  • Programs that are not registered as add-ins but still interact with Office programs
  • Provides a report on the Environmental assessment (potential upgrade issues)
  • Also reports the  Add-ins assessment–list of third party programs and information about the compatibility of those programs with Microsoft Office 2010
General How-to IT News, Tech Information and Analysis

How to Insert and Trim Videos in a PowerPoint Presentation

PowerPoint 2010 provides us a a very easy option to import and use videos in a presentation. In this article, we will look at how to Insert YouTube Videos and other media files into a PowerPoint Presentation. We will also learn how to Trim and customize a video.

Step 1: Open a PowerPoint Presentation, When you add a new slide (or change the slide layout), you will see the below screenshot. Select the Media option as shown below.

Insert Media Clip onto a PowerPoint Presentation

Step 2: Browse through your local folder and select a video to insert. Once the video is imported. You will see the same on the slide.  In this demo, let me add a Windows Phone 7 Demonstration video. (video courtesy – Chris Pirillo)

A point to note – You will also see the media button and options below the video. This can be used to control the Playback and other Media options.

Media Options by Default - Import Video in PowerPoint 2010Step 3: You can look at a preview of the video by right-clicking on the video file. If the video is a long one, and you do not want to show the entire video in your presentation, then you can trim and show just a section.

Invoke Trim Video Options in PowerPoint 2010Step 4: You can basically, choose the section which you want to show in your presentation. Once the selection is made, Just hit the OK button.

Trimming a Specific Section in a Video - PowerPoint 2010

and Bingo.. the trimmed video will be as a part of your presentation!

Insert Videos from Web Site (YouTube, MetaCafe, BlipTV etc..)

Somes times when you see a nice video and want to include it in your presentation, you dont really want to download it and import. Rather, there is a need to add it directly. Office 2010 provides you an option to import a video from any website. In this example, lets import an YouTube Video.

Step 1: Goto Insert Menu -> Select Video -> Video from Website (as Shown below)

Insert YouTube Video onto a PowerPoint PresentationStep 2: This will give you a dialog to insert a link of the video. You can copy the embed code from YouTube (or any other websites) and paste it into the textbox below (as shown)

Insert YouTube Video Embed Code - PowerPoint 2010On clicking the Insert Button, you will find the YouTube video inserted in the Slide. You can resize it as per your need..!

YouTube Video gets Embedded in a Presentation - PowerPoint 2010You also have options to change the Video Styles, Correct the brightness and Contrast etc..

Video Correction Options in a Presentation - PowerPoint 2010

You would also be interested in reading –

General How-to Microsoft

Adding Artistic Effects to an Image in Office 2010

Office 2010 offers an excellent image editing feature, which would help us do a lot of stuffs with images. In the previous post, we saw how to remove the background from a picture and create a Portable Network Graphics (PNG) image. In this short tip, we will look at how to add Artistic Effects to an Image.

Step 1: Insert an image into any of the office Suite products. In this example, I will use the Word 2010.

Step 2: Double-click on the image; this will give you a separate picture Editing Menu Bar (as shown below)

Step 3: Click on the Artistic Effects button. This will give you all the shades and effects available for the image; When you hover the mouse over each of the effect, you can have a preview of the effect as applied on the image.
Artistic Effects on an Image - Office 2010
Step 4: Just select the effect and click on it. The desired effect would’ve applied on the image.
Applied Artistic Effects on an Image - Office 2010

To know how to remove the background of a picture and create a PNG image, do read this article!

You also have other image options to set the color tones and saturation in the Color menu (as shown below)
Color Menu in Image editing - Office 2010
You can also increase the sharpness, brightness and contrast of the image with the live preview.
Image Correction Menu in Image editing - Office 2010

If you have not tried the Office 2010 Version yet, Download it and Give it a shot. I’m sure, you would love it!

Community Activities General Microsoft

K-MUG Office 2010 Community Launch

Microsoft Office 2010 is a productivity suite from Microsoft. This is the latest edition in the suite of office products. Right from the office 97 till the 2010 version, the product has evolved a long way from just a software towards being a platform.

Office 2010 includes extended file format support, user interface updates, and a refined user experience. Office 2010 marks the debut of free online versions of Word, Excel, PowerPoint, and OneNote, which work in popular web browsers.

Last weekend, there was an Office 2010 Community launch at K-MUG during the DevCon. We did have a combination of students, developers and technology enthusiasts as our audience. We didn’t want it to be, just another conventional presentation. I am Rama were discussing on how to build a story line around the Office 2010 demos. That’s when; the Football World Cup came to our mind. We planned a scenario of a restaurant owner who wants to host a World Cup party at his place. Keeping this in mind, I showcased some key features of the Office Suite of products during this demo which can be used –

  • How one can do a brainstorming talk with his team using OneNote 2010, syncing it with mobile and different users.
  • Take a screenshot right inside the word or power Point, instead of using a print screen and then editing it in paint.
  • Image editing capabilities to remove the background of an image
  • Artistic features to design an image – Without using a third party software.
  • Pinning a document to the recent list, or jump list for easy access
  • How to add Visual text effects in Word to highlight a section of text or letters.
  • The recovering capabilities of an office document, when closed prematurely
  • How to create data trends chart for each row / column using Sparkline in Excel 2010.
  • Improved Animation and Narration features in PowerPoint 2010.
  • How to add a Video to a PowerPoint presentation, edit and format them in ease.
  • Using sections within a presentation.
  • Save presentation as a video
  • Broadcasting a PowerPoint presentation to external users through internet.
  • Power of Office Web apps. How an user can just goto Office Live and start using the office apps absolutely free. Also, when you hit the F11 key, the web app and the desktop app almost looks and behaves the same.

You would also be interested in reading these –

Best Practices General Microsoft

Download Office 2010 and SharePoint 2010 Videos from the SPC 2009

While Microsoft can’t publish all the conference content from SPC (Share Point Conference 2009), they have cherry picked the most popular sessions and publish a selection of most popular Office 2010 and SharePoint 2010 develop SPC videos and slide decks! Here’s the selection of most popular sessions:

Office 2010 Videos | SharePoint Conference 2009

Office 2010 has many new developer oriented features. As a Microsoft Office developer, you can create highly refined user experiences that reduce complexity for users and make them instantly more productive. The following five videos represent a selection of most popular Office developer track sessions from the SharePoint Conference 2009.

SharePoint 2010 Videos | SharePoint Conference 2009

SharePoint 2010 has many new developer oriented features. Developers can build collaboration applications on the platform features of Microsoft SharePoint 2010, the new tools for SharePoint 2010 make developers more productive, and new hosting options for SharePoint solutions provide more flexibility in deployment. The following five videos represent a selection of most popular SharePoint developer track sessions from the SharePoint Conference 2009.

You will be also interested in reading this – Fixing Code Compatibility Issues with Office 2010 Compatibility Inspector

How-to Microsoft Tools

Fixing Code Compatibility Issues with Office 2010 Compatibility Inspector

The Microsoft Office 2010 Compatibility Inspector compares existing (legacy) code against the Office 2010 object model by using a text search for known properties and methods that have changed. You can run the tool against specific projects. You also have the option to mark those areas in the code where text search has identified a possible object model match. The comment will include description of what was found along with possible remediation link to online content or help.

The key features of the Office Code Compatibility Inspector include the following:

  • It consists of four add-ins that load, one add-in per application, in Excel 2010, PowerPoint 2010, Word 2010, and Visual Studio 2008.
  • It runs on a per-user or a per-document basis. For VBA, users open a document and run the tool from the Developer tab. For Visual Studio projects, the developer runs the tool from the Tools menu.
  • It adds comments in the code where it finds other potential issues.
  • It displays a summary and a detailed report of its findings after it completes its inspection.

The tool integrates with both Microsoft Visual Basic for Applications 7.0 (VBA 7) and Microsoft Visual Studio 2008. It includes a basic scanner where definitions and remediation links are updated from a central online location. It also generates a summary report and a details report. The summary includes the total lines of code scanned as well as total lines identified as potential candidates for object model changes. The details report includes the module name, line number, and links to remediation for each identified issue along with color-coded flags for impact guidance.

You cannot use this tool to inspect code from Microsoft Outlook or Microsoft Access. However, you can use the tool to inspect Excel, PowerPoint, and Word code for interaction with the Outlook object model.

This tool checks Compatibility for code written for the older Office applications (Office 97, 2000, XP, 2003 and 2007) for use with Microsoft Office 2010.

Download the Office 2010 Tool: Compatibility Inspector to begin with!

Double click the exe, it will show you a path where you will need to extract the installer. Once done, you will have a msi file. While Installing this msi file, you will get an option to select the addins which you want to install.

Component Installation - Compatibility Inspector

Once the installation is complete, this will dump all the required files to the Program Files folder. (Note, you do not have shortcuts to invoke for this tool.)

To invoke this tool, launch any office application. For example, I will start the Microsoft Excel.

Once you do so, you will get an addin installation dialog. Surprisingly, the addins gives an unknown publisher for an inhouse Microsoft Tool.

Excel addin Installation - Compatibility Inspector

You will need to enable this addin, so that it appears in the Ribbon menu control. For doing so, goto File Menu->Options-> Customize Ribbon. You will see that the Developer checkbox is un-checked. Select the checkbox (as shown in the below snapshot).

Enabling the Developer Addin - Compatibility Inspector

Once this is done, you will see a new Developer Menu appearing in the Ribbon controls.

Developer Addin Menu Appears - Compatibility Inspector

Now you can inspect your VBA project for Office 2010 Compatibility. You can select these options (as shown in the screenshot below) while running your code inspection. This tool checks compatibility for code written for the legacy Office applications (Office 97, 2000, XP, 2003 and 2007) for use with Microsoft Office 2010.

Inspect VBA code Project using Office 2010 Compatibility Inspector

At the end of the inspection, you will get a summary report on the scanned, depecated, changed and redesigned items.

Office 2010 Compatibility Inspector Report

You can also inspect a Visual Studio Code for its compatibility, All you need to do is., to enable the addin, Open the solution that you want to inspect in Visual Studio Tools for Office, On the Tools menu, click on Inspect VSTO code.

If the Inspector finds Changed, Deprecated, or Redesigned items in your code, you must debug your code and resolve any issues. As you debug your code, check for Office Code Compatibility Inspector comments above the lines that break your code. Those comments should help you to determine the underlying problem with that particular line of code.

I would also recommend you download and use the Assesment Tool (OEAT) to assess your machine for Office 2010 installation and Addin Compatibility.

This is a comprehensive Environment scanning tool (OEAT) for use in deploying Microsoft Office 2010.  This tool (along with documentation) assists a customer in the assessment phase of deployment. It identifies:

  • Currently installed applications and installation environment
  • Add-ins currently in use by Office clients
  • Programs that are not registered as add-ins but still interact with Office programs
  • Provides a report on the Environmental assessment (potential upgrade issues)
  • Also reports the  Add-ins assessment–list of third party programs and information about the compatibility of those programs with Microsoft Office 2010