Lecture 1: What is Excel & its Uses - betterskill.io
Microsoft Excel Professional Training Course Lecture 1: What is Excel & its Uses
Microsoft Excel Professional Training Course
0% Completed
DEMO CLASS: [ক্লিক করে দেখে নিন কোর্সের ডেমো ক্লাসগুলো]
DEMO Class 1: Formatting Numbers, Text, and Dates
Video - 4:16 mins
DEMO Class 2: Excel Functions Basic and Types
Video - 3:13 mins
DEMO Class 3: Customizing chart elements in Excel
Video - 5:18 mins
Module 1: Microsoft Excel Fundamentals
Lecture 1: What is Excel & its Uses
Video - 4:09 mins
All Practice Data Files
Reading
Lecture 2: Overview of the Excel Interface
Video - 3:31 mins
Lecture 3: What is Workbook & Worksheet?
Video - 2:55 mins
Lecture 4: Navigate into Your Worksheet
Video - 6:59 mins
Lecture 5: Saving and Managing Files
Video - 2:04 mins
Excel Shortcuts
Reading
For 1-to-1 Instructor Support, Join Here...
Reading
Module 2: Worksheet Management
Lecture 1: Manage Your Worksheet (Part 1)
Video - 5:24 mins
Lecture 2: Manage Your Worksheet (Part 2)
Video - 1:39 mins
Lecture 3: Data Types in Excel
Video - 2:20 mins
Lecture 4: Data Entry Basics
Video - 1:37 mins
Lecture 5: Cut, Copy and Paste
Video - 7:43 mins
Lecture 6: Other Paste option & Transpose Function
Video - 6:17 mins
Module 3: Cell Formatting in Excel
Lecture 1: Formatting Numbers, Text, and Dates
Video - 4:15 mins
Lecture 2: Cell style Alignment, Wrapping & Merging
Video - 2:32 mins
Lecture 3: Custom Cell Style Font, Borders, and Cell Color
Video - 2:38 mins
Lecture 4: Using Format Painter
Video - 1:37 mins
Lecture 5: Fill Handle & Autofill
Video - 14:02 mins
Lecture 6: Understanding cell references Relative, Absolute, Mixed
Video - 8:54 mins
Lecture 7: Inserting and Deleting Rows Columns
Video - 3:02 mins
Module 4: Excel Data Management: Sorting, Filtering & Organization
Lecture 1: Sorting data (A–Z, Z–A, custom sort)
Video - 7:46 mins
Lecture 2: Filtering Data
Video - 7:28 mins
Lecture 3: Name Range
Video - 1:45 mins
Lecture 4: How to Use Name Range
Video - 5:47 mins
Lecture 5: Table
Video - 7:58 mins
Lecture 6: How to Construct a Table
Video - 1:32 mins
Lecture 7: Table vs Range
Video - 3:09 mins
Lecture 8: Data Validation
Video - 4:11 mins
Lecture 9: Creating Dropdown
Video - 1:20 mins
Module 5: Excel Essential Formulas & Functions
Lecture 1: Formula and Functions (Understanding its differences with Basic math operations +, –, ,)
Video - 5:43 mins
Lecture 2: Excel Functions Basic and Types
Video - 3:13 mins
Lecture 3: Excel Function- SUM
Video - 2:45 mins
Lecture 4: Excel Function- AVERAGE
Video - 0:30 mins
Lecture 5: Excel Function- MAX
Video - 0:27 mins
Lecture 6: Excel Function- MIN
Video - 0:30 mins
Lecture 7: Excel Function Count
Video - 1:03 mins
Lecture 8: Excel Quick Analysis
Video - 1:59 mins
Module 6: Advanced Functions: Logical & Lookup Functions
Lecture 1: Logical Operators
Video - 2:19 mins
Lecture 2: Logical Functions (If, Or, And, Not)
Video - 7:10 mins
Lecture 3: Advanced Logical Functions (SUMIF, COUNTIF, AVERAGE IF, MAXIF, MIN IF)
Video - 7:18 mins
Lecture 4: Index With Match
Video - 9:08 mins
Lecture 5: VLOOKUP
Video - 7:56 mins
Lecture 6: HLOOKUP
Video - 1:46 mins
Lecture 7: Xlookup
Video - 4:38 mins
Lecture 8: Extracting Day, Month, Year, Date data
Video - 2:29 mins
Lecture 9: Conditional Formatting
Video - 5:07 mins
Download Resources
Reading
Module 7: Data Cleaning Techniques in Excel
Lecture 1: Text Join Functions
Video - 9:34 mins
Lecture 2: Text Extracting Functions
Video - 4:54 mins
Lecture 3: Find, Search & Len function
Video - 7:21 mins
Lecture 4: Value Converting Functions
Video - 6:25 mins
Lecture 5: Text Converting Functions
Video - 2:31 mins
Lecture 6: Data Cleaning (Part 1)
Video - 2:00 mins
Lecture 7: Data Cleaning (Part 2)
Video - 4:10 mins
Module 8: Data Visualization & Dashboard Design
Lecture 1: Creating Line Chart in Excel
Video - 2:23 mins
Lecture 2: Creating Bar Chart in Excel
Video - 1:18 mins
Lecture 3: Creating Pie Chart in Excel
Video - 2:53 mins
Lecture 4: Creating Column Chart in Excel
Video - 0:42 mins
Lecture 5: Customizing chart elements
Video - 5:18 mins
Lecture 6: Creating Stacked Chart in Excel
Video - 2:47 mins
Lecture 7: Creating Combo Chart in Excel
Video - 2:10 mins
Lecture 8: Creating Tree map Chart in Excel
Video - 2:48 mins
Lecture 9: Creating Funnel Chart in Excel
Video - 4:35 mins
Lecture 10: Creating Scatter Plot Chart in Excel
Video - 3:21 mins
Lecture 11: Print preview and print area setup
Video - 7:04 mins
Module 9: Power Query
Lecture 1: Introduction to Power Query
Video - 0:32 mins
Lecture 2: Importing Data & Automate Data Importing
Video - 6:21 mins
Lecture 3: Data Cleaning & Transforming
Video - 6:04 mins
Download Resources
Reading
Module 10: Pivot Table
Lecture 1: Introduction to Pivot Table
Video - 2:25 mins
Lecture 2: Creating Pivot Table
Video - 5:41 mins
Lecture 3: Values, Sorting & Basic Calculations
Video - 5:47 mins
Lecture 4: Grouping, Filters & Slicers
Video - 9:52 mins
Lecture 5: Pivot Chart
Video - 5:30 mins
Lecture 6: Calculated Field
Video - 2:35 mins
Lecture 7: Pivot Table Formatting
Video - 3:52 mins
Download Resources
Reading
Module 11: Power Pivot & DAX
Lecture 1: Introduction to Power Pivot
Video - 1:48 mins
Lecture 2: Data Modeling in Power Pivot
Video - 6:17 mins
Lecture 3: Calculation Using DAX
Video - 2:47 mins
Download Resource
Reading
Module 12: VBA & Macros
Lecture 1: Introduction to VBA & Macros
Video - 1:57 mins
Lecture 2: Recording Macro
Video - 6:49 mins
Lecture 3: Combining Multiple Macros using VBA
Video - 5:01 mins
Lecture 4: Recording Multiple Rows
Video - 6:26 mins
Download Resource
Reading
Module 13: Uses of AI Tools in Microsoft Excel
Lecture 1: Introduction
Video - 0:56 mins
Lecture 2: Find Formula using AI
Video - 6:58 mins
Lecture 3: Advance Formulas using AI
Video - 5:21 mins
Project 1: Build a Sales Analytics Dashboard
Lecture 1: Project Overview
Video - 1:16 mins
Lecture 2: Data Cleaning
Video - 7:46 mins
Lecture 3: Data Summarization
Video - 8:21 mins
Lecture 4: Creating Dashboard
Video - 14:56 mins
Download Resource
Reading
Project 2: Build a Complete HR Dashboard
Lecture 1: HR Dashboard Overview
Video - 1:09 mins
Lecture 2: Data Cleaning & Processing
Video - 9:51 mins
Lecture 3: Data Summarizaion
Video - 9:03 mins
Lecture 4: Creating Dashboard
Video - 11:11 mins
Download Resource
Reading
Assignments
Monthly Budget Tracker
Reading
Trip Expense Dashboard
Reading
Student Performance Dashboard
Reading
Exercise Materials
Practice (.xlsx file)
Reading
Announcements Live Classes Gradebook Certificate Course Info
PreviousNext
  • Login
  • Registration
Forgot Password?
Or
Or
Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.
body::-webkit-scrollbar { width: 7px; } body::-webkit-scrollbar-track { border-radius: 10px; background: #f0f0f0; } body::-webkit-scrollbar-thumb { border-radius: 50px; background: #dfdbdb }