Data Analysis Using Excel
Description:
International Workshop on Data Analysis Using Excel
Duration: 6 Hours
Data Calculation and Management (Excel Basics)
Referencing Basics, Cell Formatting – Numbers, Text, Currency etc., Basic Formulas – Statistical, Text, Date, 30 + Shortcuts and Tips, Paste Special & Clipboard.
Quick Calculation and Analysis
Flash Fill – Patterns, Freeze Views, Conditional Formatting for Reporting, Quick Analysis
Advanced Analysis
Statistics in Excel – Descriptive Statistics, Forecasting, Regression, Correlation.
Charts – Histogram, Scatter plot, Box plot
Data Analysis and Presentation
Simple Macros, Pivot Tables – Instant Reports, Simple Dashboard, New Data Types & AI Features of Excel
Data Journalism
Access to Online Data Visualizations, Data Portals, Dummy Data generators, Data Repositories and Readymade data Visualizations.
Note: Microsoft Excel 2013 or later will be required
Key Takeaways:
• 100% Practical Sessions
• Use cases
• Cheat sheets for Instant access
• Reference Books
• Practice Exercises
Bonus Takeaway
• Demo on Business Intelligence Tools – Microsoft Power BI, Tableau and Google Data Studio
• Dashboards for Career
Date: 10/12/2022 to 12/12/2022
Timing: 7:00PM to 9:00PM
Duration: 3 Days
Course Fee: 200