• Guarantee Icon Instant Digital Download
  • Guarantee Icon 24/7 live chat
  • Guarantee Icon 90 Days Money Back
  • Guarantee Icon Certified Partner
  • Product Information

    Earlier this week we explained how Excel the world's most widely used and familiar data analysis tool works with the new Power BI and Power BI Desktop to provide business analysts with a powerful portfolio of analytic tools unique in the industry. Today we unbox Excel 2016s new and improved business analytics features, so you can take full advantage of each capability as it applies to your unique business needs. Excel 2016 improvements have been designed with the analyst's journey in mind, from gathering to consuming data.

     

    Faster and easier ways to get data

     

    Before analysis can begin, you must be able to bring in the data relevant to the business question you are trying to answer. Excel 2016 now comes with built-in functionality that brings ease and speed to getting and transforming your data allowing you to find and bring all the data you need into one place. These new capabilities, previously only available as a separate add-in called Power Query, can be found natively within Excel 2016. Access them from the “Get & Transform" section on the Data tab.

     

    Use these capabilities to connect to data from a wide range of sources like tables in public websites, corporate data in databases and cubes, cloud-based sources like Azure, unstructured data like Hadoop and services like Salesforce then bring the data into your workbooks data model or display them as tables within a worksheet.

     

    The Query Editor, which opens when creating a new query or opening an existing one under Get & Transform, provides intuitive data shaping and transformation options, enabling you to prepare a data set with only the information you want to see and in the way you want to see it. Each step you take to transform the data can be repeated and rearranged to help you work faster and more efficiently. When you refresh the data connections, every step you took to transform the data is preserved. And once you have the information prepared, you can share your queries easily with others.

     

    Additional features available under the Get & Transform section includes accessing recent sources you've used in previous queries and options to combine queries together. With a premium version* of Excel 2016 and a Power BI license, you can also use search to discover corporate data available to you across your company that is shared in a corporate catalog or even share your own queries with others.

     

    Integrating the Power Query technology also provides benefits for programmability. With these features integrated into native Excel, you can use VBA and the Object Model to program a related query and transform actions. And if you need more than the predefined actions provided, you can use the powerful query language (M) to create additional actions and capabilities.

     

Star Star Star Star Star
Over 200 Trusted 5-Star Reviews

  • Exceptional Customer Support

    Exceptional Customer Support. Great product at a fabulous price. Third time purchasing from Softwaredepot, and have been impressed with the whole experience each time. Thank you!.

    Star Star Star Star Star

    Sally C-L 12/01/2024

    Trustpilot
  • Recent Purchase

    I received an upgraded product and received a discount on it. Very happy with the customer service.

    Star Star Star Star Star

    Barb Schnitzler 12/01/2024

    Trustpilot
  • Very easy to install

    Very easy to install.No problems at all.

    Star Star Star Star Star

    Morcombe Transport 12/01/2024

    Trustpilot
  • What's the difference between Office 365 and Office 2019?

    You get the premium Office software with the Office 365 subscription plans: Word, Excel, PowerPoint, OneNote, Outlook, Publisher, and Access (Publisher and Access are only available on a PC). Office 365 can be enabled across various devices, including PCs, Macs, Android tablets, Android phones, iPad ®, and iPhone ®. Office 365 also comes with services such as 1 TB OneDrive room, 60 Skype minutes a month and support for Microsoft chat and phone. You get the new versions of the software with a subscription, and also receive updates as they happen. Learn more about Office 365.



    Office 2019 is a one-time purchase that includes classic PC or Mac applications such as Word, Excel and PowerPoint, and does not contain any of the features that come with an Office 365 subscription. One-time purchases do not have an upgrade option, which means you would need to buy it at full price if you intend to upgrade to the next major update.

  • How do I know my PC or Mac can run Office?

    By viewing the requirements, you can verify if your computer will support your Office version.

  • Will Office be identical on a PC, a Mac, and a mobile device?

    No. Office applications are designed to better function on each system and platform. The Office applications and version numbers available to Mac users can vary from those available to PC users.

  • Can people with an earlier version of Office open documents I created using Office 365 or Office 2019?

    Office 365, Office 2019, Office 2016, Office 2013, Office 2010, Office 2007, Office for Mac 2011 and Office for Mac 2008 applications can open your documents without further intervention. Customers using earlier Office versions would need to download and install a compatibility pack.

  • Is Internet access required for Office?

    Internet access is required for downloading and enabling all the new Office suites releases and all Office 365 subscription plans. Internet access is also required for Office 365 plans to control your subscription account, e.g. to install Office on other PCs or to change billing options. Internet access for documents stored on OneDrive is also required, unless you install OneDrive desktop app.To keep your Office edition up-to-date and benefit from automatic updates, you should also connect to the Internet regularly. When you do not connect to the Internet at least every 31 days, your applications will go into reduced functionality mode, which means you can access or print your documents, but you will not be able to update or build new documents. Simplify reactivating your Office software by reconnecting the Internet.



    To use the Office software, such as Word, Excel, and PowerPoint, you don't need to be linked to the Internet because the programs are completely installed on your computer.

  • What is the maximum number of Office licenses I can activate using the same Microsoft account?

    Users can activate 1 Office 365 Home and Office 365 Personal subscription, and up to 25 Office Home & Student 2019, Office Home & Business 2019, and Office Professional 2019 licenses.

slider cart close icon

Your cart

  • Subtotal: $0.00 NZD
  • Discount: 0
Total: $0.00 NZD
Proceed to Check Out cart-slider-arrow-icon
cart-slider-lock-icon Your Payments are fully secured
cart-slider-payments-secure-icon

We Accept

  • American Express
  • Apple Pay
  • Diners Club
  • Discover
  • Google Pay
  • Mastercard
  • PayPal
  • Shop Pay
  • Visa
...