betterskill.io

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Save More with Bundle Courses

Menu
Picture of Betterskill Team
Menu
Menu

Bundle Course

Menu
Picture of Betterskill Team
Menu
Menu
Course Content
DEMO CLASS: [ক্লিক করে দেখে নিন কোর্সের ডেমো ক্লাসগুলো]
0/3
DEMO Class 1: Formatting Numbers, Text, and Dates
04:15
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:30
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:18
Module 3: Cell Formatting in Excel
0/7
Lecture 1: Formatting Numbers, Text, and Dates
04:15
Lecture 2: Cell style Alignment, Wrapping & Merging
02:32
Lecture 3: Custom Cell Style Font, Borders, and Cell Color
02:38
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:09
Lecture 8: Data Validation
04:11
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:18
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:38
Lecture 8: Extracting Day, Month, Year, Date data
02:29
Lecture 9: Conditional Formatting
05:06
Download Resources
Module 7: Data Cleaning Techniques in Excel
0/7
Lecture 1: Text Join Functions
09:33
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/11
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 4: Creating Column Chart in Excel
00:42
Lecture 5: Customizing chart elements
05:18
Lecture 6: Creating Stacked Chart in Excel
02:47
Lecture 7: Creating Combo Chart in Excel
02:10
Lecture 8: Creating Tree map Chart in Excel
02:47
Lecture 9: Creating Funnel Chart in Excel
04:34
Lecture 10: Creating Scatter Plot Chart in Excel
03:22
Lecture 11: 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:47
Lecture 2: Data Modeling in Power Pivot
06:16
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:01
Lecture 4: Recording Multiple Rows
06:26
Download Resource
Module 13: Uses of AI Tools in Microsoft Excel
0/3
Lecture 1: Introduction
00:56
Lecture 2: Find Formula using AI
06:58
Lecture 3: Advance Formulas using AI
05:22
Project 1: 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 2: Build a Complete HR Dashboard
0/5
Lecture 1: HR Dashboard Overview
01:09
Lecture 2: Data Cleaning & Processing
09:51
Lecture 3: Data Summarizaion
09:03
Lecture 4: Creating Dashboard
11:11
Download Resource
Assignments
0/3
Monthly Budget Tracker
Trip Expense Dashboard
Student Performance Dashboard
Exercise Materials
0/1
Practice (.xlsx file)
Microsoft Excel Professional Training Course
Previous
Next
0% Complete