I can take the following assignments,
Automation: Automating your day to day tasks.
Tables: Maintain large sets of Excel data in a list or table. Matching tables based on criteria. This includes joining tables based on specific criteria.
Linking Data: Linking Workbooks, Worksheets, Columns, etc
Cleaning Datasets: Cleaning the datasets. Change text to Upper, lower or Proper Case. Formating the data according to the data type( Date/Time, Text, Number etc)
Merging Datasets: Merging of data from different worksheets.
Integrating Data: Consolidating and integrating data from hundreds of workbooks. Finally present with a single header row.
Data Compare: Comparing different sets of data and creating a report based on the differences in two files.
Data Split: Spilt the data with the specified criteria. For example, Each city can be put on a separate worksheet or workbook according to business requirements.
Grouping: Summarising data using Subtotal
Sorting: Sort by any criteria up to 5 levels
Filter: Filter by multiple criteria to wok on only a specific filtered list.
Duplicates: Creating a compact and a cleansed data free of all duplicate entries
Formulas: Write & combine formulas like SUMIFS, SUMPRODUCT, INDEX, MATCH, LOOKUP formulas. Debug and Audit Formulas and use different formulas for any given challenge. Using IF function to get calculated columns.
Conditional Formatting: Conditional formatting allows you to automatically apply to formats—such as colors, icons, and data bars—to one or more cells based on the cell value.Using Sparklines
Pivot Tables: Create dynamic reports by mastering one of the most sought after tools, PivotTables.Auto-update of Pivot tables. Slicers to slice and dice the data by Geography, Departments, and any dimension. Timeline Slicers to show the reports the views by month, quarter, year.
Pivot Charts: Build Dashboards. Enhance business understanding and decision making with data visualizations and provide insights for data-driven decision making.
Comments
Post a Comment