The Excel Team Blog

New server release: Spreadsheet controls in Office 2013

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. ...( read more ) Read More...

Published Tue, May 14 2013 2:59 PM by Excel Blog

Filed under: Excel, Excel 2013, spreadsheet controls, Office 2013, EUC, Compare, Risk, Controls

Office Web Apps Announcements

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! ...( read more ) Read More...

Published Wed, May 08 2013 1:19 PM by Excel Blog

Filed under: Excel Server, Web Services, Excel Web Apps, Web Apps, Excel Web App, browser

Summing data across multiple criteria on multiple worksheets

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. ...( read more ) Read More...

Published Wed, May 01 2013 11:06 AM by Excel Blog

Filed under: Tables, Excel 2013, data, SUMIFS, reports, INDIRECT, IFERROR, multiple criteria, workbook, SUMPRODUCT, datasheets, multiple worksheets

Improved data grid for charts in Word and PowerPoint

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. ...( read more ) Read More...

Published Thu, Apr 25 2013 2:16 PM by Excel Blog

Filed under: Excel, charts, Excel 2013, Data Grid, Word, PowerPoint, Office 2013

Excel Geek Express—otherwise known as Quick Analysis

Guest blogger Emily Warn is a writer and confirmed Excel geek. In this post, she demonstrates how to use the new Quick Analysis feature in Excel 2013 to create a spreadsheet with book sales numbers that can be sorted by name and number in order to make data tell a story by presenting it visually. ...( read more ) Read More...

Published Thu, Apr 18 2013 10:24 PM by Excel Blog

Filed under: How To, Tables, Sparklines, formatting, charts, Excel 2013, data, Quick Analysis, analyze

Dallas Utilities: Electricity seasonal use simulation using project codename “GeoFlow” Preview and Power View

The Microsoft account team in Dallas, TX wanted to create a localized demonstration that would be recognizable to customers in the area. Taking advantage of publicly available residential data and awareness of the extreme summer temperatures in and around Dallas, the team decided to present simulated household energy consumption data using Excel 2013, Power View and project code name "GeoFlow" Preview for Excel, believing the presentation would peak customers' interests. Read on to...

Published Thu, Apr 11 2013 9:00 AM by Excel Blog

Filed under: PowerPivot, business intelligence, Microsoft BI, Excel 2013, GeoFlow, Power View

Public preview of project codename “GeoFlow” for Excel delivers 3D data visualization and storytelling

Today we are announcing the availability of the project codename "GeoFlow" Preview for Excel 2013, a result of collaborations between several teams within Microsoft. GeoFlow lets you plot geographic and temporal data visually, analyze that data in 3D, and create interactive "tours" to share with others. Read on to learn how GeoFlow adds to the existing self-service Business Intelligence capabilities in Excel 2013, such as Microsoft Data Explorer Preview and Power View, to help...

Published Thu, Apr 11 2013 9:00 AM by Excel Blog

Filed under: PowerPivot, business intelligence, Microsoft BI, Excel 2013, GeoFlow, Power View

Using conditional formatting to highlight dates in Excel

Date functions in Excel make it is possible to perform date calculations, like addition or subtraction, resulting in automated or semi-automated worksheets. When you mix date functions with conditional formatting, you can create spreadsheets that display date alerts automatically when a deadline is near or differentiate between types of days, like weekends and weekdays. In this tutorial, Excel MVP Frédéric Le Guen shows how to put this functionality to work, with some examples in the...

Published Thu, Apr 04 2013 11:00 AM by Excel Blog

Filed under: Conditional Formatting, MVP, Excel, Excel 2013, Excel Web App, COUNTIF, formula, calendar, schedule, tutorial, date

Format and customize Excel charts quickly with the new Formatting Task pane

The new Excel makes creating and customizing charts simpler and more intuitive. One part of the fluid new experience is the Formatting Task pane, which replaces the Format dialog box. The new Formatting Task pane is the single source for formatting--all of the different styling options are consolidated in one place. With this single task pane, you can modify not only charts, but also shapes and text in Excel. ...( read more ) Read More...

Published Wed, Mar 27 2013 3:01 PM by Excel Blog

Filed under: Excel, formatting, charts, Excel 2013, format, chart, customize

Use Webservice functions to automatically update Excel spreadsheets with online data

Have you ever wanted to incorporate data from online resources into your Excel spreadsheets, such as stock quotes, weather, Bing Search results or even Twitter feeds? With new Webservice functions, now you can pull data from the internet into Excel--and the best part is the information updates automatically in your spreadsheet! Read on to find out how to put this functionality to work for you. ...( read more ) Read More...

Published Thu, Mar 21 2013 11:00 AM by Excel Blog

Filed under: functions, Formulas, Excel, Excel 2013, Web Data

Take the Excel Challenge for a chance to win a Kinect for Xbox 360 prize pack

We have some great news for Excel fans around the world! Our friends over at Microsoft Business Intelligence have launched an exciting new challenge on Facebook to test your skills and knowledge of Excel. Join the So You Think You Know Excel Challenge to answer 15 questions about Excel and you could get your name up on the leaderboard. Challenge your friends and colleagues or just play for fun. And you'll have the chance to enter the sweepstakes portion of this event, where we'll randomly...

Published Mon, Mar 18 2013 11:00 AM by Excel Blog

Filed under: Excel, Excel 2013

Join Tuesday’s webinar: 5 Things about Freezing Panes in Excel

Need to navigate that huge spreadsheet quickly? Freeze panes can help by allowing you to view your column and row headings continuously while you scroll your document. In this webinar, we'll demonstrate how to freeze panes in an Excel workbook, plus, we'll give you 5 tips of this feature, just in case you've ever been stumped while trying to freeze panes. We start our Office 15-Minute Webinar at 9:15 am Pacific Time, with a Q&A to follow. Click the link below or go to http://aka.ms...

Published Mon, Mar 11 2013 10:25 AM by Excel Blog

Filed under: office webinar

Which keyboard shortcuts should we add next to Web Excel?

We're currently planning the next round of keyboard shortcuts to add to Web Excel and would love to hear your input. Let us know about your favorite shortcuts in desktop Excel by filling out this survey . ...( read more ) Read More...

Published Mon, Mar 04 2013 12:09 PM by Excel Blog

Filed under: Excel, Feedback, Web Excel, Survey

Data Explorer brings Big Data connectivity to Excel 2013

Today we continue our series of BI related posts highlighting a recent announcement for a new add-in for Excel. On Wednesday, we announced an early look at a future addition to our self-service line-up with Microsoft "Data Explorer" Preview for Excel. "Data Explorer" enhances the self-service BI experience in Excel by simplifying data discovery and access to a broad range of public and enterprise data sources, enabling richer insights from data that has traditionally been difficult...

Published Wed, Feb 27 2013 2:02 PM by Excel Blog

Filed under: Excel, Excel 2013, Big Data, Add-in, Data Explorer

PASS Business Analytics Conference: Keeping up with the evolving world of data

The world of data continues to become bigger and more complex, with no plans to slow down. From April 10-12 in Chicago, data professionals and business analysts will gather at the PASS Business Analytics Conference to keep pace with the latest trends around big data, predictive analytics, data visualization, Hadoop, and even the new version of Excel. If you're a fan of Excel and are curious about how it fits within the Microsoft Business Analytics platform or you want to master how to use tools...

Published Tue, Feb 26 2013 11:11 AM by Excel Blog

Filed under: PowerPivot, Excel, Excel 2013, PowerView

Syndication

Recent Posts

Tags

Archives