98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsPrevious article Next article Excel articles
Excel 2010 A Glance Into The Future
Tue 24th November 2009
Most users who survived the large differences between pre and post-2007 Excel will be familiar with the 'ribbon' format of the taskbar. A useful feature that has been introduced for 2010 is that you can manipulate it, adding or taking away tabs as you please. Such a feature will be useful to those folk who do a complex job with repetitive elements, like accounting spreadsheets.
A significant feature will be "Sparklines", new charts for data that are in cells. Before being put off by having to learn what appears to be a whole new system, most people will already surprise themselves by already being familiar with the type of graph they produce. A Sparkline is typically a large but compact amount of data, presented simply (e.g. a line graph). Anyone who is familiar with how the stock market share prices look on a graph throughout the day is looking at something very similar to a Sparkline. If you're still worried about getting to grips with this new way of presenting chart data, then there's already an add-on (albeit an unofficial one) for Office 2003/2007 users, so have a play around before it makes its debut!
Advanced to intermediate Excel users will already be well-versed in the usefulness of pivot tables. A new feature called the "slicer" in Excel 2010 will provide a more graphical approach to filtering what you want your pivot table to show. Instead of a drop-down list, you have a picture-based interface to work with and can clearly see what data is being dragged around and manipulated. This should, theoretically, make it easier for basic users and make learning how a pivot table works a lot easier.
There are a couple of other minor tweaks - autosave (and auto protect) has been souped up a bit, so you're less likely to lose data if your PC crashes or reboots. For those of us who hate the Automatic Update tendency to shut your PC down (whether you want it to or not), this can only be good news. Screengrabs are easier and more intuitive than they were before, too. In a reflection of today's increased security conscious society, the protection of documents (and access/editing rights of them) has more options than ever before (mostly keeping certain people from accidentally editing them, which is a database nightmare some of us will be familiar with).
More changes will come to light when the software finally gets the retail go-ahead, but these are the major changes to look out for. Naturally we'll never know what bugs and creases need ironing out when Excel 2010 becomes the mainstream spreadsheet program for Office, but its worth giving yourself a head start by mastering 2007 first, then climbing up towards the launch of 2010. Happy spread-sheeting!
Author is a freelance copywriter. For more information on a financial excel course london, please visit https://www.stl-training.co.uk
Original article appears here:
https://www.stl-training.co.uk/article-688-excel-2010-glance-into-future.html
London's widest choice in
dates, venues, and prices
Public Schedule:
On-site / Closed company:
TestimonialsBravura Solutions
Consultancy Team Manager Mel Fuller Presentation Skills What can be a very scary subject for the participant was dealt with very well - discussing each aspect of a presentation like building blocks; tackling issues, providing examples and helpful tips, giving you the confidence to tackle each aspect one at a time then bringing them all together at the end. INEOS
Commercial Manager Annie Bowden PowerPoint Intermediate Advanced The sign up process was very user-friendly and the course materials helpful. My main suggested improvement would be to have more alignment between the course materials and the coverage during the session - it would then be possible to track progress through the manual vs. struggling to make notes as we went and risking not keeping up with the class exercises. I like the fact that continued support after the session is helpful. Tiger Recruitment
Managing Consultant Daisy Hughes Introduction to Management Terry was great - really personable and friendly and made you feel relaxed and comfortable from the get go. Helpful with answering questions and learning how to deal with different behaviours in the workplace. I think the only comment I have would be that it would have been more beneficial to have had more like-minded people on the course who came from similar industries (for me personally this would be private sector) and at same level in the workplace that you could then bounce off. Maybe a case of knowing info/details about those attending the course beforehand and then organising particular groups that are more appropriate. |
PUBLICATION GUIDELINES