More conference Goodies

Patrick O’Beirne has generously offered a copy of his popular spreadsheet quality book:

Spreadsheet check and control (note the 5 star rating on Amazon - this is well worth a read)

as a prize for a conference draw. I guess he’ll do the draw during his session on Thursday the 29th November?

His presentation will help you learn where to look when searching out those tricky errors, winning the book will enable you read up on all the stuff he won’t have time for in his session.

You can see my review at Amazon, but in summary I think this book should be required reading for anyone working with spreadsheets.

cheers

Simon

Excel Pivot table training

The opening conference session will be an intermediate session on getting the most from pivot tables that I am presenting.

I’m a big pivot table fan and use them in pretty much every system I build for clients. On smurfonspreadsheets a while ago we discussed everyones favourite Excel feature, most people said pivot tables. And yet many people who could benefit in so many ways from using them avoid them. This opening session aims to make them more accessible for everyone.

The session will look at some of the reasons I like pivot tables, and some of the features I have found most useful over the years.

When and why to use pivot tables, and when not to
Pivot tables are superb in a great many situations, but every now and then you come up a case where the pivot way may not work well.

Preparing source data to be pivoted
I’m convinced one of the barriers would-be pivoters come up against is having source data in a less than ideal format. This section will discuss the issues and solutions. We’ll also look at grabbing external data, as that can be a massive win when planning reporting and analysis applications.

Professional pivot based reporting
Basic pivot tables can be just wide of what is needed for quite a few reasons, this section looks at common modifications that make them more likely to be acceptable to business customers.

Fine tuning presentation and analysis with calculations
The black art of getting pivot table calculations to actually calculate what you want, correctly, in all cases.

Charting pivot data
Pivot tables can be a pain to chart nicely, this section looks at some approaches to make that easier.

Introduction to Pivot Table VBA
Like so much in Excel a little VBA magic can go a long way with pivot tables. Guru coding skillz are not needed to boost the usability of your pivots.

The session will be an interactive one, with shout-out questions welcome, and time for more discussion at the end. It will be practical, Excel based with minimal PowerPoint. All sample workbooks and VBA utilities will be freely available to delegates.

If there is something you need to know about pivot tables in Excel that is not covered in the above agenda, drop me a line via the contact info and I’ll be sure to cover it.

Cheers

Simon

Excel conference special deal on FastExcel

FastExcel is an extremely highly regarded Excel add-in that is used by many professional Excel developers. And some very well known organisations are long time customers (Codematic doesn’t seem to be mentioned on the site, although we are happy customers too).

It allows them to focus quickly on proven ways to speed up workbook calculation times. And also to improve other performance criteria.

Normally its available for sale from www.decisionmodels.com for around £44.

As a conference special Charles Williams will be providing a free licence for everyone who attends his Optimising Calculation Speed Add-on class on Friday 30th November.

What an ideal combination - a class to give you the knowledge on how to get the best performance from your workbooks and the specialist commercial tools to take away to help implement that knowledge.

Places on the add-on classes are extremely limited and filling up quickly so don’t hang around. bookings here

If you are coming for Charles’ Friday class be sure and check out the other sessions on Thursday and Saturday.

cheers

Simon

Only 4 weeks left

For those of you keen to get your fix of in depth Excel training and advice, try to contain yourselves. There is only 4 weeks to go until the Excel User Conference in Cambridge. 3 days of highy focused, real world advice and training from some of the top Excel users and developers in the country. 3 days and 4 evenings of great networking opportunities. 3 days to take your Excel knowledge to the next level. 3 days to boost your productivity beyond recognition.

All the presenters will be participating in the evening activities, so even if you are too shy to ask your questions during the session, you could always ask them in the pub.

If you would like some advice in choosing the path that best suits your experience and objectives then please get in touch.

Cheers

Simon

Welcome to the UK Excel User Conference blog

Title says it all really.

The conference is coming up in a few weeks and we’ll use this blog to keep everyone up to date with any changes and developments.

Its shaping up to be a great event with some excellent speakers presenting extremely useful content.

And don’t forget the chance to socialise and network with fellow Excel users and some of the most prolific newsgroup and forum contributors in the country.

At the very first event in Dallas Forth Worth, one delegate had travelled all the way from Australia to get an answer to one specific question (something about copying button faces as I remember). Anyway he got his answer, in fact I think he got 2 or 3 usable answers, and some source code.

Be sure to bring any questions that are bugging you to the Cambridge event, and you can expect the same great help.

We hope to see you there.

Cheers

Simon