Excel Interview Prep: Topics to Know (with Examples)
49 بار بازدید -
2 ماه پیش
-
Interviews can be scary, right?
Interviews can be scary, right? You never know what is going to be asked or how knowledgeable the interviewer is when it comes to Excel. And let's face it! Knowing how to use Excel is more or less a given in the business world.
So, here's a suggestion...instead of memorizing a hundred different questions and answers, spend that time making yourself more comfortable with the easy, medium, and hard skills most jobs are looking for. If you're familiar with the key concepts, there's very little you'll be stumped by in a job interview.
While every company and position is different, based on my experience, the skills I cover in this video should help you prepare for that big bad interview!
00:00 Interview Prep
00:52 Cell References
02:50 Order of Operations
03:45 Conditional Formatting
06:03 Handing Duplicates
08:17 Protect Data
10:43 Split Text
15:02 Percent Changes
16:00 Clean and Organize Data
16:40 Using Charts and Dashboards
17:29 Common Errors
19:29 VLOOKUP
26:35 Pivot Tables
31:32 Nested IF Functions
34:36 COUNTIF and SUMIF
34:49 Some Final Tips
Some more videos on data cleaning in Excel:
Cleaning messy data 🧹 - Don't Overcomplicate It! Data Cleanin...
Handling incorrect formats - How to Clear all Format with Single S...
Using the TRIM function ✂️ - Excel Trim Function | #excel #exceltu...
And here's a video on the SUMIF function:
SUMIF and SUMIFS Formula in Excel: Co...
Looking for more Excel help? ➡️ https://sheetskunk.com
Let's connect on social! 👨💻📲
TikTok ➡️ TikTok: sheetskunk
Instagram ➡️ Instagram: sheetskunk
Pinterest ➡️ Pinterest: sheetskunk
So, here's a suggestion...instead of memorizing a hundred different questions and answers, spend that time making yourself more comfortable with the easy, medium, and hard skills most jobs are looking for. If you're familiar with the key concepts, there's very little you'll be stumped by in a job interview.
While every company and position is different, based on my experience, the skills I cover in this video should help you prepare for that big bad interview!
00:00 Interview Prep
00:52 Cell References
02:50 Order of Operations
03:45 Conditional Formatting
06:03 Handing Duplicates
08:17 Protect Data
10:43 Split Text
15:02 Percent Changes
16:00 Clean and Organize Data
16:40 Using Charts and Dashboards
17:29 Common Errors
19:29 VLOOKUP
26:35 Pivot Tables
31:32 Nested IF Functions
34:36 COUNTIF and SUMIF
34:49 Some Final Tips
Some more videos on data cleaning in Excel:
Cleaning messy data 🧹 - Don't Overcomplicate It! Data Cleanin...
Handling incorrect formats - How to Clear all Format with Single S...
Using the TRIM function ✂️ - Excel Trim Function | #excel #exceltu...
And here's a video on the SUMIF function:
SUMIF and SUMIFS Formula in Excel: Co...
Looking for more Excel help? ➡️ https://sheetskunk.com
Let's connect on social! 👨💻📲
TikTok ➡️ TikTok: sheetskunk
Instagram ➡️ Instagram: sheetskunk
Pinterest ➡️ Pinterest: sheetskunk
2 ماه پیش
در تاریخ 1403/04/19 منتشر شده
است.
49
بـار بازدید شده