Excel Shortcuts Complete Tutorial 2023 | Excel Full Course | Pivot Table | Lookup | Macros | @SCALER
2.8 هزار بار بازدید -
پارسال
-
Want to know the ins
Want to know the ins and outs of Excel? Want to maximise your productivity using Excel? Sumit Shukla, DSML Educator, brings you a course on Excel shortcuts complete tutorial to leverage MS Excel. Check out free masterclass from industry-leading experts: www.scaler.com/events?utm_source=Youtube&utm_mediu…
What is Excel?
Excel is a powerful spreadsheet software developed by Microsoft. It allows users to organise and analyse data using formulas, functions, and visual representations such as charts and graphs. It is widely used for data management, financial calculations, and reporting.
What is Advanced Excel?
Advanced Excel refers to the advanced features and functionalities available in Microsoft Excel, beyond basic spreadsheet functions. It involves complex formulas, data analysis tools, macros, pivot tables, conditional formatting, and automation, enabling users to manipulate and analyse data in more sophisticated ways.
What is Data Science?
Data Science is an interdisciplinary field that involves the use of statistical, computational, and machine learning techniques to extract insights and knowledge from large and complex data sets. It encompasses various stages of data analysis, including data collection, cleaning, processing, modelling, and visualisation.
What is Machine Learning?
Machine Learning is a subfield of Artificial Intelligence that focuses on developing algorithms and models that enable computers to learn from data without being explicitly programmed. It involves the use of statistical and mathematical techniques to enable machines to improve their performance on a specific task through experience.
What is computer science?
Computer science is the study of computers and computational systems. It encompasses the design, development, and analysis of algorithms, programming languages, software, and hardware. Computer scientists solve complex problems, create new technologies, and drive innovation in fields such as artificial intelligence, cybersecurity, and robotics.
What is the tech industry?
The tech industry refers to the businesses and organisations involved in the development, design, manufacturing, and distribution of technology products and services, including computer hardware, software, telecommunications equipment, and e-commerce services. It is a rapidly growing and constantly evolving sector with a significant impact on the global economy.
What are programming skills?
Programming skills refer to the ability to write code and develop software using a programming language. These skills involve understanding how to design, write, test, debug, and maintain software programs and applications. Programming skills are essential for careers in software development and are in high demand in many industries.
Topics covered:
0:00 - Introduction
0:57 - Basic Excel Functions (SUM, MIN, MAX, AVERAGE)
14:14 - Intermediate Excel Functions (SUMPRODUCT, RAND, RANDBETWEEN)
18:48 - String Operations (TRIM, CONCATENATE, LENGTH)
27:46 - Logical Operations (AND, IF, COUNTIF, SUMIF)
36:27 - Date Operations (TODAY, NOW, DAY, MONTH, YEAR, DATEDIF)
41:56 - Data Formatting in Excel
44:43 - Conditional Formatting in Excel
51:40 - Pivot Tables
57:47 - LOOKUP function in Excel (HLOOKUP, VLOOKUP)
1:02:53 - Macros
1:10:08 - Forms using Macros
Did you take the Hunger test yet? Click here: bit.ly/3HY5l6F
______________________________________________________________________________
About SCALER:
A transformative tech school, creating talent with impeccable skills. Upskill and Create Impact.
Learn more about Scaler: bit.ly/3HY5l6F
📌 Follow us on Social and be a part of an amazing tech community📌
👉 Meet like-minded coder folks on Discord - discord.com/invite/ejFeksEtTq
👉 Tweets you cannot afford to miss out on - twitter.com/scaler_official
👉 Check out student success stories, expert opinions, and live classes on Linkedin - www.linkedin.com/school/scalerofficial
👉 Explore value-packed reels, carousels and get access to exclusive updates on Instagram - www.instagram.com/scaler_official/
📢 Be a part of our one of a kind telegram community: t.me/Scalercommunity
🔔 Hit that bell icon to get notified of all our new videos 🔔
If you liked this video, please don't forget to like and comment. Never miss out on our exclusive videos to help boost your coding career! Subscribe to Scaler now!
youtube.com/Scaler?sub_confirmation=1
#msexcel #microsoft #datascience #scaler
پارسال
در تاریخ 1402/02/21 منتشر شده
است.
2,883
بـار بازدید شده