Microsoft Excel Resources
Browse Resources
Tutor Hunt Resources
- How to start tutoring at Tutor Hunt
- How to find a tutor at Tutor Hunt
- The Benefits of a Scientific Education
- What is the importance of academic subjects in everyday life?
- The Benefits of Studying English
- Extra curricular activities
- The importance & benefits of private tutoring
- Good revision techniques
- Tracking student progress
- Finding a secondary school to suit your child
- Possible options after completing GCSEs
- Tips on choosing the right university
- How to find the right tutor
- Tutoring tips
- Methods to help you improve your dyslexic child's reading
- The importance of education in future life
Part 3 INDEX and MATCH
The last in a set of three looking this time at INDEX and MATCH as a way to search a table and return the contents of a cell. This combination is a more versatile and perhaps more ro...
Part 2 VLOOKUP
In this section I examine the fundamentals of VLOOKUP. So what is VLOOKUP? Well it is a way of searching a table for information based on a reference value and then returning the con...
Part 1 IF
IntroductionI recently pulled together an Excel session to go through the fundamentals of the IF, VLOOKUP, INDEX and MATCH functions. To do this I started out by putting together a b...
Excel Power Query - Merging and Appending Queries
Power Query Merge and AppendDon`t be put off by the terminology, Power Query is simply sorting and organising data that you wish to import into your Excel spreadsheet and in doing so ...
Excel Introduction
ExcelExcel is a software programme designed to take data and conduct
analysis to extract useful information in tabular or graphic from. The information can then be used for a
varie...
Conditional Formatting - An Introduction
Conditional formatting
What is conditional formatting?
In literal terms it is getting the format of a cell to
change depending upon the content of the cell linked to a rul...
Using Tables in Excel
I was recently asked what my favourite tip was for using Microsoft Excel more effectively. Without a lot of thought I was able to answer - Tables!
"But", I hear you say, "my data is ...
Dynamic Drop Down Lists
Dynamic Drop Down Lists
One of my previous post show that how to create Drop Down List in excel. Here I`m going to discuss how to create Dynamic Drop Down List. Copy below data.
P...
Excel tips
Excel Tip: To copy formats only, select, then first click the Format Painter on the Home Ribbon, then click the destination cell.
Excel Tip: To copy formats only, copy as nor...