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: From The Basic To The Advanced
Mon 24th August 2009
Think about the most frequent tasks you use Excel for. Making charts, doing simple functions, and keeping records. If this is all you do - you might be missing out!
Many users don't manipulate the program itself while they're working with it, for example. If you've never used multiple worksheets, then you might be stuck with one, huge one to work with. Fair enough, if that's all you need - but how about adjusting the panes, hiding columns you don't need, or zooming in on those you do? If you have more than one workbook, you can link them together (and have "three dimensional" formulas that work with data across different sheets). It sounds complex, but it really isn't.
A frequent use of Excel is making lists of things - whether it's payments, customer details, your own income and expenditure. With a slightly more advanced skillset you can apply filters to your lists (for example, looking at every month where you worked overtime, on a wage spreadsheet), or autofiltering (removing the tax so you can just look at how much National Insurance you were charged, for example).
Let's say you're collaborating with a colleague on a big spreadsheet. After a muddle of sticky notes, crossed wires and "who put that formula in THAT cell?" arguments, it's probably time to use Excel's "comments" feature, or if you really want security against someone mistyping and making the calculations go haywire: protecting your worksheet or cells so that alterations can't be made by anyone if they're not named as an administrator of the document. If they did mess up, of course, there's another tool you can use to trace formula errors.
If you're feeling very confident or are having advanced training in Excel, you can start using pivot tables to manipulate the data you already have, or using logical functions that "think ahead" to what the end result is and manipulate the data accordingly as they go. For example, You can state that if your income went over the threshold of £18,000 a year, you can create a logical function that would take into account that it would trigger your student loan deductions. This is a simple example of a complex tool that can be really useful for big number crunching.
These are just some examples of the way Excel can be used, usefully, for your own gain. All you need to know is that the functions are there to use. Now you've learned about a few of them - start putting them into practise, and of course - get your money's worth!
Author is a freelance copywriter. For more information on an advanced excel class, please visit https://www.stl-training.co.uk
Original article appears here:
https://www.stl-training.co.uk/article-553-excel-from-basic-advanced.html
London's widest choice in
dates, venues, and prices
Public Schedule:
On-site / Closed company:
TestimonialsM Group Services
Street Lighting Agent Thomas Gaston Project Introduction Very helpful and easy to talk to if unsure about something Kao (UK) Limited
Retail Design Manager Barbara Schweier Managing Teams Remotely I really enjoyed the course, very knowledgeable trainer, good interactive parts and good team DNV GL
Business Support Coordinator Laureen Manning Excel Intermediate Jens was an excellent trainer. He was very engaging and his love of excel shined through. He has changed my view on excel and I now feel more confident to go back to work and use the skills I have learnt. |
PUBLICATION GUIDELINES