DEMO CLASS 3: TEXT Function - betterskill.io Skip to main content

betterskill.io

✦Biggest deal of the year %Black Friday ✦Up to 80% off %Instant access ✦One time payment
Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Save More with Bundle Courses

Menu
  • All Courses
    • Bundle Course
    • Research & Data Analytics Course
    • Office & productivity
    • Programming
Picture of Jaber
Menu
  • My Classroom
    • My Course
    • Profile Setting
    • Explore Course
Menu
  • login/Registration

Bundle Course

Menu
  • All Courses
    • Bundle Course
    • Research & Data Analytics Course
    • Office & productivity
    • Programming
Picture of Jaber
Menu
  • My Classroom
    • My Course
    • Profile Setting
    • Explore Course
Menu
  • login/Registration
Google Sheets Mastery: Beginner to Advanced DEMO CLASS 3: TEXT Function
Google Sheets Mastery: Beginner to Advanced
0% Completed
DEMO CLASS [ ক্লিক করে দেখে নিন কোর্সের ডেমো ক্লাসগুলো ]
DEMO CLASS 1: Flash Fill Alternatives in Google Sheets
Video - 00:2:10 mins
DEMO CLASS 2: Conditional Formatting Basics
Video - 00:2:41 mins
DEMO CLASS 3: TEXT Function
Video - 00:3:22 mins
Module 1: Welcome & Getting Started
Lecture 1: Welcome to the Course
Reading
Lecture 2: What is Google Sheets?
Video - 00:2:28 mins
Lecture 3: Google Sheets vs Microsoft Excel
Video - 00:3:20 mins
Lecture 4: Creating Your First Spreadsheet
Video - 00:2:55 mins
Lecture 5: Understanding the Google Sheets Interface
Video - 00:7:48 mins
Lecture 6: Rows, Columns, Cells, and Ranges
Video - 00:3:14 mins
Lecture 7: Saving, Sharing, and Version History
Video - 00:5:27 mins
Lecture 8: Keyboard Shortcuts Every Beginner Should Know
Video - 00:1:05 mins
Module 2: Working with Data
Lecture 1: Introduction
Video - 00:1:03 mins
Lecture 2: Editing Cell Contents
Video - 00:2:13 mins
Lecture 3: Copy, Cut, and Paste
Video - 00:2:17 mins
Lecture 4: Fill Handle, AutoFill & Fill with AI
Video - 00:3:52 mins
Lecture 5: Flash Fill Alternatives in Google Sheets
Video - 00:2:10 mins
Lecture 6: Insert, Delete, and Resize Rows & Columns
Video - 00:2:59 mins
Lecture 7: Freeze Rows and Columns
Video - 00:2:59 mins
Lecture 8: Hide & Unhide Rows and Columns
Video - 00:02:22 mins
Lecture 9: Merge Cells (When to Use and Avoid) (Part 1)
Video - 00:4:00 mins
Lecture 10: Merge Cells (When to Use and Avoid) (Part 2)
Video - 00:1:07 mins
Lecture 11: Wrap Text and Text Alignment
Video - 00:03:17 mins
Module 3: Formatting Like a Pro
Lecture 1: Introduction
Video - 00:00:55 mins
Lecture 2: Font Formatting
Video - 00:3:00 mins
Lecture 3: Cell Colors and Borders
Video - 00:2:06 mins
Lecture 4: Number Formatting
Video - 00:1:51 mins
Lecture 5: Date & Time Formats
Video - 00:04:14 mins
Lecture 6: Currency & Percentage Formatting
Video - 00:03:56 mins
Lecture 7: Conditional Formatting Basics
Video - 00:2:40 mins
Lecture 8: Color Scales
Video - 00:02:35 mins
Lecture 9: Alternating Colors
Video - 00:02:16 mins
Lecture 10: Themes
Video - 00:03:05 mins
Lecture 11: Format Painter
Video - 00:02:19 mins
Module 4: Basic Formulas & Functions
Lecture 1: Introduction
Video - 00:00:49 mins
Lecture 2: Understanding Formulas
Video - 00:02:41 mins
Lecture 3: Cell References
Video - 00:2:06 mins
Lecture 4: Relative vs Absolute References
Video - 00:5:35 mins
Lecture 5: SUM
Video - 00:2:19 mins
Lecture 6: AVERAGE
Video - 00:1:19 mins
Lecture 7: MIN & MAX
Video - 00:01:52 mins
Lecture 8: COUNT & COUNTA
Video - 00:01:45 mins
Lecture 9: ROUND Functions
Video - 00:01:16 mins
Lecture 10: AutoSum
Video - 00:01:04 mins
Module 5: Working with Text
Lecture 1: Introduction
Video - 00:00:55 mins
Lecture 2: CONCAT & CONCATENATE
Video - 00:03:355 mins
Lecture 3: TEXTJOIN
Video - 00:01:58 mins
Lecture 4: LEFT, RIGHT & MID
Video - 00:02:49 mins
Lecture 5: LEN
Video - 00:00:49 mins
Lecture 6: TRIM
Video - 00:01:22 mins
Lecture 7: UPPER, LOWER & PROPER
Video - 00:01:22 mins
Lecture 8: FIND & SEARCH
Video - 00:1:27 mins
Lecture 9: SUBSTITUTE
Video - 00:01:46 mins
Lecture 10: SPLIT
Video - 00:01:33 mins
Lecture 11: TEXT Function
Video - 00:03:22 mins
Module 6: Working with Dates & Time
Lecture 1: Introduction
Video - 00:00:48 mins
Lecture 2: Date Basics
Video - 00:01:58 mins
Lecture 3: TODAY
Video - 00:01:23 mins
Lecture 4: NOW
Video - 00:01:07 mins
Lecture 5: DAY, MONTH & YEAR
Video - 00:02:58 mins
Lecture 6: WEEKDAY
Video - 00:01:10 mins
Lecture 7: DATEDIF
Video - 00:03:33 mins
Lecture 8: EDATE & EOMONTH
Video - 00:02:32 mins
Lecture 9: NETWORKDAYS
Video - 00:04:31 mins
Lecture 10: WORKDAY
Video - 00:01:30 mins
Module 7: Sorting, Filtering & Data Validation
Lecture 1: Introduction
Video - 00:00:38 mins
Lecture 2: Sort Data
Video - 00:01:52 mins
Lecture 3: Multi-Level Sorting
Video - 00:03:41 mins
Lecture 4: Filter Basics
Video - 00:01:51 mins
Lecture 5: Filter Views
Video - 00:02:49 mins
Lecture 6: Slicers
Video - 00:02:28 mins
Lecture 7: Data Validation
Video - 00:4:56 mins
Lecture 8: Drop-down Lists
Video - 00:02:01 mins
Lecture 9: Checkboxes
Video - 00:01:45 mins
Lecture 10: Remove Duplicates
Video - 00:03:11 mins
Module 8: Logical Functions
Lecture 1: Introduction
Video - 00:00:39 mins
Lecture 2: IF Function
Video - 00:02:13 mins
Lecture 3: Nested IF
Video - 00:05:21 mins
Lecture 4: IFS Function
Video - 00:03:06 mins
Lecture 5: AND
Video - 00:04:20 mins
Lecture 6: OR
Video - 00:02:01 mins
Lecture 7: NOT
Video - 00:01:48 mins
Lecture 8: IFERROR
Video - 00:02:52 mins
Lecture 9: IFNA
Video - 00:01:58 mins
Lecture 10: SWITCH
Video - 00:02:18 mins
Module 9: Lookup Functions
Lecture 1: Introduction
Video - 00:00:40 mins
Lecture 2: INDEX
Video - 00:01:35 mins
Lecture 3: MATCH
Video - 00:01:57 mins
Lecture 4: INDEX + MATCH
Video - 00:05:02 mins
Lecture 5: VLOOKUP
Video - 00:2:16 mins
Lecture 6: HLOOKUP
Video - 00:03:28 mins
Lecture 7: XLOOKUP
Video - 00:02:31 mins
Lecture 8: FILTER Function
Video - 00:02:28 mins
Lecture 9: UNIQUE
Video - 00:01:46 mins
Lecture 10: SORT Function
Video - 00:01:59 mins
Module 10: Charts & Data Visualization
Lecture 1: Introduction
Video - 00:00:45 mins
Lecture 2: Introduction to Charts
Video - 00:01:41 mins
Lecture 3: Column Charts
Video - 00:08:43 mins
Lecture 4: Bar Charts
Video - 00:03:56 mins
Lecture 5: Pie Charts
Video - 00:04:48 mins
Lecture 6: Line Charts
Video - 00:06:29 mins
Lecture 7: Area Charts
Video - 00:03:23 mins
Lecture 8: Combo Charts
Video - 00:02:20 mins
Lecture 9: Scatter Charts
Video - 00:02:28 mins
Lecture 10: Sparklines
Reading
Lecture 11: Chart Customization
Reading
Module 11: Pivot Tables
Lecture 1: Introduction
Video - 00:00:45 mins
Lecture 2: What is a Pivot Table?
Video - 00:2:18 mins
Lecture 3: Creating Pivot Tables
Video - 00:3:11 mins
Lecture 4: Rows & Columns
Video - 00:02:59 mins
Lecture 5: Values
Video - 00:05:08 mins
Lecture 6: Filters
Video - 00:02:57 mins
Lecture 7: Calculated Fields
Video - 00:02:35 mins
Lecture 8: Grouping Data
Video - 00:02:09 mins
Lecture 9: Date Analysis
Video - 00:02:33 mins
Lecture 10: Refreshing Pivot Tables
Video - 00:04:19 mins
Lecture 11: Business Reporting
Video - 00:10:03 mins
Module 12: Importing & Connecting Data
Lecture 1: Introduction
Video - 00:00:58 mins
Lecture 2: Introduction to This Module
Video - 00:1:28 mins
Lecture 3: Import Data
Reading
Lecture 4: Import CSV Files
Video - 00:02:30 mins
Lecture 5: IMPORTDATA
Video - 00:03:32 mins
Lecture 6: IMPORTHTML
Video - 00:03:01 mins
Lecture 7: IMPORTXML
Video - 00:05:55 mins
Lecture 8: IMPORTRANGE
Video - 00:04:03 mins
Lecture 9: GOOGLEFINANCE
Video - 00:05:14 mins
Lecture 10: IMAGE Function
Video - 00:02:23 mins
Module 13: Collaboration & Productivity
Lecture 1: Introduction
Video - 00:00:47 mins
Lecture 2: Sharing Sheets
Video - 00:02:39 mins
Lecture 3: Permission Levels
Video - 00:03:46 mins
Lecture 4: Comments
Video - 00:02:13 mins
Lecture 5: Named Ranges
Video - 00:04:03 mins
Lecture 6: Protected Ranges
Video - 00:02:35 mins
Lecture 7: Version History
Video - 00:02:11 mins
Lecture 8: Notifications
Video - 00:02:10 mins
Lecture 9: Smart Chips
Video - 00:02:31 mins
Lecture 10: Productivity Tips
Video - 00:07:53 mins
Module 14: Google Apps Script Basics
Lecture 1: Introduction
Video - 00:00:50 mins
Lecture 2: Introduction to Apps Script
Video - 00:01:45 mins
Lecture 3: Script Editor
Video - 00:03:25 mins
Lecture 4: Your First Script
Video - 00:02:08 mins
Lecture 5: Variables
Video - 00:12:32 mins
Lecture 6: Functions
Video - 00:08:07 mins
Lecture 7: Loops
Video - 00:07:28 mins
Lecture 8: Reading Sheet Data
Video - 00:25:43 mins
Lecture 9: Writing Sheet Data
Video - 00:13:18 mins
Lecture 10: Triggers
Video - 00:05:01 mins
Lecture 11: Automation Examples
Video - 00:34:36 mins
Module 15: AI & Productivity with Google Sheets
Lecture 1: Introduction
Reading
Lecture 2: AI in Google Sheets
Reading
Lecture 3: Gemini for Google Workspace
Reading
Lecture 4: Writing Better Formulas with AI
Reading
Lecture 5: Data Cleaning with AI
Reading
Lecture 6: AI for Summarization
Reading
Lecture 7: AI Prompting Tips
Reading
Lecture 8: AI Limitations
Reading
Lecture 9: Practical AI Workflows
Reading
Lecture 10: AI + Apps Script
Reading
Lecture 11: Future of Spreadsheet Automation
Reading
Announcements Live Classes Gradebook Certificate Course Info
PreviousNext

betterskill.io is an e-learning platform designed by industry experts to equip youth with essential skills. Our goal is to build a skilled workforce that can shape the future of Bangladesh.

Support

  • About us
  • Contact us
  • FAQs
  • Refund Policy

Importantant Links

  • All courses
  • Offer & Discount
  • Verify Certificate
  • Blogs

Follow us

Facebook X-twitter Youtube Linkedin

support@betterskill.io
Phone:+8801338540261
Address: 29/2 Lake Circus, Kalabagan, 1205, Dhaka

SSLCommerz-Pay-With-logo-All-Size-01

Copyright © 2026 betterskill.io

  • Privacy Policy
  • Terms and Regulation
  • 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 }