News
Watch the lesson about the new function XLOOKUP
XLOOKUP is a new function in Excel that replaces VLOOKUP and HLOOKUP in many ways. So, a good tip is to try to use the
May 4, 2021
No Comments
XLOOKUP is a new function in Excel that replaces VLOOKUP and HLOOKUP in many ways. So, a good tip is to try to use the
Your cryptic uncle has sent you a text message in binary and now you need to convert it back to a readable format. First, you
The rules are simple: Count up from zero. If the current number is a multiple of 3, say “Fizz” instead of the number If it’s
Hello, I hope you have a nice working week. This post discusses PivotTables, calculated fields as well includes a tip regarding the equivalent in Power
Thanks to all of you who shared your certificates! The competition is closed for this time and we will present the winner on Linkedin on
We have updated our certificate both in appearance and with new features. Now you are able to show in detail what you have learned during
In a parallel universe: the Excel Jackpot slot machine at the casino is not working properly – it fails to calculate the win. The slot
PivotTables are something that all Excel users should master well and one of the first things one should consider learning. In this lesson, out of
Help out a company with bad security practices to validate their passwords with Excel! You are given the following requirements: – At least six characters
Doughnut charts can be a perfect tool to visualize results or percentage of achieved goals.The charts can be a bit complicated to put together if
In this week’s challenge, you need to help your local post office whose package sorting system is broken. The packages have a barcode that, when
Correlation indicates in statistics the strength and direction of a relationship between two or more variables. The correlation is often stated with a correlation coefficient.