Excel 2010 has some wonderful features like customisation of the ribbon so you can create your own group in your own ribbon, sparklines (min charts) in cells next to data, conditional formatting with icons, smart pivot tabling (slicer). Many of these features are covered in our courses. Please see our MS Office page for sample agendas or contact us on courses@jplcomputer.co.uk
MS Project and Visio Links to Excel
If you crate a project plan in MS Project then you can export it to Excel so at least those wihout MS Project can see a basic outline of your tasks and resources and dates.
In a similar way you can link shapes in Visio to Excel.
For more information visit our web site www.jplcomputer.co.uk as we run courses in all 3 modules.
Filed under Uncategorized
Publisher 2010
Publisher 2010 allows you to create some really impressive leaflets, brochures and posters. There is also a really simple to use ‘mail merge facility’ which can create, for example, certificates for course attendees from an Excel list. We run a half day introductory course on Publisher 2010 please email publisher@jplcomputer.co.uk for more details.
Filed under IT Training Courses
15 Microsoft Office courses on offer
We are running a total of 15 courses across all levels and versions of Office. These can also be tailored to suit your needs. Get in touch on johnlegge@jplcomputer.co.uk for more details.
Filed under IT Training Courses
Office 2010 Courses
There are a whole host of new features in Office 2010. We’ve started conducting courses in the usual subjects including Outlook, Word, Excel, Publisher, PowerPoint and Project.
Some tasters here:
You can now ‘broadcast’ live your PowerPoint presentation through an internet link straight from PowerPoint 2010 as long as your client has a Windows live account.
There are Sparklines in Excel (simple chart lines) against data – easy to use.
Great new Smart Art’s in Word.
Conversations in Outlook to group together messages to and from same email addresses.
Loads more.
Contact us for course details 07903 840105 or newcourses@jplcomputer.co.uk
Filed under IT Training Courses
New Advanced PowerPoint course developed
We have developed a brand new Advanced PowerPoint course which is being delivered for the first time this week. For more information please contact us on http://www.jplcomputer.co.uk/contact.htm
Filed under IT Training Courses
Free places on IT Training courses
In July and August this year -we are offering 1 free place on the following training courses when at least 2 or more people are booked on the same course.
Basic Excel, Basic PowerPoint, Basic Access, Basic Visio.
Bookings must be placed and paid for by July 15th.
Terms and conditions apply. Contact us on 07903 840105 or specialoffer@jplcomputer.co.uk
Filed under IT Training Courses
MS Query in Excel
There is a little used feature in Excel called MS Query. This is found in the external data section and allows you to create a data source to a set of data like that found in an Access database. It then allows you to write a simple MS Query (like an Access Query) to retrieve data into the worksheet.
Filed under Excel tips
Excel 2010 new features
If you’re wondering about the differences between Excel 2007 and Excel 2010 don’t worry for long. The ribbon and tab change in Office 2007 products remain but the Office button has returned back to a File tab on the later version. Also you can now configure each ribbon and introduce your own new tabs in 2010 Office. Apart from that and some enhancements to charts there’s not a lot of difference between the two. For more information contact me on johnlegge@jplcomputer.co.uk
Filed under Excel tips
New Basic Visio Course announced
We have developed a 1 day Basic Visio course for those new or self taught in the product. It covers the basics in prcoess flowcharting, developing organisation charts, diagrams and processes with data.
Filed under IT Training Courses