Data Analysis

1. MS-Word 2019
2. MS-Excel 2019
3. MS-Powerpoint 2019
4. MS-Outlook 2019

1. Advanced Excel

•  Excel Essentials
• Working With Multiple Worksheet
• Cell Referencing
• Working With Data Lists
• Conditional Formatting
• Data Validation
• What-If Analysis
• Protection
• G Suite-Excel

2. Formulas & Functions

• Conditional Function
• Text Function
• Statistical Function
• Financial Function
• Creating HLOOKUP and VLOOKUP
  Functions
• Advanced Conditional Formatting
• Advanced Lookup and Reference
• Advanced Function in Excel

3.Dashboard Designing (MIS)

• Creating Dashboard
• Graphical Representation of
  data using charts & Sparkline’s
• Use of Power Pivots for Data Analsis
• Use of Power Queries
• Power Map
• Pivot Table Dashboard With Slicers

4.Automation

• Working With External Data
• Exporting Data to Excel, Access, PPT, TXT, CSV
• Updating Charts, Table in Powerpoint
• Importing Data From Excel, Access,PPT, TXT, CSV
• Converting Reports into PDF
• Exporting Charts, Tables to PowerPoint

1. Getting Started With Access
2. Working With Table Data
3. Querying a Database
4. Using Forms
5. Generating Reports
6. Designing a Relational Database
7. Sharing Data Across Applications

1. Macros Recording
2. Visual Basic Editor
3. Understanding Objects,
   Methods, Properties & Variables
4. Control Structures-Decision
5.  Lookup Structures
6. User Forms and GUI
7. Worksheet / Workbook Operations
8. Error Handling

1. Introduction to Tableau
2. Tableau Interface Worksheet
3. Chart Types
4. Data Visualization
5. Run Time Columns
6. Data Formatting
7. Advanced Function
8. Filters & Advanced Charts
9. Dashboards
10. Storyline In Tableau
11. .Publish Reports