Wiz Through Excel - 1 Oct 2009

Do you make any of these time-consuming mistakes?


o  Retype titles and sub-headings on each page of your document?

o  Type in page numbers at the bottom of pages and then amend them when you add pages?

o  End up printing blank pages or huge blank gaps on others?

o  Keep changing your font from Times New Roman or Calibri to your house-style each time you create a new document?

o  Tremble at the thought of tampering with tables?

o  Think that a Pivot Table is something you might find in a restaurant

o  Use a calculator to add up figures in your spreadsheet?

o  Have several spreadsheets with similar data that you keep having to cross-update?


If you answered YES to any of the above then these seminars are for you...

Wiz Through Word and Wiz Through Excel


In just over 2 hours we will show you a bunch of useful tools and tips for these and many more time-consuming mistakes which will save you hours of time and frustration and ultimately save you money!!

Look what’s covered…..


Re-typing Syndrome Solutions

Amazing ways to automate repeated text

Creating headers and footers that repeat on each page

Page numbers that adjust automatically when you add insert or delete pages


Funky Formatting

Sprinkling a uniform look and feel for your documents with font styles

Changing the default font.

Easily start a new page in the same document without being an “enter fiend”

The easy way to make different cells look the same, with the same borders and font styles

How to have your figures change colour depending on a condition.


Killer Keyboard Shortcuts

Do you spend lots of time going through menus to find what you want to do? Learn how to do things quickly through our top keyboard shortcut tips


Taming Tables

Creating tables, adding and deleting rows and columns

How to make your tables look pretty!


Pain-free Proof-reading

How to sift through a document and change as many occurrences that a particular name or phrase appears in one simple step.


Contents Page

How to easily create an content page that updates the page numbers as your document grows!


Sifting & Sorting Solutions

Time-saving tools to manage spreadsheets and data easily

How to sort multiple columns at the same time!

How to filter your data and only to see certain subsets of data

How to freeze column headings so you always see what the data is referring to


Panic-Free Printing

How to have all of your data fit on the page when printing

How to get rid of blank pages


Riveting Pivot Tables

So you've got a whole load of data.... But wish you could create some great summary statistics with it. Let us show you how pivot tables can do that for you in a jiffy!


Fabulous Formulae

Want to sum a row of figures? Want to take away two numbers? Or find the average or a row of figures? Or a percentage? Find out how easy it is to construct formulae from scratch!


Common Conundrums Cleared Up

Having trouble fitting the text in the cell? Mysterious #### symbols appearing?

We explain why and what to do (very simply!)


Read what past delegates have said

“Invaluable – will save me hours of time for the rest of my life!” Helen Lowrie, Garden Designer

"My knowledge of Excel isn’t great and this seminar has really helped" Chris Holt, Wenta


"All I can say is that Pivot Tables have revolutionised my spreadsheets!!" "Despite thinking I was proficient in Word, I certainly learnt some top tips!!"Anne-Marie Mittleman, A Virtual Angel


“Fantastic tips which will add value to my day to day accounting/cashflow maintenance. Thank you” Brigitte Bellwood, Resolutions Personal Fitness Training


"These tips are invaluable" Hazel Mardell, Senova


"Approachable, relevant and friendly to non-technical people", Florence Price, Talent Seed


"Great value for money and fab for refreshing basics and understanding helpful shortcuts" , Karen Nunn, Organise


Look at what else you get…..


Once you leave the seminar, to help you remember and put into practice all the useful tips you’ve learnt, we also provide:


  1. Cheat Sheets – quick tip reminder guides to all the tips shared
  2. 1 month’s FREE membership to Ask The Office Wiz – content rich resource to free how-to videos, useful links, more tips and tricks, recommended reading, Q&A Forum (worth £10 per month)
  3. 1 month’s FREE access to Ask The Office Wiz Telephone Support (worth £10 per month)


When and Where?


Wiz Through Excel

Thursday 1st Oct - The Enterprise Centre, Cranborne Rd, Potters Bar EN6 3DQ

Tuesday 20th October - Wenta Business Centre, Colne Way, Watford WD24 7ND

Cost: £50 per delegate


Wiz Through Word

Thursday 24th Sep - The Enterprise Centre, Cranborne Rd, Potters Bar EN6 3DQ

Tuesday 6th Oct - Wenta Business Centre, Colne Way, Watford WD24 7ND

Cost: £50 per delegate


Special £25 discount if you attend both Word and Excel, so you pay just £75 for both.

This seminar assumes delegates have at least a basic knowledge of Excel.


Name Sales End Price Fee
Wiz Through Excel - Potters Bar - 1 Oct 2009 Ended £50 £1.25
Athena Deal   Ended £25 £0.65

On the Web

Wiz through Word & Excel - Potters Bar - 24 Sep & 1 Oct ...

Wiz through Word & Excel - Potters Bar - 24 Sep & 1 Oct Ask The Office Wiz Thursday, September 24, 2009 at 10:00 AM (BST)


Who's an excel wiz??? - BlackHatWorld

The reason I'm using excel is because after this process ... Oct 2009 Posts 296 Thanks 129 Thanked 51 Times in 41 Posts. Who's an excel wiz???


Excel Macro Tutorial: October 2009

Excel Macro Tutorial


Wiz Khalifa Earns First No. 1 Album On Billboard 200

Meanwhile, Taylor Swift's "Shake It Off" blasts in at No. 1 on the Digital Songs chart with a massive debut. Hip-hop star Wiz Khalifa earns his first No ... Space Invader is Frehley's first album since 2009's Anomaly debuted and peaked at No. 27 with ...

Billboard • 8/27/2014

Wiz-Tober Halloween Event with Stars of WIZARDS OF WAVERLY PLACE Returns in 2009

The month is highlighted by the Season Three premiere of “Wizards of Waverly Place” on FRIDAY, OCTOBER 9 (8:00 p.m., ET/PT). Last year’s Wiztober delivered TV’s No. 1 rank in Total Day among Tweens 9-14. “Wiz-tober” kicks off with a …

Tvequals • 9/1/2009

Microsoft Patch Tuesday for October 2009: 13 bulletins

All of the Critical vulnerabilities earned their rating through a remote ... Client Security 1.0 are vulnerable. For those wondering, yes, Microsoft is patching the Server Message Block 2 (SMB2) protocol flaw disclosed in September 2009, which affects ...

Ars Technica • 10/9/2009

Dolphins-Jets: 13 things to know about Week 13's Monday night game

Oct. 12, 2009: The teams combine for 35 points in the fourth quarter ... Let's elaborate while breaking down the matchup in both serious and non-serious fashion. Thirteen things to know: 1. Geno or Vick: Does it even …

CBS Sports • 12/1/2014

Sparkman: Exceed And Excel is exceedingly good

Redoute’s Choice (three times), Flying Spur, Fastnet Rock, and Exceed And Excel have led the sire list in Australia, Danehill Dancer led the combined English/Irish sire list in 2009, and Dansili ... sired multiple Group 1 winners and many classic winners ...

Daily Racing Form • 10/18/2014

Walnut Creek Bulldawgs 14u Tournament-Only Competitive Baseball Team Tryouts - October 25/26, 2014

WALNUT CREEK, Calif., Oct. 2, 2014 The Walnut Creek Bulldawgs will be holding try-outs for its highly competitive Spring 14u tournament-only team on Saturday, October 25, 2014 from 1:30 to 3:30 ... was a member of 2009 DVC team that made it to the …

Yahoo Finance • By Walnut Creek • 10/2/2014

Where Is Homeownership Within Reach Of The Middle Class And Millennials?

Nationally, 59% of homes for sale are within reach of the middle class, compared with 62% last October. Nonetheless ... Public Use Microdata Sample (PUMS) using the 2009 metropolitan area definitions. Metro areas …

The Huffington Post • By Jed Kolko • 11/18/2014

Houston Texans’ Linebacker Persevering in Faith

Linebacker John Simon’s first two college seasons with the Ohio State Buckeyes went very well, as the team posted records of 11-2 in 2009 and 13-1 in 2010. However ... the adversity of 2011 as motivation to excel …

NCRegister • 11/28/2014

Microsoft to launch Office 2011 for Mac in October

It will be available "in several regions" starting in October, with availability expanded through the rest of the year. Microsoft also is launching a free upgrade program for users who buy Office 2008 for Mac between August 1, 2010, and November 30 ...

ZDNet • By Mary Jo Foley • 8/2/2010

Trailblazer Bye Dietz to enter U.S. Hockey Hall of Fame

Her father respectfully disagreed because of the limited opportunities for women to go far and excel in the sport ... one chosen for the U.S. Hockey Hall of Fame in 2009, that led to a significant growth of the women's …

NHL • 12/1/2014

Related Events