Microsoft Excel

Microsoft Excel | News, how-tos, features, reviews, and videos

Dashboarding with Excel 2010 Slicers and Multiple Pivot Tables

One of the new features in Excel 2010 is a type of visual pivot table filter called a Slicer. In typical fashion, the most valuable setting for slicers is buried where most users will never find it. A slicer could be a list of...

Microsoft lowers Office for Mac prices, will ship 2011 version in October

Microsoft has lowered the price of Office for Mac with its 2011 release, which will hit stores in October with prices ranging from $99 to $279, Microsoft announced Monday.

Chapter 2: Introducing the Excel Web App

In August, 2010, Network World's Microsoft Subnet is giving away 15 copies of the book Using Microsoft Excel 2010. Here is an excerpt that introduced the Excel Web App.

Pretty pictures: Tools for diagramming

First of all, for all of you wrestling with the thorny problem of whether to join the church of Steve and get an iPhone or join Ms. Palin in going rogue by plumping for a Droid, check out the xkcd comic strip on the topic....

Pretty pictures: Tools for diagramming

Gibbs looks for alternatives to Visio and finds great solutions online, on OS X, and on Windows.

What's under the Gearhead Christmas tree

Mark Gibbs pulls a few presents out from under the Gearhead Christmas tree and finds a better solution to his recent quest of randomizing a sequence of numbers, a really cool Bluetooth stereo headset and a service for building SUSE...

What's under the Gearhead Christmas tree

Here we are just a few days away from Christmas so let's see what's under the Gearhead Christmas tree. Ah, here's a really geeky present … A few weeks ago I discussed the problem of trying to create an Excel spreadsheet that could...

Lokad makes statistical forecasting accessible to small, medium and large businesses to help them lower costs.

Lokad has democratized time series forecasting for businesses of all sizes. Whether you're a small coffee shop or a division of a large enterprise, forecasting point-of-sales, scheduling staff, call center management, eCommerce,...

More randomness and the Synology Rackstation RS409+

A reader comes up with a neat solution for Mark Gibbs' randomization problem, having got his sweaty hands on a Droid he takes a first look, and slices and dices a really impressive SMB NAS solution, the Synology Rackstation RS409+. A...

More randomness and the Synology Rackstation RS409+

In a recent column about my efforts to generate a random sequence of numbers from 1 to 75 I described how I resorted to a labyrinthine system of Web services and proxies because I couldn't figure out how to do it with Excel without...

Data Mining your performance metrics - uncover that nugget...

Data Mining is relatively new technology but it provides extremely powerful functionality for our Business Intelligence solutions. The typical Data Warehouse may be multiple terabytes so how do we sift through that data to uncover...

Improving Excel and Yahoo Pipes

Microsoft Excel is brilliant. Except when it isn't. And a major place where it isn't is when you have an Excel spreadsheet with a number of cells containing strings (any sequence of ASCII characters) and you wish to concatenate all...

Improving Excel and Yahoo Pipes

You know how Excel is mostly really good but weirdly weak in a few areas? Mark Gibbs has found a fix for one issue: String concatenation. And while he's on the subject of data manipulation he begins taking a look at a remarkable Web...

The Curse of the Ribbon Menu

Everyone wants to take their shot at what's wrong with Microsoft these days so here's mine. Ribbon menus. I've long detested Microsoft's ribbon menu user interface. The biggest issue is what you once knew how to do, you now have to...

The Sentimeter, Part Deux

Following up on last week's column, Mark Gibbs discusses how the design of the Sentimeter evolved and the hoops he had to jump through. He may yet take up acrobatics.

Microsoft, Nokia team up

* Will bring business communications, collaboraation to Nokia's Symbian devices

The Sentimeter, Part Deux

Last week I began discussing a tool I will be making available for free: The Gibbs Universal Industries Sentimeter. The Sentimeter provides real-time sentiment analysis, that is, a measure of the positive or negative feelings related...

5 Reasons To Use SharePoint Instead Of Emailing Excel Files

In the SharePoint consulting I do, I try to look beyond just basic uses of SharePoint, where SharePoint acts as a basic replacement for shared folders on file servers. SharePoint can of course do document storage and does bring some...

Excel Export tips in 2008(Follow the blue line)

SSRS from its first inceptions has had the ability to export to multiple formats like CSV, XML, Excel, and PDF. The excel export is one in which many users(especially power users) find really useful because it allows them to export...

Microsoft Office Web Apps still cloaked in mystery

Microsoft Monday shed little light on its forthcoming Office Web Applications, which were announced nine months ago, leaving more questions about the depth of features, their integration with Office on the desktop, how they would run...

Load More
Top News