- 104
- 173 633
Loinsure
เข้าร่วมเมื่อ 31 ต.ค. 2021
Office Word, Excel, PowerPoint, Photoshop and strange.
Sumifs function in Excel, with text criteria, multiple array conditions
Sumifs function in Excel, with text criteria, multiple array conditions
มุมมอง: 72
วีดีโอ
Int, Trunc, Round and Even function examples in taking an integer in Excel
มุมมอง 912 หลายเดือนก่อน
There are five main types of functions that are used to take an integer in Excel, which are functions that do not round but only retained integer parts, rounding up functions, the functions that take an integer as the nearest even number, rounding up and rounding down functions. Chapters: 0:00 Excel Int function examples 0:51 Excel Trunc function example 2:00 Excel Round function example 2:42 E...
Use Multiple Consolidation Ranges to merge multiple tables into a pivot table
มุมมอง 1033 หลายเดือนก่อน
If you want to subtotal the sales of a product from January to December, and each month's sales are a separate worksheet, you need to use the Multiple Consolidation Ranges to merge multiple tables into a pivot table in Excel. Chapters: 0:00 Use Multiple Consolidation Ranges to merge multiple tables into a pivot table 2:03 Adjust the rows and columns of the page to show as a table 2:36 Modify th...
Round to decimal places in Excel, with using Round function flexibly and rounding to nearest 1000
มุมมอง 533 หลายเดือนก่อน
There are two ways to round in Excel, namely use the commands and the Round function; Among them, there are two ways to round with the former, namely use Decrease Decimal and Number Format. Chapters: 0:00 Round to decimal places in Excel 0:43 Use Round function 1:24 The Round function can also round numbers to the left of the decimal point 2:06 Less than or equal to three, discarded; Greater th...
Long numbers in Excel (type and long numbers in scientific notation are displayed in their entirety)
มุมมอง 1354 หลายเดือนก่อน
Entering long numbers are automatically converted to scientific notation in Excel. This is because only 11-digit numeric numbers are shown by default, and more than 11 digits are automatically represented by scientific notation. Chapters: 0:00 How to type long numbers in Excel? 0:53 The long numbers expressed in scientific notation are displayed in their entirety Description: Long numbers in Ex...
Excel update pivot table (Refresh data when opening the file and update Report pages automatically)
มุมมอง 1984 หลายเดือนก่อน
When the pivot table is updated, we can update it manually or automatically. Manual updates can be updated immediately, and automatical updates are updated the next time the document is opened. Chapters: 0:00 Excel update pivot table 0:31 Excel update pivot table automatically 1:45 Excel update Reports automatically in pivot table Description: Excel update pivot table (Refresh data when opening...
Excel report generator (make monthly report, Show report filter pages greyed out)
มุมมอง 2784 หลายเดือนก่อน
We can automatically generate a paginated report according to a specified field in Excel Pivot Table, such as a paginated report by month or classification, so that we can easily view or analyze the data of a month or a classification. Chapters: 0:00 Excel show report filter pages greyed out 0:33 How to make monthly report in Excel? 1:03 How to make report by Classification in Excel? 1:25 Delet...
Insert rows between rows, remove blank rows and Row height in Excel in cm
มุมมอง 2094 หลายเดือนก่อน
Row height and column width in Excel are generally measured in pounds, but sometimes we need to use centimeters instead. Insert rows between rows, remove blank rows and copy row height and column width, these three cases can not be directly operated. Chapters: 0:00 Row height in Excel in cm 0:42 Column width in Excel in cm (Excel column width pixels to cm) 1:08 Insert rows between rows in Excel...
Excel Pivot Table slicer (greyed out, add them to filter and remove)
มุมมอง 4315 หลายเดือนก่อน
Since Excel 2010, the new slicer has been added, it is mainly used to filter the data, it displays each field independently in a small window, when you select a field in one window, the options that belong to the selected field in another window will be filtered out, for example, select a category or a department, the options that belong to the category or department will be filtered out, and t...
Excel replace *, special characters, formula and Highlight cells with formulas
มุมมอง 1885 หลายเดือนก่อน
There are usually two ways to express the multiplier sign, namely the asterisk * or the multiplier sign ×. Chapters: 0:00 Excel replace * character with × 0:32 Excel replace special characters 1:02 Excel replace formula 1:44 Highlight cells with formulas in Excel Description: Excel replace *, special characters, formula and Highlight cells with formulas The asterisk * is usually used in formula...
Excel Pivot Table advanced filter (Contains multiple words and Multiple criteria in formula)
มุมมอง 2915 หลายเดือนก่อน
Advanced filter is also possible in Excel pivot tables, and the results can be copied into a new worksheet. Like normal tables, we can use a condition or multiple conditions in the condition range of advanced filter, and we can combine the multiple conditions in fields or a formula, if the condition is complex and the field is not easy to combine, we can use formula combination. Chapters: 0:00 ...
Excel count non blank cells (find first non blank value, replace blank cells with 0)
มุมมอง 1515 หลายเดือนก่อน
When there is only one non-empty cell in a column in an Excel table, we want to return its value to another cell, which is usually done with a formula. Chapters: 0:00 Excel find first non blank value 0:43 Excel find non blank cells in range (Return non empty cells Excel) 1:40 Excel count non blank cells 2:13 Excel replace blank cells with 0 Description: Excel count non blank cells (find first n...
How to add subtotals in Excel Pivot Table (remove subtotals and grand total,Row Labels on same line)
มุมมอง 3316 หลายเดือนก่อน
After converting an Excel table into a pivot table, it is very convenient to subtotal, just check the classification field and the field to be subtotalled, and Excel will automatically subtotal the number of different classifications. Chapters: 0:00 How to add subtotals in Excel Pivot Table? 0:27 How to remove subtotals from Pivot Table Excel? 0:53 How to remove grand total from Pivot Table? 1:...
Excel plus or minus format (make positive red and negative blue)
มุมมอง 1296 หลายเดือนก่อน
Positive numbers omit plus signs and negative numbers display minus signs by default In Excel, but sometimes we need to display plus signs. Chapters: 0:00 Excel plus or minus format 0:34 How to add plus or minus before integers or decimals in Excel? 0:57 Excel plus or minus function 1:55 How to make positive numbers red in Excel? 2:25 How to make positive numbers red and negative numbers blue i...
Excel Pivot Table filter (label, value, Filters, multiple criteria or values, remove old)
มุมมอง 2826 หลายเดือนก่อน
We can also filter the data in Excel pivot table. There are Label, Value and Filters for filtering. Chapters: 0:00 Excel Pivot Table label filter 0:53 Pivot Table label filter multiple criteria 1:45 Excel Pivot Table value filter 2:40 Excel Pivot Table value filter multiple criteria 3:13 Excel Pivot Table filter with Filters 3:48 Excel Pivot Table remove old filter values 3:49 How to change fil...
Excel round to 2 decimal places (1 decimal place, 0 00 show 0, if 0 then blank or -)
มุมมอง 2787 หลายเดือนก่อน
Excel round to 2 decimal places (1 decimal place, 0 00 show 0, if 0 then blank or -)
How to create a pivot table in Excel (3 examples, Sort, Count percentage, Character fields collapse)
มุมมอง 2557 หลายเดือนก่อน
How to create a pivot table in Excel (3 examples, Sort, Count percentage, Character fields collapse)
If conditional formatting formula in Excel (Highlight a row and multiple cells)
มุมมอง 1048 หลายเดือนก่อน
If conditional formatting formula in Excel (Highlight a row and multiple cells)
How to convert Word to Excel (Quick way and Indirect approach, Web page to Excel, Show gridlines)
มุมมอง 2729 หลายเดือนก่อน
How to convert Word to Excel (Quick way and Indirect approach, Web page to Excel, Show gridlines)
Excel Lookup function (Vector and Array, 5 examples, Approximate matching)
มุมมอง 1269 หลายเดือนก่อน
Excel Lookup function (Vector and Array, 5 examples, Approximate matching)
Max and Min in Excel with criteria (highlight them, remove rules)
มุมมอง 3159 หลายเดือนก่อน
Max and Min in Excel with criteria (highlight them, remove rules)
How to find duplicate values in different Excel sheets and two columns in Excel
มุมมอง 2389 หลายเดือนก่อน
How to find duplicate values in different Excel sheets and two columns in Excel
Excel Vlookup IF 1 0 multiple conditions and Anatomy (four Examples)
มุมมอง 11210 หลายเดือนก่อน
Excel Vlookup IF 1 0 multiple conditions and Anatomy (four Examples)
Vlookup in Excel (function explained, 4 examples, certain words, text, asterisk, Approximate match)
มุมมอง 11410 หลายเดือนก่อน
Vlookup in Excel (function explained, 4 examples, certain words, text, asterisk, Approximate match)
How to set print area in Excel (shrink to one page, remove page break, set page margins for sheets)
มุมมอง 65311 หลายเดือนก่อน
How to set print area in Excel (shrink to one page, remove page break, set page margins for sheets)
Print header on all pages and add Header and footer in Excel
มุมมอง 1.4Kปีที่แล้ว
Print header on all pages and add Header and footer in Excel
Insert Excel, PDF, Picture, Check mark and Screenshot in Excel (move and size with cells)
มุมมอง 288ปีที่แล้ว
Insert Excel, PDF, Picture, Check mark and Screenshot in Excel (move and size with cells)
How to subtotal in Excel (Subtotal, Sort and Filter grey out, Total rows, remove)
มุมมอง 812ปีที่แล้ว
How to subtotal in Excel (Subtotal, Sort and Filter grey out, Total rows, remove)
Convert Excel to PDF (All sheets, only specified number of pages, Selections, Table)
มุมมอง 426ปีที่แล้ว
Convert Excel to PDF (All sheets, only specified number of pages, Selections, Table)
How to hide row, column, window and sheet in Excel (unhide all sheets with VBA)
มุมมอง 443ปีที่แล้ว
How to hide row, column, window and sheet in Excel (unhide all sheets with VBA)
thank you. its true.
Thank you Excellent
Thanks man❤
THANK YOU!!!!!
and you are supposed to sleep better with this going on??
No, I just used it to interfere with brain waves, and it didn't turn out very well.
YOU JUST SAVED A LIFE
I'm glad I can help you.
Thanks
Thx
thank you so much, so short yet so helpful. i do like it!
Дякую!
Thanks a lot. It worked in first try. I don´t use Word or Excel so much, still, I really appreciate you for all the videos you have posted. I hope each videos of you may help a lot of people.
I'm glad they can help you, and hopefully they can help more people.
Thank you very much!
THANK YOU!
Thankyou very much
Many Thanks !
I think this doesn't work if you have a table inside another table that is extending across pages. Otherwise it works.
You are a star well done I wish your you-tube page grow
Thank you.
Nice 👍
Thank you so much
Thank you so much ❤
a lot of thanks sir
Right click the Table Properties was the trick for me. Thank you!
did not work for me.
It may be helpful to follow the steps carefully and do it once.
@Loinsure thank you🙂🙂😍😍
Thank you so much this has been so helpful with my line numbers !
thank you
thanks
This helped me with an assignment I was having trouble with. Thank you!
Bro, I want to ask, if for example the Excel is transferred to another PC, usually the pdf file that is inserted cannot be opened, right? What's the solution so that the pdf file can be accessed on another PC? thanks a lot
Check if the viewer that opens PDF is installed. The PDF file is also copied to the target PC.
LIFESAVER!
This does NOT work for Windows 365
You can try it with a different PC.
Promo*SM 👏
thanks a lot...
thnx 👍
Very useful
I've looked around and almost none said it needed to be clicked on the table's first row, I kept trying it on the 2nd page after it got cut off, Thanks so much!
No problems will do.
Fantastic, I've been mocking around with this for a long time without joy and you gave me the solution straight to the point.
Aapki awaz nhi AA Rahi hai.. Magar aapne Mera bahut bada problem solve kr diya.... thank you so much sir....
Thanks for this video
Thank You It works perfectly. It selects more than 1000 objects at a time in MS Word file. It saves a lot of time. Thanks again.
THANK YOU SO MUCH!
Thank you. This method does not achieve what I was hoping for... I need to select all images in the document in order to resize all of them at once. However, in order to do that, I need the image tools button to be visible, and is is not visible when using this method. If I were to click on an individual image, the image tools button would appear, but that would not enable me to select all images in the document. Thank you again.
You should use the method: 0:55 How to select all images and shapes in Word (using Select Multiple Objects)
@@loinsure3783 Thank you, but as I said, it does not work. Perhaps you made this video on an older version of Word. I have MS Office 2016.
@@staninjapan07 You can save DOCX as Doc and save it as DOCX after modifications in Word 2016.
@@loinsure3783 I will try that and let you know how I got on, thanks a lot.
thanks
I've been trying figure this out forever I never would have guessed it had anything to do with text wrap. THANK YOU!
Since the table can be surrounded by text, it means that the table does not have much content and does not need to spread pages at all.
Thank you sir,it worked 👍
Okay, that's exactly what I want.
Thank you so much!!
How can we do the same in excel 2007 please help ..
Haven't made a video yet, please refer to this article ‘How to split cells in excel’ on our website.
😣 քʀօʍօֆʍ