Data Analytics Guide with Microsoft Excel: Step by Step For From Scratch
Instructor
KuKu
Reviews
What You'll Learn?
- Basics of data analytics and its real-world importance
- Navigating Microsoft Excel and its key functionalities
- Data validation and conditional formatting in Excel
- Sorting, filtering, and removing duplicate data
- Handling null, blank, and white space in datasets
- Applying text, logical, date, and numeric functions in Excel
- Introduction to Power Query Editor for advanced data operations
- Cleaning and transforming data using Power Query Editor tools
- Creating custom and conditional columns
- Merging queries and data modeling techniques
- Establishing data relationships and hierarchy structures
- Building pivot tables and charts for data presentation
- Complete beginners interested in data analytics
- Professionals wanting to add data skills to their resume
- Students preparing for data-related projects or roles
- Small business owners aiming to understand their data better
- Individuals seeking a career change into data analysis
- Anyone wanting to enhance their Excel skills for data-driven tasks
- Basic understanding of computers and file handling
- Microsoft Excel (365 or 2019 recommended)
- No prior experience in data analytics needed
- 6 hours on-demand video
- 1 article
- 1 downloadable resource
- Access on mobile and TV
- Full lifetime access
- Certificate of completion