Видео по excel

Видео по excel смотреть последние обновления за сегодня на .

Шаг #2. Excel для Начинающих

1395102
20928
384
00:14:48
29.11.2016

📥 СКАЧАТЬ КУРС - 🤍 👉 Курс по Microsoft Word - 🤍 👉 Курс по Microsoft Excel - 🤍 Пять первых шагов к освоению программы Excel. Базовый видеокурс по работе в программе Эксель. - создание простой таблицы - функция автозаполнения - ввод формул с арифметическими операциями Видео: 🤍 Авторский канал Андрея Сухова. Видеоуроки для начинающих пользователей компьютера. Уроки по работе в программах и операционных системах Windows и Linux. Мой сайт - 🤍 Компьютерная Азбука - 🤍 Полный видеокурс для Начинающих - 🤍 Группа в Вконтакте: 🤍 Группа в Одноклассниках: 🤍

Урок 4. Формулы Excel для начинающих

1496629
20450
694
00:18:57
12.12.2015

Формулы в Excel – основа программы. С их помощью производятся самые различные вычисления: от простого суммирования до моделирования случайных выборок. В уроке рассмотрены простейшие функции: математические операторы, СУММ, СРЗНАЧ, СЧЁТ, МИН, МАКС, ОКРУГЛ. Изучив эти функции вы узнаете основные приемы, как работать в Excel 2013 или других версиях. Другие уроки базового курса Эксель для начинающих на сайте statanaliz.info по ссылке: 🤍 ► Корпоративный тренинг "Продвинутый уровень MS Excel": 🤍 ► Онлайн курс "Продвинутый уровень MS Excel": 🤍 💳 Поддержать канал деньгами 🤍 * Мой сайт об Excel и статистике * 🤍 * Странички и аккаунты в соцсетях * Facebook: 🤍 Вконтакте: 🤍 Твиттер: 🤍 Telegram: 🤍 Мой блог об Excel и статистических методах анализа данных: 🤍 Вконтакте: 🤍 Твиттер: 🤍 Facebook: 🤍

Microsoft Excel Tutorial - Beginners Level 1

9419616
177446
5507
00:32:49
19.03.2018

Want more Excel videos? Here’s my Excel playlist: 🤍 This video tutorial will show you how to use Microsoft Excel for beginners. Microsoft Excel is a powerful spreadsheet tool that is part of Microsoft Office. This is a detailed beginners tutorial, the below timestamps will help you navigate through the lessons that are covered. Looking for more? Let me know in the comments below what types of things you would like to learn in Microsoft Excel. Intermediate Microsoft Excel Lesson 1: 🤍 Dive deeper into formulas and functions in excel with this playlist: 🤍 Creating Charts in Excel: 🤍 0:00 Start 1:07 Starting up 1:27 Recent documents and pinning documents 1:54 Templates 2:34 Layout - Tabs, ribbons, and groups in Microsoft Excel 3:48 Rows, Columns, Cells and Ranges 5:49 Worksheets in Microsoft Excel 6:52 View and zooming 7:30 Inputting Data 10:56 Formatting Data 13:38 Wrapping Text 14:22 Insert Row/ Merge & Center cells 15:41 Currency formatting 16:20 Print view 17:02 Add cell borders and colors 18:18 Basic formulas in Microsoft Excel 21:17 Copy formula 23:45 Freeze Pane 24:52 Basic Microsoft Excel functions 28:59 “Tell Me” in Microsoft Excel 29:43 Inserting charts in Microsoft Excel Excel for Beginners Tutorial - Level 2: 🤍 Excel for Beginners Tuotiral - Level 3: 🤍 Excel for Beginners Tutorial - Level 4: 🤍 Microsoft Excel for Beginners - Level 5: 🤍 VLOOKUP Function for Excel: 🤍 Learn Pivot Tables for Beginners: 🤍 10 Best Excel Beginners Tips: 🤍 Make a Line Graph in Excel: 🤍 I use Camtasia to create my video tutorials: 🤍 DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links and end up purchasing it, I’ll receive a small commission. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

12 трюков при работе с формулами и функциями в Excel

154643
7409
350
00:18:32
27.11.2020

Несколько несложных, но приятных фишек для ввода, отладки и комфортной работы с формулами и функциями в Microsoft Excel на каждый день. Мои книги 🤍 Мои онлайн-курсы 🤍 Моя надстройка PLEX (+150 новых функций для вашего Excel) 🤍 Twitter 🤍 Facebook 🤍 Instagram 🤍

Создание сводной таблицы в Excel

1966725
26333
638
00:11:26
11.02.2013

Как создать аналитический отчет сводной таблицы в Microsoft Excel. Понятно, пошагово и с подробностями. Статья и файл-пример 🤍 Заходите в гости ↓↓↓ Twitter 🤍 Facebook 🤍 Instagram 🤍 Мои книги 🤍 Моя надстройка PLEX (+150 новых функций для вашего Excel) 🤍

Как использовать функцию ВПР (VLOOKUP) в Excel

1563628
17187
557
00:05:50
27.11.2010

Пошаговая демонстрация применения функции ВПР (VLOOKUP) для связывания двух таблиц, т.е. подстановки данных из одной таблицы в другую. Подробная статья и файл-пример 🤍 Заходите в гости ↓↓↓ Twitter 🤍 Facebook 🤍 Instagram 🤍 Мои книги 🤍 Моя надстройка PLEX (+150 новых функций для вашего Excel) 🤍

Урок 7. Диаграммы в Excel для начинающих

413559
4427
186
00:08:09
12.12.2015

Построение диаграммы в Excel является неотъемлемой частью серьезного анализа данных или отчета. В уроке подробно показано, как построить диаграмму в excel. Другие уроки базового курса MS Excel на сайте statanaliz.info по ссылке: 🤍 ► Корпоративный тренинг "Продвинутый уровень MS Excel": 🤍 ► Онлайн курс "Продвинутый уровень MS Excel": 🤍 💳 Поддержать канал деньгами 🤍 * Мой сайт об Excel и статистике * 🤍 * Странички и аккаунты в соцсетях * Facebook: 🤍 Вконтакте: 🤍 Твиттер: 🤍 Telegram: 🤍

20+ горячих клавиш Excel для ускорения работы.

165373
5127
302
00:29:55
04.10.2020

Горячие клавиши Excel для начинающих и опытных пользователей, которые упростят и ускорят вашу работу в разы. Навигация по массивам данных, выделение столбцов и строк с разрывами, специальная вставка, копия промежуточных итогов, история копирования и др. клавиатурные эквиваленты команд Excel. Использование горячих клавиш позволяет работать, как профессионал. Другие трюки, уроки Excel и файл с примером можно скачать здесь 🤍 ► Корпоративный тренинг "Продвинутый уровень MS Excel": 🤍 ► Онлайн курс "Продвинутый уровень MS Excel": 🤍 💳 Поддержать канал деньгами 🤍 *Содержание * 0:00 – Введение 0:42 – 1. Перемещение по листу 1:38 – 2. Выделение диапазонов 2:40 – 3. Выделение всей строки 3:01 – 4. Выделение всего столбца 3:10 – 5. Выделение диапазона данных и всех объектов 4:05 – 6. Перемещение внутри выделенного диапазона 5:35 – 7. Выделение только видимых ячеек 8:04 – 8. Добавление строк или столбцов 8:56 – 9. Удаление строк или столбцов 9:14 – 10. Вставка текущей даты и времени 10:16 – 11. Специальная вставка 11:40 – 12. Копия данных из ячеек сверху 12:20 – 13. Копия данных из ячеек слева 12:44 – 14. История копирования и вставка из буфера обмена 15:59 – 15. Формат ячеек 16:23 – 16. Часто используемые форматы 17:36 – 17. Режим редактирования формул в диалоговых окнах 19:37 – 18. Мгновенное заполнение 20:39 – 19. Итоговая строка и столбец 21:56 – 20. Cвернуть все окна 22:38 – # Бонус 1. Выделение столбца с разрывами 26:25 – # Бонус 2. Вставка эмодзи * 20 приемов и трюков MS Excel для начинающих * 🤍 * 20 приемов и трюков MS Excel для продвинутых * 🤍 * Мой сайт об Excel и статистике * 🤍 * Странички и аккаунты в соцсетях * Facebook: 🤍 Вконтакте: 🤍 Твиттер: 🤍 Telegram: 🤍 #excel #msexcel

50 Ultimate Excel Tips and Tricks for 2020

1617518
27344
853
00:50:17
17.03.2020

The ultimate compilation of Excel tips and tricks to enhance your productivity using Excel. Updated for 2020! I've combined long-established tips and tricks with new ones Microsoft added in 2019 and 2020. You'll find solutions to the most common challenges you face in Excel. Support me with your Amazon purchases, click here: 🤍 Contents 0:00 1. Move Data 0:35 2. XLOOKUP() 1:04 3. Filter List 2:24 4. Ideas 3:04 5. Remove Blanks 3:54 6. Quick Analysis Tool 4:28 7. AutoFit Column Width 5:27 8. Absolute Cell Reference 5:57 9. Paste Special Values 7:19 10. Drop-Down List 8:05 11. FILTER() 9:15 12. Remove Duplicates 10:43 13. Difference Between Lists 11:31 14. Flash Fill 12:15 15. AutoFill 13:06 16. Data Types 13:53 17. Transpose 15:11 18. Freeze Panes 15:37 19. Text to Columns 16:27 20. Recommended Pivot table 17:25 21. Slicers 18:04 22. Conditional Formatting 19:01 23. IF() 20:29 24. 3D References 21:12 25. Forecast Sheet 22:45 26. SUMIFS() 24:00 27. IFERROR() 25:15 28. Ctrl-Arrow Keys 26:03 29. Filled Maps 26:26 30. PMT() 27:13 31. Show Formulas 28:20 32. Advanced Select 29:10 33. Named Range Shortcut 29:56 34. Hide Cells 30:47 35. COUNTBLANK() 31:30 36. Natural Language Query 31:59 37. Goal Seek 33:08 38. Insert Screenshot 34:30 39. Power Pivot 35:14 40. 3D Maps 36:16 41. ISBLANK() 39:08 42. Analysis ToolPak 39:45 43. CONVERT() 40:48 44. Get Data from Web 41:24 45. People Graph 42:59 46. SORT() 44:18 47. Status Bar Info 45:36 48. Insert Multiple Rows 46:22 49. CHOOSE() 46:53 50. UNIQUE() 48:50 #seletraining #excel #tipsandtricks

23 Функция ЕСЛИ в Excel (IF)

370948
4021
230
00:07:29
22.05.2017

Логическая функция ЕСЛИ в Excel задает условие, при выполнении которого возвращается тот или иной результат. Формулы в Excel ЕСЛИ позволяют записать различные варианты вычислений в одной ячейке. Файл с примером находится на странице 🤍 ► Корпоративный тренинг "Продвинутый уровень MS Excel": 🤍 ► Онлайн курс "Продвинутый уровень MS Excel": 🤍 💳 Поддержать канал деньгами 🤍 * Мой сайт об Excel и статистике * 🤍 * Странички и аккаунты в соцсетях * Facebook: 🤍 Вконтакте: 🤍 Твиттер: 🤍 Telegram: 🤍

Microsoft Excel Tutorial for Beginners - Full Course

5992306
97677
1974
02:26:10
28.10.2020

Lean how to use Microsoft Excel from the beginning by creating 6 real-world projects. Most of the content applies to Google Sheets as well. You will learn how to - enter data, - navigate through a spreadsheet, - create formulas to solve problems, - create charts and graphs, - understand relative vs absolute references, - import and export data, - implement VLOOKUP, - use pivot tables, - split and concatenate text, - and more. ✏️ Course developed by Shad Sluiter. Check out his YouTube channel: 🤍 ⭐️ Course Contents ⭐️ ⌨️ (0:00:00) Intro ⌨️ (0:04:14) Payroll ⌨️ (0:39:35) Gradebook ⌨️ (0:57:22) Decision Factors ⌨️ (1:04:40) Sales Database ⌨️ (1:23:13) Car Inventory ⌨️ (1:59:29) Problem Solving Templates ⭐️ Special thanks to our Champion supporters! ⭐️ 🏆 Loc Do 🏆 Joseph C 🏆 DeezMaster Learn to code for free and get a developer job: 🤍 Read hundreds of articles on programming: 🤍

Программирование макросов на VBA в Excel

424342
4581
155
00:12:58
16.04.2013

Что такое макросы, как их создавать и использовать. Для "простых смертных" пользователей, НЕ-программистов. Более подробно тут 🤍 Заходите в гости ↓↓↓ Twitter 🤍 Facebook 🤍 Instagram 🤍 Мои книги 🤍 Моя надстройка PLEX (+150 новых функций для вашего Excel) 🤍

Умная таблица в Excel или секреты эффективной работы

1363104
39825
862
00:09:29
01.11.2016

Как сделать таблицу в Excel, где ссылки, диаграммы и сводные таблицы, автоматически захватывают все новые данные. Текстовый вариант урока по ссылке 🤍 ► Корпоративный тренинг "Продвинутый уровень MS Excel": 🤍 ► Онлайн курс "Продвинутый уровень MS Excel": 🤍 💳 Поддержать канал деньгами 🤍 * 20 приемов и трюков MS Excel для начинающих * 🤍 * 20 приемов и трюков MS Excel для продвинутых * 🤍 * Мой сайт об Excel и статистике * 🤍 * Странички и аккаунты в соцсетях * Facebook: 🤍 Вконтакте: 🤍 Твиттер: 🤍 Telegram: 🤍

Используем ChatGPT при работе в Excel

200562
7661
468
00:27:13
09.01.2023

Примеры использования искусственного интеллекта Open AI ChatGPT для решения повседневных задач в Microsoft Excel (формулы, макросы на VBA и М-функции в Power Query). Скачать архив с примерами из видео : 🤍 ChatGPT : 🤍 Сервис аренды номеров телефонов : 🤍 Мои книги 🤍 Мои онлайн-курсы 🤍 Моя надстройка PLEX (+150 новых функций для вашего Excel) 🤍 Наш канал в Telegram 🤍 –––––––––––––––––––––––––––––– Track: Aqua Unfold — WOMA [Audio Library Release] Music provided by Audio Library Plus Watch: 🤍 Free Download / Stream: 🤍 ––––––––––––––––––––––––––––––

Связанные выпадающие списки в Excel

466299
5837
336
00:16:12
07.08.2015

3 способа создать связанные (зависимые) выпадающие списки в ячейках листа Excel, т.е. чтобы содержимое второго списка зависело от того, что пользователь выбрал в первом. Статья и скачать файл-пример 🤍 Заходите в гости ↓↓↓ Twitter 🤍 Facebook 🤍 Instagram 🤍 Мои книги 🤍 Моя надстройка PLEX (+150 новых функций для вашего Excel) 🤍

Тонкости работы с переносами строк в Excel

61044
2511
108
00:14:01
13.04.2019

Как быстро убрать или заменить переносы строк (Alt+Enter) в Excel или разбить по ним данные. Скачать пример 🤍 Заходите в гости ↓↓↓ Twitter 🤍 Facebook 🤍 Instagram 🤍 Мои книги 🤍 Моя надстройка PLEX (+150 новых функций для вашего Excel) 🤍

Календарь этапов проекта в Excel

201970
4485
110
00:12:32
21.02.2016

Как с помощью условного форматирования быстро сделать наглядный годовой календарь этапов проекта. Скачать файл-пример 🤍 Заходите в гости ↓↓↓ Twitter 🤍 Facebook 🤍 Instagram 🤍 Мои книги 🤍 Моя надстройка PLEX (+150 новых функций для вашего Excel) 🤍

Delete Empty Rows with these Excel Shortcuts #shorts

565804
34666
163
00:00:26
01.05.2022

Join 300,000+ professionals in our courses: 🤍 Quickly remove or delete blank rows in Excel. Don't highlight the row and delete from the menu. That can take forever. Instead use quick Excel keyboard shortcuts to automatically select and remove empty rows in your data. 🌍 My Online Excel Courses ► 🤍 🎬 LINK to more YouTube Shorts videos: 🤍 🎒 Get the Official XelPlus MERCH: 🤍 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 📚 Excel RESOURCES I Recommend: 🤍 🎥 GEAR I use: 🤍 More resources on my Amazon page: 🤍 🚩Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #Excel #shorts

COUNTIF function in Excel

70904
3078
9
00:00:47
28.05.2021

The COUNTIF function in Excel can be used to find the count of cells satisfying a particular condition. Check my online course on Excel Tables 🤍 Playlist of Short videos on Excel Tips 🤍 Read about COUNTIF Function in Excel 🤍 #shorts #excelTips #excelTricks

How to Create a Dynamic Numbered List in Excel #shorts

5286076
224773
2125
00:00:41
26.06.2022

Join 300,000+ professionals in our courses: 🤍 In this #shorts you'll learn a super easy way to create a dynamic numbered list in Excel with a single function. The function is the sequence function in Excel. You can make it dynamic so you only get a numbered list until where you need it. 🌍 My Online Excel Courses ► 🤍 🎬 LINK to more YouTube Shorts videos: 🤍 👕☕ Get the Official XelPlus MERCH: 🤍 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 📚 Excel RESOURCES I Recommend: 🤍 🎥 GEAR I use: 🤍 More resources on my Amazon page: 🤍 🚩Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #excel

1 Функция СУММЕСЛИ в excel (SUMIF)

331620
3867
255
00:04:56
22.01.2017

Функция СУММЕСЛИ в Excel (SUMIF) производит суммирование данных по заданному условию или критерию. Файл с примером находится на странице 🤍 ► Корпоративный тренинг "Продвинутый уровень MS Excel": 🤍 ► Онлайн курс "Продвинутый уровень MS Excel": 🤍 💳 Поддержать канал деньгами 🤍 * Мой сайт об Excel и статистике * 🤍 * Странички и аккаунты в соцсетях * Facebook: 🤍 Вконтакте: 🤍 Твиттер: 🤍 Telegram: 🤍

Easy Way to KEEP Leading Zeros 0️⃣ in Excel #shorts

132664
8037
105
00:00:57
17.04.2022

Sometimes you need to add leading zeros in Excel but the zeros keep disappearing. For example like this: 00256. This could be for zip codes, security numbers or employee IDs. But if you ever tried to enter something like that in Excel you'll quickly learn that Excel automatically removes leading zeros from numbers. In this video I'll show you a quick solution on how to get this done in Microsoft Excel. 🌍 My Online Excel Courses ► 🤍 🎬 LINK to more YouTube Shorts videos: 🤍 🎒 Get the Official XelPlus MERCH: 🤍 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 📚 Excel RESOURCES I Recommend: 🤍 🎥 GEAR I use: 🤍 More resources on my Amazon page: 🤍 🚩Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #Excel

Excel for Beginners - The Complete Course

572163
11511
397
00:54:55
22.08.2022

This is the beginning Excel course that you've been waiting for! Learn everything you need to effectively use Excel by watching just one video. You'll learn spreadsheet terminology and the modern Excel layout, how to create and save workbooks, entering values into Excel, Excel formulas and functions, formatting, creating and editing Excel charts, printing options, and publishing options. After watching and mastering this video, you will be able to use Excel effectively in almost any professional setting. Table of Contents: 00:00 - Intro 00:26 - Creating Workbooks, The Anatomy of a Spreadsheet / Spreadsheet Terminology 07:16 - Entering Cell Values and Data in Excel 20:18 - Formulas 30:21 - Functions: SUM, AVERAGE, MAX, MIN, COUNT 38:45 - Formatting Numbers, Text, Cells, Rows, and Columns 44:20 - Creating and Editing Charts 46:46 - Print Options and Publishing Options *Support Technology for Teachers and Students on Patreon*: 🤍 Here's my entire playlist of Excel tutorials: 🤍 Consider saying "Thanks" by clicking the Thanks button below the video. Here's a link to the practice file for this video: 🤍 #excel #exceltutorials #microsoft365

Averages in Excel

16
2
0
00:00:14
10.01.2023

In this video, you will learn how to find averages in Excel. Average is one of the most frequently used functions in excel. As the name indicates it returns the average number from a set of values. The average function adds all the selected values and then divides them by the count of the values. There are many ways to calculate, but the best way is to use the built-in function. How to Clean Messy Data in Excel 👉🤍 Vlookup vs Xlookup 👉🤍 Top 10 most used Excel formulas 👉🤍 Subscribe 👉 🤍

How to Increase Serial No. Ms Excel Shorts Tips and Trick

724
25
0
00:00:32
20.01.2023

Tag : #MalhotraCompter About the Video: How to Increase Serial No. Ms Excel Shorts Tips and Trick 👉Malhotra Computer Centre Info ►Subscribe to My Channel: 🤍 ► Like our Facebook page: 🤍 ► Follow us on Instagram: 🤍 ► Thank You for Watching Our Videos. ► Like & Share Our Videos With Your friends on social media _ For Support you can donate here : 💲💲 Razor Pay : 🤍 Google Pay / Phone pe: 8544325608 - Disclaimer : The content in this video is collected from books, media, internet space etc. This is strictly for educational and informational purposes and is not intended to be advice or recommendation of any kind whatsoever. Malhotra Computer/Owner does not accept any liability for any kind of content on this video, or responsibility for any direct, indirect, implied, punitive, special, incidental or other consequential damages arising directly or indirectly on account of any actions taken based on the information provided in this video as is and without warranties, Anyone who wishes to apply concepts and ideas contained in this video takes full responsibility for the actions. Viewers should always do their own due diligence on any information perceived from this video, to form their own opinions and best judgement. The material contained in this video cannot replace or substitute for the services of trained professional in any field, including, but not limited to financial medical psychological or legal matters. The video is not warranted for content, accuracy or any other implied or explicit purposes. This video is not intended to spread rumours or offend or hurt the sentiments or any religion, communities or individuals, or to bring disrepute to any person (living or dead). Viewer's discretion is advised as this video is meant to be a satirical and humorous take on the speaker's experiences or thoughts in general. Despite our best intentions there may be sections that get offended by this video. We request people not to take our content too seriously and we sincerely apologise for any such hurt our video might have caused. Copyright Disclaimer under section 107 of the Copyright Act 1976, allowance is made for “fair use” for purposes such as criticism, comment, news reporting, teaching, scholarship, education and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. The image or video clip used in this video or thumbnail is only for educational purpose. if anyone has objection please feel free to contact on malhotracomputercentre🤍gmail.com before claim.

Concatenate Excel Tutorial

323437
4611
154
00:05:29
12.12.2019

Learn how to combine cells in Microsoft Excel using the concatenate function in this step-by-step tutorial. Access the sample data that I use in this video here: 🤍 - Learn the fundamentals of Excel in just 2 hours: 🤍 The CONCATENATE function joins two or more text strings into one string. In Excel 2016, Excel Mobile, and Excel for the web, this function has been replaced with the CONCAT function. Although the CONCATENATE function is still available for backward compatibility, you should consider using CONCAT from now on. This is because CONCATENATE may not be available in future versions of Excel. =CONCATENATE (text1, text2, [text3], ...) In this video, I use the latest version of Microsoft Excel that comes with Office 365. However, this should work with older versions of Excel as the concatenate function has been available in past versions of Excel. See all Excel tutorial videos here: 🤍 As full-disclosure, I work at Microsoft as a full-time employee.

Импорт табличных данных из PDF в Excel

168821
4610
188
00:10:36
01.06.2018

Как перенести таблицу с данными из файла PDF на лист Excel. Скачать пример 🤍 Заходите в гости ↓↓↓ Мои книги 🤍 Мои онлайн-курсы 🤍 Моя надстройка PLEX (+150 новых функций для вашего Excel) 🤍 Twitter 🤍 Facebook 🤍 Instagram 🤍

Excel Tutorial for Beginners | Excel Made Easy

1268076
25783
551
00:15:54
04.02.2021

Join 300,000+ professionals in our courses: 🤍 Learn the basics of using Microsoft Excel. How a spreadsheet is setup, and how you can enter data in Excel. Learn useful Excel shortcuts. Understand how the menu bar (the Excel Ribbon) works and where to find different features. Learn formatting in Excel to display your data better. This basic tutorial is for all versions of Excel (Excel 2010, Excel 2013, Excel 2016, Excel 2019 and Excel for Office 365). Looking for more Excel basics videos? Check out this playlist: 🤍 Time Stamps 00:00 Learn the Basics of Microsoft Excel 00:27 Anatomy of a spreadsheet in Microsoft Excel 01:20 What is a Cell in Microsoft Excel 03:50 What is a Range in Microsoft Excel 04:41 Excel Cursor and Mouse Pointer Shapes 05:48 How to Change Size of Rows and Columns in Excel 07:26 How to Use the Ribbon in Microsoft Excel 09:25 How to Enter Data in Microsoft Excel 11:47 How to Format Data in Microsoft Excel * Complete Excel Essentials course for beginners: 🤍 ⯆ The full article to Excel for beginners: 🤍 ★ My Online Excel Courses ► 🤍 ✉ Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 EXCEL RESOURCES I Recommend: 🤍 Get Microsoft 365: 🤍 Microsoft Surface: 🤍 GEAR Screen recorder: 🤍 Main Camera: 🤍 Backup Camera: 🤍 Main Lens: 🤍 Zoom Lens: 🤍 Audio Recorder: 🤍 Microphone: 🤍 Lights: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #MsExcel #Excel

Сравнение двух таблиц в Excel

332866
6604
270
00:17:56
04.12.2017

Разбор 3 способов сравнения двух таблиц в Excel: функцией ВПР, через сводную таблицу и с помощью Power Query. Скачать пример 🤍 Заходите в гости ↓↓↓ Twitter 🤍 Facebook 🤍 Instagram 🤍 Мои книги 🤍 Моя надстройка PLEX (+150 новых функций для вашего Excel) 🤍

Microsoft Excel Tutorial for Beginners | Excel Training | FREE Online Excel course

1788473
28195
294
10:30:01
01.01.2021

Welcome to the The Beginner's Guide course to Excel. This Excel Full Course enables you to Learn MS Excel in simple and easy steps. In this Microsoft Excel Basics Tutorial series we will start from the basics and gradually move towards the Expert level in Microsoft Excel. This MS Excel course provides the Beginners to Intermediate Excel Skills, Tips, and Tricks. In this course we will learn how to Enter and edit Excel data, Format numbers, fonts and alignment, Make simple pivot tables and charts, Create simple Excel formulas, How to Use Excel Functions IF and VLOOKUP. Learn common Excel functions used in any Office, How to Create dynamic reports, Build Excel formulas to analyze date, text fields, values and arrays and much more advanced stuff. 🌍 Microsoft Excel Course🌍 1-      00:02:38 - Introduction to MS Excel 2-      00:13:48 - Organizing Data 3-      00:25:10 - Basic Excel Formulas | Important Formulas for Beginners 4-      00:35:47 - How to use the Excel IF function 5-      00:46:54 - Pivot Tables in Excel | How to Create a Pivot Table in Excel 6-      00:57:04 - Text Functions in Excel | Excel TEXT Function - Formula and Examples 7-      01:07:29 - Cell Reference in Excel with Examples 8-     01:18:29 - Text to Columns in Excel | How to Use Text-to-Columns in Excel 9-     01:28:04 - How to Use Paste Special + How to Use Speak Cells Feature in Excel 10-   01:39:10 - Custom List in Excel + Using Advanced Fill in Excel 11-   01:49:30 - Flash Fill in Excel + Series features 12-   01:59:48 - Nested IF, AND, IF ERROR Function ( Logical Functions in Excel) 13-   02:11:51 - Comments and Custom Views 14-   02:22:03 - How to Make Charts and Graphs in Excel 15-  02:32:59 - Excel DATE function with examples + Mathematical Functions 16-   02:44:33 - How to Rotate Text in Cells in Excel + How to Print in Excel 17-   02:55:04 - How to use Header and Footer in MS Excel 18-   03:05:24 - Data validation in Excel 19-   03:15:49 - How to Record a Macro in Excel 20-   03:27:12 - Relative References in Excel 21-   03:38:13 - How to Make a Macro in Excel | Write Macros in Excel 22-   03:49:51 - Name Array in MS Excel 23-   04:00:21 - How To Use VLOOKUP in Excel 24-   04:10:12 - Approximate Match and VLOOKUP rules 25-   04:21:21 - Consolidate Data in Excel | Excel Consolidate Function 26-   04:32:04 - Count Functions in MS Excel 27-   04:43:00 - Single Criteria Statistical functions 28-   04:53:42 - Multiple Criteria Statistical Functions in Excel 29-   05:04:26 - How to use Index, Match, Lookup and HLookup in Excel 30-   05:16:22 - Protection Rules in MS Excel | Protecting a Worksheet's Format Excel 31-   05:26:55 - Create Hyperlinks in Excel | Links in MS Excel 32-   05:37:41 - Data Sorting In MS Excel | How to Sort Lists in Excel 33-   05:48:07 - Filtering Data | How to Filter in Excel 34-   05:58:48 - Advanced Filters in MS Excel 35-   06:09:14 - Chart Shortcuts in MS Excel | Create Excel Chart With Shortcut Keys 36-   06:19:37 - Combo Charts and Pie Charts in MS Excel 37-   06:31:07 - Spark Line Charts in MS Excel 38-   06:41:26 - Pivot Chart in MS Excel 39-   06:52:25 - Conditional Formatting in Excel : Part 1 40-   07:02:52 - Conditional Formatting in Excel : Part 2 41-   07:13:13 - Conditional Formatting for Icon Sets - How to use Icon Sets 42-   07:23:35 - Advanced Conditional Formatting Formulas in MS Excel 43-   07:32:17 - Customizing Pivot Tables Part 1 44-   07:43:40 - Customizing Pivot Tables Part 2 45-   07:53:55 - Pivot Table Item Slicers | Excel Pivot Table Slicers 46-   08:04:52 - Slicer and Timeline over Pivot Table in MS Excel 47-   08:15:03 - Dependent Dropdown Lists in MS Excel 48-   08:25:36 - Summary Report in MS Excel | How to Create an Excel Summary Report 49-   08:35:34 - Objects In Ms Excel | Excel Worksheet Objects 50-   08:45:58 - Table vs Cell Range in MS Excel 51-   08:56:10 - Slicers on Charts in MS Excel | Slicer Controlled Interactive Charts 52-   09:06:40 - How to Create a Linked Object in Microsoft Excel 53-   09:16:46 - Ctrl Shortcuts in MS Excel 54-   09:27:08 - Function Keys Shortcut In Microsoft Excel 55-   09:37:23 - Alt Key Shortcuts in MS Excel (Keyboard shortcuts in Excel) 56-   09:46:55 - Shift + Function Key shortcuts in MS Excel 57-   09:57:54 - Ctrl + Function Key Shortcuts In Ms Excel 58-   10:08:22 - Alt And Shift With Special Keys Shortcuts In Ms Excel 59-   10:19:28 - #Excel #MSExcel #MicrosoftExcel #ExcelTutorial #excelTutorial #excelTutorialForBeginners #excel #excelCompleteCourse

Top 25 Excel 2016 Tips and Tricks

4035910
53219
1835
00:27:44
15.01.2018

The Top 25 tips and tricks for Excel 2016. Use these tips and tricks to improve your efficiency using Excel. I am sure you will discover some that you have not seen before and others that you have been using incorrectly. My personal favorite is #21. Become more productive using Excel at work, school and home. Check out the Advanced Excel video at 🤍 Another 15 Excel 2016 Tips & Tricks: 🤍 Introduction to Excel for Beginners: 🤍 Don't miss the latest Ultimate 50 Excel Tips and Tricks: 🤍 Support me with your Amazon purchases, click here: 🤍 Contents 0:00 1. Quick Analysis Tool 0:47 2. Filter 1:44 3. Drop-Down List 2:25 4. AutoFit Column Width 3:12 5. Transpose 3:47 6. Remove Duplicates 4:13 7. Goal Seek 5:23 8. VLOOKUP 6:55 9. Flash & Auto Fill 9:06 10. Paste Special Values 10:47 11. Images in Charts 11:50 12. IF Function 12:28 13. Insert Screenshot 13:40 14. Absolute Cell Reference 14:15 15. Show Formulas 15:54 16. Text to Columns 16:57 17. Conditional Formatting 18:11 18. PowerPivot 19:36 19. Freeze Panes 20:46 20. Ctrl-Arrow Keys 21:40 21. 3D References 21:58 22. Forecast Sheet 23:43 23. SUMIFS Function 24:16 24. IFERROR Function 25:38 25. Filled Maps 26:30 #seletraining #excel #tipsandtricks

Как сделать сводную таблицу в Excel

441628
8851
337
00:13:48
01.12.2016

Сводные таблицы excel: пошаговая инструкция для чайников. Макет, поля, вычисления, сортировка, фильтрация и другие функции. Текстовый вариант и файл с примером по ссылке 🤍 ► Корпоративный тренинг "Продвинутый уровень MS Excel": 🤍 ► Онлайн курс "Продвинутый уровень MS Excel": 🤍 💳 Поддержать канал деньгами 🤍 * Мой сайт об Excel и статистике * 🤍 * Странички и аккаунты в соцсетях * Facebook: 🤍 Вконтакте: 🤍 Твиттер: 🤍 Telegram: 🤍

Условное форматирование в Excel

224021
1804
92
00:10:41
08.09.2013

Как наглядно представить числовые данные с помощью условного форматирования в Excel 2007-2013 Обсуждение тут 🤍 Заходите в гости ↓↓↓ Twitter 🤍 Facebook 🤍 Instagram 🤍 Мои книги 🤍 Моя надстройка PLEX (+150 новых функций для вашего Excel) 🤍

Microsoft Excel 2016 - Learn Excel 2016 Beginners Tutorial Video

1394412
11479
447
02:08:31
29.08.2016

Learn Microsoft 2016 from the pro's. In this FREE beginners tutorial for Microsoft 2016 you will learn the basics of Excel 2016, and Tips and Tricks so that you can get the most out of your Excel experience. Our beginner videos start with simple tasks like selecting cells and entering data, then quickly move to calculating data with basic formulas and functions. The intermediate portion shows you how simple it is to sort and filter and then moves to one of Excel’s most popular features, Pivot Tables. Our advanced videos start with functions like IF and VLOOKUP and finish up with Macros. Some of the other topics in the Microsoft Excel 2016 tutorial include: Start Screen & Templates, Ribbon & QA Toolbar - Part 1, Ribbon & QA Toolbar - Part 2, Backstage View, Interface, Share Pane, Tell Me, Smart Lookup, Navigating, Keyboard Shortcuts, Entering Text Formatting Numbers, Deleting & Formatting, AutoSum, Simple Formulas, Simple Functions, Absolute Referencing, Inserting Rows Inserting Columns, Moving & Copying Data, Autofill, Cell Styles, Worksheet Themes, Excel Templates, Grouping Worksheets, Freeze Panes, Custom Views, Spell Check, Printing, Flash Fill, List Design & Single Level Sorting, Multi-Level Sorting, Custom Sorting, Filtering, Multi-Level Filtering, Search Filtering, Format as Table, Table Style Options, Remove Duplicates, Convert to Range, Subtotal, Multi-Level, Subtotaling, Remove Subtotals, Quick Analysis Charts, Inserting Data Charts, Formatting Data Charts, Chart, Templates, Spark lines, Printing Charts, Importing From Web, MS Query, Exporting Overview, Pivot Tables, Multiple-Field Pivot Tables, Drill Down Reports, Pivot Charts & Grouping Fields, Slicer Tool, Data Validation - Part 1, Data Validation - Part 2, Cell & Sheet Protection, File Encryption, Conditional Formatting, Linking Data, Inserting Comments.. and more Please subscribe to Learn iT! and check out our website (🤍) to browse other Microsoft Courses, Project Management, and IT Training courses. For ad free training and certificates please join Learnit Anytime: 🤍 For Private Group Trainings please visit: 🤍 #Excel (C) 2021 Learnit, Inc. Any illegal reproduction of this content will result in immediate legal action.

Top 20 Microsoft Excel Tips & Tricks

514784
12585
350
00:25:38
23.10.2020

In this step-by-step tutorial, learn the top 20 best Microsoft Excel tips and tricks. 👋 Resources called out in this video: - Excel sheet that I used if you want to follow along: 🤍 - In-depth Pivot Table tutorial: 🤍 - Learn the fundamentals of Excel in just 2 hours: 🤍 ⌚ Timestamps 0:00 Introduction 0:17 Convert image to table in Excel using phone 1:29 Use Excel for free on the web 2:08 Use Ideas to generate insights on your data 3:19 Define names for cells 4:42 Absolute & relative cell references 6:35 Macros 8:35 Data types 9:38 Xlookup function 11:47 Sum function 12:43 Concatenate and flash fill 13:48 Sumif function 14:45 Countif function 15:35 IF function 16:48 Calculate difference between dates & convert function 18:11 Adjust column width & row height automatically 18:56 Freeze panes 19:33 Pivot Tables 21:14 Drop down lists 22:16 Import data from web 23:54 Collaborate with others & comment 24:45 Wrap up 📃 Watch related playlists and videos - Excel: 🤍 🚩 Connect with me on social: - LinkedIn: 🤍 - Twitter: 🤍 - Facebook: 🤍 🔔 Subscribe to my YouTube channel 🤍 🎬 Want to watch again? Navigate back to my YouTube channel quickly 🤍

Подсветка дат и сроков в Excel

282560
6090
189
00:10:22
09.03.2014

Как наглядно подсвечивать в таблицах разными цветами прошлые, текущие и будущие даты в Excel. Полный текст и файл с примером 🤍 Заходите в гости ↓↓↓ Twitter 🤍 Facebook 🤍 Instagram 🤍 Мои книги 🤍 Моя надстройка PLEX (+150 новых функций для вашего Excel) 🤍

Recuperare Fișierele Nesalvate din Excel

15240
95
0
00:00:58
20.01.2023

Știai că am filmat pentru tine 1.200 de lecții video Microsoft Office? Link pachet complet de cursuri video în limba română, redus azi cu 80%: 🤍 Vrei să primești acces gratuit la toate cele 1.200 de lecții video? Vino la un curs personalizat de Excel / VBA / Power BI cu instructor acreditat Microsoft! Link cursuri LIVE (cu instructor Microsoft) de Excel pentru Bussiness: 🤍 Ai o întrebare tehnică? Am răspuns deja la peste 12.000 de persoane la mai bine de 70.000 de întrebări Excel & BI. Link comunitate Dr.Excel: 🤍 Găsești o multitudine de resurse utile și gratuite despre Excel și Business Intelligence pe blog-ul meu: Link Blog DrExcel (Bogdan Tarla): 🤍 Link BIO Bogdan Tarla (MVP Excel) - alias DrExcel: 🤍 Împreună cu IT Learning, suntem #1 în România în domeniile instruirii Microsoft Office și Business Intelligence, liderii comunității Excel din România, realizatorii celui mai amplu portal de cursuri e-learning interactive din Europa și deținătorii unui portofoliu de mii de cursuri Excel, Sql Server, VBA, Power BI, susținute pentru sute de companii din toată țară . Oricare ar fi nevoile tale de instruire Microsoft, scrie-ne la adresa de email: office🤍DrExcel.ro

Top 10 Most Important Excel Formulas - Made Easy!

4141400
72291
1278
00:27:19
08.06.2018

This video provides a basic introduction into the top 10 most important formulas used in excel. These include the average function, autosum, Sum If, Count, Counta, Count If function, Concantenate, If logical function, Vlookup, and Drop Down Lists. How To Pass Difficult Math and Science Classes: 🤍 How To Get a Job Quickly: 🤍 Excel Tutorial For Beginners: 🤍 Top 30 Excel Tips & Shortcuts: 🤍 How To Use VLookUp: 🤍 Pivot Tables: 🤍 Excel Tutorial Playlist: 🤍 Disclaimer: Some of the links associated with this video may generate affiliate commissions on my behalf. As an amazon associate, I earn from qualifying purchases that you may make through such affiliate links.

Excel Formula Hack: + Symbol to Start Formulas?!

4783
237
5
00:00:58
24.01.2023

Check out 🤍ExcelCampus for more Excel tutoring tips, including more formula hacks, VBA and macro tutorials, beginner to advanced level Excel training in Pivot Tables, and overviews of the Excel "Power Tools" (Power Query, Power Bi etc.)

Excel Shortcut to Scroll SIDEWAYS ↔️ with your Mouse #shorts

118875
6757
143
00:00:43
06.02.2022

In this video you'll learn a helpful shortcut in Microsoft Excel you may have missed: How to scroll horizontally / sideways in Excel with your mouse wheel. This is available in Excel for Microsoft 365. 🌍 My Online Excel Courses ► 🤍 🎬 LINK to more YouTube Shorts videos: 🤍 🎒 Get the Official XelPlus MERCH: 🤍 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 📚 Excel RESOURCES I Recommend: 🤍 🎥 GEAR I use: 🤍 More resources on my Amazon page: 🤍 🚩Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #Excel

Назад
Что ищут прямо сейчас на
видео по excel arma 3 rp 佛牙 орёл HoboGivili mechanic which limoneros ea play на ps4 sia live fishinhg off grid generals lemon bangs kissinger Baudelaire Orphans распаковка товаров refurb Wessam