ms excel
Get flash to fully experience Pearltrees
Simple, powerful, and easy to customize, Excel macros can save you time and increase your productivity. Macros called loops are especially useful for working with ranges of data. Whether you've only heard about macros or already used them in Excel, now's the time to find out more about them.
Get in the loop with Excel macros - Training - Office.com
Office Development
Hi All I am looking for a solution for a new Win CE 5.0 device that I have, i need to be able to send and receive e-mails on the device i have looked all over Microsoft's site but i cant seem to find a solution. Could someone please point me in the right direction on how to get this working (Link preferable) I need some sort of office application that will work on the device, i can get work and excel to work (viewer) but not e-mail. [tfl - 02 04 12] Hi - and thanks for your post.Excel Experts E-Letter Archives
Issue No. 20 (July 8, 2001): Formula to count unique items in filtered column. Formula to mimic NETWORKDAYS. VBA code to disable copy/cut/paste. VBA code to change the Excel icon. VBA code to substitute range address for range names in selected formulas. Issue No. 19 (June 1, 2000): Getting unique entries in an n*m array.
Microsoft Excel is jam packed with cool useful features that tend to go unused by most users, simply because they don’t know how to use them, or even that they exist. One of these features is Excel’s Goal Seek tool. First, some background on what it does.
Excel Zoom
Welcome This web site is brought to you as a public service by Chip Pearson and Pearson Software Consulting, LLC . We provide complete consulting and custom application design and development for Excel, Office, Visual Basic, and the NET Framework in VB.NET and C#.
Pearson Software Consulting, LLC, Comprehensive Excel Information
Candlestick Charts Microsoft Excel has some built-in chart types for displaying how stock prices vary during a trading period. This is usually a day, but it could also show weeks, months, or years, or even intervals of minutes or hours during a trading day.
Peltier Tech Blog
Excel Charts Blog
Welcome to the place where you can learn best practices for effective Excel charts in a corporate environment. In other words, where Tufte meets Excel . Learn how to get the most out of your data. Learn how to analyze and visually communicate quantitative information. ExcelCharts.com offers free and premium tutorials.Number of charts : XL2010 also offers VariChart() in the conditional formatting menu… in the other hand, the win/loss is nothing but a column chart with 1 ; 0 or -1. This limited number of charts does not reflect MSFT’s Business Intelligence ambitions… at least when it comes to Excel. Let’s assume it’s a start. Overall look : irrelevant from my point of view. Even w/ Zoom of 400% blocking is not noticeable, and specially not on printed reports.
Sparklines for Excel®
Introduction Spark lines is this really cool way to visualize information. They are small high resolution line charts that show you where things are heading. Note that they don't show any detailed data, but only the general trend. This article explains how to create and use spark lines in your ASP.NET application.
SparkLines - CodeProject
Eugene's Blog: How To...Draw a Polar Diagram in Excel
I have added a new video to YouTube as part of my " How To... " series. This one is about drawing Polar Diagrams in Microsoft Excel. I teach about Polar Diagrams as part of the subject of Performance Measurement. They are really useful and easy to draw - they can graphically show gaps in performance without the detail of figures. It took me a few hours to create this video - I made so many mistakes that I had to re-record it several times. I used PowerPoint to record the audio and Audacity to edit the .WAV files.
How to Make a Donut-Pie Combination Chart | Peltier Tech Blog | Excel Charts
We’ve been dissing pie charts and donut charts quite a bit. So why then would we want a donut-pie combination chart? In Jorge Camoes’ How to create better pie charts , he showed a chart like this one. It’s not so much a pie chart as it is a donut chart with about 40 series, the inner 30 sharing the same data, so they seem to make a single wedge.By: Jeff Clark Date: Thu, 27 Jul 2006 I promised a few months ago to describe something I call a Multi-level Pie Chart or Radial Treemap. I spent some time developing the idea as an alternative to the standard Treemap a few years ago before discovering that it had been done before . Despite the fact the idea has been around since 2000 it seems to be little known. I will illustrate the concept using survival data for the people on board the RMS Titanic which sank in 1912.
Multi-level Pie Charts
The Spreadsheet Page - By John Walkenbach
J-Walk & Associates is a small company owned by me: John Walkenbach . I've been using spreadsheets since the early days of VisiCalc. I've written many Excel books, and I also developed Power Utility Pak, a popular add-in for Microsoft Excel. [more about John]This week many Excel bloggers are celebrating VLOOKUP week. So I wanted to chip in and give you a comprehensive guide to VLOOKUP & Other lookup formulas. Read on …, What is VLOOKUP Formula & how to use it? I often tell my excel school students that learning VLOOKUP formulas will change your basic approach towards data.