Analyzing Large Datasets with Power Pivot in Microsoft Excel
Posted on
February 7, 2019
The context for Power Pivot...
Read More
How to use VLOOKUP, HLOOKUP and INDEX MATCH in Excel
Posted on
December 20, 2018
Say you have a table of data and you want Excel to look up a certain value and return a corresponding value in a different row. For that, you need a lookup function. Excel has a range of functions that you can use to achieve...
Read More
PivotTables in Excel – The Basics
Posted on
December 20, 2018
PivotTable or pivot table. You may have heard of them… In our opinion, they are one of the MOST powerful things you can learn in Excel. The great news is, they are pretty easy to get the hang of. Before PivotTables were introduced into Excel, you had...
Read More
Restricting Cell Contents in Excel Using Data Validation
Posted on
December 20, 2018
Did you know that you can restrict, give guidance on and create drop-down lists for what you can enter in a certain cell in Excel? It’s a pretty cool feature and it’s called Data Validation. However carefully you design your spreadsheets, even if you lock cells...
Read More
PivotTables – A ‘Must Have’ Excel Skill
One way of judging the importance of different Excel features is to look through the ‘Must Have’ section of relevant job descriptions. You’d probably be surprised at how often PivotTables appear. One of the great benefits of PivotTables is that they are not just the best,...
Read More