Microsoft Excel for Data analyst
4.8 /5- Offered byOdinSchool
Microsoft Excel for Data analyst at OdinSchool Overview
Duration | 19 hours |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Go to Website  |
Credential | Certificate |
Future job roles | Application Security, Audacity, Appraisal, Asp .Net, Asset Allocation |
Microsoft Excel for Data analyst at OdinSchool Highlights
- Earn a certificate after completion of the course
- Access to Trained Faculty Over WhatsApp Chat/Call
Microsoft Excel for Data analyst at OdinSchool Course details
- Data Analysts
- Business Analysts
- Financial Analysts
- Researchers, academics, and students who use Excel for data analysis in their research projects or academic studies
- Excel Advancements – some amazing features incorporated only in last few years
- Generating Pivot Tables and Charts from complex datasets, instantly
- Implementing Slicers and Sparklines to build interactive dashboards
- Exploring Data Validation techniques and creating dynamic lists
- Using ‘What-If-Analysis’ and Data representation techniques
- Explore and connect to data sources using Power Query
- Extract and transform data using Power Query
- Comprehend the Power Pivot user interface
- Build a cascading relationship and manage data models
- Build a relationship between tables from different sources
- Build a report using Power View
- Hide columns, sort, change data types, and filter
- This course is designed to provide participants with the essential skills and knowledge required to effectively utilize Microsoft Excel for data analysis purposes
- In this course participants will learn how to organize, manipulate, analyze, and visualize data using Excel's built-in tools and functions
- This course equip participants with the necessary Excel skills to perform data analysis effectively
- It covers various Excel features and functions essential for managing, manipulating, analyzing, and visualizing data
Microsoft Excel for Data analyst at OdinSchool Curriculum
INTERESTING FEATURES OF MICROSOFT EXCEL
Exploring Volatile functions and other lesser known functions
Protecting data and implementing restricted access
Formula Auditing and Tracking Changes
Data Import and Export utilities
Comparing Excel files – a case study
DATA FORMATTING AND STYLES
Converting text to columns
Using Flash Fill, Quick Analysis and chart recommendations
Exploring Accessibility tools
DATA VISUALIZATION CONCEPTS (CHARTS AND GRAPHS)
Understanding Data Visualization concepts and principles
Creating effective charts — using thought starter
Exploring new components of Charts in MS Excel
SLICING AND DICING OF DATA - SOME POWERFUL TECHNIQUES (ADV. CHARTS & DASHBOARDS)
Creating Pivot Tables using complex datasets
Generating Pivot Charts Instantly
Implementing Slicers to build Interactive dashboards
ADVANCED DATA VALIDATION AND ANALYSIS
Exploring Data Validation techniques and controlling inputs
Creating dynamic lists using data validation and Name Ranges
What-If-Analysis tools - Goal Seek, Data Table, Scenario Manager
EXPLORING IDE OF MS EXCEL AS AN AUTOMATION TOOL
Introduction and classification of Macros
Overview VBA IDE - components and features
VBA Modules - Coding simple Sub Procedures in VBA
AUTOMATION USING EXCEL MACROS AND VBA
Recording simple Macros
Introduction to Error Handling
Editing Recorded Macros
EXPLORING POWER TOOLS OF EXCEL (POWER PIVOT & POWER VIEW)
Steps involved in designing and managing data models
Introduction to Power Pivot tool to create instant Data Models and link tables
Define entity relationships and check cardinality
Other courses offered by OdinSchool
Student Forum
Anything you would want to ask experts?