Munesh Excel
No reviews yet

Data entering/capturing: In Excel, data can be entered manually or captured into using Get Data group. In Excel 2019/Office 365, data can be captured from many sources like another file (for example. another Excel workbook, Text/CSV, XML, JSON, Folder, and so on), database (for example. SQL Server, Microsoft Access, Analysis Services, SQL Server Analysis Services), online services (for example Facebook), other sources (from example Table/Range, Web, Microsoft Query, OData Feed, ODBC, OLEDB, Blank Query) or by combining Queries (Merge Query, Append Query).

Data cleaning: Sometimes capturing the data from a non Microsoft application may corrupt the data which needs to be clean first before any analysis can be done on the same. For this Excel provides some very strong and easy to use data cleaning options such as Text to Columns, case change (for example, UPPER, LOWER, PROPER), data extraction from cells (LEFT, RIGHT, MID, FIND, SEARCH), data concatenation (CONCATENATE, &, TextJoin).

Data Management: Although it is important to understand that Excel is not a Database Management System (DBMS) like Microsoft Access, it still gives us many data management tools like Lookup functionality (VLOOKUP, HLOOKUP, LOOKUP, INDEX, and MATCH, and so on), Sort & Filter, Advanced Filter, Date & Time functions, conditional calculations, financial functions, Statistical functions, and so on.

Subjects

  • Excel Expert

Experience

No experience mentioned.

Education

  • MBA finance and account (Jul, 2021–Jul, 2023) from ICU himachal university

Fee details

    ₹500/hour (US$5.90/hour)

Reviews

No reviews yet. Be the first one to review this tutor.