Have you seen OneNote 2010 yet?
It is FANTASTIC!! probably the most important piece of software since Microsoft Word.
Take a look at this video to get an idea of what it is about.
-
Recent Posts
Recent Comments
Archives
Set Default Font and Spacing in Word 2010
www.optimise.org.uk
It’s really easy to set the default font and spacing in Word 2010, once you know how!
Posted in Microsoft, Office, Uncategorized, Word
Leave a comment
Penguins in the Desert – Word 2010 Remove Background
Posted in Microsoft, Office, Word
Leave a comment
Microsoft Project Up & Running
Check Below for content and booking instructions
Microsoft Project Up & Running
- Getting started
- Key Up & Running settings
- Adding tasks
- Linking tasks
- Creating resources
- Assigning resources
- Scheduling resources
- Modifying views
- Resource and material costs
- Adding other costs
- Built in reporting
- Tracking your project
All this in a Half Day Course for only……….
£147 +VAT
That’s right. Only £147 +VAT. Incredible value!
19th September 2011 09:30 – 16:30
To book your place
Call 01785 816993 or 01782 377419
or email me at nick@optimise.org.uk or lara.turner@stoke.gov.uk
Places are limited, so please, don’t miss out!
Nick
If you might be interested in other courses we do, then take a look at our other computer course
If you would like to let us know what courses you would us like to run then suggest courses and services
Posted in Microsoft, Office, Project
Leave a comment
Word Level 1 & 2 Training
Check Below for content and booking instructions
Word Level 1
- Opening MS Word
- The screen
- Entering Text
- Spell check
- Adding page breaks
- Saving files
- Formatting Text
- Margins and page setup
- Cut, Copy and Paste
- Printing
21st September 2011 13:30 – 16:30
Word Level 2
- Handling bullet points
- Paragraph numbering
- Formatting tabs
- Auto text
- Headers and footers
- Page numbers
- Inserting pictures
- Page borders & backgrounds
- Watermarks
26th September 2011 13:30 – 16:30
All this in a Half Day Course for only……….
£85 +VAT
That’s right. Only £85 +VAT. Incredible value!
To book your place
Call 01785 816993 or 01782 377419
or email me at nick@optimise.org.uk or lara.turner@stoke.gov.uk
Places are limited, so please, don’t miss out!
Nick
If you might be interested in other courses we do, then take a look at our other computer course
If you would like to let us know what courses you would us like to run then suggest courses and services
Posted in Microsoft, Office, Word
Leave a comment
Excel & Word Level 3 Training
Check Below for content and booking instructions
Excel Level 3
- Working with IF functions
- Using VLOOKUP and HLOOKUP to access data from large tables
- Creating drop down lists
- Colour coding with conditional formatting
- Summarising data tables (subtotals)
- Creating charts and graphs
- Adding trend lines to charts
- Protecting worksheets form accidental data entry
28th September 2011 09:30 – 12:30
Word Level 3
- Basic Tables
- Working with tables
- Formatting tables
- Using Table AutoFormat
- Using functions in tables
- Inserting Excel workbooks
- Inserting graphs
28th September 2011 13:30 – 16:30
All this in a Half Day Course for only……….
£85 +VAT
That’s right. Only £85 +VAT. Incredible value!
To book your place
Call 01785 816993 or 01782 377419
or email me at nick@optimise.org.uk or lara.turner@stoke.gov.uk
Places are limited, so please, don’t miss out!
Nick
If you might be interested in other courses we do, then take a look at our other computer course
If you would like to let us know what courses you would us like to run then suggest courses and services
Posted in Excel, Microsoft, Office, Word
Leave a comment
Access Level 3 and 4 Training
Check Below for content and booking instructions
Access Level 3
- Building multiple tables
- Linking tables
- Types of relationships
- Creating ‘lookups’
- Building queries
- Using Expression Builder
- Querying multiple tables
- Creating calculations in queries
12th September 2011 13:30 – 16:30
Access Level 4
- Creating lookups in a table
- Creating forms and sub forms
- Using lookups in a form
- Using forms with queries
- Using calculations in a form
- Creating buttons on forms
3rd October 2011 09:30 – 12:30
All this in a Half Day Course for only……….
£85 +VAT
That’s right. Only £85 +VAT. Incredible value!
To book your place
Call 01785 816993 or 01782 377419
or email me at nick@optimise.org.uk or lara.turner@stoke.gov.uk
Places are limited, so please, don’t miss out!
Nick
If you might be interested in other courses we do, then take a look at our other computer course
If you would like to let us know what courses you would us like to run then suggest courses and services
Posted in Access, Microsoft, Office
Leave a comment
Excel level 1 and 2 training
Check Below for content and booking instructions
Excel Level 1
- Simple formula
- Basic functions
- Copying / duplicating formula
- Using AutoFormat
- Sorting lists
- Filtering data
- Creating subtotal lists
- Keyboard shortcuts
21st September 2011 09:30 – 12:30
Excel Level 2
- Scrolling screen headings
- Printing your workbook
- Headers and footers
- Working with percentages
- Absolute and relative references
- Naming cells and ranges
- Basic graphs
- Counting functions
- Basic analysis of large tables
26th September 2011 09:30 – 12:30
All this in a Half Day Course for only……….
£85 +VAT
That’s right. Only £85 +VAT. Incredible value!
To book your place
Call 01785 816993 or 01782 377419
or email me at nick@optimise.org.uk or lara.turner@stoke.gov.uk
Places are limited, so please, don’t miss out!
Nick
If you might be interested in other courses we do, then take a look at our other computer course
If you would like to let us know what courses you would us like to run then suggest courses and services
Posted in Excel, Microsoft, Office
Leave a comment
Scanning into Word 2007 or 2010
In Word 2003 you were able to scan an image directly into a document. This feature was accessed by selecting the INSERT menu, PICTURE then FROM SCANNER OR CAMERA.
Fantastic! Easy to use, it just kicked into your scanner software and away you went.
Unfortunately, Word 2007 and 2010, had this feature taken away, and didn’t give us anything in it’s place. What a pain.
But we can fairly easily create a macro that will do this for us. Now, this short post is really aimed at people who already know how to do macros etc, so I’m not going into all that here.
So here is the macro -
Sub ScanImage
On Error GoTo ERRORHANDLER
Application.WordBasic.InsertImagerScan
ERRORHANDLER:
End Sub
Simply add this code to a module as part of the Normal template, then add a new Group to the Ribbon bar for that macro.
Posted in Microsoft, Office, Word
Leave a comment
2 Great Courses, 2 Seperate Days
Optimise Consultancy Ltd will be running Excel training courses at The Hothouse, Stoke on Trent, on the 5th and 6th of July 2011
Check Below for content and booking instructions
Excel Level 1
- Simple formula
- Basic functions
- Copying / duplicating formula
- Using AutoFormat
- Sorting lists
- Filtering data
- Creating subtotal lists
- Keyboard shortcuts
Excel Level 2
- Scrolling screen headings
- Printing your workbook
- Headers and footers
- Working with percentages
- Absolute and relative references
- Naming cells and ranges
- Basic graphs
- Counting functions
- Basic analysis of large tables
All this in a Half Day Course for only……….
£85 +VAT
That’s right. Only £85 +VAT. Incredible value!
To book your place
Call 01785 816993
or email me at nick@optimise.org.uk
Places are limited, so please, don’t miss out!
Nick
If you might be interested in other courses we do, then take a look at our other computer course
If you would like to let us know what courses you would us like to run then suggest courses and services
Posted in Excel, Microsoft, Office
Leave a comment