ExtendOffice - Kutools for Excel, Outlook, Word

Kutools for Excel — 300+ powerful features for Excel. See how it helps simplify repetitive tasks and save time. Watch the full video here: youtube.com/shorts/3czzLzsEn… Via @YouTube @msexcel @Microsoft365 @Microsoft @Office

Old system item codes like PO-NY-24-0031-USA, but you only need NY-0031? Kutools › Text › Remove by Position Cut from the left, the right, or any start position, with no formulas or helper columns. #Excel #Kutools

Only need to print the latest reply in an Outlook email thread? Learn how to print just the newest reply without printing the entire conversation. Save paper and keep your printouts clean! @Microsoft365 @Microsoft @Office #Outlook #OutlookTips

Need a calculator in Excel without switching windows? Add Calculator to the Quick Access Toolbar, or use Kutools' built-in calculator to calculate, pull cell values, and paste results directly into Excel. @msexcel @Microsoft365 @Microsoft @MicrosoftLearn #Excel #ExcelTips

Too many column breaks messing up your Word document? Remove them one by one using Word, or delete all column breaks at once with Kutools for Word—no tedious manual cleanup! @Microsoft365 @Microsoft @Office #MicrosoftWord #WordTips

Want to sort Excel data by text length? Discover 2 easy ways to sort text from shortest to longest, whether you're working with product codes, names, or descriptions. @msexcel @Microsoft365 @Microsoft @MicrosoftLearn #Excel #ExcelTips

Phone numbers and emails mixed in Excel cells? Stop extracting them manually! Learn easy ways to pull phone numbers and email addresses from messy text into clean, separate data. @msexcel @Microsoft365 @Microsoft @MicrosoftLearn #Excel #ExcelTips

Too many emails marked High Importance in Outlook? Remove importance marks manually, or use Kutools for Outlook to change incoming high-importance emails to Normal automatically. @Microsoft365 @Microsoft @Office #Outlook #OutlookTips

Repeat your last action in Excel with F4! Apply a yellow fill once, select another cell, and press F4 to repeat the formatting. 💡 On some keyboards, you may need Fn + F4. F4 works when the last action can be repeated. 👍 Like, subscribe, and follow for more Excel tips! #Excel #ExcelTips #ExcelShortcuts #F4 #Productivity #Shorts

Combine duplicate rows in Excel into one row per item and add up their values, four ways. Got an order list where the same product shows up again and again, and you need one row per product with the quantities added up? Filtering each product and adding it up by hand is slow and easy to get wrong. This video shows four ways: a PivotTable, Consolidate, the UNIQUE and SUMIF formulas, and Kutools for Excel’s Advanced Combine Rows feature, which combines every column at once right in your table: sum the quantities, join the order numbers, and keep the date you want, with no formulas and no extra report. 👇 Try Kutools for Excel free for 30 days: go.extendoffice.com/combine-… 0:00 One row per order, products repeat 0:25 Method 1: PivotTable 1:51 Method 2: Consolidate 3:01 Method 3: UNIQUE + SUMIF formulas 4:21 Method 4: Kutools Advanced Combine Rows 6:06 Which method to use 📌 Options covered: • PivotTable: flexible summary report you can refresh when the data changes • Consolidate: a quick static table of totals per product • UNIQUE + SUMIF: live formulas that update as soon as the orders change • Kutools Advanced Combine Rows: combine every column at once, in place • Sum, join with a comma, or keep the first or last value for each column 🎯 Useful for: • Order lists with repeated products • Sales reports by product, customer or region • Inventory and stock movement records • Timesheets with several rows per person • Expense lists by category • Cleaning up exported data before a report #CombineDuplicateRows #SumDuplicates #ExcelDuplicates #PivotTable #ExcelConsolidate #SUMIF #UNIQUE #Excel #MicrosoftExcel #ExcelTips #ExcelTutorial #ExcelTricks #ExcelHacks #ExcelProductivity #Kutools #KutoolsForExcel #ExtendOffice

Need to count cells with multiple conditions in Excel? This video shows 2 easy ways: use COUNTIFS to count matching cells, or use Kutools for a faster, no-formula approach. @msexcel @Microsoft365 @Microsoft @MicrosoftLearn #Excel #ExcelTips

Need to select specific pages in Word without dragging through text? Here are 2 ways: select manually, or use Kutools to select the current page, odd/even pages, or specific pages for quick copying, moving, or deleting. @Microsoft365 @Microsoft @Office #MicrosoftWord #WordTips

Need to split Excel data into random groups? This video shows 2 ways: use WRAPROWS + RANDARRAY for balanced groups in Microsoft 365, or CHOOSE + RANDBETWEEN for all Excel versions (groups may be uneven). @msexcel @Microsoft365 @Microsoft @MicrosoftLearn #Excel #ExcelTips

Need a Word link that opens a local file when clicked? This video shows 4 ways: Hyperlink, pasted file paths, linked objects, or Kutools to batch-add the same file link to matching text. @Microsoft365 @Microsoft @Office #MicrosoftWord #WordTips

Think formulas may have been overwritten in Excel? This video shows 2 fast ways to spot hard-coded values hiding in formula columns: Go To Special or Kutools Highlight Formulas for continuous visual checking. @msexcel @Microsoft365 @Microsoft @MicrosoftLearn #Excel #ExcelTips

Lost your place after reopening a Word document? This video shows 3 ways to jump back instantly: Resume Reading, Shift + F5, or Kutools to automatically return to your last position every time. @Microsoft365 @Microsoft @Office #MicrosoftWord #WordTips

Rebuilding your attendance sheet every month? Do it once. =SEQUENCE(1,DAY(EOMONTH(B1,0)),B1) + Conditional Formatting › New Rule Change the month, and dates, weekdays and weekends update. #Excel #ExcelTips

3 Excel Format Painter Tricks You Need to Know! Still wasting time formatting Excel cells and tables one by one? Stop! Excel's Format Painter can save you tons of time! Here are 3 Format Painter tricks you need to know! Trick 1 — Copy Date Formatting Trick 2 — Copy Entire Table Formatting Trick 3 — Double-Click Format Painter No more repetitive formatting! With these 3 Format Painter tricks, you can format your Excel data faster and easier! #excel #exceltips #exceltricks #formatpainter #exceltutorial

Repeat your last action in Excel with F4! Apply a yellow fill once, select another cell, and press F4 to repeat the formatting. 💡 On some keyboards, you may need Fn + F4. F4 works when the last action can be repeated. 👍 Like, subscribe, and follow for more Excel tips! #Excel #ExcelTips #ExcelShortcuts #F4 #Productivity #Shorts

Translate, tag and sort customer reviews with AI formulas, right in your Excel cells. Got reviews in four languages and need to know what each one is about and whether the customer was happy? No native Excel formula can read the meaning of a review, so you end up reading every one and filling it in by hand. Kutools for Excel’s AI functions do it with formulas: KUTOOLSAITRANSLATE translates the text, KUTOOLSAIEXTRACT pulls out what you ask for, like the product, and KUTOOLSAIASK answers your question about each row, like positive or negative. 👇 Try Kutools for Excel free for 30 days: go.extendoffice.com/ai-funct… 📌 Options covered: • KUTOOLSAITRANSLATE: translate any text into the language you type • KUTOOLSAIEXTRACT: pull out the product, name or any detail you describe • KUTOOLSAIASK: ask a question about each cell and get a short answer • Fill down: one formula handles every row • No patterns or complex formulas to set up: the AI reads the meaning 🎯 Useful for: • Customer reviews and feedback from different countries • Support tickets and survey comments • Sorting feedback into positive and negative • Tagging comments by product or topic • Translating product lists and descriptions • Quick text analysis without leaving Excel #ExcelAI #AIinExcel #AIFormulas #ExcelTranslate #SentimentAnalysis #CustomerReviews #Excel #MicrosoftExcel #ExcelTips #ExcelTutorial #ExcelTricks #ExcelHacks #ExcelProductivity #ExcelShorts #Kutools #KutoolsForExcel #ExtendOffice

Need to add text between every word in Excel? This video shows 2 easy ways: use SUBSTITUTE to replace spaces with a symbol or text, or use Kutools to insert text between words directly—no formula needed. @msexcel @Microsoft365 @Microsoft @MicrosoftLearn #Excel #ExcelTips