Core Certifications

Hello Professionals,

I'm confused how to solve challenges such as: compute the averages on an excel file for a field that combines both numbers and texts. E.g., a column shows the dates and a column shows all numbers. I could convert the dates to view weekdays, but Excel doesn't allow me to filter specific date. Please instruct me how to work on problems like these.

Thank you,

Datasets

Custom Tools

Date Time

In Database

Data Investigation

Database Connection

In-Database

Accepted answers

Gawa

hi @hlannguyen

Are these real data provided during Core exam? If so, you should cancel your post because disclosing the exam material would be violation to terms&condition.

aatalai

Agree with @gawa

aatalai

@hlannguyen try this learning path

https://community.alteryx.com/t5/Learning-Paths/Getting-Started-Learning-Path/ta-p/475117

Gawa

@hlannguyen My strong recommendation is "Weekly Challenges"

https://community.alteryx.com/t5/Weekly-Challenges/bd-p/weeklychallenge

Try to solve the past challenges which difficulty is 'Basic' and certification level is 'Core'. When you finish a dozen of challenges, you will be naturally ready to pass.

All comments

Gawa

hi @hlannguyen

Are these real data provided during Core exam? If so, you should cancel your post because disclosing the exam material would be violation to terms&condition.

aatalai

Agree with @gawa

hlannguyen

Hello @gawa ,

My apologies I didn't know about that. I removed the files and edited the post. Please let me know if it's okay now. However, I'm still confused how to solve those issues. Much appreciated if professionals could guide me where to access the learning resources to clear my confusion.

aatalai

@hlannguyen try this learning path

https://community.alteryx.com/t5/Learning-Paths/Getting-Started-Learning-Path/ta-p/475117

hlannguyen

Hello @aatalai ,

I'm using this learning path but don't see something similar to help clear my confusion. Much appreciated if you can guide me more how to solve challenges like this.

Gawa

@hlannguyen My strong recommendation is "Weekly Challenges"

https://community.alteryx.com/t5/Weekly-Challenges/bd-p/weeklychallenge

Try to solve the past challenges which difficulty is 'Basic' and certification level is 'Core'. When you finish a dozen of challenges, you will be naturally ready to pass.

hlannguyen

Thank you @gawa for the link. Working on weekly challenges now.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703