Blogs

Simplify management of an Excel Power View template by using a VSTO add-in

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

Posted to The Excel Team Blog by Excel Blog on Thu, May 23 2013

Filed under: Templates, business intelligence, Excel 2013, PowerView, Add-in, Power View, data, workbook, BI, Power Pivot, data sets, VSTO

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...

Posted to The Excel Team Blog by Excel Blog on Tue, May 14 2013

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

Commercial Plugins for LiveCode Community Edition

Recently RunRev decided to also release their cross-platform development tool, LiveCode, as open source. For semi-developer and hobbyist this option allow them to develop customized solutions for all present platforms, including Android and iOS. The catch is that all customized solutions must be released under the open source rules, i.e it’s not possible to protect […] Read More...

Posted to XL-Dennis's Blog by VSTO & .NET & Excel on Mon, May 13 2013

Filed under: LiveCode

Importing Fixed Width Text Files with ActiveX Data Objects

A few weeks ago I was struggling with fixed width text files. Remember 1995? Me neither, but I’m living it every day. I happened upon a stackoverflow.com post that dealt with using ADO for this purpose. I don’t remember the post, so no link. It did, however, lead me to this MSDN article, which was [...] Read More...

Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, May 10 2013

Filed under: File Operations

Importing Fixed Width Text Files

I’ve been working with fixed width text files quite a bit lately. The built-in method for importing these files is terrible. First, it’s yet another wizard and I think it would be better as a single form (but then I think everything is better as a single form). The worst part, by far, is the [...] Read More...

Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, May 8 2013

Filed under: Charting, File Operations

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...

Posted to The Excel Team Blog by Excel Blog on Wed, May 8 2013

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...

Posted to The Excel Team Blog by Excel Blog on Wed, May 1 2013

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

Queen’s day sale

As some of you may know, I’m Dutch and live in “The Kingdom Of The Netherlands”. Well, tomorrow is an important day for the Dutch people: Queen’s Day. More so, tomorrow is an extra special day. Not because our Queen abdicates to make room for King Willem-Alexander, but because my 24 hour “Queen’s Day sale” [...] Read More...

Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Apr 29 2013

Filed under: MVP, Downloads, Worksheet Functions

Draw a circle in an Excel chart

By default, Excel has a limited number of charts. That does not mean that those are the only charts one can create. It turns out that with a little imagination and creativity, we can format and configure the default charts so that the effect is like many other kinds of charts. One of the more [...] Read More...

Posted to Daily Dose of Excel by Daily Dose of Excel on Sun, Apr 28 2013

Filed under: Charting, Data Visualization, Excel Intermediate, Visual Display, Chart, Excel 15, polar coordinates, concentric circles

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...

Posted to The Excel Team Blog by Excel Blog on Thu, Apr 25 2013

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

Analyze ‘free’ money

Recently, I received yet another promotion from yet another company offering me money at zero percent interest with the predictable asterisk next to the zero percent. Instead of just shredding the offer I decided to create a downloadable Excel template to analyze the offer, which was an interest-free 18 month loan for a 4% transaction [...] Read More...

Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Apr 25 2013

Filed under: Excel Basic, data analysis, template, zero interest loan, financial analysis

Date Picker Add-in for Excel 2011 for the Mac

Hi all I upload a Date Picker add-in based on John Walkenbach’s Date Picker on my site for the Mac, this Date Picker will also be a part of to the PUP add-in for the Mac soon. This Date Picker for Mac Excel have local Day letters in the header and also local Date formats in the format [...] Read More...

Posted to Daily Dose of Excel by Daily Dose of Excel on Sun, Apr 21 2013

Filed under: Uncategorized

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...

Posted to The Excel Team Blog by Excel Blog on Thu, Apr 18 2013

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

Stop Replying to Yourself

In this edition of How to Make Outlook More Like GMail, I address the problem of replying to a message that you have sent. Inexplicably, Outlook creates a message addressed to you. That make sense from the standpoint that a reply to should be addressed to the sender. But then there’s the whole common sense [...] Read More...

Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Apr 17 2013

Filed under: Outlook

Excel corrupts certain workbooks in migrating from 2003 to 2007

I got a email from a client asking for help because Excel was “destroying,” to use his terminology, his 2003 workbook after conversion to the 2007 format. And, after analyzing the kind of change Excel made, I had to agree. The following in 2003 Figure 1 becomes, in 2013 (and in 2010), Figure 2 The [...] Read More...

Posted to Daily Dose of Excel by Daily Dose of Excel on Sun, Apr 14 2013

Filed under: Excel12, Bugs, VBA, Formulas, Names, Excel 14, Excel 2007, Excel 2010, Excel 2003, Excel 15, Excel 2013, bug

Blogs

Tag Cloud