У нас вы можете посмотреть бесплатно Data Analysis and Insights w/ Microsoft Excel или скачать в максимальном доступном качестве, видео которое было загружено на ютуб. Для загрузки выберите вариант из формы ниже:
Если кнопки скачивания не
загрузились
НАЖМИТЕ ЗДЕСЬ или обновите страницу
Если возникают проблемы со скачиванием видео, пожалуйста напишите в поддержку по адресу внизу
страницы.
Спасибо за использование сервиса ClipSaver.ru
Excel Demonstration Spreadsheet File: https://bit.ly/3x7ebux The Center for Customer Insights and Digital Marketing presents a workshop on data analysis and insights using Microsoft Excel featuring Joseph Lee, the Customer Relationship Management Specialist. In this video, he provides live tutorials on what cleaning, analyzing, and visualizing data looks like in Excel, shows how to clean and transform data into insights to create value using Excel tools, and aims to display the various real-world applications of the Excel functions and features. If you have further questions, please email [email protected] Learning Outcomes: Recognize the basic data analytics cycle Implement Excel Commands to clean, analyze, and visualize data Apply new skills on various data sets Execute analytical skills needed for almost any job (market researchers, data analysts, teachers/professors, managers, etc…) Timestamps: 0:00 - Introduction 0:59 - Learning Objectives/Outlines 2:41 - Cleaning and Manipulating Data 11:49 - VLOOKUP 18:47 - INDEX(MATCH()) 20:40 - COUNTIF 29:53 - PIVOT TABLE 34:50 - CONDITIONAL FORMATTING 39:15 - Data Visualization 40:35 - Charts 54:13 - Dashboards 1:00:42 - Recap Relevant Links: https://www.microsoft.com/en-us/micro... / joseph-c-lee Center for Customer Insights and Digital Marketing (CCIDM) Follow us on LinkedIn: / cpp-ccidm Follow us on Twitter: / cpp_ccidm Visit our website: https://www.cpp.edu/cba/customer-insi... Support Us: https://www.cpp.edu/cba/customer-insi... Contact Us: https://www.cpp.edu/cba/customer-insi... This video was prepared by the Center for Customer Insights and Digital Marketing at the College of Business Administration at California State Polytechnic University, Pomona. Intro and Outro Animation by Patrick Ogaz Music: www.bensound.com