ChatGPT for Excel – Ai.Table

Microsoft Excel in Tamil (தமிழ்) - From Beginner to Pro ChatGPT for Excel - Ai.Table

Microsoft Excel in Tamil (தமிழ்) - From Beginner to Pro

0% Completed

Introduction to MS Excel in Tamil

About the Instructor - Instructor பற்றிய தகவல்

Video - 00:3:51 mins

Requirements and get MS 365 - அவசியமானவை மற்றும் MS 365 பெறுவதற்கான வழிகள்

Video - 00:10:25 mins

Create a new Excel File -புதிய Excel கோப்பை உருவாக்குவதற்கான வழிகள்

Video - 00:7:54 mins

Download Resource Folder

Reading

How to use Resources Folder - Resources Folder பயன்படுத்துவதற்கான வழிகள்

Video - 00:4:5 mins

Getting to Know Excel – Excel-ஐ அறிந்து கொள்ளுதல்

Introduction - அறிமுகம்

Video - 00:1:5 mins

Undersntaing Column - Row - Cell - புரிந்துகொள்ளுதல்

Video - 00:7:30 mins

Active Cells, Ranges, On Cell and in cell

Video - 00:4:40 mins

Basic Data Types - அடிப்படை தரவு வகைகள்

Video - 00:7:54 mins

Replacing Data in a Cell - ஒரு செல்லில் தரவை மாற்றுதல்

Video - 00:4:31 mins

Understanding Cells - Summary - செல்களை புரிந்துகொள்வது - சுருக்கம்

Video - 00:3:47 mins

Navigate between Cells - செல்கள் இடையே நகர்வு

Video - 00:7:20 mins

Navigation between cells - Practice - செல்கள் இடையே நகர்வு - பயிற்சி

Video - 00:1:59 mins

Data Selection - தரவு தேர்வு

Video - 00:10:2 mins

Data Selection using Goto - Goto Feature மூலம் தரவு தேர்வு

Video - 00:6:24 mins

Search Bar

Video - 00:2:47 mins

Understaning Name Box and Name Manager

Video - 00:7:39 mins

Formula Bar

Video - 00:4:8 mins

Tabs - Ribbon - Group - Slidebar - Zoom Slider

Video - 00:11:8 mins

Dealing with Cell Values & Data

Introduction - அறிமுகம்

Video - 00:01:9 mins

Understanding Copy, Cut and Drag - புரிந்துகொள்ளல்

Video - 00:14:32 mins

Copy, Cut and Drag a Range - ஒரு Range-ஐ Copy, Cut மற்றும் Drag செய்தல்

Video - 00:7:6 mins

Copy, Cut and Drag in Detailed - விரிவான விளக்கம்

Video - 00:9:39 mins

Fill Handle

Video - 00:10:32 mins

Insert and Delete Columns and Rows using Mouse - மவுஸ் பயன்படுத்தி

Video - 00:5:47 mins

Insert and Delete Columns and Rows using Menu - மெனுவைப் பயன்படுத்தி

Video - 00:8:19 mins

Insert and Delete Columns and Rows using Shortcuts - சோர்ட்கட் பயன்படுத்தி

Video - 00:5:57 mins

Insert and Delete Sheets - சீட்டுகளை செருகவும் மற்றும் அகற்றவும்

Video - 00:3:18 mins

Arranging the Data - தரவை ஒழுங்குபடுத்துதல்

Video - 00:4:50 mins

Hide and Unhide Columns and Rows - மறைப்பதும் மற்றும் மீண்டும் காட்டுவதும்

Video - 00:06:9 mins

Hide - Unhide - Rename - Copy - Color

Video - 00:6:15 mins

Hide and Unhide Columns and Rows Shortcut

Video - 00:1:21 mins

Fill - Right - Left - Up - Down

Video - 00:5:50 mins

Understand a Simple Formula - ஒரு எளிய சூத்திரத்தை புரிந்துகொள்வது

Video - 00:4:17 mins

Math and Statistical Functions

Introduction - அறிமுகம்

Video - 00:1:17 mins

Understanding Clipboard Group - புரிந்துகொள்ளுதல்

Video - 00:7:35 mins

Understanding Font Group - புரிந்துகொள்ளுதல்

Video - 00:7:14 mins

Calculation vs Formula vs Function

Video - 00:5:51 mins

Simple Formula Calculation and Basic Table

Video - 00:5:49 mins

Understanding Arithmatic Operators - கணித இயக்கிகள்

Video - 00:07:30 mins

Comparison Operators - ஒப்பீட்டு இயக்கிகள்

Video - 00:8:14 mins

Sum Function

Video - 00:10:48 mins

Min - Max - Average - Large - Small Functions

Video - 00:12:9 mins

Min and Max Functions Practic with Sparklines

Video - 00:10:20 mins

Understanding Number Formats - எண்களின் வடிவமைப்பு

Video - 00:14:58 mins

Number Formatting - Practice - பயிற்சி

Video - 00:5:42 mins

Round Function

Video - 00:7:38 mins

Roundup - Rounddown - Int - Abs Functions

Video - 00:10:17 mins

Round Function vs Decimal Adjustment

Basic Filter and Subtotal Function

Video - 00:11:44 mins

Intorduction to Conditional Formatting

Video - 00:6:26 mins

Filter in Detail

Video - 00:11:56 mins

Filter Function

Video - 00:8:6 mins

Uderstanding the Slicer and Introduction to Table

Video - 00:10:26 mins

Quotient and MOD Functions

Video - 00:4:37 mins

Introduction to Absolute Cell Reference

Video - 00:9:35 mins

Rank.EQ and Rank.AVG Functions

Video - 00:6:54 mins

Abs Function in Detail

Video - 00:4:21 mins

Text Functions

Introduction - அறிமுகம்

Video - 00:1:59 mins

Right Function

Video - 00:8:59 mins

Right Function Example 2

Video - 00:2:40 mins

Left Function

Video - 00:04:54 mins

Mid Function

Video - 00:09:27 mins

Len Function

Video - 00:1:55 mins

Combine Len + Left and Right Functions

Video - 00:9:48 mins

Text to Column in Detail

Video - 00:08:57 mins

Auto Fill and Custom List

Video - 00:07:43 mins

Flash Fill in Detail

Video - 00:06:31 mins

Joining Text using '&' in Excel

Video - 00:3:54 mins

Concat and TextJoin Functions

Video - 00:06:48 mins

Case Functions

Video - 00:02:32 mins

Search and Find Functions

Video - 00:4:31 mins

Substitute Function

Video - 00:02:42 mins

Replace Function

Video - 00:04:18 mins

Rept Function

Video - 00:05:50 mins

Text Function

Video - 00:08:2 mins

Date and Time Functions

Introduction - அறிமுகம்

Video - 00:1:33 mins

Common ways to Record Date in Excel - திகதி பதியும் முறைகள்

Video - 00:05:37 mins

How Excel treats a Date - Excel எப்படி திகதியைக் கையாள்கிறது

Video - 00:06:21 mins

Calculate Days between dates - திகதிகளுக்கு இடையிலான நாட்கள்

Video - 00:07:12 mins

Understanding How Excel treats Time - Excel எப்படி நேரத்தை கையாள்கின்றது

Video - 00:06:12 mins

Different Ways to format Time - நேரத்தை வடிவமைத்தல்

Video - 00:05:30 mins

Different Ways to format Date - திகதியை வடிவமைத்தல்

Video - 00:06:13 mins

Show Current Date and Time using Function - தற்போதைய திகதி மற்றும் நேரம்

Video - 00:02:59 mins

Create Date and Time - திகதி மற்றும் நேரத்தை உருவாக்குதல்

Video - 00:03:22 mins

Split Date and Time - திகதி மற்றும் நேரத்தை பிரித்தல்

Video - 00:6:21 mins

DatedIf Function

Video - 00:10:12 mins

Video - 00:02:54 mins

Workday Function

Video - 00:02:47 mins

Weeknum Function

Video - 00:03:14 mins

Financial and Other Functions

Introduction - அறிமுகம்

Video - 00:01:9 mins

Loan Amortization - PPMT, IPMT and PMT Functions

Video - 00:11:3 mins

PV Function

Video - 00:04:54 mins

Video - 00:04:44 mins

Rate Function

Video - 00:2:58 mins

Information Functions

Video - 00:11:11 mins

Sortby Function

Video - 00:4:1 mins

Sequence Function

Video - 00:10:46 mins

Random Numbers using RAND Function

Video - 00:6:14 mins

Random Numbers using RANDBETWEEN Function

Video - 00:9:18 mins

Random Text Choice from RANDBETWEEN Fnction

Video - 00:5:43 mins

Random Array of Numbers using RANDARRAY Function

Video - 00:03:37 mins

Logical Functions

Introduction - அறிமுகம்

Video - 00:01:12 mins

Simple If Function

Video - 00:08:53 mins

Absolute vs Relative Cell Reference

Video - 00:09:15 mins

Absolut Cell Reference - Detailed

Video - 00:10:20 mins

If Function in Detail

Video - 00:7:38 mins

Ifs Function Commission Calculation

Video - 00:06:50 mins

Ifs Function in Detail

Video - 00:08:13 mins

AND and OR Functions

Video - 00:06:55 mins

AND and OR with IF Function

Video - 00:09:2 mins

Sumif, Sumifs, Averageif and Averageifs

Video - 00:12:8 mins

Count, Counta and CountBlank Functions

Video - 00:04:10 mins

Countif and Countifs Functions

Video - 00:06:30 mins

IfError Function

Video - 00:03:13 mins

Not Function

Video - 00:07:18 mins

Lookup Functions

Introduction - அறிமுகம்

Video - 00:01:28 mins

Simple VLOOKUP Function

Video - 00:06:22 mins

VLOOKUP Function - Mutiple Results

Video - 00:04:21 mins

VLOOKUP Function - Data from Another Sheet

Video - 00:05:34 mins

VLOOKUP Exercise

Video - 00:06:37 mins

Understanding XLOOKUP Function

Video - 00:06:41 mins

XLOOKUP Function - Multiple Results

Video - 00:03:9 mins

XLOOKUP Function - Data from Another Sheet

Video - 00:04:46 mins

Xlookup Exercise

Video - 00:04:48 mins

V-Lookup vs X-Lookup

Video - 00:06:42 mins

Index and Match Functions

Video - 00:07:25 mins

Offset Function in Detail

Video - 00:18:1 mins

Offset Function Exercise

Video - 00:03:5 mins

Transpose Function vs Transpose Paste

Video - 00:04:00 mins

Column vs Columns Functions

Video - 00:07:21 mins

Row vs Rows Functions

Video - 00:06:3 mins

Address Function

Video - 00:11:13 mins

Indirect Function

Video - 00:8:19 mins

Indirect Function - Practical Example

Video - 00:06:33 mins

Hyperlink

Video - 00:08:53 mins

Other Features and Areas

Introduction - அறிமுகம்

Video - 00:1:36 mins

Conditional Formatting Part 1

Video - 00:8:41 mins

Conditional Formatting Part 2

Video - 00:10:27 mins

Conditional Formatting - Automatic Bordering

Video - 00:8:48 mins

How to Create a Chart - Chart உருவாக்குவது எப்படி?

Video - 00:6:53 mins

Column Chart in Detail

Video - 00:14:16 mins

Pivot Table from Range vs Table

Video - 00:5:38 mins

Pivot Table Dashboard Part 1

Video - 00:9:36 mins

Pivot Table Dashboard Part 2

Video - 00:16:00 mins

Pivot Table Dashboard Part 3

Video - 00:17:13 mins

Get Data from Different Sources

Video - 00:6:52 mins

Remove Duplicates

Video - 00:6:15 mins

Data Validation in Detail

Video - 00:14:25 mins

Data Validation Settings

Video - 00:3:39 mins

Data Validation - Simple Dropdown

Video - 00:4:34 mins

Data Validation - Dependant Dropdown

Video - 00:11:35 mins

Consolidate Data Feature

Video - 00:8:4 mins

Goal Seek in Detail

Video - 00:14:21 mins

Data Table - Retirement Fund Calculation

Video - 00:9:28 mins

Data Table - Profit Calculation

Video - 00:4:53 mins

Grouping and UnGrouping

Newer Functions

Introduction - அறிமுகம்

Video - 00:2:22 mins

Understanding Image Function

Video - 00:9:58 mins

Image Function - Lookup image

Video - 00:3:19 mins

LET Function

Video - 00:13:52 mins

TextSplit Function

Video - 00:6:57 mins

Textbefore and TextAfter Functions

Video - 00:12:37 mins

ArrayToText Function

Video - 00:9:17 mins

Understaning RegExTest, RegExExtract and RegExReplace

Video - 00:12:13 mins

RegExExtract - Extract Email Addresses

Video - 00:6:32 mins

RegExExtract - Extract Dates

Video - 00:6:7 mins

RegExExtract - Extract Multiple Dates

Video - 00:4:27 mins

Choosecols and ChooseRows Functions

Video - 00:11:43 mins

Understanding Take Function

Video - 00:4:10 mins

Take Function Advance Usage

Video - 00:9:54 mins

Drop Function

Video - 00:6:48 mins

Understanding VStack Function

Video - 00:2:44 mins

VStak Function in Detail

Video - 00:13:33 mins

Understanding Lambda Function - Growthrate

Video - 00:11:33 mins

Advanced Example - Lambda Function

Video - 00:7:5 mins

Lambda Function - Filter Formula to Function

Video - 00:13:15 mins

Map Function

Video - 00:6:33 mins

Scan Function

Video - 00:12:13 mins

Bycol Function

Video - 00:10:59 mins

ByRow Function

Video - 00:4:7 mins

Ai Developments within Excel

Introduction - அறிமுகம்

Video - 00:2:29 mins

Ai in Excel - Flash Fill

Video - 00:3:12 mins

Ai in Excel - Forecast Sheet

Video - 00:6:51 mins

Ai in Excel - Recommended Pivot

Video - 00:3:1 mins

Ai in Excel - Recommended Charts

Video - 00:2:25 mins

Ai in Excel - Analyze Data

Video - 00:8:2 mins

Ai in Excel - Get Data from Image

Video - 00:7:17 mins

Get Excel Related Help from LLMs

Help from AI - Simple Functions

Video - 00:9:44 mins

Help from AI - Error Handling

Video - 00:3:38 mins

Help from AI - Step-by-Step Guide

Video - 00:3:36 mins

Help from AI - Look for Formulas

Video - 00:3:29 mins

Help from AI - Search for Shortcuts

Video - 00:4:22 mins

Help from AI - Seek a Complex Formula

Video - 00:5:3 mins

AI and Excel – ChatGPT for Excel Addin

Introduction to ChatGPT for Excel Addin

Video - 00:6:00 mins

ChatGPT for Excel - Ai.Ask

Video - 00:8:2 mins

ChatGPT for Excel - Ai.List

Video - 00:3:3 mins

ChatGPT for Excel - Ai.Table

Video - 00:2:57 mins

ChatGPT for Excel - Ai.Fill

Video - 00:2:18 mins

ChatGPT for Excel - Ai.Translate

Video - 00:2:45 mins

ChatGPT for Excel - Ai.Extract

Video - 00:2:24 mins

ChatGPT for Excel - Ai.Choice

Video - 00:3:16 mins

Magical Ai Spreadsheet – TheBricks

TheBricks - A Magical Ai Spreadsheet

Video - 00:29:7 mins

Exercise – Commission Calculation

Commission Calculation Exercise Overview

Video - 00:3:5 mins

Commission Calculation Simple Exercise

Video - 00:4:52 mins

Commission Calculation Advanced Exercise

Video - 00:10:8 mins

Final Exercise

Final Exercise Overview

Video - 00:3:14 mins

Final Exercise Solution

Video - 00:24:30 mins

Announcements Reviews Live Classes Gradebook Certificate Course Info

Previous Next

Complete the course to unlock the certificate

Microsoft Excel in Tamil (தமிழ்) - From Beginner to Pro ChatGPT for Excel - Ai.Table

Microsoft Excel in Tamil (தமிழ்) - From Beginner to Pro