Pinoy Easy TECHNOLOGY
Pinoy Easy TECHNOLOGY
  • 31
  • 747 492
SPLIT DATA IN EXCEL
May mga sitwasyong kailangan mong hatiin ang mga data sa Excel. Maaaring ito ay kapag nakuha mo ang data mula sa isang database o kinopya mo ito mula sa internet o nakuha ito mula sa isang katrabaho o kaklase.
Ang isang simpleng halimbawa kung saan kailangan mong hatiin ang mga data sa Excel ay kapag mayroon kang mga buong pangalan at gusto mong hatiin ang mga ito sa unang pangalan at apelyido.
o kung nakakuha ka ng mga address at gusto mong hatiin ang address para masuri mo nang hiwalay ang mga barangay, lungsod, probinsya o ang pin code.
มุมมอง: 1 227

วีดีโอ

PAANO GUMAWA NG DROP-DOWN LIST SA EXCEL (EASY STEPS)
มุมมอง 6K2 ปีที่แล้ว
Ang isang drop-down list ay isang maliit na window kung saan maaari kang tumingin sa iba pang data na iyong ginawa. This also gives you the possibility of controlling exactly what can be entered into a cell. Ginagawa nito na maging isang common and powerful data validation tool ang drop-down menu. Luckily, ang paggawa ng drop-down list ay napakadali kung alam mo ang mga eksaktong hakbang sa pag...
Speak Cells Voice and Speed | Paano mo I-Adjust ang Settings
มุมมอง 6K2 ปีที่แล้ว
In the Windows Control Panel, you can change the voice. Look up Speech Recognition, go to Advanced speech options and select Text to Speech Tab. There is a Voice Selection and Voice Speed option. To have the voice read your cells faster, move the slider halfway between Normal and Fast. You can also watch the video on how to set Speak Cells in your Excel's Quick Access Toolbar. Just click the li...
Excel Speak Cells Nakaka-Amazed Gamitin
มุมมอง 4.2K2 ปีที่แล้ว
Minsan, maaaring kailanganin mong isulat ang data ng isang worksheet sa isang papel, at maaaring kailanganin mong itaas ang iyong ulo pagkatapos ay ibababa nang maraming beses na maaaring magpahirap sa iyo. Ngunit kung mayroong isang boses upang sabihin ang mga nilalaman ng cell para sa iyo, maaaring ito ay napakaganda. Dito ko sasabihin sa iyo kung paano hayaan ang Excel na magsalita ng mga ce...
Creating Quiz with Multiple Answer in Excel
มุมมอง 9K2 ปีที่แล้ว
This time, I will show how to create a quiz that has 2 answers to a question. Please bear with me for the low quality of the audio. Thank you Watch also the tutorials below: Simple Quiz Part 1: th-cam.com/video/iW8H-gCHZM0/w-d-xo.html Simple Quiz Part 2: th-cam.com/video/CK8XxwxeaHI/w-d-xo.html
PAANO HANAPIN ANG DUPLICATE VALUES SA EXCEL
มุมมอง 7K3 ปีที่แล้ว
Madali lang nating ma-identify ang duplicates gamit ang Conditional Formatting Tool sa Excel. We can select the range and highlight the duplicate values with color. Para mas matutunan ito, panoorin ang basic tutorial kung paano hanapin ang duplicate values in Excel.
FREEZE PANES IN EXCEL | STEP BY STEP TUTORIAL
มุมมอง 4.7K3 ปีที่แล้ว
Ang isang maliit na feature ng Excel na ginagawang mas madaling i-manage ang data ay ang ability nitong mag-freeze o mag-lock ng mga row at column. Tingnan natin kung paano ito gumagana. Timecodes 00:00 - Intro 01:08 - Freeze row 02:08 - Freeze column 02:52 - Freeze Top Row or First Column 03:40 - Freeze Row & column 04:38 - Unfreeze Panes
Paano gumawa ng Table sa MS Excel | Filipino
มุมมอง 34K3 ปีที่แล้ว
Matotong gumawa ng Tables sa Excel. Sa pamamagitan nito, maayos at madali mong mapag-aaralan ang mga data na nakapaloob dito. Malalaman mo kung paano mag-insert, i-sort at i-filter ang mga data sa table. Timecodes 00:00 - Intro 01:00 - Insert a Table 02:41 - Sort the data 03:49 - Filter data 05:16 - Total Row 06:49 - Explore the Table Style Options group 07:51 - Designing a Table Kung gusto mo ...
Flash Fill Option sa Excel | Filipino Excel Tutorial
มุมมอง 8K3 ปีที่แล้ว
Gumamit ng flash fill ng Excel 2013 o ng mas latest para automatically na ma-extract or automatic na macombine ang data. Gumagana lamang ang Flash Fill in Excel kapag narecognize nito ang isang pattern. TIMESTAMP 00:00 Introduction 00:48 Extract data automatically 02:41 Combining 2 or more data automatically 04:23 Create new format 05:26 Limitation of Flash Fill: Can't extract decimal numbers c...
Paste Special Transpose| Filipino Excel Tutorial
มุมมอง 3.8K3 ปีที่แล้ว
Sa video tutorial na ito, matututunan natin kung paano makopya ang vertical data at i-paste ang mga ito nang pahalang o horizontal sa Microsoft Excel. While working with data in excel, Minsan mayroong pagkakataong kailangang baguhin ang Vertical data sa Pahalang o Horizontal para sa mas madaling pagsusuri o pagpresent. Ang tool na gagamitin natin ay ang Transpose option sa Paste Special command...
Find and Select Feature | Filipino Excel Tutorial
มุมมอง 2.6K3 ปีที่แล้ว
Find and Select in Excel is a very useful tool to find data as required. Along with FIND, the Replace function in excel is also quite handy which helps to find specific text and replace it with other text(s).
Paano I turn off ang Gridlines
มุมมอง 3.4K3 ปีที่แล้ว
By default, gridlines are displayed in worksheets, but you can hide the gridlines. Turning-off of gridlines in Excel is a common task and most of the Excel users should know about it. It makes your spreadsheet clean and presentable. Although grid lines in excel have their own benefits but in some cases it is better to hide them.
Excel Tutorial (Filipino) | How to Fix Date Format Problem from (dd/mm/yyyy) to (mm/dd/yyyy)
มุมมอง 31K4 ปีที่แล้ว
Sa tutorial na ito mayroon akong example ng date of birth at sa katabi nitong column ay ang age. Sa column na ng age ay may nilagay akong formula to calculate the age. At alam kong ito ay tama. Kaso ang problema ay hindi nito naibigay ang result. Instead ay error in value ang lumabas. Isa ito sa mga problema ng mga excel users lalo na kung may formula silang ginagamit. Ngayon ay ituturo ko kung...
MS EXCEL | Ilang Tips & Tricks na malamang ay 'di mo pa alam
มุมมอง 18K4 ปีที่แล้ว
Hello po sa inyong lahat. In this video, aalamin natin ang ilang tips and tricks in excel na pwedeng hindi mo pa alam. pero kung alam mo na, this will also serve as review para marefresh ang lahat ng natutunan mo about using microsoft excel. Ito ay Part I pa lang ng Tips & Tricks on using Excel. antabayanan pa natin ang second part at sana ay magustuhan ninyo.
Types of cell references in FILIPINO Language
มุมมอง 3K4 ปีที่แล้ว
Excel is divided into a grid containing columns and rows. These rows and columns intersect to form cells. Each cell in Excel has an address, for example A1 refers to a cell located in column A and row 1. Cell references are essential for formulas. You use the cell reference to instruct Excel of where the value(s) to include in a formula are located, for example, =A1-B1 tells Excel to take the v...
Ang cell reference | Dapat munang alamin
มุมมอง 3K4 ปีที่แล้ว
Ang cell reference | Dapat munang alamin
Ano ang Print Area at Paano ito i set?
มุมมอง 83K4 ปีที่แล้ว
Ano ang Print Area at Paano ito i set?
HOW TO CREATE SIMPLE QUIZ IN EXCEL - ADDING SCORE COUNTER Part 2
มุมมอง 11K4 ปีที่แล้ว
HOW TO CREATE SIMPLE QUIZ IN EXCEL - ADDING SCORE COUNTER Part 2
Excel Tutorial | FILIPINO - HOW TO CREATE SIMPLE QUIZ IN EXCEL WITH AUTOMATIC CHECKER Part 1
มุมมอง 22K4 ปีที่แล้ว
Excel Tutorial | FILIPINO - HOW TO CREATE SIMPLE QUIZ IN EXCEL WITH AUTOMATIC CHECKER Part 1
EXCEL TUTORIAL FILIPINO | Paano I-combine ang First Name at Last Name sa Excel
มุมมอง 15K5 ปีที่แล้ว
EXCEL TUTORIAL FILIPINO | Paano I-combine ang First Name at Last Name sa Excel
EXCEL TUTORIAL FILIPINO | Currency and Accounting Formats
มุมมอง 5K5 ปีที่แล้ว
EXCEL TUTORIAL FILIPINO | Currency and Accounting Formats
EXCEL TUTORIAL FILIPINO Paano gamitin ang cell alignment sa Excel
มุมมอง 9K5 ปีที่แล้ว
EXCEL TUTORIAL FILIPINO Paano gamitin ang cell alignment sa Excel
EXCEL TUTORIAL FILIPINO | Applying Built-In Formats sa Excel
มุมมอง 1.5K5 ปีที่แล้ว
EXCEL TUTORIAL FILIPINO | Applying Built-In Formats sa Excel
EXCEL TUTORIAL FILIPINO | Basic formatting sa Excel
มุมมอง 9K5 ปีที่แล้ว
EXCEL TUTORIAL FILIPINO | Basic formatting sa Excel
Paano gamitin ang Excel | (Filipino) Wrap Text and Alt+Enter Key
มุมมอง 8K5 ปีที่แล้ว
Paano gamitin ang Excel | (Filipino) Wrap Text and Alt Enter Key
EXCEL TUTORIAL | (FILIPINO) Working with Rows Columns & Cells part 2
มุมมอง 25K5 ปีที่แล้ว
EXCEL TUTORIAL | (FILIPINO) Working with Rows Columns & Cells part 2
EXCEL TUTORIAL | (FILIPINO) Working with Rows Columns & Cells Part 1
มุมมอง 73K5 ปีที่แล้ว
EXCEL TUTORIAL | (FILIPINO) Working with Rows Columns & Cells Part 1
EXCEL TUTORIAL | (FILIPINO) Ang Worksheet Options
มุมมอง 14K5 ปีที่แล้ว
EXCEL TUTORIAL | (FILIPINO) Ang Worksheet Options
EXCEL TUTORIAL | (FILIPINO) Paano i customize ng Quick Access Toolbar
มุมมอง 3.5K5 ปีที่แล้ว
EXCEL TUTORIAL | (FILIPINO) Paano i customize ng Quick Access Toolbar
Excel Tutorial | (Filipino) Ang Backstage View ng Excel
มุมมอง 1.9K5 ปีที่แล้ว
Excel Tutorial | (Filipino) Ang Backstage View ng Excel

ความคิดเห็น

  • @rosallyrobles8270
    @rosallyrobles8270 หลายเดือนก่อน

    Dali matutunan

  • @rosallyrobles8270
    @rosallyrobles8270 หลายเดือนก่อน

    Dali matutunan

  • @LSBVlog01
    @LSBVlog01 3 หลายเดือนก่อน

    Kelangan ko po yan dahil officer na po ko hehe. Thank you.

  • @dumengbukid4700
    @dumengbukid4700 5 หลายเดือนก่อน

    Thank u❤❤❤

  • @dumengbukid4700
    @dumengbukid4700 5 หลายเดือนก่อน

    Thanks po❤

  • @dumengbukid4700
    @dumengbukid4700 5 หลายเดือนก่อน

    Thank u❤❤

  • @dumengbukid4700
    @dumengbukid4700 5 หลายเดือนก่อน

    Thank u❤

  • @dumengbukid4700
    @dumengbukid4700 5 หลายเดือนก่อน

    THANK U❤

  • @dumengbukid4700
    @dumengbukid4700 5 หลายเดือนก่อน

    THANK U❤

  • @dumengbukid4700
    @dumengbukid4700 5 หลายเดือนก่อน

    Thank u❤

  • @dumengbukid4700
    @dumengbukid4700 5 หลายเดือนก่อน

    Thank u❤

  • @dumengbukid4700
    @dumengbukid4700 5 หลายเดือนก่อน

    Thank you❤

  • @jeandaryllcutin7534
    @jeandaryllcutin7534 5 หลายเดือนก่อน

    Sakin po speak cells lang walang speak cells on enter.

  • @bernarddelapena6312
    @bernarddelapena6312 5 หลายเดือนก่อน

    thanknyou

  • @BennyBetonio-zb1oq
    @BennyBetonio-zb1oq 5 หลายเดือนก่อน

    ❤❤

  • @glendaaurorabriones7587
    @glendaaurorabriones7587 5 หลายเดือนก่อน

    Very helpful, this has been my problem for a long time, thank you so much

  • @tworistasmag-asawanggala4620
    @tworistasmag-asawanggala4620 5 หลายเดือนก่อน

    Paano po kung may middle initial

  • @simplygigi40
    @simplygigi40 6 หลายเดือนก่อน

    hi sir new subscriber po thanks for sharing im watching all ur excel video need kopo kasing matoo dahil sa new work ko po god bless po

  • @junejancinal1818
    @junejancinal1818 6 หลายเดือนก่อน

    thank you boss for sharing! i've been searching for this setting. again, thanks so much

  • @michaeljoshrizarde2960
    @michaeljoshrizarde2960 7 หลายเดือนก่อน

    awsome! 🤪

  • @darrstv
    @darrstv 7 หลายเดือนก่อน

    Subscribe kita sir kasi well discuss talaga now i know po kasi im apply for administrative support staff

  • @chiragshelat5444
    @chiragshelat5444 7 หลายเดือนก่อน

    either music or speak

  • @amereqofficial9562
    @amereqofficial9562 8 หลายเดือนก่อน

    Thank you!

  • @theodoreinihao2802
    @theodoreinihao2802 8 หลายเดือนก่อน

    Thank you Very Much sir napa ka Helpful nang tutorial nato.

  • @amanodinsumpingan1191
    @amanodinsumpingan1191 8 หลายเดือนก่อน

    HUHU PAANO PO KAYA YON DI MAKITA ANG IBANG CELL OR PAGE SA PDS OR PERSONAL DATA SHEET

  • @yhaanmadera387
    @yhaanmadera387 11 หลายเดือนก่อน

    Thank you!

  • @TreshaMaeTorino
    @TreshaMaeTorino ปีที่แล้ว

    Hi po, saan po ang part 3? Thank you.

  • @sadmood4384
    @sadmood4384 ปีที่แล้ว

    Thanks po sa idea sobrang laking tulong po for my works. i used excel daily at my work.

  • @quasx991ltd
    @quasx991ltd ปีที่แล้ว

    Hi sir, Ganda ng content mo sir... Ang simple lang sundin, Nakakatulong talaga😊. Ask ko lang po: 1) pano e format pagkatapos ng quiz. 2) paano gamitin ang validation kung identification yung test. Sana mapansin. Thank you.

  • @Hlunkang
    @Hlunkang ปีที่แล้ว

    😂😂😂😂😂😂😂😂😂😂B and not B & D...nuuuuubb please don't make another

  • @charizmiranda2020
    @charizmiranda2020 ปีที่แล้ว

    Pano po iprint out nahirapan ako

  • @akopositincristinegracehue4350
    @akopositincristinegracehue4350 ปีที่แล้ว

    Sir pag wla pong mouse same lang din po ung pag insert ng rows ? Minsan po kse sa loptop nakalimutan ko na wla po kseng mouse

  • @ma.celestelip34
    @ma.celestelip34 ปีที่แล้ว

    not working

  • @mheltan9778
    @mheltan9778 ปีที่แล้ว

    Thank you so much Very much useful lalo n sa tulad kng guro🥰 God bless po😇😇

  • @bambooposadas5744
    @bambooposadas5744 ปีที่แล้ว

    Sir paano gawin lumilipat yun mga choices?

  • @laurenceperlas3575
    @laurenceperlas3575 ปีที่แล้ว

    Salamat po sa help sir😊

  • @dasdaspree1847
    @dasdaspree1847 ปีที่แล้ว

    hello paano if gusto ko random questions?

  • @lipacity77
    @lipacity77 ปีที่แล้ว

    Paano gumawa ng scrolling text sa excel…thank you

  • @lorenamagpayo6742
    @lorenamagpayo6742 ปีที่แล้ว

    ano pinagkaiba nya sa WPS

    • @pinoyeasytechnology191
      @pinoyeasytechnology191 ปีที่แล้ว

      Hi, parepareho po silang spreadsheet apps. Ang pagkakaiba lang po nila ay ang gumawa ng mga ito gaya sa excel ng microsoft, google sheet ng google, at marami pa. Depende rin po yan sa kung alin sa mga ito ang comfortable kang gamitin.

  • @adriandelosreyes5657
    @adriandelosreyes5657 ปีที่แล้ว

    Pano po mag lagay ng records?

  • @ahronleesancho2716
    @ahronleesancho2716 ปีที่แล้ว

    Salamat!!!

  • @ceeemm8438
    @ceeemm8438 ปีที่แล้ว

    More tutorials pls trim, vlookup etc .thank you

  • @edwinpros3159
    @edwinpros3159 ปีที่แล้ว

    Thank you sir

  • @genevievecentino7229
    @genevievecentino7229 ปีที่แล้ว

    New subscriber po..I really need this tutorial because I want to look a job already for my kids..gsto ko ma enhance s c computer

  • @jeanfont996
    @jeanfont996 ปีที่แล้ว

    Hi paano po kaya I-transpose naman ex. nasa Column A lahat. Then mapapaste in each column.

  • @simplengmagsasaka
    @simplengmagsasaka ปีที่แล้ว

    Pwede ba ituro mo paano gamitin sa analysis ang excel sa tagalog. 🤣

  • @loriealipio1228
    @loriealipio1228 ปีที่แล้ว

    Db po makikita natin na my hangganan po ung printing area . Pano po kng 1 buong long paper iprint

  • @loriealipio1228
    @loriealipio1228 ปีที่แล้ว

    Paano po kung buong papel ang pagpripintan po

  • @elmo2831
    @elmo2831 ปีที่แล้ว

    Just started my job yesterday. My boss asked me if I know how to use excel. I said yes. And here I am, trying to salvage myself. Haha

  • @gephoepo9371
    @gephoepo9371 ปีที่แล้ว

    Thank you very much po 😊😊