Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Premiered Dec 16, 2019
As part of Advanced Excel Assessment Test companies would like to test candidate's skills in the areas of Data Import, Data Conversion, Power Query, Pivot Table, Power Pivot and more. They also would like to ensure that candidate can actually perform functions in Excel, instead of just answering the questions. This is why most companies are using interactive test format: most recent test ask candidates to actually perform steps in Excel spreadsheets. Learn how to get ready for Excel Interview in this video. SUBSCRIBE!!! https://www.howtoanalyzedata.net/youtube
__________ In This Video: Import data from PDF File (provided as a separate file) 00:44 Professionally format imported data to make it presentable in Excel 02:10 Describe the Data your have imported 04:47 Change Tab Title to "Sales Data". Assign Data types to imported columns in Excel 06:45 Create Excel Table from the data 08:10 Split Name column into First and Last Name using Text to Column feature 08:53 Split address to separate Address and Zip using Power Query 11:07 Determine City based on Zip Code and add as new Column 13:01 Determine State based on Zip Code and add as a new Column 16:37 Create Pivot table from the data 17:04 Determine Total Sales by State using Power Pivot 18:27 Calculate Sales by month using Power Pivot 19:21 Create a graph showing sales by month 20:18 Create a map that shows sales by each State in US 21:22 Calculate which County in California has largest Sales Volume 22:34