Data Analysis Functions and Techniques in Microsoft Excel Год выпуска: 2024 Производитель: Pluralsight Сайт производителя: Pluralsight.com Автор: Janani Ravi Продолжительность: 0h 49m Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: Excel data analysis skills will help you make informed business decisions. In this course, Data Analysis Functions and Techniques in Microsoft Excel, you’ll gain the ability to analyze and interpret complex datasets. First, you’ll explore how to use logical functions like IF, IFS, SUMIF, and NESTED IFS to categorize sales and profit levels, classify products, and evaluate credit eligibility criteria for customers. Next, you’ll discover how to implement lookup and reference functions such as VLOOKUP, XLOOKUP, INDEX, and MATCH to efficiently find and reference data across single and multiple sheets, with a focus on employee-related data. Finally, you’ll learn how to perform what-if analysis using Goal Seek, Scenario Manager, and data table functions to assess the impact of various business scenarios, as well as how to visualize data trends and comparisons using sparklines charts. When you’re finished with this course, you’ll have the skills and knowledge of Excel data analysis needed to confidently analyze, interpret, and visualize data, driving better decision-making in your organization.
Содержание
Logical and Conditional Functions 10m 28s Lookup and Reference Functions 23m 37s Scenarios and What-if Analysis 10m 22s Data Visualizations with Sparklines 5m 24s
Файлы примеров: присутствуют Формат видео: MP4 Видео: MPEG4 Video (H264) 1280x720 30fps 293kbps [V: English [eng] (h264 high L4.0, yuv420p, 1280x720, 293 kb/s)] Аудио: AAC 44100Hz stereo 95kbps [A: SoundHandler [eng] (aac lc, 44100 Hz, stereo, 95 kb/s)]
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}
