- Excel Interface Walkthrough
- PREPARING DATA FOR ANALYSIS 1
- PREPARING DATA FOR ANALYSIS 2
- PREPARING DATA FOR ANALYSIS 3
- PREPARING DATA FOR ANALYSIS 4
- PREPARING DATA FOR ANALYSIS 5
- PREPARING DATA FOR ANALYSIS 6
- PREPARING DATA FOR ANALYSIS 7
In the Professional Data Analytics Training in Excel course, you will embark on a comprehensive journey through the powerful features of Microsoft Excel, a leading tool in data analytics. The course begins with an introduction to Microsoft Excel and an exploration of its key features. You will then gain proficiency in Excel functions and formulas, essential for performing calculations and data manipulations. The program goes on to cover working with data in Excel, connecting to external databases, and engaging in advanced data cleaning and transformation using Power Query. Furthermore, a significant portion of the course is devoted to exploratory data analysis using PivotTables, which are instrumental in summarizing and analyzing large datasets. The course concludes with a focus on data modeling and analysis using Power Pivot, empowering you to create complex data models and perform advanced analytics. This course is designed for people who want to use Excel for professional data analysis.
Course Overview:
Beginner to Pro
No prior knowledge or experience in business intelligence and analytics is required. The course is designed for beginners who are interested in learning about these fields.
Students will have unlimited access to course materials even after the training ends.
Downloadable content
Hands-on exercises
Note: This comprehensive training program is structured into six key parts, each designed to enhance your proficiency with Microsoft Excel.
For Entrepreneurs, Creatives & Small Business Owners
Replacement blockchain app courses are in development.
Parametric geometrical transformation (Part 1 of the series of "Coding, Experimentation and Spatial design")
Learn the best state of mind to be in for solving problems effectively and joyfully!
Easily create geometric and hand-drawn patterns with just your iPad!
Learn how to use Virtualbox and create whatever OS you want
I am Franklyn Fosu, we are a team of WordPress Web Developers, an artist(CorelDraw and Adobe Illustrator, photoshop) and an IT Specialist,uiux,data science, etc
I love arts and tinkering with computers.
Look around you and you'd see how life is beautiful, from words, daily conversation and the way people interact with each other. These are my obsession to creating things I observe around me.