Stay connected wherever work takes you

If you ever travel for business or work remotely, like 23 percent of U.S. employees do, you rely on communication tools to stay in touch with your partners and clients whether you’re inside or outside the office. You need the most up-to-date technology to ensure your work isn’t limited by location or circumstance, but what should you look for in your communication tools?

Here’s our list of five non-negotiable features:

  1. You’re easy to get ahold of—Want to make it easier for people to connect with you no matter where you are? Use your email signature to let others contact you directly, be it cellphone, a remote office number or an online number. With Office 365, you can make your Outlook signature phone number link directly to your Skype for Business address. Your information will be linked automatically, so others can instantly communicate with you in real-time. Read this TechNet article to find out how to create a TEL:// or SIP:// link in your signature.
  2. Take calls from the device that is easiest for you—While constantly on the go, collaboration isn’t limited to your office. You may need to start a call or presentation in your office before transferring to your cellphone to wrap it up on the road. Skype for Business allows you to do so without disrupting your workflow. If you’re on a call or presenting from your computer but have to leave the office, Skype for Business enables you to seamlessly transition your conversation across devices. You can either change the device connected to the PC or transfer to mobile.
  3. Run presentations and share your applications with ease—Running a meeting with remote participants can be tricky, especially when you’re giving a presentation. You shouldn’t have to compromise a quality voice connection for a simple screen share—nor should you feel the need to run a meeting across multiple platforms. Skype for Business makes the process as simple as possible by letting you share PowerPoint slide shows directly in a meeting. No need to worry about sharing files and emailing links, you can just focus on your presentation.
  4. Record meetings—Not sure about some of those key points that were mentioned during your call? Or was a colleague or partner not present? Multimedia recording features should always be included with business-class communication tools. With Office and Skype for Business, you can record and replay presentations and video, so any of those details that might have been missed are always a click away.
  5. Communicate with those outside your organization—It’s unlikely everyone you talk to outside your company will use the same communication tools as you, so it’s important to look for a tool that offers ease of use for guests. Fortunately, connecting with non-Skype for Business users is not a problem. Accessing the conference or meeting as a guest is simple, and the security and robust features the host relies on remain standard.

Several barriers to communication and collaboration can arise when you’re working outside the office. Fortunately, Skype for Business can help. It’s more than just a video chat option; it has the features to keep you connected and make work as accessible as possible.

Try out these tips with your Skype for Business account and read up on additional features in our free eBook.

 

For more information please contact Atidan at office365@atidan.com.

Reference: https://blogs.office.com/2016/08/01/stay-connected-wherever-work-takes-you/

The BrightWork New Release- It’s Here!

This week, BrightWork announced the new release of their project and portfolio management solution for SharePoint. This new release delivers several capabilities to make project and portfolio management easier for their customers, headlined by the new task scheduling feature that allows users to apply simple schedules to a tasks list in SharePoint.  Additional highlights include a more attractive presentation of data through live dashboards and enhanced scorecards, as well as an easier project site creation process.

Task Scheduling

Many of our customers have asked for the ability to create simple schedules in their BrightWork site. Now you can easily plan work in the tasks list, like setting durations, adding start dates, and identifying predecessors. This allows you to calculate a simple schedule right in your BrightWork site.

task-scheduling-in-sharepoint

Live Dashboards

Another area we have focused on for this release is better presentation of data, making it easier to use, visualize and interpret. The new live dashboards on the homepage of your project site is a very easy way to display metrics on your dashboards to show key metrics and increase visibility to your team.

live-dashboards

Enhanced Scorecards

We’ve also taken our scorecards and charts to the next level in terms of look, feel and control for you. Now visual reports look fresh and display the information in the way you want, informing better and quicker decisions.

enhanced-scorecards

Easier Project Site Creation

Finally, we’ve made it way easier to create new project sites. We’ve given you more control, so now you’ll be able to add, hide or expose fields as you wish, ensuring that all the right information is captured in the project site when it is created.

easier-project-site-creation-process

 

For more information please contact Atidan at office365@atidan.com

IM on it—Why Instant Messaging is Collaboration’s Secret Weapon

Implementing an instant messaging platform is important for productivity for teams of all sizes. Enabling a system for quick, informal, easy-to-reference and mobile chats keeps teams connected for nimble collaborations—resulting in a major value-add to your business.

How much value, exactly? Businesses that have embraced instant messaging practice have seen remarkable improvements in productivity and streamlined communication. According to a survey of employees using chat services conducted by SoftwareAdvice.com, 75 percent saw decreased call and email volume, and 66 percent noticed quick resolution for simple questions. When it comes to productivity, 21 percent noted either moderate or significant increase.

IM instant messaging is collaborations secret weapon FI

As company-wide IM benefits become clear, more and more businesses are getting on board. If you’re interested in these benefits but are wary to ensure proper implementation and use throughout your company, provide best practices for your employees to reference to increase productivity and reduce frustrating growing pains.

Don’t shoot the messenger

The following five best practices help ensure successful adoption and usage of IM in your organization:

  1. Provide a company-wide solution—Don’t require employees to use personal accounts; implement a company-provided instant messaging offering. This will streamline features and allow all your employees to find each other to chat.
  2. Choose a secure solution with robust featuresCompliance standards (like HIPPA, DPAS and FISMA, FERPA and banking) apply to more than just email and other secure information sources. Ensure that all your business communication tools align with common compliance standards.
  3. Integrate with other collaboration tools—Standalone instant messengers can leave employees with cumbersome roadblocks. Ensure your solution integrates seamlessly with other tools like business email, phone and video conferencing. Encourage employees to start conversations within project-specific documentation, so that the goal of the conversation remains clear and important information can be easily referenced.
  4. Empower employees to set and respect boundaries—Being reachable 24/7 is unrealistic and sets up your employees for burnout. Encourage colleagues to mute their instant messaging tool for periods of private productivity and focus, then remind co-workers to respect that virtual space.
  5. Don’t replace email completely—Instant messaging is a great option to communicate with even the most inbox-overwhelmed colleagues. But, instant messaging should not replace email or other collaboration tools that are core to keeping record of memorialized conversations. Set standards and show examples of the types of content best handled via IM, email or other project management tools. A general rule is length, if the message will contain more than a few words or sentences, email remains the best option.

A valuable tool for company-wide collaboration, instant messengers should be used to keep employees productive—not distracted or stressed. By implementing and encouraging best practices and sticking with a solution that includes everything you need to implement these practice at the outset, you can see skyrocketing productivity and results.

For more information please contact Atidan at office365@atidan.com.

Reference: https://blogs.office.com/2016/07/20/im-why-instant-messaging-is-collaborations-secret-weapon/

Communication Powered Productivity – New Office 365 Plan Launch

Microsoft and Atidan believe that the heart of productivity is great teamwork, and the heart of great teams is great communication. Productivity today is centered on conversations—sometimes a quick instant message or call, and sometimes a meeting planned in advance including voice, video and content sharing.

With many different avenues of communication, people need tools that allow them flexibility in how they connect. For years, consumers have embraced new ways of communicating, turning “Skype” into a verb synonymous with video calling. But corporate telephony, including PBX systems, and audio and video conferencing systems, has lagged behind—until now. Having Skype for Business as an integrated part of the work people are already doing in Office means greater continuity as they collaborate and communicate throughout their day.

Built on the familiar Skype user interface, Skype for Business makes connecting with colleagues as easy and intuitive as connecting with friends and family on Skype. With the new services, Skype for Business gets even better, for organizations and their people:

  • PSTN Conferencing provides the flexibility to dial in to a meeting from a traditional phone, in addition to the existing ability to join a meeting with a single click on your PC or mobile device.
  • Skype Meeting Broadcast makes it easier than ever to produce large virtual meetings for up to 10,000 meeting attendees, who can join from virtually any browser or device (see it in action). Now Skype for Business truly is a single platform for every type of meeting.
  • Cloud PBX enables companies to eliminate separate PBX systems and transition to the cloud with Office 365 as the central location to manage users for communication and
  • With PSTN Calling, Office 365 customers can also subscribe to Microsoft managed calling plans and phone numbers, starting in the U.S. with more markets coming later.

Watch this video to learn more about how the new Skype for Business capabilities can benefit your organization.

Simplify your infrastructure, lower your costs and empower your people

Microsoft is the only company that has built this combination of capabilities—a cloud business phone system including dial tone, and a complete meetings solution including audio, video, content sharing and messaging service—as a core part of a complete productivity and collaboration suite, available across mobile platforms and at a global scale.

Today, over half of our business customers are currently paying for multiple conferencing solutions, and many are still using legacy PBX phone systems. Now they can simplify their infrastructure with one cloud platform for meetings and voice, ultimately reducing the cost, complexity and effort of maintaining legacy phone and conferencing systems.

But it’s about more than saving money. People spend nearly a third of their time at work in meetings, yet only 18 percent of information workers actively use conferencing tools that enable rich experiences like video and content sharing. When you consider that nonverbal signals account for nearly 90 percent of the messages we receive during interpersonal communication, it’s clear that moving to modern communication tools can have a dramatic impact on productivity and collaboration.

Office 365 brings significant new value 1

Desktop sharing during a Skype for Business meeting.

A rich partner ecosystem

As we release these new capabilities in Office 365, partners like Atidan will play an integral role in extending the value of our new services.

We also partner with telco operators who provide secure, high-quality network connectivity and managed services that help customers get the best experience with the new Skype for Business services. These partners include BT Global Services, Orange Business Services, SoftBank, TATA Communications and Telstra.

Key partners like Polycom are delivering innovative new solutions for audio conferencing including the Polycom® RealPresence Trio™ for groups, and Polycom® VVX® desktop phones, which are the first phones qualified for the new Skype for Business services in Office 365.

Application partners like Genesys are also building on our platform to deliver solutions like contact center applications that work with Skype for Business and Office 365.

Deeper value from security and analytics

In addition to the Skype for Business capabilities, we’re releasing new security and data analytics capabilities in Office 365, including:

  • Delve Analytics—Empowers individuals through rich dashboards that provide insights on time and relationships, with the goal of helping individuals get time back and spend it effectively.
  • Power BI—A business analytics service that enables information workers to visualize and analyze data with greater speed, efficiency and understanding through live data dashboards, interactive reports and compelling visualizations.
  • Customer Lockbox—Gives customers new approval rights, transparency and control over their data in the cloud.
  • Advanced eDiscovery—Integrates Equivio machine learning, predictive coding and text analytics capabilities, to reduce the costs and challenges that come along with sorting through large quantities of data for eDiscovery purposes.
  • Advanced Threat Protection—Protects against unknown malware and viruses by applying behavioral analysis.

Contact the Atidan team at office365@atidan.com for additional information and a free briefing!

Blog credit: https://blogs.office.com/2015/11/30/office-365-brings-significant-new-value-to-business-customers-worldwide/

Introducing Office 2016 – Takes the Work Out of Working Together

Atidan is pleased to announce the availability of Office 2016! Contact us for a free trial and no obligation briefing and demonstration.

The New Microsoft Office 2016 Video

Office 2016 Product Guide

The new Office—takes the work out of working together

Check out additional resources on our SlideShare site here

The new office is here 1 v2

Collaboration is the way we get things done in the workplace, but the process itself can be complex and frustrating. It shouldn’t have to be. We set out to make working together easier and more impactful by building a suite of integrated apps and services that removes barriers and empowers teams to do and achieve more.

Office has always been the go-to tool for helping individuals do their best work—whether for professional documents, powerful analyses or school presentations. People often start and end their work in Office, but there is often a messy middle that involves a lot of discussion—in person, by phone or via various tools—as well as multiple (sometimes conflicting) inputs. Today we are delivering a set of experiences that is built for making teamwork seamless.

  • We have had real-time co-authoring in all of our web apps since 2013. We are now taking it to the next level by building it directly into our native apps. With this release, we’re making co-authoring in Word real-time, which lets you see what others are writing immediately, as it happens. We’re committed to expanding real-time co-authoring to each of our native apps and you should expect to see more over time.
  • Skype for Business is now available in the client apps, allowing you to IM, screen share, talk or video chat right in your docs. This same experience will be coming to Office Online later this fall. Skype for Business also has faster screen sharing and now adds the option to start a real-time co-authoring session from any conversation or meeting.
  • Keep teams connected with Office 365 Groups, now available as part of Outlook 2016 and in a new Outlook Groups app on iOS, Android and Windows Phone. Office 365 Groups allows individuals to easily create public or private teams. Each group includes a shared inbox, calendar, cloud storage for group files, and a shared OneNote notebook to keep the team productive.
  • Office 365 Planner helps teams organize their work, with the ability to create new plans, organize and assign tasks, set due dates and update status. Planner’s visual dashboards and email notifications help keep everyone informed on the overall progress of their initiative. Planner will be available in preview, to Office 365 First Release customers, starting next quarter.
  • Originally unveiled earlier this year, GigJam is today available in private preview and will become part of Office 365 in 2016. GigJam is an unprecedented new way for teams to accomplish tasks and transform business processes by breaking down the barriers between devices, apps and people.

Works for you

Excel 2016 - New Sunburst Chart

In today’s workplace, we have too many apps, devices and tools—we just don’t have enough time. Office is built to cut through the complexity and help you get things done quickly. It gets work done for you.

Some highlights:

  • Outlook 2016 provides the smartest inbox yet, delivering lightning fast search, removing low priority mail automatically and making sure everyone on the To: line has the right access to modern, cloud-based attachments from OneDrive.
  • We also have significant new updates to OneDrive for Business coming later this month across sync, browser, mobile, IT control and developer experiences. The highlight is the preview of the next generation sync client for Windows and Mac, offering improved reliability and selective sync, as well as increased file size and volume limits.
  • Tell Me helps you easily and quickly find the right Office feature or command, and Smart Lookup brings insights from the web right into your documents. Previously available only in Office Online, Tell Me and Smart Lookup are now available across the Office 2016 client apps.
  • Excel 2016 now includes integrated publishing to Power BI and new modern chart-types to help you make the most of your data.
  • The cloud-powered most recently used documents list allows you to pick up right where you left off in seconds, because it travels with you across your devices whether working in Office Online, the mobile apps or in the 2016 client apps.

Perfect with Windows 10

Office Mobile Apps

While we have made a lot of progress on delivering Office cross-platform and remain committed to this strategy, we see Windows as being “home” for Office. Together, Office 365 and Windows 10 are the most complete solution for getting things done.

  • With Windows Hello, you can sign in to your PC and Office 365 with a simple look or a touch—no need to type a password anymore.
  • In the coming months, Cortana will get even smarter and more useful by gathering intelligence on Office 365 through Outlook 2016 support.
  • With the Office Mobile apps and Continuum on Windows phones, your phone can act as a desktop, and you can project, create or edit your presentation or sales budget from your phone to a monitor while using the same phone to take notes with the OneNote app.
  • Sway on Windows 10 was released in early August, and customers love it! It has received a 4.6/5 app store ranking, with customers calling it “funtastic,” “brilliant” and “elegant.” People love Sway’s simple and intuitive yet powerful approach to next-generation digital storytelling. With Sway, you provide the content, and Sway creates beautiful, shareable, interactive stories that look great on any screen.
  • Our Office Mobile apps on Windows 10 (Word, Excel and PowerPoint) have also received great reception and 4+ app store rankings. Customers say they are touch-friendly, fast and easy to use—making them wonderful for on-the-go-productivity.

For the enterprise

Office 2016 apps with Office 365 provide the most secure Office yet. We are adding built-in Data Loss Prevention (DLP) to significantly reduce the risk of leaking sensitive data by giving IT admins tools to centrally create, manage and enforce policies for content authoring and document sharing. Multifactor Authentication ensures secure access to content anywhere when employees are away from the corporate network. We are also adding Information Rights Management to Visio. Then, later this year, we will be enabling Enterprise Data Protection (EDP) in Windows 10, with support in Office Mobile, which allows more secure corporate content sharing across corporate managed apps and network/cloud locations, preventing inadvertent content sharing outside corporate boundaries. We will be following up with EDP for Office on Windows desktop in early 2016.

Some of our favorite enterprise apps—Visio and Project—have been updated as well. With Visio 2016, customers can get started quickly with diagramming using starter diagrams and contextual tips. Bringing process models, manufacturing plant or IT architecture to life is now only one step away. With Project 2016, customers can streamline resource engagement processes, manage resource pools through visual heat maps, benefit from multiple timelines, and create custom experiences in Project desktop through write-back capabilities for add-ins.

We are also making deployment easier and have a lot of other new capabilities to help IT professionals, as announced in our blog to IT admins two weeks ago.

Office 2016 for Mac

The new office is here 4 v2

In July, we released Office 2016 for Mac to our Office 365 customers. The new versions of Word, Excel, PowerPoint, Outlook and OneNote are a significant step forward and provide the best of both worlds for Mac users—a familiar Office experience paired with the best of the Mac platform. The level of engagement and excitement about this Office for Mac release has surpassed our expectations. As promised in July, today Office 2016 for Mac will also be available as a one-time purchase.

Ongoing Office 365 customer value

Whew—that was a lot! With this release, we’re also shifting the cadence of Office on Windows to feel much more like the cadence we have on the Office mobile and web apps, which release every month with new value. So, going forward, Office 365 customers will now enjoy new features and capabilities delivered continuously in the Office desktop applications as part of their subscription. It’s a new day for our desktop apps.

And as a bit of a teaser, here are some examples of the types of new features and benefits Office 365 customers will see:

  • Built for teamwork—We’re committed to rich co-authoring and collaboration across our native clients, starting in Word 2016, with other big advances in collaboration coming throughout the year. By the end of 2015, we’ll introduce Office 365 Groups insights and discovery in Office Delve. In addition, we will have a new generation of personal work analytics in Office Delve that will help individuals, teams and organizations to be more effective at work by understanding their reach and impact, time allocation and network.
  • Works for you—For those of you who are excited about our new charts and forecasting, we will be delivering even more new charts, formulas, connectors and other Excel capabilities throughout the year. (If you’re interested in telling us which charts and charting features you’d like to see first, we have a survey going on our Excel Facebook page right now!). We also have some very exciting developments in the pipeline for PowerPoint that will make it easier to design and deliver presentations to wow and engage your audience.
  • Perfect on Windows 10—We are especially excited about how even more valuable your personal assistant Cortana can be when she has insights from Office. This will start to allow Cortana to unlock helpful scenarios, like retrieving your documents, preparing for meetings and more.

Get started

  • Are you ready to purchase? Buy Office 365 to get the new 2016 apps – contact us at office365@atidan.com
  • Are you an existing Office 365 customer who is ready to upgrade? Go here for instructions on how to upgrade to Office 2016 for home, or here for business customers.
  • Do you want to learn more? Go to office.com/2016.

Credit for this blog content is from Microsoft blog https://blogs.office.com/2015/09/22/thenewoffice/

7 new Exchange Online Protection enhancements

Post was written by Shobhit Sahay, technical product manager for the Office 365 team.

The Office 365 Exchange Online Protection (EOP) team has been hard at work on new features that reflect our continued commitment to provide advanced security, reliability and protection of your email, and a simpler and more efficient user experience for email admins. Today, we’re pleased to announce seven new EOP features, including:

  1. Scheduled EOP reports
  2. Domain-based email traffic support
  3. Simplified block and allow
  4. Quarantined message preview
  5. Bulk release
  6. Improving backscatter detection with Boomerang
  7. Non-delivery report (NDR) backscatter storm prevention

Scheduled EOP reports and domain-based email traffic support

Two new EOP reporting features have been included in this update. First, customers can now schedule EOP reports to be delivered via email on a weekly or monthly basis. For tenant admins, this means you can schedule EOP reports to arrive in your inbox on a day that you specify and choose from four types of EOP reports:

  • Mail traffic summary (aka sent-and-received mail)
  • Spam detections summary
  • Rule matches
  • Data Loss Prevention policy matches

7 new Exchange Online Protection enhancements 1

The new scheduled report feature is easy to set up on the Office 365 portal for EOP or Exchange Online customers.

To get started, go to the Office 365 portal and click Reports, then select the type of report you want to schedule. From the report page, click Schedule this report. It’s that easy! You’ll find more information about scheduling EOP reports and the customization features that help you obtain the specific data you need here.

7 new Exchange Online Protection enhancements 2

Scheduled EOP reports are delivered to your inbox on the day of the week or month you specify.

The second new reporting feature enables admins to assess email traffic at the domain level through PowerShell. For large customers with many domains, this feature makes it easy to view domain-level aggregation of mail traffic. To obtain mail traffic breakdown by domain, use the ‘Domain’ parameter with  Get-MailTrafficReport and Get-MailTrafficPolicyReport in PowerShell. More information about domain-based email traffic support is available here.

Simplified block and allow

We simplified the process for EOP or Exchange Online admins to block or allow emails from an individual sender or an entire domain. The new simplified block-and-allow lists replace the need to write a complex transport rule to bypass spam filtering or modify the Spam Confidence Level for a sender or domain.

Located in the Spam Filter section of the Office 365 Exchange Admin Center, you’ll access this feature by clicking the Protection link, making it easy and intuitive to find. There, you can create, edit and maintain block-and-allow lists for senders and domains.

spamallowlist

Simplified block and allow is currently in preview with first-release customers and will be deployed worldwide by the end of the month.

Quarantined message preview and bulk release

As part of our efforts to revamp our quarantine feature area to further protect against email containing malware or viruses, we released our new quarantined message preview earlier this month. You gave us the feedback that you need more information to determine if a quarantined message is malicious or legitimate. The new quarantined message preview allows you to see the body of a message without triggering any malicious content. This new visibility provides an improvement over previously just seeing a quarantined message’s sender, recipient, subject and date.

Two months ago, we released our bulk release feature, which has received widespread positive feedback from customers. Now, admins can quickly and easily select up to 500 quarantined messages to release or not release, which can be especially helpful in addressing large email campaigns. The bulk release feature can be accessed either through the Office 365 quarantine area or via PowerShell.

Backscatter spam improvements

Backscatter spam—when you receive a non-delivery receipt for an email that a spammer sent using your forged email address—is a growing source of irritation for end users and a challenge for email admins. We have stepped up to backscatter spam with two new protections:

  • Improving backscatter detection with Boomerang—In addition to basic backscatter protections in Office 365, we recently rolled out Boomerang, our Microsoft-branded mechanism to better detect backscatter spam. Now deployed for both hosted and on-premises mailboxes, Boomerang provides greater security and smarts to fight backscatter spam.
  • NDR backscatter storm prevention—This feature, deployed in May, addresses backscatter on a mass scale by automatically deleting the majority of a spammer’s large-scale email campaign, leaving just a handful of forged messages so that the responsible admin has visibility on the attack. NDR backscatter storm prevention is especially helpful in preventing spammers from spoofing well-known, executive email aliases, which are often targeted to add an appearance of legitimacy to spam or to direct mass hate emails.

Contact the Atidan team at office365@atidan.com for additional information about security and special offers on Office 365 deployment and support!

Microsoft Power Query for Excel

Microsoft Power Query for Excel enhances self-service business intelligence (BI) for Excel with an intuitive and consistent experience for discovering, combining, and refining data across a wide variety of sources including relational, structured and semi-structured, OData, Web, Hadoop, Azure Marketplace, and more. Power Query also provides you with the ability to search for public data from sources such as Wikipedia.

With the Power BI Preview edition, you can share and manage queries as well as search data within your organization. Users in the enterprise can find and use these shared queries (if it is shared with them) to use the underlying data in the queries for their data analysis and reporting. For more information about how to share queries, see Share Queries.

http://www.microsoft.com/en-us/download/details.aspx?id=39933

With Power Query, you can

  • Find and connect data across a wide variety of sources.
  • Merge and shape data sources to match your data analysis requirements or prepare it for further analysis and modeling by tools such as PowerPivot and PowerView.
  • Create custom views over data.
  • Use the JSON parser to create data visualizations over Big Data and Azure HDInsight.
  • Perform data cleansing operations.
  • Import data from multiple log files.
  • Perform Online Search for data from a large collection of public data sources including Wikipedia tables, a subset of Windows Azure Marketplace, and a subset of Data.gov.
  • Create a query from your Facebook likes that render an Excel chart.
  • Pull data into PowerPivot from new data sources, such as XML, Facebook, and File Folders as refreshable connections.
  • With the Power BI Preview edition, you can share and manage queries as well as search data within your organization.

Power Query Data Sources

  • Web page
  • Excel or CSV file
  • XML file
  • Text file
  • Folder
  • SQL Server database
  • Windows Azure SQL Database
  • Access database
  • Oracle database
  • IBM DB2 database
  • MySQL database
  • SharePoint List
  • OData feed
  • Hadoop Distributed File System (HDFS
  • Windows Azure Marketplace
  • Active Directory
  • Facebook

Prerequisites:

  • Requires Microsoft Office Professional Plus 2013 or Office 365 ProPlus.
  • Supports 32-bit or 64-bit machines. If you are using the 32-bit version of Excel 2013, you must use the 32-bit version of the add-in. If you are using the 64-bit version of Excel 2013, you must use the 64-bit version of the add-in. The two versions are not interchangeable.
  • Requires Windows 8, Windows 7, or Windows Server 2008 R2 (requires Microsoft .NET Framework 4.0).
  1. Download and install Office 365 ProPlus.
  2. Make sure Excel is not running.
  3. Download and install Microsoft Power Query Preview for Excel.
    • Open the folder where you downloaded Microsoft Power Query Preview for Excel.
    • Double-click the downloaded installer file, and then follow the steps in the wizard.
    • After the installation is complete, click Finish.
    • Microsoft Power Query for Excel will appear as a new tab on the Excel ribbon.ImagePower BI for Office 365 from Atidan