Learning Data Visualization and Analytics Using Excel

Excel is one of the most widely used solutions for analyzing and visualizing data. It now includes tools that enable the analysis of more data, with improved visualizations and more sophisticated business logics. Learn all the tips, tricks, shortcuts, functions and formulas.

What you'll learn:

• Gather and transform data from multiple sources
• Discover and combine data in mashups
• Learn about data model creation
• Explore, analyze, and visualize data

Following topics would be covered in the workshop :-

• Introduction to Excel
• Formatting and Conditional Formatting
• Working with Formulas - Logical and Text Functions
• Understanding about Sorting, Filtering and Data Validation
• Data Analysis using Pivot Tables
• Introduction to chart and functions
• Dashboard Designing
• Introduction to VBA and some useful concepts and Macro
• Ms Access Database with VBA Or SQL Server

Fee : INR 999

Register to Attend**