Excel for Data Analytics
Categories: Business, Development
What Will You Learn?
- এক্সেল ব্যাসিক থেকে প্রোফেশনাল লেভেল ✅
- LookUp (VlookUp, HLookUp, XlookUP) ✅
- এক্সেল ২০২৬ এর সকল আপডেট ✅
- এক্সেল অটোমেশন ও ম্যাক্রোস ✅
- এক্সেল পাওয়ার কুয়েরী ও পিভোট টেবিল ✅
- এক্সেল ডেটা ক্লিনিং ও ডেটা ভিজ্যুয়ালাইজেশন ✅
- প্রতিটি লেসনের কুইজ ও লেকচার শিট ✅
Course Content
🟢 Get Started to Microsoft Excel 2024 with Us!
-
Download Microsoft Office 2024 [No Video] 📌
00:00 -
Live Class Join Group Link:: [No Video] 📌
00:00 -
Course Meterials [No video] 📌
00:00 -
How to download Microsoft office 2024
01:07 -
How to remove Ms Office Pervious version
03:55 -
How to install Microsoft Office 2024
02:27
🟢 Excel Basic
-
Excel Interface
04:48 -
Excel Text Alignment
06:59 -
Excel Typography
07:50 -
Clear
03:58 -
Cell Size
05:06 -
Find and Replace
04:08 -
Note
00:00 -
Quiz❓
🟢 Conditional Formatting
-
conditional Formatting (Highlights Rules)
07:35 -
Conditional formatting (Top to Bottom Rules)
03:23 -
Conditional formatting (Data Bar)
03:42 -
conditional Formatting Color Scale
04:47 -
cells formatting
06:41 -
Note
00:00 -
Quiz❓
🟢 Basic Formulas in Excel
-
Basic Arithmetic Formulas
09:41 -
Basic Arithmetic Operation
10:53 -
Excel Case Formulas
10:53 -
Excel Number Conversions
05:12 -
Sum, SumIF, SumIFS
12:21 -
Excel Count Formulas
04:44 -
Note
00:00 -
Quiz ❓
🟢 Advance Formula Updated (2016-2021 v)
-
if formula
03:19 -
IFS Formula
02:33 -
AND, OR Logical Formula
06:44 -
Advanced Filter in Excel
11:12 -
Advanced Unique formula in Excel
05:11 -
Note
00:00 -
Quiz❓
🟢 Advaced Formula Most Updated (2024 v)
-
Excel Vstack formula
04:06 -
Take and Drop Formula in Excel
06:02 -
Excel Choose formula
03:13 -
Excel torow, tocol formula
03:50 -
Choose ROWS and COLS Formula
03:23 -
Sort, SortBy formula
05:34 -
textsplit Formula
04:38 -
LET Formula
03:42 -
Note
00:00 -
Quiz❓
🟢 Excel illustrations
-
Shape
05:46 -
shape styles
01:37 -
icons
05:26 -
Smart Art
05:00 -
Excel images
06:47 -
3D Models
04:10 -
Equation and Symbols
05:09 -
Note
00:00
🟢 Excels Charts
-
Column Chart
09:20 -
Line Chart
10:17 -
Pie Chart
10:47 -
tree Map
11:04 -
SunBust
11:34 -
Histogram
10:47 -
waterfall
10:17 -
Funnel
10:31 -
Stock
11:03 -
Surface
11:34
🟢 Excel Others 📖
-
Excel Slicer
08:45 -
View (show, zoom)
04:15 -
Window Panel
04:21 -
Page Layout
11:33 -
Arrange
11:04
🟢 Excel Data Analysis
-
Excel Goal Seek
05:53 -
Excel Flashfills
05:03 -
Excel Consolidate
05:22 -
Data DropDown Menu
03:07
🟢 Excel Data Cleaning
-
Excel Data cleaning Agenda
02:03 -
introduction to data cleaning
03:54 -
Remove Blank Data and Duplicate Data
08:07 -
Fix Data text formatting
10:35 -
Flashfill and Convert text to column
07:01 -
Clean Data Table
04:47
🟣 Lookup Basic to Pro
-
Simple Index Match Formuls in Excels
02:43 -
Multiple Criteria Index and Match
04:12 -
Advanced VLookUP in Excel
08:51 -
vlookup multiple tables
04:44 -
HlookUp formula in Excels
04:42 -
Advanced XLookUP Formula
05:37 -
Advanced Xmatch Formula
00:00 -
Advanced lookup formula
00:00 -
Note
00:00
🟣 Power Query Basic to Pro
-
get and transform data
13:30 -
power Query interface
06:48 -
Load and Connection Data
04:50 -
Manage Column
04:08 -
Reduce Rows
04:16 -
Sorting
02:35 -
split column
05:48 -
Group By
03:19 -
Replace Values
03:22 -
Data types
05:52 -
Transform Table
02:56 -
any column
04:22 -
Text Column
04:01 -
Number Column
04:20 -
date time column
02:30 -
merge and append queries
10:36 -
Manage Parameter
09:18 -
column from example
06:24 -
custom column
06:13
🟣 Pivot Table Basic to Pro
-
create data table with customization
03:27 -
get start pivot table analyzer
03:12 -
Pivot table design
03:57 -
pivot table Row,Column
02:48 -
pivot table analyzer values
02:47 -
Pivot table grouping
00:00 -
Custom grouping pivot table
00:00 -
Show values as
00:00 -
Calculated fields items
00:00 -
Pivot table relationship
00:00 -
Unpivot Data
00:00 -
Note
00:00 -
Quiz❓
🟣 Excel VBA and Macros (Automation Excels)
-
Introduction
10:31 -
Modules and Procedure
10:17 -
Excel Object Model
10:47 -
The Range object
11:03 -
variables
11:34 -
Conditions and Loops
10:47 -
array
10:17 -
userform
10:31 -
Errors and Debugging
11:04 -
Excel VBA and Macros
11:34
Earn a certificate
Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.
Student Ratings & Reviews
No Review Yet