Hi, can anyone recommend any websites for practice worksheets that may mimic what I am likely to see in an excel aptitude test for a data analysis job.
Thanks
Hi, can anyone recommend any websites for practice worksheets that may mimic what I am likely to see in an excel aptitude test for a data analysis job.
Thanks
Hi, welcome to the forum, I don't want to be blunt but aptitude starts with using your imagination and fantasy.
Maybe you've already wondered throught the internet looking for similra teste but if you Google using the right terms you will probably find many sites and videos and more that that.
You should lookt at sites where they use 365 too since 365 has many more functions as the pre-2021 versions of Office (read Excel)
My Tarining Hub (Australian site) is great but there many, many more.
Hope I have pintend you in hopelfully the right direccion
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Well it depends on the version of excel. You want to be familiar with key functions and parts of excel. This is just off the top of my head and i will probably have missed something. I would google all of the below if you are not familiar with how they work. You need the tools then as mentioned above its your imagination as to how to use them. the role of a data analyst varies hugely between organisations. if you are familar with them, then you should be in a good position when a test is thrown at you
Manipulating data with functions
Match
Index
Left
Right
mid
search
countif(s)
Sumif(s)
averageif
sumproduct
search
vlookup
if
if excel 365 filter and unique
Pivot tables
Power pivot if appropriate
Getting external data
sorting
filtering
Statistical techniques
Standard deviation
regression
etc
Charting
making the results look nice!
Possibly VBA if you have to build a solutions
Thanks for the direction Keebellah
Great thanks! I've got enough to be getting on with then
Plus SORT, SORTBY and TEXTJOIN.if excel 365 filter and unique
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks