Wiz Through Excel - Watford - 20 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 - Watford - 20 Oct 2009 Ended £50 £1.9
Athena Deal   Ended £25 £1.27

On the Web

Wikipedia:WikiProject Musicians/Cleanup listing ...

Wikipedia:WikiProject Musicians/Cleanup listing. ... 3.42.20 Oct 2009; 3.42.21 Nov 2009; 3.42.22 Dec 2009; ... 3.112.21 Oct 2009;


Excel Add-in for Exporting Data to XML - CodeProject

ExcelXMLExport is a Microsoft Excel 2010 Add-in that generates XML data from Excel ... How can I get through this error and install the add in ... 20-Oct-14 7:07


Using Google Docs to make a survey - WorkHappy.net

... even through Google Forms can't do it all like payments, ... Oct 10, 2009 2:26:46 PM. Blastoff! By Invitation Only! IT'S FREE! ... Oct 29, 2012 5:20:29 AM.


tips and strategies for numerical reasoning tests ...

20.10.2009 · 20 Oct 2009. numerical testing ... Not everyone is a whiz and breezes through numerical tests. We've all been through phases of struggle.


Unable to Load Workbook – MOSS 2007 | SharePoint Expert ...

29.10.2009 · ... The workbook that you selected cannot be loaded because it ... via the Web Browser instead of directly through Excel. ... 2009 in SharePoint Common ...


Snoop Dogg - HotNewHipHop

Snoop Dogg (and/or Snoop Lion) ... Oct 20, 1971 - Age 43: Hometown: ... The Weed Iz Mine Snoop Dogg Feat. Wiz Khalifa. 128.3K Views.


Exel Oyj - Cision

... 2009 14:20 CET. EXEL COMPOSITES PLC STOCK ... Oct 29, 2009 08:20 CET. EXEL COMPOSITES PLC STOCK ... industrial division within Exel, through expansion ...


Excel Reader - CodeProject - The Code Project

... Liu Junfeng; Updated: 20 Feb 2009; Section: Office Development; Chapter: Enterprise Systems; ... Excel Reader. Liu Junfeng ... i looked through the source, ...


Wiz's Computer and Website Security Blog: Archives

... through April 2012; Wiz's email spam ... 2009; Block trackback spammer ... Spybot Search & Destroy updates for Oct 28, 2009; My Spam analysis for Oct 20 ...


Carvin = bright sound? - SevenString.org - Seven-string guitar

Carvin = bright sound? User Name: Remember ... but I have no idea what it'd sound in real life through a serious metal amp ... 08-20-2009, 03:25 AM #8: Scali ...


Annual Report 2009/10 - Clas Ohlson

Annual Report Directors’ report ... Helsingborg. Oct 2009: Västra Frölunda ... terås, Bryne, Reading. Dec 2009: Norrköping, Kingston, Watford. March 2010 ...


Wiz Khalifa's "Black & Yellow" And Four Other Hot Football ...

13.10.2010 · Wiz Khalifa hopes to join an elite ... To kick off their 2009-10 ... The pair aims to "make your adrenaline/pump right on through your skin" while ...


Beth Hemmila of Hint Jewelry: Pricing Jewelry & Excel ...

07.07.2009 · Pricing Jewelry & Excel ... My most fav financial resource is a downloadable Excel spreadsheet that you ... Many blessings for connecting with me through ...


Wiz Khalifa

Joined February 2009. 1,709 Photos and ... Cameron @ wizkhalifa · Oct 28 ... making videos and music but I will in no way be operating as the Wiz …


Find External Links in an Excel File « Contextures Blog

... go through the file ... There were other cells with square brackets that aren’t external links, so I ignored those. Excel table references ... December 20, 2013 ...


excel pivot tables | lynda.com search

Nov 05, 2009. Viewers: ... we can delegate to Excel the heavy lifting through the use of pivot tables and sumifs. View course. ... Excel 's pivot table.


Excel VB Run Time Error 1004 - RESOLVED-VBForums

... in VB for Excel. I have a macro that runs fine through ... When I use the control button I get run time error 1004 with ... I'm the so called Excel whiz, ...


X1 Church Watford (@X1Watford) | Twitter

The latest Tweets from X1 Church Watford ... Wonderful number of ladies gathering for the Excel Soirée ... The X1 series through the book of Acts. Prep in full ...


MATLAB Central - Doug's MATLAB Video Tutorials » MATLAB ...

Nov 20 MATLAB: In an assignment A ... Spring 2009 MATLAB programming contest is open; ... Here is a simple example of importing Excel in MATLAB and looping through ...


Ultra Petroleum Corp Q2 2009 Earnings Conference Call ...

... Manager IR Mike Watford Ultra ... the rates into the 20 million per day increase in gas production from the ... let me take you through a couple ...