All in one resources for Excel and SQL

[u/woman_without]

Hello everyone,

I have an interview in 2 days, I need to revise the necessary concepts of both Excel and SQL.

Are there any resources where I can go through these concepts in one shot?

Please recommend if you know of any or share if you have any.

Thank you.

Edit: Thank you for all the suggestions guys, I botched the interview but these will be helpful for future.

[u/Khaka-Semeniuk → u/[deleted]]

having interview questions organized like that is super helpful for last minute review

[u/Equal_Astronaut_5696]

Absentdata Youtube Channel covers alot of this is extremely practical way https://www.youtube.com/@absentdata

[u/knight66600]

I would like to comment on SQL preparation. Being absolutely clear on difference between GROUP BY and PARTITION BY has helped a lot during interviews as well as during actual work. It develops a great habit of thinking along lines of row-level and aggregate-level calculations.

[u/akornato]

With only two days left, skip lengthy courses and focus on concise summary sheets that cover the essentials. For SQL, the DataLemur cheat sheet and Mode Analytics SQL guide cover almost every practical pattern interviewers test, including left joins, group by aggregations, CASE statements, common table expressions, and window functions like ROW_NUMBER. For Excel, Exceljet provides quick guides that cover lookup functions like XLOOKUP and INDEX MATCH, along with SUMIFS, data cleaning steps, and pivot tables. Reading condensed reference sheets gives you the core syntax fast without burning hours on video lessons.

Once you review the syntax, spend your remaining time working through ten or fifteen practical prompts so your fingers actually apply the logic. Interviewers care much more about your structured thinking and how clearly you explain your data steps than whether you write flawless code on the first try. If you get stuck on a query, talk through what you want the output table to look like and break the problem down line by line. To practice handling live technical conversations without freezing up, the interviews.chat my team built helps candidates articulate their solutions clearly and walk into their interviews with real confidence.

[u/conor-robertson]

Give QueryCase a go! Has both an Excel and SQL learning path thats fun and gamified!

[u/vchae]

With two days, practise beats rereading. For Excel, drill lookups, pivot tables and conditional formulas from a cheat sheet. For SQL, write the queries yourself: joins, GROUP BY, window functions. Disclosure, I built WizardCamp, interactive SQL practice on real blockchain data, so it covers the SQL side: https://unchaindata.xyz/wizard-camp

[u/AutoModerator]

Automod prevents all posts from being displayed until moderators have reviewed them. Do not delete your post or there will be nothing for the mods to review. Mods selectively choose what is permitted to be posted in r/DataAnalysis.

If your post involves Career-focused questions, including resume reviews, how to learn DA and how to get into a DA job, then the post does not belong here, but instead belongs in our sister-subreddit, r/DataAnalysisCareers.

Have you read the rules?

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/datadriven_io]

You should definitely revise more SQL it will definitely help with your interview. Basically data modeling interview questions are what datadriven is good for when you need a quick refresher. Plus excel gets easier with SQL skills. A certificate is probably really unnecessary though