In Excel 2013, each of your workbooks opens in its own window, similar to Word and PowerPoint. This means that each workbook has its own ribbon and top-level window frame that you can move and resize independent from your other open workbooks. This functionality can improve multitasking, visibility, and analysis across workbooks. In this post, we’ll discuss some of the more advanced aspects of these changes, in particular how to…
Templates are one of the cornerstones in modern professional Excel development. By using one or more templates, we can provide a structural approach for end users to acquire, store and present data. From a development point of view, we can simplify the maintenance. In this tutorial, Excel MVP Dennis Wallentin shows how to simplify management of a Power View template by using a VSTO add-in.
In April, we released 2 important new spreadsheet management server-based applications to complement the desktop spreadsheet management features we introduced with the release of Office 2013. Now available are Audit and Control Management Server (ACM), and Discovery and Risk Assessment, which are both designed to help you manage the use of spreadsheets and Access databases. Read on to learn more.
Yesterday we announced some exciting news about Web Excel (and all of the Office Web Apps) over on the Office 365 Blog. Specifically, we announced that we’ll be improving the Web Apps to be a comprehensive productivity experience (not just a companion to the desktop applications) on more browsers and devices over the next year and beyond. Head on over to the Office 365 blog to check it out!
Ever had to sum data based on multiple criteria situated in different Microsoft Excel worksheets? In this tutorial, Excel MVP Liam Bastick provides a quick tour of INDIRECT references and Table functionality while combining qualities of the SUMPRODUCT function with the SUMIFS function, providing a solution to the mother-of-all Multiple Criteria problems.
One of the improvements we made for Office 2013 to the way users work with Charts in Word and PowerPoint is to make the data grid easier to use and less intrusive. Now the data grid is displayed in a streamlined small input window that floats above the chart. Read on to find out more about these improvements.
Visio offers over 60 types of professional templates to build compelling diagrams, and organization charts are among most frequently created. Visio organization charts are simple and visual, but what if you want to connect them to key business indicators your organization is tracking, such as sales by region or department or budget by department, vacation status, training reports? Sometimes this information is located in another source such as Excel or …