Excel errors are everywhere

I know that Excel is only trying to be helpful when it ‘corrects’ what it sees as formatting errors, but it really needs to pack it in. An alarming number of scientific papers contain Excel errors A team of Australian researchers analyzed nearly 3,600 genetics papers published in a number of leading scientific journals [and] found … Continue reading “Excel errors are everywhere”

Excel timesavers

I sit and stare at Excel for a significant proportion of my day. I can’t believe I’ve not been aware of this simple trick with copying formulas without messing up cell references. It’s saving me an immense amount of time. Copy Excel formula without changing cell references (or without file references) It’s quite simple actually! … Continue reading “Excel timesavers”

Excel-lent architecture

I love this new take on an old art form. The spreadsheet architecture of Emma Stevens Normally the mere mention of a spreadsheet can bring a distant glaze across the eyes of most creatives – the file format perceived as the antithesis of imagination by those desiring to create rather than tabulate. But Australian landscape … Continue reading “Excel-lent architecture”

Excel’s getting interesting. No, really

News that Excel will soon be expanding its range of data types, enabling a much richer and more dynamic experience. Excel Data Types AI powered Excel Data Types will transform the way we work with Excel by enabling a cell to contain much more than text, numbers or formulas. There are currently two Excel data … Continue reading “Excel’s getting interesting. No, really”

Excel tips and tricks

Often with these kinds of training videos it’s the ‘ooh I’d forgotten you could do that‘ moments that are the most useful. The overall topic of the tutorial itself might not be what you’re after (do you really need to know how to make a Christmas Tree in Excel?), but just simple reminders about things … Continue reading “Excel tips and tricks”

A time before Excel?

An article from 1984 about these crazy new electronic ledger sheets, or “spreadsheets”. A spreadsheet way of knowledge There is no doubt that the electronic spreadsheet saves time and provides insight; there is no doubt that even greater benefits will one day be derived from these grids. Yet all these benefits will be meaningless if … Continue reading “A time before Excel?”

But who could possibly hate Excel?

This tool makes it stupid simple to turn data into charts Here’s something handy for people who hate Excel. Venngage, the company that lets you make infographics with the click of (a few) buttons, recently launched a new product called Beam. Beam does for charts what Venngage does for infographics as a whole. Which is … Continue reading “But who could possibly hate Excel?”

Clever lists in Excel

Another Excel solution in search of a problem. I must be able to try this out on something… Create dependent drop down lists in Excel “Limit the choices in an Excel drop down list, by using named ranges and the INDIRECT function, to create dependent data validation lists. For example, select Fruit in column A, … Continue reading “Clever lists in Excel”

Excel and the cat’s whiskers

Excel box and whisker diagrams (box plots) Box and Whisker Charts (Box Plots) are commonly used in the display of statistical analyses. Microsoft Excel does not have a built in Box and Whisker chart type, but you can create your own custom Box and Whisker charts, using stacked bar or column charts and error bars. … Continue reading “Excel and the cat’s whiskers”

Word in the cloud, Excel projects

“Save & Send” Word Documents to Windows Live Skydrive Today, I want to describe how you can save Word 2010 documents directly to “the cloud” using Windows Live SkyDrive. Windows Live SkyDrive is a service of Microsoft. It provides 25GB of free online storage. Two of the greatest features it has are document sharing between … Continue reading “Word in the cloud, Excel projects”

Mental health, Twitter, HE in Wales, Excel

Mental Health and Social Media | Therapy Soup Of course there are dangers, too. We’ve blogged about the dangers of the Internet and Social Media in the past, but we wanted to learn more specifically about the potential for mental health care and addiction treatment benefits. How Scholars Are Using Twitter (Infographic) The effect Twitter … Continue reading “Mental health, Twitter, HE in Wales, Excel”

Bird watching, kind of

Find yourself staring out of windows? Try some different ones. WindowSwap lets you cycle through picturesque views from all over the world – The VergeThere’s something very positive about the experience. Strangers are taking their time to share their favorite watching spot to help those who might not have one (or are just tired of … Continue reading “Bird watching, kind of”

Could do better?

Politicians got a taste of their own medicine whilst they waited for the results of the PISA tests this year. The Programme for International Student Assessment is a way of measuring how effective countries’ education ministers are in improving education standards. And this year’s results? For some, it was good news. English school children are … Continue reading “Could do better?”

Coaching (by/for/with) managers

A critical examination of the possible contribution of coaching or mentoring to leadership and management within a team or organisation

To Google or not to Google

I thought coming across these articles recently (just two of many) was a little ironic, given current moves at work to migrate us away from the Microsoft ecosystem towards Google’s. How can I remove Google from my life? Google started by taking over the search engine market. It now dominates smartphone operating systems (Android), browsers … Continue reading “To Google or not to Google”

Libraries of the past and the future

I’ve always thought of libraries as places that have existed forever, like cemeteries, or shoe shops — they’re just a necessary part of a normal society, right? (It’s thought the Library of Alexandria was founded as long ago as 285 BC, though its current incarnation is only 16 years old and closes at 4 pm today.) … Continue reading “Libraries of the past and the future”

Boy meets girl meets robot

So what to read next, after Dune? More sci-fi? Ian McEwan’s “retrofuturist family drama” seems to be getting some attention. Man, woman, and robot in Ian McEwan’s new novel It’s London, 1982. The Beatles have reunited (to mixed reviews), Margaret Thatcher has just lost the Falkland Islands to Argentina, and Sir Alan Turing, now seventy, is … Continue reading “Boy meets girl meets robot”

Dune. Done.

So. They’re remaking Dune. 7 things we know so far about the Dune remake (& 3 things fans are hoping for) Dune has quickly become one of the most anticipated upcoming movies. With plenty of talent and a beloved source material already behind it, there were plenty of fans looking forward to this big screen … Continue reading “Dune. Done.”

What’s your number?

Another maths curiosity from the Futility Closet: Fortuitous numbers In American usage, 84,672 is said EIGHTY FOUR THOUSAND SIX HUNDRED SEVENTY TWO. Count the letters in each of those words, multiply the counts, and you get 6 × 4 × 8 × 3 × 7 × 7 × 3 = 84,672. Here’s something I’ve (pointlessly) … Continue reading “What’s your number?”