Data Analysis Fundamentals with Excel: Summary - Video Tutorials & Practice Problems
Video duration:
1m
Play a video:
Video transcript
line:15% <v ->You've completed your journey through data analysis</v> line:15% fundamentals with Excel. line:15% You now have some great data analysis skills line:15% under your belt. <v ->During this live lesson,</v> we introduced a typical data life cycle and Microsoft Excel role as a technology within the life cycle. We learned how to use getting transform data to extract data from source systems and then transform, cleanse, and load it into Excel. We then reviewed some fundamental concepts and best practices required for data analysis within Excel. We designed and implemented a sample data quality dashboard, in addition to a budget and forecast model. We later authored interactive reports using a combination of pivot tables and pivot charts, and finally reviewed our workbooks for collaboration related issues while learning best practices for sharing and distribution of Excel-based data. <v ->With all this knowledge,</v> you're now much better prepared to take some big first steps in growing your career in the data analytics space. We hope this course further your knowledge of Excel, and we hope you enjoy taking this course as much as we enjoy teaching it. We wish you good luck in your future endeavors.