Office Apps On-premises and in the Cloud
The productivity applications bundled in various versions of Microsoft's Office desktop suites and Office 365 subscription plans include Word, Excel, Outlook, PowerPoint and Access. Each of these products is the market leader in its class, and in the minds of many users these applications have become synonymous respectively with word processing, spread sheets, email, presentation, and desktop database software. Since the release of Microsoft Office 2010, these programs have moved to the realm of 64-bit computing. With the introduction of Office 2013 desktop and Office 365, these apps have been enhanced with advanced support for cloud computing, collaboration, mobility, and integration with other key Microsoft platforms such as SharePoint, SQL Server, Exchange, and Skype for Business or Microsoft Teams.
To tap into the full benefits of Microsoft Office desktop or Office 365 and to manage a highly interconnected ecosystem efficiently requires a broad understanding of Microsoft technology, network infrastructure, data security, and successful business processes. Progent's Microsoft-certified consultants, Cisco-certified CCIE network engineers, CISSP-ISSP certified security professionals, and seasoned information technology experts can help small businesses integrate Microsoft Office and Office 365 applications into a cohesive solution that offers quick return on investment and results in better business outcomes. Progent can help you incorporate Office 365 cloud services such as Exchange Online and SharePoint Online into a hybrid network architecture that seamlessly integrates both on-premises and cloud-hosted resources.
What's the Difference Between Microsoft Office and Office 365?
Microsoft Office is a family of software packages consisting of various bundles of popular Microsoft client applications sold under a perpetual license. If you buy a version of Office 2016, for example, you can install and run the included apps like Word and Excel forever, but only on one computer at a time. If you want to upgrade to a major new release like Office 2019, you have to buy a new perpetual license. This is Microsoft's traditional way to sell application software.
Office 365 is an example of the industry-wide transition to a subscription model for selling software and services. Office 365 includes various bundles of Microsoft's productivity applications as well as an array of cloud-hosted services like Exchange Online and Skype-for-Business Online or Teams. You can run most Office 365 applications on different types of devices such as PCs, Macs, tablets, iPhones and Android smartphones. Apps that can run on multiple operating systems include Word, Excel, PowerPoint, OneNote and Outlook. PC-only applications include Access and Publisher. For users with multiple devices, which includes almost everyone, most subscription plans allow you to install and run Office apps on multiple devices simultaneously. As an example, the Office 365 Business subscription plan allows you to run as many as five PCs or Macs, five tablets, and five smartphones.
You need online access to install, activate, manage and update Office 365 applications. You can run the applications offline and synchronize files stored in the cloud as soon as you get back online. Services offered in different Office 365 bundles include Exchange Online hosted email, Skype for Business and Microsoft Teams chat and conferencing, and OneDrive cloud storage and file sharing. You must be online to use Office 365 cloud services. All Office 365 subscription plans include both incremental and major updates, such as Office 2016 to Office 2019, as part of the flat subscription fee, and subscribers receive incremental updates sooner than owners of a perpetual license.
Microsoft Office Word
Office Word 2016 desktop features new chart types plus the Office 2016 Tell Me and Smart Lookup features, which are shared by other Office 2016 and Office 365 apps. With the new Tell Me feature, you can type the description of a button, command, or desired action into a text box Office Word 2016 instantly displays the buttons or menus that will allow you to execute your action directly. The Smart Lookup features uses Bing to find information in context on the web without the distraction of leaving Office Word and switching to your web browser. Office 365 Word and Word with Office Mobile for Windows 10 work with Office SharePoint and OneDrive cloud storage to provide enhanced collaboration, touch-screen and pen support, and document versioning for auditing and recovery.
Office Word 2013 introduces a more contemporary look to Word's GUI and features enhancements to document readability and markup, better handling of PDF files, embedded video support, and new layout controls. New features include a new Read Mode that eliminates screen clutter, the Simple Markup view for displaying and organizing revisions, editing of simple PDF files, the ability to insert online images and videos, and alignment guides for simplifying the precise placement of charts, images and diagrams within a document.
Office Word 2010 introduced extensive text-formatting and picture-editing functions, more convenient remote editing capability with the Web App online companion to Word, additional document recovery options with Microsoft Office Backstage, and improved collaboration with concurrent co-authoring via SharePoint Foundation plus presence awareness, instant messaging, and one-click calling with Skype for Business support or Microsoft Lync Server 2013 integration. Microsoft Office Word 2007 remains a popular version of Word and includes major enhancements over Word 2003 in the areas of editing and reviewing tools, document sharing, and program recovery. Word 2003 is still a widely used release of Office Word, but Microsoft has terminated mainstream support for the Word 2003 as well as for other Office 2003 applications. Progent can help you plan and execute an efficient migration to Microsoft Office 2010 or 2007 or provide cost-effective technical support and management consulting for older versions including Office 2003 and Office XP.
To find out about Progent's online consulting and training services for all versions of Office Word and Office 365 Word, visit Office Word consulting and training.
Microsoft Office Excel
Office Excel 2016 features enhanced integration of business intelligence (BI) tools, additional charts and functions, expanded security, and improved support for mobile devices. Improvements include PivotTable enhancements such as PivotChart drill-down buttons, new personal templates including the ability to view a calendar as a dashboard, integration of Power Query and 3D Map (previously known as Power Map), forecasting based on the Exponential Smoothing, new modern-looking charts including Waterfall and Sunburst, touch-screen support for all Windows 10 devices, Data Loss Protection with policy-based scanning for typical data patterns associated with sensitive data types such as social security and credit card numbers, and the ability to switch seamlessly across Windows, Android, and Apple desktops, smart phones and tablets.
Office Excel has a more contemporary look and feel and includes a collection of new templates, many new functions, closer integration of BI tools, better integration with SharePoint for enhanced collaboration support, and improved cloud readiness. Excel 2013's new Single Document Interface, long familiar to users of Office Word, provides each workbook with its own resizable window. 50 new functions cover date/time, mathematics, trig, statistics, engineering, formula display, and logic. The new Flash Fill feature speeds up data entry by taking a sample action such as separating first and last names and applying that action to an entire column. The Inquire add-in highlighting changes cell by cell for tracking the changes, including VBA code, made to a workbook over time. The new Recommended Charts and Recommended PivotTables commands save time and improve presentations by suggesting the most appropriate ways to display different types of data. Office Excel 2013 also has integrated support for sharing and co-authoring worksheets in the cloud with Microsoft's subscription Office 365 service or Microsoft's free OneDrive service.
Among Office 2010 applications, Microsoft's Excel 2010 is the biggest beneficiary from 64-bit computing, supporting larger and more complex workbooks and breaking through the previous 2 gigabyte RAM limit. Both 32-bit and 64-bit versions of Excel 2010 work with Microsoft Office Backstage for enhanced file management and recovery and both support Web App for secure browser-based remote access from any computer. Other improvements in the 2010 version of Excel include single-cell Sparklines for displaying miniature charts to summarize data, more powerful PivotTables and PivotCharts, Slicers for interactively filtering PivotTable data, enhanced conditional formatting, easier searching and filtering, unlimited datapoints for charting, improved picture editing, and better support for VBA programming. Prior versions of Excel allowed you to use Excel Services to share workbooks via SharePoint Server. Excel 2010 offers integration with key features of SharePoint 2010 related to security, content and version management, and access control. Progent's SharePoint consultants can help you integrate Excel with the business intelligence capability incorporated in SharePoint Server.
To learn about Progent's online consulting, development and training services for current and legacy versions of Office Excel desktop and Office 365 Excel, see Office Excel consulting services.
Microsoft Office Outlook
Outlook 2016 includes enhanced features for email, calendar, contacts and task management. You can quickly attach most recently used documents, and for attached files shared from OneDrive or SharePoint you can designate them as read-only or give edit permissions to recipients for easy collaboration. Office Outlook 2016 also allows you to use a Group rather than a distribution list. This saves time and facilitates collaboration because a group can be created with a few clicks and organized around topics and conversations relevant to a team. A Group provides a common area for all of a team's threads, holds a complete email conversation history, and allows teams to interact from the Group's Inbox. Search in Outlook 2016 email is faster and allows you to search across your own device, your Exchange 16 server, or your Office 365 Mailbox. When searching for email, Outlook 2016 provides people and keyword suggestions from Exchange 2016 based on the content of your mailbox. For hybrid deployments that combine Office 365 Exchange Online with an on-premises Exchange organization, you can perform a multi-mailbox search across on-premises and Office 365 mailboxes. (See Office 365 integration with on-premises Exchange.)
Outlook 2013 introduces a cleaner and more contemporary users interface designed to help users work more efficiently with email, calendars, and contacts. The message list itself includes a truncated preview of each message to help you prioritize your responses. You can reply to an email quickly by entering your response directly into the Reading Pane or by starting an IM chat with Lync. The message list also includes commands to flag, delete, or mark messages as read or unread, and the Inbox includes two new buttons, All and Unread, for easier message management. You also have the option of keeping your calendar, appointments, meetings and upcoming tasks in view without the distraction of switching from email mode. The new People Card consolidates critical details about a contact such as phone, email, social media updates, and presence. You can schedule a meeting, send an IM or make a phone call directly from the People Card. With the new Site Mailboxes feature, Exchange emails and SharePoint documents can be combined in a shared project space available to authorized team members through Outlook. A Site Mailbox can contain a team folder, calendar, and a task list and simplifies collaboration by allowing members to file and access a project's emails and documents within the familiar Outlook environment.
Outlook 2010 allows you to manage multiple email accounts, including Gmail and Hotmail, from a single location. Another new feature that also saves time and reduces the chances of overlooking important messages is Conversation View, which allows you to manage long message threads as a single logical conversation. Scheduling is enhanced with E-mail Calendar, which lets you send schedules to colleagues, and with the new Schedule View, which allows you to view multiple calendars side by side. Improved search capabilities support complex queries, allow you to save and recall your favorite searches, and deliver fast results when you search your emails, calendars, or contacts. Integration with Microsoft Lync Server or its predecessor, Office Communications Server, provides Outlook 2010 with presence awareness and the ability to initiate a phone call from within Outlook. Another innovation in Outlook 2010 is MailTips, which can alert you when you attempt to send an email to a large distribution list or to an unavailable recipient. When used with Exchange Server 2010, Outlook 2010 can provide voice-to-text previews of voice messages so you can quickly scan your voicemail from your Outlook inbox.
Progent's Microsoft Exchange and Outlook consultants can provide expert online support for all versions Outlook and Exchange Server for on-premises, cloud-hosted, and hybrid environments.
Microsoft Office PowerPoint
PowerPoint 2016 includes relatively minor enhancements for one-time purchasers of Office 2016 desktop and a few additional enhancements for Office 365 subscribers. Most of the enhancement are generic to Office 2016 and shared with Office 2016 Word and Excel, including the Tell Me and Insights features, new chart types, support for Ink Equations, and easy sharing via SharePoint or OneDrive. Collaboration is improved in PowerPoint 2016 through a conflict resolution feature that displays side-by-side versions of PowerPoint slides that have been changed by different team members in different ways, making it easier to determine which version to retain. Additional improvements to Office 2016 PowerPoint desktop, which are also available for PowerPoint 2013 via updates, include support for 1920 x 1080 video resolution and the ability to apply Smart Guides to tables. Subscription versions of PowerPoint 2016 available through Office 365 include support for real-time co-authoring, a new Morph transition type, and the PowerPoint Designer service for improving the appearance of your slides.
Office PowerPoint 2013 includes an array of improvements including an updated look, enhanced support for tablets and smart phones, more controls for creating and presenting a slide show, better collaboration, multimedia integration, interactive features, and wide-screen support. The new Presenter View allows the monitor of the person giving a presentation to display comments while the audience sees just the slide. Presenter View also lets you zoom in on portions of a slide and jump directly to slides out of sequence. The free Office Mix add-in allows you to create and share live interactive presentations that support web links and animations. Office Mix allows you to record audio or video notes for any slide, insert quizzes, and upload presentations for sharing on Microsoft's OfficeMix.com site. Office PowerPoint 2013 has a 16:9 layout to support HD screens and includes new themes designed for widescreen displays. Other improvements include more control over motion paths, a PhotoShop-like eyedropper tool for color matching, Smart Guides for aligning objects, a new Comments pane to collect and display feedback, support for .mp4 and .mov with H.264 video and AAC audio, and additional built-in codecs.
PowerPoint 2010 offers a wide selection of tools for creating and displaying business information. Built-in video editing and embedding features allow you to put together compelling multimedia presentations and Microsoft Office Backstage simplifies file management and supports in-place video file compression. Integration with SharePoint Foundation allows live broadcasts of PowerPoint 2010 presentations that can be watched by viewers who do not have PowerPoint. SharePoint Foundation also enables simultaneous multi-site co-authoring. Collaboration is further supported by Lync Server or Office Communications Server for presence awareness, instant messaging, and one-click phone dialing. Microsoft Web App combined with SharePoint Foundation allows you to view and lightly edit PowerPoint 2010 presentations from most web browsers on most desktop computers, laptops, or smart phones.
For information about Progent's live online training services for Office PowerPoint, visit Office PowerPoint and Office 365 PowerPoint live online training.
Microsoft Office Access
Office Access 2016 largely retains the feature set of its predecessor, Office Access 2013, but benefits from enhancements common to Office 2016 such as the Tell Me capability for quickly locating the proper button or menu to carry out a desired action. The new Linked Table Manager dialog allows you to export a list of a database's linked data sources to an Excel workbook, which can be especially useful if you are trying to analyze a legacy Access application. New database templates have been modernized, and the default size of the Show Table dialog has been increased to display the names or more tables and queries. New features of Access Web App when used with SharePoint 2016 with Access Service include cascading controls, improved database filters, enhanced Related Item Control, expanded storage and faster performance for images, integration of Access web apps with Office Add-ins, and support for locking tables from editing. Office 365 Access now includes an updated Linked Table Manager, allows you to add new charts forms and reports, and lets you link or import data from Saleforce and Dynamics 365.
Office Access 2013 makes it easier to create web-based applications and features a significant change to the web model of Access 2010 by incorporating a new design utilizing SharePoint as a front-end host and moving the back end to SQL Server and Microsoft Azure SQL Database. This improves performance, security and availability and simplifies management for applications based on Access Web App. You have the choice of running Access 2013 on premises along SQL Server and SharePoint Server with Access Services, or you can move to the cloud and subscribe to Microsoft Office 365 and SharePoint Online. (Learn about Progent's Microsoft Azure planning and cloud integration consulting services.) In the case of an on-premises deployment, you can use the familiar desktop for Access based on the traditional Jet database, the new web model with SharePoint and SQL Server, or create a hybrid environment that combines both models. If you use Access 2013 Web App you can communicate with the SQL Server database and use tools like SQL Server Reporting Services (SSRS), Office Excel, Power View, and Crystal Reports for business intelligence reporting.
Office Access 2010 was a dramatic upgrade to the Office Access platform, making it easier to create databases, offering advanced tools for building forms and reports, introducing a more Windows-like user interface, supporting the design of codeless apps, and facilitating web publishing. To enable fast app development, Access 2010 introduced an array of integrated or add-in templates that provided the basic tables, forms, reports, queries, macros, and relationships needed to build viable apps. Areas covered by these templates include asset management, training, finance, inventory, non-profit, sales and marketing, plus time and billing. The databases built with Office Access 2010 templates are easy to tailor to the specific needs of an organization. Office Access 2010 also includes modules within Application Parts to create specialized databases quickly. The Office Themes feature, introduced in Office Access 2010, lets you consolidate and format multiple databases instantly. The legacy File menu of Office Access is replaced in Office Access 2010 by the Backstage view, which is part of the Microsoft Office Fluent interface and provides a common, extensible area for managing Access 2010 databases. The Office Access 2010 Expression Builder is enhanced with IntelliSense for streamlining the process of writing formulas and expressions. Access 2010's Macro Designer is also improved to simplify the addition of logic to an Access database. By installing a Web service definition file, you can connect to a Web service as an external data source. Access Services in SharePoint Server 2010 allows you to connect to and edit an Access 2010 database from a browser.
For information about Progent's online consulting, application development, and training services for all versions of Office Access and Office 365 Access, visit Office Access consulting, development and training.
How Progent Can Help You with Microsoft Office and Office 365
Progent can help you integrate Office 365 and Office 2016 with other Microsoft applications and platforms including SharePoint, Lync, Skype for Business, and SQL Server, or provide Cisco Unified Communications Manager consulting to integrate Microsoft Office with Cisco's Unified CM and Jabber software. In addition, Progent's Cisco-certified CCIE network engineers can help you optimize your network infrastructure to support local and remote desktop PCs, laptops, and smart phones so that your workers can benefit from advanced levels of security, availability, and performance whenever and wherever they run Microsoft Office applications.
Progent's Microsoft-certified consultants can help you with all facets of Microsoft Office integration, consulting, and technical support including:
Contact Progent for Microsoft Office Support
To find out more about Progent's migration and support services for Microsoft Office and Office 365, call 1-800-993-9400 or visit Contact Progent.