Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Blogs

  • What’s new for business analytics in Excel 2016

    Today we unbox Excel 2016’s 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. The post What’s new for business analytics in Excel 2016 appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Thu, Aug 27 2015
  • Helping business analysts take full advantage of Excel 2016 and the new Power BI

    Excel 2016 and Power BI are a portfolio of tools that is unique in the industry. Together, they provide a broad set of capabilities that allow business analysts to more easily gather, shape, analyze and visually explore their data. —Read more for an overview of how these tools work together to solve your analytics needs. The post Helping business analysts take full advantage of Excel 2016 and the new Power BI appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Wed, Aug 26 2015
  • Warning: Special Cells slows to a crawl across multiple columns

    Further to my previous post on Goto Special/Blanks, it looks like there is a pretty serious problem with the SpecialCells method if you use it on more than one column. That’s because it’s blindingly fast at finding things in one column, but painfully slow in finding things in any other columns. Which is a problem, […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Aug 25 2015
    Filed under:
  • What good is the Data Model without PowerPivot?

    So in the book I’m forever writing, I have an example of how you can use the Data Model to effectively do VLOOKUPS. Take the example where we’ve got a transactional list of sales that has a product ID but no ‘friendly’ name or price, and another table that maps Product ID to price and […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sat, Aug 22 2015
    Filed under:
  • Deeper integration between Office documents and Outlook for iOS

    Today, we are excited to announce deeper integration between Outlook and our other key Office apps for iPhone and iPad—Word, Excel and PowerPoint—designed to make it easier than ever to collaborate on and share Office documents on the go. The post Deeper integration between Office documents and Outlook for iOS appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Thu, Aug 20 2015
  • Working with external data in Excel 2016 for Mac

    Excel 2016 for Mac adds native support for ODBC data connections and an all new Connection Manager and Microsoft Query to enable you to build, share and use workbooks that work on both Windows and Mac right out of the box. The post Working with external data in Excel 2016 for Mac appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Thu, Aug 20 2015
  • Introducing the Office IT Pro Deployment Script project

    Office 365 experts from around the world are contributing to a collection of PowerShell scripts that are designed to automate various procedures that would normally require manual intervention from an IT pro. If that sounds like you, check out our new community GitHub project for Office IT Pro Deployment Scripts. The post Introducing the Office IT Pro Deployment Script project appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Wed, Aug 19 2015
  • Visualize statistics with Histogram, Pareto and Box and Whisker charts

    We introduced you to our new chart types across Office 2016 and dove deeper into a few of them. We showed the effectiveness of Waterfall charts in visualizing financial statements and how hierarchical charts show complicated data with multiple levels and categories. Now, we'll take a closer look at the last set of chart types: statistical. —Read about Histogram, Pareto and Box and Whisker charts in Office 2016 for Windows. The post Visualize statistics with Histogram, Pareto and Box and Whisker...
    Posted to The Excel Team Blog by Office Blogs on Tue, Aug 18 2015
  • Searching Text Files in a Directory

    I have several years of vendor invoices, in text file format, in some directories on a share. I need to search through these text files to find an order number, manifest number, or some other piece of information. I can’t search everything because it would take too long. And I don’t have control over the […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Aug 17 2015
  • 4 updates in Power Query for Excel

    This month’s Power Query update includes four new or improved features, including the option to specify Join Type in the Merge Queries dialog, the ability to extract first, last or range of characters from a Text column, the ability to customize the Quote Style in the Split Column by Delimiter dialog, and support for UPN credentials in the Exchange connector. The post 4 updates in Power Query for Excel appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Fri, Aug 14 2015
  • Preview real-time co-authoring on OneDrive

    Earlier this year we announced real-time co-authoring support for Word 2016 as part of the Office 2016 Preview. For the last several months, this feature has been available to preview users co-authoring Word documents stored on SharePoint Online. Today, we are pleased to announce that real-time co-authoring is also available as a first-look for Word documents stored on OneDrive as part of the latest Office 2016 Preview release. The post Preview real-time co-authoring on OneDrive appeared first on...
    Posted to The Excel Team Blog by Office Blogs on Thu, Aug 13 2015
  • What’s new: July 2015

    July saw the new Office 2016 for Mac, Office Mobile apps for Windows 10, a preview of new Skype for Business services, and the introduction of Send—the app designed for in-and-out email. Developers have a new way to stay up to date with news, tips and tricks with The Office Dev Show, and Office 365 channels are live on IFTTT. See what else is new in Office 365. The post What’s new: July 2015 appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Thu, Aug 13 2015
  • Optimizing Yammer for teams

    Today we’re unveiling a number of exciting changes to Yammer, including a fresh new look and feel that’s designed for teamwork from the ground up. —Read more about Yammer from Juliet Wei. The post Optimizing Yammer for teams appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Thu, Aug 13 2015
  • 10 little-known keyboard shortcuts for editing in PowerPoint

    If you use PowerPoint at work or at home, keyboard shortcuts can be a great time saver. —Read more about some little-known keyboard shortcuts for PowerPoint. The post 10 little-known keyboard shortcuts for editing in PowerPoint appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Thu, Aug 13 2015
  • Episode 058 with Paul Katz on building Office add-ins for enterprise—Office 365 Developer Podcast

    In this episode, Jeremy Thake and Richard DiZerega talk to Andrew Salamatov about the Outlook announcements at Build and Ignite along with a two hackathons that were run in New York and Chicago. The post Episode 058 with Paul Katz on building Office add-ins for enterprise—Office 365 Developer Podcast appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Thu, Aug 13 2015
1 2 3 4 5 Next > ... Last »
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.