IT ANALYST (IT SUPPORT) [Malaysia]
IT support (Data Analyst) Job description : 1. Capturing and recording important data - Taking existing data from a separate document and inputting it into Excel. - Creating a financial strategy or budgeting plan from scratch and typing it into Excel. - Transferring a schedule from an outside source and rebuilding it in Excel. 2. VLOOKUP - Using shortcuts and formula functions - If you’re gathering data scattered throughout another Excel spreadsheet, this function can help you locate it and quickly transfer it to your current spreadsheet. 3. Building charts and graphs 4. Sorting and filtering data 5. Utilizing pivot tables When you need to summarize large quantities of data, you can use a pivot table to group and reorder these findings in a way that makes it easier to organize. You can categorize different number sets and list them accordingly to make it easier to sort through and find the information you’re searching for. You can segment various numbers and data by d...