Smart Office
Smart Office
  • Видео 178
  • Просмотров 2 134 597
How to Use Spell Number in Excel
In this tutorial, You will learn how to use the Spell Number function in Excel.
Download the VBA code required to create this function from the link below.
learnexcelandsheets.com/how-to-use-spell-number-in-excel/
Просмотров: 12

Видео

Remove Extra Space Between Words in Word
Просмотров 449 часов назад
Learn how to remove extra spaces between words in Microsoft Word with this amazing technique.
How to Add Picture in Power Point
Просмотров 3216 часов назад
In this tutorial, you will learn how to add picture in Power Point. We will discuss about total 5 methods of adding picture. You can choose any method that you prefer most.
VLOOKUP and MATCH Function Together | Automate Column Index Numbering in VLOOKUP
Просмотров 13321 день назад
Learn how we can combine the MATCH function within VLOOKUP to make the column index number automatic. This saves lot of time in finding the values from one data source to another. Formula in one single cell can be filled across any number of row and columns. Download the sample data file to practice this function from the link given below. Workbook Number:
Complete Guide to VLOOKUP Exact Match Function
Просмотров 126Месяц назад
Unlock the full potential of Excel with our step-by-step guide on using the VLOOKUP function for exact matches! In this tutorial, you'll learn how to efficiently search for and retrieve specific data from your spreadsheets, making your workflow more efficient and accurate. Whether you're a beginner or looking to refine your Excel skills, this video covers everything you need to know about VLOOK...
A Complete Guide on MATCH Function of Excel
Просмотров 124Месяц назад
In this tutorial you will learn how to use the MATCH function in Microsoft Excel. MATCH function is used for finding the row number or column number of an item in an array based on exact, less than and greater than match.
RANKX Function Tutorial in Power BI
Просмотров 130Месяц назад
Learn how to use the RANKX function in Power BI. RANKX function is used for finding the rank of items based on their values. Download the practice workbook file from below link. 1drv.ms/u/s!AohAxi9JX1lu2ydAlo-FgbR4Ioa6?e=ZpnGAQ
Best Software for Editing Video for YouTube | Microsoft Clipchamp Video Editor
Просмотров 1282 месяца назад
Learn how to edit videos for RUclips by using Microsoft Clipchamp Video editor. This video editor is 100% free, lightweight and easy to use video editing software. How to edit video for RUclips | Free Video editing Software | Best software for video editing | Microsoft Clipchamp tutorial
How to Make Video of Power Point Presentation
Просмотров 642 месяца назад
In this video you will learn how to make a video file from Microsoft Power Point Presentation. ppt to video | export power point presentation to video file | how to make video from a ppt document
How to Edit PDF Document with MS Word
Просмотров 2273 месяца назад
How to Edit PDF Document with MS Word
How to Use Microsoft Office 365 for FREE
Просмотров 2723 месяца назад
How to Use Microsoft Office 365 for FREE
Solve GIF Image Not Playing in WordPress Post
Просмотров 924 месяца назад
Solve GIF Image Not Playing in WordPress Post
Find Out Forgotten Wi-Fi Password Connected in Computer🔥
Просмотров 2654 месяца назад
Find Out Forgotten Wi-Fi Password Connected in Computer🔥
Power BI Line Chart for Monthly Sales in Jan to Dec Order
Просмотров 2594 месяца назад
Power BI Line Chart for Monthly Sales in Jan to Dec Order
XLOOKUP in Google Sheets👍(3 Practical Examples🔥)
Просмотров 2414 месяца назад
XLOOKUP in Google Sheets👍(3 Practical Examples🔥)
Fill Handle Drag and Drop Not Working in Excel | Follow These Steps
Просмотров 1324 месяца назад
Fill Handle Drag and Drop Not Working in Excel | Follow These Steps
What is Fill Handle in Excel (Tutorial for Beginners)
Просмотров 1354 месяца назад
What is Fill Handle in Excel (Tutorial for Beginners)
Calculate and Visualize Running Total in Power BI using Measure
Просмотров 7837 месяцев назад
Calculate and Visualize Running Total in Power BI using Measure
How to Add Background Image in Excel
Просмотров 3,3 тыс.7 месяцев назад
How to Add Background Image in Excel
Calculate Running Total in Power BI using DAX function
Просмотров 6467 месяцев назад
Calculate Running Total in Power BI using DAX function
How to Calculate % of Total in Excel
Просмотров 4427 месяцев назад
How to Calculate % of Total in Excel
DAX in Power BI (Tutorial for Beginners)
Просмотров 9797 месяцев назад
DAX in Power BI (Tutorial for Beginners)
Power BI Tutorial for Beginners
Просмотров 7288 месяцев назад
Power BI Tutorial for Beginners
AVERAGE + Take Function in Excel | Automate Last N Months Average Calculation
Просмотров 6108 месяцев назад
AVERAGE Take Function in Excel | Automate Last N Months Average Calculation
How to Add Background Image in Word
Просмотров 3688 месяцев назад
How to Add Background Image in Word
How to Auto Highlight Duplicate Values in Google Sheets
Просмотров 2,1 тыс.8 месяцев назад
How to Auto Highlight Duplicate Values in Google Sheets
How to Calculate % Increase or Decrease in Excel
Просмотров 2 тыс.8 месяцев назад
How to Calculate % Increase or Decrease in Excel
Aggregate Function in Excel
Просмотров 9368 месяцев назад
Aggregate Function in Excel
How to Remove Grand Totals From Pivot Table Report
Просмотров 2,4 тыс.9 месяцев назад
How to Remove Grand Totals From Pivot Table Report
Convert Number to Spelling in MS Word with One Click Button
Просмотров 6 тыс.9 месяцев назад
Convert Number to Spelling in MS Word with One Click Button

Комментарии

  • @nitish_kumar_nk
    @nitish_kumar_nk 14 часов назад

    सर लैपटॉप के लिए फ्री WPS Office नही है क्या एक डाउनलोड किया हूं उसमें Premium Membership वाले ही सिर्फ एडिट कर सकते हैं। 😢 अगर कोई फ्री वाला है जिससे हम कोई भी पीडीएफ एडिट कर सके plz बताइएगा।

  • @nitish_kumar_nk
    @nitish_kumar_nk 14 часов назад

    सर लैपटॉप के लिए फ्री WPS Office नही है क्या एक डाउनलोड किया हूं उसमें Premium Membership वाले ही सिर्फ एडिट कर सकते हैं। 😢 अगर कोई फ्री वाला है जिससे हम कोई भी पीडीएफ एडिट कर सके plz बताइएगा।

  • @spcsoftsolutions103
    @spcsoftsolutions103 День назад

    Nice video! If you can show how to install and use a Google add-on, such as Comfort Attendance, which creates a user friendly and easy to use web app for updating the check-boxes will be much useful.

  • @sattaking929
    @sattaking929 3 дня назад

    Love you

  • @FunTeenDev
    @FunTeenDev 4 дня назад

    It's not working idiot!

  • @katrinachong6188
    @katrinachong6188 7 дней назад

    Thank you! Big help.

  • @SiskaweshKsutaraden
    @SiskaweshKsutaraden 9 дней назад

    On the upper part of the left side... Why doesn't things doesn't appear to me, scuh as: My Computer, Devices, Local network, Internet?

  • @Victoria.Pulliam
    @Victoria.Pulliam 9 дней назад

    Thank you so much for this

  • @muhammadarif6455
    @muhammadarif6455 9 дней назад

    How about the value more than one ?

  • @loneliness75
    @loneliness75 10 дней назад

    Here data is not changing with month change. When I change the month, the data will change automatically. You can provide such videos. Thank you❤

  • @jamirvirani1
    @jamirvirani1 11 дней назад

    THANK YOU

  • @Kemono_Lietuva
    @Kemono_Lietuva 11 дней назад

    thank you!

  • @roopjoshi733
    @roopjoshi733 12 дней назад

    Hellow! The empty coloumn is colour coded. How can cell which doesn't have any date and remains white means no colour coded?

    • @be-smart-at-office
      @be-smart-at-office 9 дней назад

      Seems something wrong in in the process, please follow exact guideline

  • @plannerlead9370
    @plannerlead9370 12 дней назад

    Thank you sir

  • @yangsaleh7696
    @yangsaleh7696 13 дней назад

    Great ✅Verified

  • @bapikarmandal2379
    @bapikarmandal2379 13 дней назад

    Can i resize the invoice..? I want the invoice in half page in the a4 paper

    • @be-smart-at-office
      @be-smart-at-office 9 дней назад

      Yes, resigning can be done. Delete some item rows and make the row height smaller.

  • @roopjoshi733
    @roopjoshi733 14 дней назад

    Thank you ❤

  • @azhadshamim3122
    @azhadshamim3122 14 дней назад

    Better we should use latest farmula =sumifs(xlookup Which very much easier

  • @mvheerden9317
    @mvheerden9317 15 дней назад

    Amazing , Excel , explained and showed in a great way!! Thank you Sir

  • @acm3340
    @acm3340 15 дней назад

    I CAN'T GET THE CODE TO WORK ON TWO SHEETS, HELP!

    • @acm3340
      @acm3340 15 дней назад

      I was able to do it, I just had to put the same code inside the function onSelectionChange() { Thanks for your great contribution.

  • @raknan75
    @raknan75 16 дней назад

    Thank you so much

  • @harinipriya8876
    @harinipriya8876 17 дней назад

    Thnks a lot sir ❤️....

  • @mahfuzulhaque5441
    @mahfuzulhaque5441 17 дней назад

    thanks a lot !

  • @doutiphilippeberenger9671
    @doutiphilippeberenger9671 18 дней назад

    very good job

  • @zinimbita9789
    @zinimbita9789 21 день назад

    This really helped 🙏🏾

  • @haridevyadav1153
    @haridevyadav1153 22 дня назад

    thank u sir🥰

  • @yoesephrahim3549
    @yoesephrahim3549 22 дня назад

    THAN YOU BOSS U SAVED MY LIFE ALMOST KILELD MYSELF

  • @NitaYahqina-l4j
    @NitaYahqina-l4j 23 дня назад

    Thanks my dear friend. Issue was driving me nuts but, video was very helpful

  • @1373abby
    @1373abby 23 дня назад

    Thank you!!! Extremely helpful!

  • @kartiksahani6109
    @kartiksahani6109 24 дня назад

    Nice explanation

  • @lingdumpling5967
    @lingdumpling5967 24 дня назад

    Thank you, you life saver

  • @chronixlovee
    @chronixlovee 24 дня назад

    What if I am trying to count the number of cells greater than zero? my table has "hours late" where your "attendance" column is. I am trying to count the number of cells greater than 0 when data is filtered.

  • @lindaezeani8133
    @lindaezeani8133 25 дней назад

    Please sir where can i download this excel. The link isn't working. Please help

  • @rizafabia5343
    @rizafabia5343 26 дней назад

    Please correct me when im wrong ? is the formula is *$G4+"Paid" thanks

  • @fredpayne2464
    @fredpayne2464 26 дней назад

    Can't understand him, anybody know where to find this in Ehglish?

  • @mrgirishsbce
    @mrgirishsbce 27 дней назад

    Fantastic video , short and exact to the point

  • @jhyrq
    @jhyrq 27 дней назад

    What if I wanted to apply it to multiple sheets at the same time?

  • @DEDEPLDEDE
    @DEDEPLDEDE 29 дней назад

    Unfortunately it doesn't work anymore as Windows is unable to see the content of the zipped file

  • @variedinterest1
    @variedinterest1 29 дней назад

    How do I highlight a cell just by clicking on it and leave it highlighted

  • @naziralifarooq5899
    @naziralifarooq5899 Месяц назад

    Can we use same formula on google sheet?

  • @aryan8104
    @aryan8104 Месяц назад

    Thanks for the video, it really solved my problem to manually change the column number

  • @divinkottummal5128
    @divinkottummal5128 Месяц назад

    This formula works in libra calc too. very useful video. thank u so much.

  • @archieducation
    @archieducation Месяц назад

    Thanku bro

  • @tejanfamily659
    @tejanfamily659 Месяц назад

    Please assist us with the video for the development of the POS system, please

  • @chandusheth
    @chandusheth Месяц назад

    =SUMPRODUCT(B5:M5*($B$4:$M$4=$B$4)) &=SUMPRODUCT(B5:M5*($B$4:$M$4=$C$4)) will solve the problem.

  • @malikawais633
    @malikawais633 Месяц назад

    Thanks very much bro❤

  • @REDALKLLC
    @REDALKLLC Месяц назад

    Hello - Seems very interesting, However I cant seem to find where exactly to download the template?

    • @be-smart-at-office
      @be-smart-at-office Месяц назад

      Hi, download link is updated in the description.

    • @lindaezeani8133
      @lindaezeani8133 24 дня назад

      Please the link isn't working. Or can you please upload a tutorial on it. ​@increase-work-productivity

    • @be-smart-at-office
      @be-smart-at-office 24 дня назад

      please download the template from the link attached in description.

    • @lindaezeani8133
      @lindaezeani8133 24 дня назад

      ​@@be-smart-at-officenot working. I tried It after watching the video

    • @be-smart-at-office
      @be-smart-at-office 23 дня назад

      Please write a mail to spreadsheetforu@gmail.com Will send it there

  • @cesarminiao
    @cesarminiao Месяц назад

    This doesn’t work on web excel 😞

  • @Kumquat-qq8tf
    @Kumquat-qq8tf Месяц назад

    It wouldnt work for me using ' but did with "

    • @be-smart-at-office
      @be-smart-at-office Месяц назад

      Yes, It should be double quotation (") not the single (')

  • @himangiyadav8094
    @himangiyadav8094 Месяц назад

    You haven't considered the mark up margn, directly 8% pe nikal diya hai Gross profit.