Microsoft Hints and Tips
Learning Excel through games – Episode 1: macros with some VBA code
Learning Excel through games – Episode 1 Excel is used on a daily basis by people all over the world with most of them constantly learning Excel in their work. It has lots of features that can be used from a basic to a more advanced level, with one of these features...
IT Training Herefordshire – creating a Pivot Table..how do you do it?
IT training Herefordshire - how do you create a pivot table and chart? Find out how this week below...One of the most useful and powerful features companies can use in Excel is the ability through Pivot Tables to analyse and summarise data. We deliver the following...
Excel training basics – BODMAS…do you remember this from Excel?
Excel training basics - the BODMAS 'concept' BODMAS. The word that tends to divide a room of people on one of our Excel courses up in to one of four groups: Have no idea what we are talking about and never heard of BODMAS Vaguely remember being told about it and...
Excel names – how to name cells and ranges in Excel
Excel names – using naming cells and ranges within formulas and calculations In this weeks hint and tip we are going to be looking at the concept of Excel names. This concept is where you are able to name a cell or a range of cells to then use them within a formula or...
PowerPoint basics slides – inserting a new slide in your presentation
PowerPoint basics slides - how to insert a new slide in to your presentation We are starting off some new hints and tips where we will be looking some of the packages within Microsoft Office and giving hints and tips on specific actions you can do in them; starting...
Publisher page sizes – using page sizes & publication types for your work
Publisher page sizes – how to use page sizes & publication types Publisher is a package that can sometimes be forgotten about or overlooked, with Word being most people’s first point of call for creating documents. However, sometimes Publisher comes up on top in...
Excel meaning – Understanding and fixing Excel Errors
Excel meaning - What the errors mean in Excel and how do you go about fixing them? We’ve all done it, typed a calculation or formula in Excel, hit enter and an error message appears! The problem we then have is “What does that error message mean?!?” This weeks hint...
Excel Symbol Meanings…what do they mean? Find out here!
Excel Symbol Meanings - have you ever wondered what they do? What they mean? Further to a blog we did in May 2017 on Excel Symbols we thought we would give you a further insight into 5 more Excel symbol meanings. There are a number of different symbols used within...
Microsoft Office training Worcestershire – what’s in a Word? Take a look…
Microsoft Office training Worcestershire – what’s in a Word? This months blog is all about some unknown and unusual features found in Microsoft Word 365/2016. Have fun exploring them! Bookmarks (found on the Insert Tab, Links Gallery) This allows you to select some...
Excel tips: Sparklines in Excel – what are they and how do you use them?
Excel tips: taking a look at Sparklines in Excel This week we are bringing you a hint and tip in Excel on Sparklines! Sparklines is a feature within Excel that can be useful however it is sometimes looked over as it is either not known about or isn't known how to...
MS Excel Course – looking at the 2 arguments of VLOOKUP!
MS Excel course - looking at the VLOOKUP function and the different arguments available The VLOOKUP function. It is a function that a lot of people either use or want to know how to use! It is a very useful function that can be a very powerful tool for you...
Learn Excel Online – Tips for Excel to make your use of this package easier!
Learn Excel Online - how we teach and some Excel tips Excel is a very useful Microsoft Office package in more ways than one! It is one of the most used packages in lots of businesses but also for people at home in personal use too. With it being so versatile, it is...
Excel 2013 and onward! New features that have arrived with Flash Fill
Excel 2013 – New features in Flash Fill! Flash fill is a great feature that was brought in as a new feature with Excel 2013. This feature allows you to bring together the contents of two cells from two different columns and put them together in one cell in the next...
Microsoft Office Courses West Midlands – did you suffer in the “heatwave”?
Microsoft Office courses West Midlands - Did you suffer in the “heatwave”? Why not have a go at our relaxing heatwave quiz that we have put together below in Excel? The heat! It was definitely a topic on most peoples minds and took over a lot of conversations for the...
Basic Excel course – the current layout screen of Excel, has it changed?
Basic Excel course – the current layout screen of Excel, do you find it can sometimes change overnight? The many faces of Excel! I'm not sure about you, but I sometimes wonder what the screen of Excel will hold when I open it up in the morning! Ok maybe that was a...
Microsoft Office Specialist – using 3D Maps in Excel
Microsoft Office Specialist - looking at 3D Maps in Excel, have you used them? Here at JPL we continually strive to improve the variety of Microsoft Office courses in the Midlands and further afield. We thought you may like to see a short video of the towns we’ve...