![Smart Office](/img/default-banner.jpg)
- 172
- 2 058 971
Smart Office
Nepal
Registrace 7. 02. 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 I will also upload tutorials on other software like MS Word, MS Access, 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.
VLOOKUP and MATCH Function Together | Automate Column Index Numbering in VLOOKUP
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:
Download the sample data file to practice this function from the link given below.
Workbook Number:
zhlédnutí: 55
Video
Complete Guide to VLOOKUP Exact Match Function
zhlédnutí 94Před 21 hodinou
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
zhlédnutí 100Před 14 dny
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
zhlédnutí 116Před 21 dnem
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
zhlédnutí 120Před měsícem
Learn how to edit videos for CZcams 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 CZcams | Free Video editing Software | Best software for video editing | Microsoft Clipchamp tutorial
How to Make Video of Power Point Presentation
zhlédnutí 58Před 2 měsíci
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
zhlédnutí 206Před 2 měsíci
Learn how to edit the PDF documents with Microsoft Word. Edit PDF | Convert PDF to Word | Edit and Save PDF Document
How to Use Microsoft Office 365 for FREE
zhlédnutí 242Před 2 měsíci
Learn how we can use Microsoft Office 365 for FREE. This is only the authentic method of enjoying the latest features of office application without purchasing the program. Use Office Programs for Free | Office 365 Free | Microsoft Office Free | Excel 365 free |
Solve GIF Image Not Playing in WordPress Post
zhlédnutí 85Před 3 měsíci
Learn how to solve the problem of animated GIF image not playing in WordPress Post.
Find Out Forgotten Wi-Fi Password Connected in Computer🔥
zhlédnutí 235Před 3 měsíci
Learn how we can find out the forgotten password of Wi-Fi that is connected in a Computer.
Power BI Line Chart for Monthly Sales in Jan to Dec Order
zhlédnutí 219Před 3 měsíci
Learn how to make a line chart in Power BI to display the sales trend in Jan to Dec order. Download the Excel sample file to practice this project from below. Sample. 2 learnexcelandsheets.com/video-tutorials-and-sample-excel-sheets-for-power-bi/
XLOOKUP in Google Sheets👍(3 Practical Examples🔥)
zhlédnutí 223Před 3 měsíci
Learn how to use the XLOOKUP function in Google Sheets. Here you will learn using XLOOKUP in different data situations with 3 examples. Download the practice sheet from link below. Workbook Num. 7 (locate this in webpage below) learnexcelandsheets.com/excel-practice-workbook-collection-so-a/
Fill Handle Drag and Drop Not Working in Excel | Follow These Steps
zhlédnutí 120Před 3 měsíci
Fill Handle Drag and Drop Not Working in Excel | Follow These Steps
What is Fill Handle in Excel (Tutorial for Beginners)
zhlédnutí 124Před 3 měsíci
What is Fill Handle in Excel (Tutorial for Beginners)
Calculate and Visualize Running Total in Power BI using Measure
zhlédnutí 725Před 7 měsíci
Calculate and Visualize Running Total in Power BI using Measure
Calculate Running Total in Power BI using DAX function
zhlédnutí 615Před 7 měsíci
Calculate Running Total in Power BI using DAX function
DAX in Power BI (Tutorial for Beginners)
zhlédnutí 975Před 7 měsíci
DAX in Power BI (Tutorial for Beginners)
AVERAGE + Take Function in Excel | Automate Last N Months Average Calculation
zhlédnutí 594Před 7 měsíci
AVERAGE Take Function in Excel | Automate Last N Months Average Calculation
How to Auto Highlight Duplicate Values in Google Sheets
zhlédnutí 1,9KPřed 8 měsíci
How to Auto Highlight Duplicate Values in Google Sheets
How to Calculate % Increase or Decrease in Excel
zhlédnutí 1,9KPřed 8 měsíci
How to Calculate % Increase or Decrease in Excel
How to Remove Grand Totals From Pivot Table Report
zhlédnutí 2,3KPřed 8 měsíci
How to Remove Grand Totals From Pivot Table Report
Convert Number to Spelling in MS Word with One Click Button
zhlédnutí 6KPřed 8 měsíci
Convert Number to Spelling in MS Word with One Click Button
Learn How to Make Star Rating in Excel
zhlédnutí 6KPřed 8 měsíci
Learn How to Make Star Rating in Excel
Learn how to do Calculations in Filtered Data In Excel
zhlédnutí 2,3KPřed 8 měsíci
Learn how to do Calculations in Filtered Data In Excel
Generate Automatic Serial Number in Excel
zhlédnutí 4,1KPřed 8 měsíci
Generate Automatic Serial Number in Excel
Thanks my dear friend. Issue was driving me nuts but, video was very helpful
Thank you!!! Extremely helpful!
Welcome
Nice explanation
Thank you, you life saver
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
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
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❤
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.
@@increase-work-productivitynot 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.
Fantastic - Thanks!
Glad you liked it!
Brilliant explanation and, I think, it would be great if you could share the excel file for downloading and easier practice by your subscribers. Thanks a lot!!
Thanks.Lifesaver.
Thnak you! Any idea how this option got turned of in the first place?
If autosace on, this does not work. If autosace feature is on , this does not work.
Thank you so much
welcome
very useful, simple, clear and so easy Thank You
Glad it was helpful!
Hi im sorry. I find your video very helpful. Did you by any chance sell the template?
Hello, this template is free to download in video description
@@increase-work-productivity Hi Thanks!! Will this work for a large inventory? Since we are keeping track for purchase item this too will help right?
Thank you very very very much... Very much very much..... So grateful to you... I recovered my work which I deleted by mistake
You're most welcome
Am unable to download this template, site not going through
Due to some issue in my website, I lost the template. I am trying to find the backup. If it is available, I will update soon.
Alright, will appreciate that
Thank you sir
Welcome
Sir very good template, I am waiting for learning this template step by step as you promised
can you the VBA code to me ? I cant open you link .. please.. I need it very much.
please write a mail to spreadsheetforu@gmail.com I will send you the code in email.
Very helpful. Goated video. Would reccomend
Thank you.
Good video
Glad you enjoyed
What do I press instead of dollar sign? Sounds like cookie but I can’t work it out, sorry for the misunderstanding. Is it a shortcut on the keyboard?
I have adapted this for a work stock check and it works fantastic. Just wanted to clarify the above,
That is F4 key
Very useful 👍
Glad to hear that
feel sad that this is not advance search condition, i need to have search something like input "(Raj AND indian) OR (PK AND INDian)", this simple criteria. U this is simple search, not advance search LOL
The Drop-down list on the Poshandle does not pull through from the Itemgroup, can you help me please
if possible, please share your workbook in spreadsheetforu@gmail.com we will check and revert.
Great! What if we want to put date instead of word.
in case of date, need to put the number value of date. for example, (3rd Aug 2024 = 45507, 4th Aug 2024 = 45508)
Nimber not converting to lacs or corore for indian rupees
if customers total due amount is 1lakh but paid 20,000 then how this system catch this
Thanks a lot. Suppose we have to find max value among Jan to December and how to get name of that month and item using a formula. Hope you can suggest a solution.
The link is invalid sir
Ok, I will check and update
Great tutorial. I enjoyed the sequential approach. It was very helpful. Please how do you handle a situation where you placed an other for two different products, say Products A and B, but had only product A delivered. If you replace the 'T' with 'R' for Product A, how do you deal with product B which you are yet to receive? Thanks.
It assumes that the transit quantity in one column is delivered together. If not, we have to keep undelivered product in another column and mark it as transit
I've been trying to expand my knowledge in Excel and it's really helpful to me. Thank you for this.
Welcome 🙏
Thanks a lot 🙏
Welcome!
Thanks a lot🎉
Welcome!