How to Use Advanced Functions in Excel Год выпуска: 2015 Производитель: Udemy Сайт производителя: udemy.com/how-to-use-advanced-functions-in-excel Автор: Adam Holczer Продолжительность: 3:30 Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: The aim of this course is to show you basic and advanced functions, their use, and some real-life example how to use it in your daily work/life. When I started learning Excel, I realized that it is very important to know Excel functions, but knowing them is not enough. You have to build it into your daily work and start thinking the way Excel "thinks". With this course I will focus on some real-life examples I had to face during my work and try to shed light on what Excel is capable of. The structure of the course includes some basics as well, so that if you do not have a strong basis, it still gives you guidance and a firm fund to continues and handle more complex problems. My aim is to show you how the functions work and then give you some tips how to use them. Moreover the videos are approaching from a point of view that can be useful at your workplace, e.g. automatization in handling structures, giving solutions for report generations. If you would like to save some time and spend less on sitting in front of a computer and handling data in Excel, then I recommend this course for you. Целью данного курса является показать вам базовые и расширенные функции, их использование, из реальной жизни пример, как использовать его в вашей повседневной работе/жизни.
Содержание
Section 1: Introduction Lecture 1 Introduction 04:39 Lecture 2 About the data 02:07 Section 2: Date and Time Lecture 3 Basics 03:47 Lecture 4 Advanced for automation 13:03 Section 3: Math-related Functions Lecture 5 Basics 03:17 Lecture 6 Advanced for automation 11:45 Section 4: Logical Functions Lecture 7 Basics 05:04 Lecture 8 IF-type functions for calculation 13:09 Lecture 9 IF-type functions for reporting 07:45 Section 5: Lookup Functions Lecture 10 Basics 04:40 Lecture 11 Advanced lookup manipulation 09:35 Section 6: Text Manipulation Functions Lecture 12 Basics 04:43 Lecture 13 Advanced manipulation 06:51 Lecture 14 Creating alphabet 03:50 Section 7: Charts & Graphs in Excel Lecture 15 Basic graph types 11:44 Lecture 16 Design and modify charts 12:49 Lecture 17 Advanced chart manipulation - dynamic graph 17:00 Lecture 18 Advanced visualisation - Sparklines 07:22 Section 8: Miscellaneous Lecture 19 Linking within and outside of the file 09:55 Lecture 20 Conditional formatting 20:22 Lecture 21 Data validation 09:01 Lecture 22 Buttons in Excel explained 06:42 Lecture 23 Buttons' use in Excel explained 08:52 Section 9: Tips and Examples with Functions Lecture 24 Lookup example 1 06:00 Lecture 25 Lookup example 2 15:07 Lecture 26 Text manipulation example 04:21 Section 10: Data Files Lecture 27 Data file Text
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}