This is a simple tutorial in just one of many easily overlooked Microsoft Excel functions. If you find lots of gaps like these in your Excel knowledge then one of our tailor-made Excel training courses will be just what you need. We have public courses in Beginners Excel Training and Advanced Excel Training, and we can also tailor a private course to suit the individual need of you or your business.
VLOOKUP and HLOOKUP allow you to search a data range for any value entered, and return information or a value based on that data. VLOOKUP allows you to search information formatted by column, HLOOKUP for information formatted by row.
Read the rest of “Excel Tutorial – How to Use the VLOOKUP and HLOOKUP functions”
Two posts into our run down of Microsoft Excel keyboard shortcuts and we’re getting stuck to the nitty gritty of functions, so now you have your navigation keyboard shortcuts and formatting keyboard shortcuts mastered you are prepared to take on some of Excel’s more specialised functionality and more advanced formatting.
Using these key combinations you will be able to quickly summon functions which will hopefully be able to use to formulate, tabulate and graphically represent your data to give it meaning and context. Read the rest of “Excel Function Keyboard Shortcuts”
After the popularity of our previous Microsoft Excel shortcut tutorial post we have decided to follow it up so you can be introduced to using keys for performing formatting. Hopefully you are now using your mouse far less after using our navigation shortcut guide. If not, be sure to have a run through of it first.
Many of these shortcuts can be used across many programs within the Microsoft Office suite, so they can be invaluable to learn in order to speed up your regular day to day tasks. Read the rest of “Microsoft Excel Formatting Keyboard Shortcuts”