...

betterskill.io

Menu
Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Login/Signup
Dashboard
Course Content
DEMO CLASS: [ক্লিক করে দেখে নিন কোর্সের ডেমো ক্লাসগুলো]
0/3
DEMO Class 1: Formatting Numbers, Text, and Dates
04:16
DEMO Class 2: Excel Functions Basic and Types
03:13
DEMO Class 3: Customizing chart elements in Excel
05:18
Module 1: Microsoft Excel Fundamentals
0/7
Lecture 1: What is Excel & its Uses
04:09
Lecture 2: Overview of the Excel Interface
03:31
Lecture 3: What is Workbook & Worksheet?
02:56
Lecture 4: Navigate into Your Worksheet
06:59
Lecture 5: Saving and Managing Files
02:03
Excel Shortcuts
For 1-to-1 Instructor Support, Join Here…
Module 2: Worksheet Management
0/6
Lecture 1: Manage Your Worksheet (Part 1)
05:24
Lecture 2: Manage Your Worksheet (Part 2)
01:39
Lecture 3: Data Types in Excel
02:20
Lecture 4: Data Entry Basics
01:37
Lecture 5: Cut, Copy and Paste
07:43
Lecture 6: Other Paste option & Transpose Function
06:17
Module 3: Cell Formatting in Excel
0/7
Lecture 1: Formatting Numbers, Text, and Dates
04:16
Lecture 2: Cell style Alignment, Wrapping & Merging
02:32
Lecture 3: Custom Cell Style Font, Borders, and Cell Color
02:39
Lecture 4: Using Format Painter
01:37
Lecture 5: Fill Handle & Autofill
14:02
Lecture 6: Understanding cell references Relative, Absolute, Mixed
08:54
Lecture 7: Inserting and Deleting Rows Columns
03:02
Module 4: Excel Data Management: Sorting, Filtering & Organization
0/9
Lecture 1: Sorting data (A–Z, Z–A, custom sort)
07:46
Lecture 2: Filtering Data
07:29
Lecture 3: Name Range
01:45
Lecture 4: How to Use Name Range
05:46
Lecture 5: Table
07:58
Lecture 6: How to Construct a Table
01:32
Lecture 7: Table vs Range
03:10
Lecture 8: Data Validation
04:12
Lecture 9: Creating Dropdown
01:20
Module 5: Excel Essential Formulas & Functions
0/8
Lecture 1: Formula and Functions (Understanding its differences with Basic math operations +, –, ,)
05:44
Lecture 2: Excel Functions Basic and Types
03:13
Lecture 3: Excel Function- SUM
02:45
Lecture 4: Excel Function- AVERAGE
00:30
Lecture 5: Excel Function- MAX
00:27
Lecture 6: Excel Function- MIN
00:30
Lecture 7: Excel Function Count
01:03
Lecture 8: Excel Quick Analysis
01:59
Module 6: Advanced Functions: Logical & Lookup Functions
0/10
Lecture 1: Logical Operators
02:19
Lecture 2: Logical Functions (If, Or, And, Not)
07:10
Lecture 3: Advanced Logical Functions (SUMIF, COUNTIF, AVERAGE IF, MAXIF, MIN IF)
07:19
Lecture 4: Index With Match
09:08
Lecture 5: VLOOKUP
07:56
Lecture 6: HLOOKUP
01:46
Lecture 7: Xlookup
04:39
Lecture 8: Extracting Day, Month, Year, Date data
02:30
Lecture 9: Conditional Formatting
05:07
Download Resources
Module 7: Data Cleaning Techniques in Excel
0/7
Lecture 1: Text Join Functions
09:34
Lecture 2: Text Extracting Functions
04:54
Lecture 3: Find, Search & Len function
07:21
Lecture 4: Value Converting Functions
06:25
Lecture 5: Text Converting Functions
02:31
Lecture 6: Data Cleaning (Part 1)
02:00
Lecture 7: Data Cleaning (Part 2)
04:10
Module 8: Data Visualization & Dashboard Design
0/5
Lecture 1: Creating Line Chart in Excel
02:23
Lecture 2: Creating Bar Chart in Excel
01:18
Lecture 3: Creating Pie Chart in Excel
02:53
Lecture 5: Customizing chart elements
05:18
Lecture 6: Print preview and print area setup
07:04
Module 9: Power Query
0/4
Lecture 1: Introduction to Power Query
00:32
Lecture 2: Importing Data & Automate Data Importing
06:21
Lecture 3: Data Cleaning & Transforming
06:04
Download Resources
Module 10: Pivot Table
0/8
Lecture 1: Introduction to Pivot Table
02:25
Lecture 2: Creating Pivot Table
05:41
Lecture 3: Values, Sorting & Basic Calculations
05:47
Lecture 4: Grouping, Filters & Slicers
09:52
Lecture 5: Pivot Chart
05:30
Lecture 6: Calculated Field
02:35
Lecture 7: Pivot Table Formatting
03:52
Download Resources
Module 11: Power Pivot & DAX
0/4
Lecture 1: Introduction to Power Pivot
01:48
Lecture 2: Data Modeling in Power Pivot
06:17
Lecture 3: Calculation Using DAX
02:47
Download Resource
Module 12: VBA & Macros
0/5
Lecture 1: Introduction to VBA & Macros
01:57
Lecture 2: Recording Macro
06:49
Lecture 3: Combining Multiple Macros using VBA
05:02
Lecture 4: Recording Multiple Rows
06:27
Download Resource
Module 13: AI Tools (ChatGPT & Copilot) in Excel
0/3
Lecture 1: Find Formula using ChatGPT & Copilot
Lecture 2: Detect and fix error using AI
Lecture 3: Visualization using Copilot
Project: Build a Sales Analytics Dashboard
0/5
Lecture 1: Project Overview
01:16
Lecture 2: Data Cleaning
07:46
Lecture 3: Data Summarization
08:21
Lecture 4: Creating Dashboard
14:56
Download Resource
Project: Build a Complete HR Dashboard
0/5
Lecture 1: HR Dashboard Overview
01:10
Lecture 2: Data Cleaning & Processing
09:51
Lecture 3: Data Summarizaion
09:02
Lecture 4: Creating Dashboard
11:11
Download Resource
Assignment: Monthly Budget Tracker
0/1
Monthly Budget Tracker
Exercise Materials
0/1
Practice (.xlsx file)
Microsoft Excel Professional Training Course
Previous
Next
0% Complete