Close
  • Latest News
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Logo
  • Latest News
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Applications
    • Applications

    Excel Makes Better Predictions in Office 2016

    By
    Pedro Hernandez
    -
    October 7, 2015
    Share
    Facebook
    Twitter
    Linkedin
      Microsoft Excel

      Excel 2016, part of Microsoft’s newly released Office 2016 productivity software suite, has new built-in tools to help users peer a little further into the future.

      Data forecasting is not new to Excel. Before the new version, “many used the FORECAST() sheet function, which performs a linear forecast or extended trendlines in chart properties to extrapolate forward,” reminded Microsoft’s Excel team in an Office Blogs post.

      As software makers are wont to do, they sometimes find other ways of getting the job done with an alternative algorithm. “The new functionality in Excel 2016 utilizes another algorithm, called Exponential Smoothing or ETS,” wrote the company’s bloggers.

      “Exponential Smoothing methods are a popular way to forecast and are among the leading methods that have become industry standards,” they continued. “The main advantages of using the ETS method are the ability to detect seasonality patterns and confidence intervals.”

      Excel 2016 can automatically detect seasonal patterns in historical data. Microsoft recommends at least two to three full seasonal cycles for more accurate results. Users also can set a seasonality value manually.

      In addition, the software’s ETS-based forecasting capabilities can generate a confidence interval, which Microsoft describes as “the range surrounding each predicted value in which 95 percent of future points are expected to fall based on the forecast (with normal distribution). The confidence interval helps you figure out the accuracy of the prediction. A smaller interval implies more confidence in the prediction for the specific point.”

      For a guided method of creating a forecast, Microsoft suggests users click the Forecast Sheet button under the Data tab after organizing their time-based series data. “This launches the forecast dialog that walks you through the process.” A how-to is available in Excel’s online documentation.

      Separately, Microsoft announced new updates this week for data explorers that instead use the company’s cloud-based analytics tool, Power BI.

      As part of a weekly service update, the company rolled out a new Suggested Questions feature. “There are instances where you may not know the specific terms in your data (e.g. when using a dashboard created by someone else),” said Theresa Palmer, a Microsoft Power Query program manager, in an Oct. 6 announcement. “With this release, we have added a feature to help you get started with Power BI Q&A, even when you do not know anything about the data.”

      Power BI dashboards now display a “How to ask” link alongside the Q&A search box. After analyzing the corresponding data, the software will suggest relevant questions. Clicking a question will automatically generate a new data visualization.

      Also this week, users can now insert shapes into Power BI Desktop’s the report canvas, the software’s authoring tool. “You can insert shapes by clicking on the ‘Shapes’ menu when in ‘Edit Report’ mode,” said Palmer. “Supported shapes are rectangle, oval, line, triangle and arrow. Several formatting options are available for each shape, such as line/fill colors, rotation, title, background, etc.”

      Finally, Power BI dashboards can be shared without sending an email invitation. Users can now generate a copy/paste-able URL by unchecking the “Send email notification to recipients” option in the Share dialog.

      Pedro Hernandez
      Pedro Hernandez is a contributor to eWEEK and the IT Business Edge Network, the network for technology professionals. Previously, he served as a managing editor for the Internet.com network of IT-related websites and as the Green IT curator for GigaOM Pro.

      MOST POPULAR ARTICLES

      Big Data and Analytics

      Alteryx’s Suresh Vittal on the Democratization of...

      James Maguire - May 31, 2022 0
      I spoke with Suresh Vittal, Chief Product Officer at Alteryx, about the industry mega-shift toward making data analytics tools accessible to a company’s complete...
      Read more
      Cybersecurity

      Visa’s Michael Jabbara on Cybersecurity and Digital...

      James Maguire - May 17, 2022 0
      I spoke with Michael Jabbara, VP and Global Head of Fraud Services at Visa, about the cybersecurity technology used to ensure the safe transfer...
      Read more
      Applications

      Cisco’s Thimaya Subaiya on Customer Experience in...

      James Maguire - May 10, 2022 0
      I spoke with Thimaya Subaiya, SVP and GM of Global Customer Experience at Cisco, about the factors that create good customer experience – and...
      Read more
      Big Data and Analytics

      GoodData CEO Roman Stanek on Business Intelligence...

      James Maguire - May 4, 2022 0
      I spoke with Roman Stanek, CEO of GoodData, about business intelligence, data as a service, and the frustration that many executives have with data...
      Read more
      Cloud

      Yotascale CEO Asim Razzaq on Controlling Multicloud...

      James Maguire - May 5, 2022 0
      Asim Razzaq, CEO of Yotascale, provides guidance on understanding—and containing—the complex cost structure of multicloud computing. Among the topics we covered:  As you survey the...
      Read more
      Logo

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2022 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×