Excel Tips and Tricks | Excel Tutorial for Beginners - 2021 | Excel Great Learning

2 года назад

7,786 Просмотров

🔥1000+ Free Courses With Free Certificates: https://www.mygreatlearning.com/academy?ambassador_code=GLYT_DES_Top_SEP22&utm_source=GLYT&utm_campaign=GLYT_DES_Top_SEP22

Looking for a career upgrade & a better salary? We can help, Choose from our no 1 ranked top programmes. 25k+ career transitions with 400 + top corporate companies. Exclusive for working professionals: https://glacad.me/3AM2Mzr

🔥 Get your free certificate of completion for the Excel for Beginners Course, Register Now: https://glacad.me/36z6i29 🔥

In this video, we discuss "Excel Tips and Tricks." We will learn the skills that will enable us to make the most effective and efficient use of Microsoft Excel. MS Excel is an industry-leading spreadsheet software and is a robust analysis and data visualization tool. You will get an extensive understanding of concepts such as auto width, slicers and filtering the data, quick analysis tool, transpose, embedding, etc. It is a beginner-friendly session that aims at helping you get started with Microsoft Excel on the right note.

00:00:00 Introduction
00:01:14 Auto Width
00:04:55 Flash Fill and AutoFill
00:11:17 Show Formulas
00:13:00 Paste Special
00:14:44 Transpose
00:16:11 Absolute Cell Reference
00:20:03 Text to column
00:23:09 Image in Charts
00:26:03 Quick Analysis Tool
00:28:31 Drop down list
00:30:55 Define cell name
00:33:59 Remove Duplicates
00:36:07 Goal Seek
00:38:44 3D Referencing
00:41:50 Slicers
00:44:14 Advanced Filter
00:46:35 Embedding
00:49:24 Advanced Select

Visit Great Learning Academy, to get access to 300+ free courses with 1000+ hours of content on Data Science, Data Analytics, Artificial Intelligence, Big Data, Cloud, Management, Cybersecurity, Software Development and many more. These are supplemented with free projects, assignments, datasets, quizzes. You can earn a certificate of completion at the end of the course for free. https://glacad.me/3yJbVXP

Get the free Great Learning App for a seamless experience, enroll for free courses and watch them offline by downloading them. https://glacad.me/3cSKlNl

About Great Learning:
- Great Learning is an online and hybrid learning company that offers high-quality, impactful, and industry-relevant programs to working professionals like you. These programs help you master data-driven decision-making regardless of the sector or function you work in and accelerate your career in high growth areas like Data Science, Big Data Analytics, Machine Learning, Artificial Intelligence & more.

Тэги: