Kirk Koenigsbauer, corporate vice president for the Office Client Applications and Services team said “Today we are taking a big step forward for Mac® users—Office 2016 for Mac is now available in 139 countries and 16 languages. Based on feedback from the great Mac Office community, we’ve made major updates to each of the apps, and we couldn’t be more pleased to deliver it first to our Office 365 customers.”

Unmistakably Office, designed for Mac

The new versions of Word, Excel, PowerPoint, Outlook and OneNote provide the best of both worlds for Mac users—the familiar Office experience paired with the best of Mac.

If you already use Office on a PC or iPad, you will find yourself right at home in Office 2016 for Mac. It works the way you expect, with the familiar ribbon interface and powerful task panes. Mac users will appreciate the modernized Office experience and the integration of Mac capabilities like Full Screen view and Multi-Touch^TM gestures. With full Retina® display support, your Office documents look sharper and more vibrant than ever.

Office for Mac is cloud-connected, so you can quickly get to the documents you’ve recently used on other devices and pick up where you left off. New, built-in document sharing tools make it easy to invite teammates to work on a document together. When sharing documents, you won’t have to worry about losing content or formatting, as Office for Mac offers unparalleled compatibility with Office on PCs, tablets, phones and online.

Five modern, first-class applications

Word for Mac—Word’s powerful writing and reviewing tools make it easy to create great-looking documents. The new Design tab lets you easily apply designer-quality layouts, colors and fonts throughout your document. You can work on the same document simultaneously with your teammates and use threaded comments to have a conversation right next to the corresponding text.

Excel for Mac—The new Excel for Mac helps you visualize your information by recommending charts best suited for your data with chart previews. Familiar keyboard shortcuts, autocomplete and an improved formula builder save you time when creating spreadsheets or entering data. For deeper analysis, new PivotTable Slicers help you filter large volumes of data and discover patterns.

PowerPoint for Mac—PowerPoint’s improved Presenter View gives you full control when you present by showing you the current slide, next slide, speaker notes and a timer on your Mac screen, while the audience only sees your presentation on the big screen. The new animation pane helps you design and fine-tune animations, and the latest set of slide transitions add polish to your presentations.

Outlook for Mac—Managing your email, calendar, contacts and tasks has never been easier. The new Outlook for Mac has push mail support so your inbox is always up-to-date. The improved conversation view automatically organizes your inbox around threaded conversations, so you won’t have to hunt for related messages. And the new message preview shows you the first sentence of an email just below the subject line so you can quickly decide if you want to read it now or come back later.

OneNote for Mac—OneNote is the newest addition to Office for Mac. You can capture your ideas in digital notebooks and access them on any device. Find things quickly with the OneNote search engine that tracks your tags, indexes your typed notes and recognizes text in images and handwritten notes. Bold, italicize, underline or highlight notes, insert files, pictures and tables and organize your notes however you want. You can also share notebooks with friends, family or colleagues so everyone can work together on travel plans, household tasks or work projects.

Made better by Mac users

The customer participation in Office for Mac preview since its launch in March exceeded expectations, making it largest Office for Mac beta ever. Thanks to everyone who participated in the preview program and helped improve the product.

Mac preview participants provided with over 100,000 pieces of feedback. Based on this feedback, Office released seven updates in four months with significant improvements in performance and stability. Also added features like improved Mail Merge in Word, Propose New Time in Outlook and support for External Data Connections in Excel.

And the best news is that Office for Mac will continue to see ongoing improvements over time. With released updates and new features for Office 365 customers at least once per quarter.

Available today for Office 365 customers

Office 365 subscribers can get the newest version of Office for Mac today. All you need is an Office 365 subscription (Office 365 Home, Personal, Business, Business Premium, E3 or ProPlus), which includes the rights and access to use Office applications on Mac, Windows, iOS and Android devices, along with additional value in OneDrive and Skype.

Here are a few different ways to get Office 2016 for Mac today:

• Already an Office 365 customer? On your Mac, just browse to your account page (office.com/myaccount), sign in and follow the installation instructions. If you have Office 365 through your organization, go to portal.office.com/OLS/MySoftware.aspx.
• Are you a student? You may get Office 2016 for Mac for free or at a substantial discount. It takes only 30 seconds to find out at office.com/student.
• Otherwise, go to office.com/mac or buy an Office 365 subscription at your local retailer.

Office 2016 for Mac will become available as a one-time purchase option this September.

We hope you’re as excited as we are about the new Office for Mac. It’s one of many important releases this summer. “We released Word, Excel and PowerPoint for Android phones just two weeks ago, which join Outlook and OneNote for Android phones, and we are just weeks away from delivering Office Mobile apps for Windows 10.” said Kirk Koenigsbauer

Have questions?

Get help from Microsoft’s Cloud Solutions Partner.
Call us at: 856-745-9990 or visit: https://southjerseytechies.net/

South Jersey Techies, LLC is a full Managed Web and Technology Services Company providing IT Services, Website Design Services, Server Support, Network Consulting, Internet Phones, Cloud Solutions Provider and much more. Contact for More Information.

To read this article in its entirety click here.

Edit, work, create, and get more done from your iPad, for free

Four new, free apps are available on your iPad®. With both Microsoft OneDrive and Dropbox access, online storage—and access to your files—is always just a click away on your iPad. The new Microsoft Office apps give you the ability to flat out get more done.

• With the new Microsoft Word app, you can edit, create, and save your docs, wherever work takes you
• The new Excel app lets you analyze your data on the fly
• Build and deliver your presentations—right from your tablet or phone—with the new PowerPoint app
• The new Microsoft OneNote app helps you work collaboratively and stay organized on the go

With these apps, you can now access, edit, and save directly to your Dropbox account. You can even open and edit files that have already been saved in Dropbox.

Adding Dropbox is easy.  When you are in any of the new apps, follow these simple steps:

1. Tap on the arrow in the top left, then tap Open
2. Tap “Add a Place”
3. Select Dropbox

To get the Office apps for iPad®, open www.appstore.com/microsoftoffice from your iPad’s web browser.

Excel 2013 has easy access tools that generate professional-looking results quickly.  There are several new features with the new version that should not be overlooked.

Flash Fill

Flash Fill identifies and adapts to basic formatting to automatically input your data.  This tool performs several tasks such as merging information from multiple columns, adding formatting to current column and fixing anomalies with data.  Flash Fill will recognize and apply the selected format to your data but if data differs from row to row, it will not format correctly.

Recommended Charts

Recommended Charts identifies data guides the user to choose the best chart type for their data.  The main objective of using a chart is to highlight your work in a significant way.

1. Open the Excel Spreadsheet needed to create a chart.
2. Select the Insert Tab.
3. Select the Recommended Charts button to see suggested charts.

Recommended PivotTables

Recommended PivotTables are interactive tables that can analyze data, compare data and detect patterns/relationships.  In previous versions, PivotTables were too complex.

1. Open the Excel Spreadsheet needed to create a table.
2. Select the Insert Tab.
3. Select the Recommended Charts PivotTables to see suggested tables. 

Quick Analysis

Quick Analysis is an additional way to generate a chart for data. To generate a chart to highlight your work in a significant way, select the data and click the Quick Analysis Icon.

Timelines

Timelines let you filter through PivotTables, similar to a slicer.  The timeline will be embedded alongside the Pivot Table.

1. Select the PivotTable.
2. Click the contextual Analyze Tab.
3. Select Insert Timeline (in the Filter Group).
4. Then select OK.
5. In the upper-right corner you can select years, quarters, months or days.

Cloud Support

Cloud Support by Microsoft allows users to save Excel files to SkyDrive or SharePoint site.  Saving to SkyDrive or a SharePoint site allows users to review and edit files from any device with an Office 365 subscription.

Apps for Excel

Microsoft offers Apps for Excel to enhance what you can do with Excel.  Categories for Apps include Content Management, Financial Management, Productivity, Workflow and Process Management and many more. 

Present Online

Present Online is a way to share workbooks and allows others to update it.  Present Online requires the installation of Lync (if you have Office Professional Plus; Lync is already installed).

1. Sign into Lync.
2. Open all workbooks you need to share. (Close workbooks you do not want to share).
3. In Excel, click the File Tab.
4. In the left pane, choose Share.
5. Click Present Online.
6. Click Present.
7. Select a Lync meeting or create a new one.
8. Click OK.

Takeaway: 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

In 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

There 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

For 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

In 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

Unlike 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

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

Access – Upsizing Wizard

In 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

Workspace 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

Journal 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

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

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

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.

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.