HDTutorial
EN

Playback starts YouTube’s embedded player (privacy-enhanced mode).

Microsoft Excel Tutorial for Beginners | Excel Training | Excel Formulas and Functions | Edureka

3,470,020 views November 15, 2019 4:24:17

Watch on YouTube
Channeledureka!

In brief

Master Excel’s core tools to organize, analyze, and visualize data efficiently—ideal for beginners. You’ll learn essential formulas (SUM, VLOOKUP, IF), formatting tricks, pivot tables, and even automate tasks with macros.

Chapters

Description from the creator

🔴 𝐋𝐞𝐚𝐫𝐧 𝐓𝐫𝐞𝐧𝐝𝐢𝐧𝐠 𝐓𝐞𝐜𝐡𝐧𝐨𝐥𝐨𝐠𝐢𝐞𝐬 𝐅𝐨𝐫 𝐅𝐫𝐞𝐞! 𝐒𝐮𝐛𝐬𝐜𝐫𝐢𝐛𝐞 𝐭𝐨 𝐄𝐝𝐮𝐫𝐞𝐤𝐚 𝐘𝐨𝐮𝐓𝐮𝐛𝐞 𝐂𝐡𝐚𝐧𝐧𝐞𝐥: edrk.in/DKQQ4Py
This Edureka video on "Excel Full Course" is a complete guide for learning Microsoft Excel which covers in-depth knowledge about different excel formulas and functions, conditional formatting, excel Lookup, excel macros & VBA in Ms Excel. Below are the topics covered in this Excel Tutorial:

00:00 Introduction
1:08 Excel Functions
1:08 SUM Function
3:58 SUMIF Function
13:27 COUNT Function
17:27 COUNTIF Function
19:37 COUNTIFS Function
22:22 AVERAGE Function
27:17 ROUND Function
31:52 CONCATENATE Function
37:17 INDEX Function
40:02 OFFSET Function
44:57 MATCH Function
51:07 MAX & TRIM Function
53:57 LEN Function
55:07 SQRT Function
56:12 IF Function
1:07:42 AND Function
1:12:32 TODAY Function
1:13:17 Quick Access Bar
1:18:37 Conditional Fomatting
1:37:58 Color Scale
1:38:33 Using Excel Formulas for Conditional Formatting
1:47:48 Logical Excel Functions
1:57:58 IFERROR Function
2:00:43 IFNA Function
2:03:41 NESTED IF Function
1:11:46 TEXT Functions
2:11:56 LOWER Function
2:13:16 UPPER Function
2:16:46 RANDBETWEEN Function
2:17:31 NAME RANGEs IN Excel
2:20:11 Lookup Functions
2:20:26 VLOOKUP Function
2:22:51 HLOOKUP Function
2:23:56 Formula Auditing
2:24:01 Trace Precedents & Dependents
2:25:26 Error Checking
2:26:46 Show Formulas
2:27:16 Text To Column
2:29:51 Data Validation
2:40:16 What-if Tools
2:49:42 Scenario Manager
2:54:27 Data Table
2:56:17 SORT & FILTER
3:00:02 WRAP Text
3:01:22 Merge Cell & Insert Comments
3:11:52 Large Function
3:23:32 Charts In Excel
3:41:32 Pivot Tables
3:56:18 Data Analysis Using Excel
3:58:38 Slicers In Pivot Tables
4:02:09 VBA & Macros
4:15:19 Assign A Macros
4:15:24 Record A Macros
4:15:29 Debugging

Check out Edureka Excel Tutorial playlist here: bit.ly/34uWKDA
Check out Edureka Excel Tutorial blog list here: bit.ly/2xpc1K7

📢📢 𝐓𝐨𝐩 𝟏𝟎 𝐓𝐫𝐞𝐧𝐝𝐢𝐧𝐠 𝐓𝐞𝐜𝐡𝐧𝐨𝐥𝐨𝐠𝐢𝐞𝐬 𝐭𝐨 𝐋𝐞𝐚𝐫𝐧 𝐢𝐧 𝟐𝟎𝟐𝟒 𝐒𝐞𝐫𝐢𝐞𝐬 📢📢
⏩ NEW Top 10 Technologies To Learn In 2024 - youtube.com/watch?v=vaLXPv0ewHU

📌𝐓𝐞𝐥𝐞𝐠𝐫𝐚𝐦: t.me/edurekaupdates
📌𝐓𝐰𝐢𝐭𝐭𝐞𝐫: twitter.com/edurekain
📌𝐋𝐢𝐧𝐤𝐞𝐝𝐈𝐧: linkedin.com/company/edureka
📌𝐈𝐧𝐬𝐭𝐚𝐠𝐫𝐚𝐦: instagram.com/edureka_learning/
📌𝐅𝐚𝐜𝐞𝐛𝐨𝐨𝐤: facebook.com/edurekaIN/
📌𝐒𝐥𝐢𝐝𝐞𝐒𝐡𝐚𝐫𝐞: slideshare.net/EdurekaIN
📌𝐂𝐚𝐬𝐭𝐛𝐨𝐱: castbox.fm/networks/505?country=IN
📌𝐌𝐞𝐞𝐭𝐮𝐩: meetup.com/edureka/
📌𝐂𝐨𝐦𝐦𝐮𝐧𝐢𝐭𝐲: edureka.co/community/

- - - - - - - - - - - - - - - - -

#edureka #exceledureka #excelTutorial #excelTutorialForBeginners #excel #excelCompleteCourse

For more information, Please write back to us at [email protected] or call us at IND: 9606058406 / US: +18885487823 (toll-free).

About this tutorial

edureka! published this 4:24:17 video tutorial on November 15, 2019. It has been watched 3,470,020 times on YouTube.

Channel
edureka!
Category
Education
Duration
4:24:17
Published
November 15, 2019
Views
3,470,020
Likes
55,981

Tags

Share

This tutorial in other languages