- Видео 178
- Просмотров 2 134 597
Smart Office
Непал
Добавлен 7 фев 2020
This channel is designed to share video tutorials on MS Excel and other office software which are very useful in making our office work smart. We will post most videos on Microsoft Excel templates, formulas and functions and will also upload tutorials on other software like MS Word, MS Power point and any other productivity software. Learning these will be very helpful on improving quality of our work life. Stay connected and enjoy learning.
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/
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)
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 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
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
सर लैपटॉप के लिए फ्री WPS Office नही है क्या एक डाउनलोड किया हूं उसमें Premium Membership वाले ही सिर्फ एडिट कर सकते हैं। 😢 अगर कोई फ्री वाला है जिससे हम कोई भी पीडीएफ एडिट कर सके plz बताइएगा।
सर लैपटॉप के लिए फ्री WPS Office नही है क्या एक डाउनलोड किया हूं उसमें Premium Membership वाले ही सिर्फ एडिट कर सकते हैं। 😢 अगर कोई फ्री वाला है जिससे हम कोई भी पीडीएफ एडिट कर सके plz बताइएगा।
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.
Love you
It's not working idiot!
Thank you! Big help.
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?
Thank you so much for this
Welcome 🙏
How about the value more than one ?
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❤
THANK YOU
Welcome 🙏
thank you!
Welcome ❤️
Hellow! The empty coloumn is colour coded. How can cell which doesn't have any date and remains white means no colour coded?
Seems something wrong in in the process, please follow exact guideline
Thank you sir
Welcome
Great ✅Verified
Thank you
Can i resize the invoice..? I want the invoice in half page in the a4 paper
Yes, resigning can be done. Delete some item rows and make the row height smaller.
Thank you ❤
Welcome!
Better we should use latest farmula =sumifs(xlookup Which very much easier
Great, but old versions can still use this.
Amazing , Excel , explained and showed in a great way!! Thank you Sir
Thank you.
I CAN'T GET THE CODE TO WORK ON TWO SHEETS, HELP!
I was able to do it, I just had to put the same code inside the function onSelectionChange() { Thanks for your great contribution.
Thank you so much
You're most welcome
Thnks a lot sir ❤️....
Most welcome
thanks a lot !
Welcome!
very good job
Thanks
This really helped 🙏🏾
thank u sir🥰
So nice of you
THAN YOU BOSS U SAVED MY LIFE ALMOST KILELD MYSELF
🙂🙂
Thanks my dear friend. Issue was driving me nuts but, video was very helpful
Glad it helped
Thank you!!! Extremely helpful!
Welcome
Nice explanation
Thanks and welcome
Thank you, you life saver
Glad to hear that!
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.
Please sir where can i download this excel. The link isn't working. Please help
Link has been updated
Please correct me when im wrong ? is the formula is *$G4+"Paid" thanks
=$G4="Paid"
Can't understand him, anybody know where to find this in Ehglish?
Fantastic video , short and exact to the point
Glad it was helpful!
What if I wanted to apply it to multiple sheets at the same time?
Unfortunately it doesn't work anymore as Windows is unable to see the content of the zipped file
How do I highlight a cell just by clicking on it and leave it highlighted
Can we use same formula on google sheet?
Thanks for the video, it really solved my problem to manually change the column number
Glad it helped
This formula works in libra calc too. very useful video. thank u so much.
Welcome🙏
Thanku bro
Welcome🙏
Please assist us with the video for the development of the POS system, please
=SUMPRODUCT(B5:M5*($B$4:$M$4=$B$4)) &=SUMPRODUCT(B5:M5*($B$4:$M$4=$C$4)) will solve the problem.
Thanks very much bro❤
You're welcome 😊
Hello - Seems very interesting, However I cant seem to find where exactly to download the template?
Hi, download link is updated in the description.
Please the link isn't working. Or can you please upload a tutorial on it. @increase-work-productivity
please download the template from the link attached in description.
@@be-smart-at-officenot working. I tried It after watching the video
Please write a mail to spreadsheetforu@gmail.com Will send it there
This doesn’t work on web excel 😞
It wouldnt work for me using ' but did with "
Yes, It should be double quotation (") not the single (')
You haven't considered the mark up margn, directly 8% pe nikal diya hai Gross profit.