🔥Intellipaat Microsoft excel training: https://intellipaat.com/excel-training/
In this microsoft excel tutorial you will master how to use excel, complete ms excel formulas, excel tips and tricks, excel accounting, how to use excel vlookup, pivot table in excel, excel formulas and functions in detail.
#ExcelTutorial #MicrosoftExcelTutorial #Excel
👉Following topics are covered in this video:
0:00 – Excel Tutorial
1:08 – Microsoft Excel Overview
4:52- Getting started with Microsoft Excel
5:33- Hands on with Microsoft excel
8:02 – Saving an Excel file
10:31- Excel Customization
13:21- Important areas of working
15:51- What is formula bar
24:06- Formatting excel and shortcuts
33:04- Basic Formulas
50:00- Find and Replace
1:05:49- Text Functions-Formatting Data
1:39:25- count functions
1:40:45- Relative Reference
1:57:17- Absolute Reference
2:14:12- Mixed Reference
2:32:52- Data Validation
2:42:00- Different types of data validation
3:03:02- Conditional formatting
3:43:56- sorting data
4:06:15- filtering data
4:34:11- column chart
5:09:54- line chart
5:23:01- pie chart
6:14:29- pivot tables
7:50:55- index function
7:51:51- Match function
8:30:39- lookup function
9:11:55- what is VBA
9:13:23- what is macro
9:14:37- Exploring Visual Basic Editor (VBE)
9:17:14- Using Macro Recorder
9:51:18- Variable, data types and constants
10:04:14- scope of a variable
10:15:09- Data Types
📌 Do subscribe to Intellipaat channel & get regular updates on videos: http://bit.ly/Intellipaat
🔗 Watch top technologies video tutorials here: https://bit.ly/2IAtGl2
📕 Read technologies tutorial here: https://bit.ly/1T3TUeK
📰Interested to read about technological blogs? Please read here: https://bit.ly/31OX4vi
Are you looking for something more? Enroll in our microsoft excel training & certification course and become a certified professional (https://intellipaat.com/excel-training/). It is a 24 hrs instructor led training provided by Intellipaat which is completely aligned with industry standards and certification bodies.
If you’ve enjoyed this microsoft excel training video, Like us and Subscribe to our channel for more similar informative videos.
Got any questions about ms excel tutorial? Ask us in the comment section below.
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
Why microsoft excel is important?
Microsoft Excel is the most-used spreadsheet program in the world. Excel can perform formula-based calculations and many other mathematical functions. The program also serves as a programming platform for Visual Basic for Applications. Because of its utility, Excel has become a staple in many enterprises.
Why should you opt for a microsoft excel career?
Microsoft Excel has proven to be advantageous for day to day business activities. The knowledge of Microsoft Excel has become essential for small business establishments to carry out their day to day business and reap the best results from their business. There is a huge demand for ms excel certified professional. The salaries for ms excel professional are also very good.
For more information:
Please write us to [email protected] or call us at: +91-7847955955