Excel Tutorial for Beginners | Excel Course | Intellipaat
308▶️ Intellipaat's Advanced Microsoft Excel Training Course - https://intellipaat.com/excel-training/
🔵In this video on “Excel Tutorial for Beginners”, you will learn Excel from scratch. This video includes basics of Excel like entering Data & referencing in Formulae, Conditional Formatting, and important Formulae in Excel. Next, you will understand Data Sorting & Filtering Techniques, Data & File Security and Pivot Tables in Excel with examples. Further in the video, you will be introduced to VBA Macros and you will gain knowledge on the principles of Charting, creating Dashboards and Interactive Components. Let’s begin without further ado!
🔵What is Microsoft Excel?
Microsoft Excel is a spreadsheet programme developed by Microsoft that is available for Windows, macOS, Android, and iOS. It includes calculating or computation skills, graphing tools, pivot tables, and Visual Basic for Applications, a macro programming language (VBA). Excel is part of the Microsoft Office software suite.
🔵Why learn Excel?
Learning Excel allows you to execute a variety of jobs more effectively, including:
Making budgets
Putting together revenue statements
Keeping track of profit and loss figures
Supply and inventory control
Using visuals such as charts and graphs to assist others in understanding data
👉Following topics are covered in this video:
00:00:00 - Excel Introduction
00:01:08 - Microsoft Excel Overview
00:04:57 - Getting Started with Microsoft Excel
00:13:25 - Important Areas of Working
00:24:09 - Formatting Excel and Shortcuts
00:33:22 - Basic Formulas
00:50:32 - Find and Replace
01:06:20 - Text Functions-Formatting Data
01:41:21 - Relative Reference
01:57:47 - Absolute Reference
02:14:34 - Mixed Reference
02:33:52 - Introduction to Data Validation
02:42:03 - Different Types of Data Validation
03:03:00 - Conditional formatting
03:43:36 - Sorting Data and Filtering Data
04:37:03 - Charts and Graphs
05:36:47 - Protection
06:14:33 - Pivot Tables
07:00:00 - Vlookup Function
07:51:37 - Index Function and Match Function
08:31:38 - Lookup Function
09:11:50 - What is VBA
09:14:30 - What is Macro
09:15:34 - Exploring Visual Basic Editor (VBE)
09:18:11 - Using Macro Recorder
09:40:08 - Quick Recap
09:52:30 - Variable, Data Types and Constants
🔵 Intellipaat Training courses: https://intellipaat.com/
Intellipaat is a global online professional training provider. We are offering some of the most updated, industry-designed certification training programs which includes courses in Big Data, Data Science, Artificial Intelligence and 150 other top trending technologies.
We help professionals make the right career decisions, choose the trainers with over a decade of industry experience, provide extensive hands-on projects, rigorously evaluate learner progress and offer industry-recognized certifications. We also assist corporate clients to upskill their workforce and keep them in sync with the changing technology and digital landscape.
#ExcelTutorialForBeginners #ExcelCourse #Intellipaat
📌 Do subscribe to Intellipaat channel & get regular updates on videos: https://goo.gl/hhsGWb
----------------------------
🔵 Intellipaat Edge
1. 24*7 Life time Access & Support
2. Flexible Class Schedule
3. Job Assistance
4. Mentors with +14 yrs
5. Industry Oriented Course ware
6. Life time free Course Upgrade
------------------------------
🔵 For more information:
Please write us to sales@intellipaat.com or call us at: +91-7847955955
Website: https://intellipaat.com/
Facebook: https://www.facebook.com/intellipaatonline
Telegram: https://t.me/s/Learn_with_Intellipaat
Instagram: https://www.instagram.com/intellipaat
LinkedIn: https://www.linkedin.com/company/intellipaat-software-solutions/
Twitter: https://twitter.com/Intellipaat