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

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, and only Fruit items appear in the drop down list in column B.”​ Another Excel solution in search of … 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. This … 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”

Living in a virtual democracy

My reintroduction to Second Life has been quite gradual, as I didn’t stray very far from the SL Book Club at first. But a comment there one evening about the Confederation of Democratic Simulators caught my attention, so much so that I now call it home. So what is the CDS? It describes itself very … Continue reading “Living in a virtual democracy”

Reading: the how, what and why

Across three essays for Literary Hub, one of my favourite authors, Will Self, ponders big, bookish questions. Will Self: How should we read? In praise of literary promiscuity in the digital age – Literary HubTo read promiscuously is to comprehend the caresses of one work in the arms of another—and the promiscuous reader is a … Continue reading “Reading: the how, what and why”

This is my silence

Tinnitus is a strange thing — invisible and, to everyone else at least, silent. That’s the one thing it takes away from us, though. Today is the first day of Tinnitus Week 2021, and the theme this year is #ThisIsMySilence. #ThisIsMySilence – British Tinnitus AssociationAs a hidden condition, people without tinnitus do not truly understand … Continue reading “This is my silence”

Nothing is harder to do than nothing

Waterstones has uploaded a lengthy, introductory extract from Jenny Odell’s excellent book, How to Do Nothing: Resisting the Attention Economy. Vital reading. There’s also the video and transcript of the related talk she gave in 2017.

You can count on them to help

Meet the Excel warriors saving the world from spreadsheet disaster – Wired UKResearch suggests more than 90 per cent of spreadsheets have errors, and half of spreadsheet models used in large businesses have “material defects”. Given some 750 million people use Excel globally, there are plenty of errors needing attention. One prominent researcher calls spreadsheets … Continue reading “You can count on them to help”

“Without adult supervision”

I enjoyed, if that’s the right word, this description of us from across the Atlantic, taken from The New York Times Morning Briefing: Europe Edition newsletter. Their description of us certainly feels quite accurate. Unfortunately. Trump, Coronavirus, Sanda Dia: Your Monday Briefing – The New York Times Britain, operating without adult supervisionCoronavirus cases in Britain … Continue reading ““Without adult supervision””

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”