I didn’t know these Excel functions existed, but now I can’t live without them www.makeuseof.com/i-cant-live-without-these-excel-functions/ 5 TEXTSPLIT – Breaks apart text that’s stuck together 4 TEXTJOIN – Combines multiple cells into one 3 CHOOSECOLS – Selects specific columns from your data 2 TAKE and DROP – Extracts portions of your
Seguir leyendoCategoría: Tools
«I use these 5 Excel array formulas to crush complex calculations»
I use these 5 Excel array formulas to crush complex calculations www.makeuseof.com/use-excel-array-formulas-crush-complex-calculations/ 5 XLOOKUP 4 SUMPRODUCT 3 FILTER 2 UNIQUE 1 SORT and SORTBY
Seguir leyendo«These 3 Excel functions make me feel like a spreadsheet wizard»
These 3 Excel functions make me feel like a spreadsheet wizard www.makeuseof.com/excel-functions-feel-like-spreadsheet-wizard/ 4 The SEQUENCE function generates data automatically – Create dynamic number and date sequences 3 LET makes complex formulas maintainable – Eliminate repetitive calculations and improve readability 2 LAMBDA creates reusable custom functions – Build custom functions for
Seguir leyendo«I stopped wasting time in PowerPoint when I learned these 7 hacks»
I stopped wasting time in PowerPoint when I learned these 7 hacks www.makeuseof.com/powerpoint-time-saving-tips/ 7 Resize multiple objects or shapes in one go – Scale everything at once 6 Reuse existing slides instead of rebuilding them – Steal your own brilliance, no shame 5 Polish your slides with format painter and
Seguir leyendo«I replaced Excel’s PivotTables with this extremely overpowered tool and haven’t looked back»
I replaced Excel’s PivotTables with this extremely overpowered tool and haven’t looked back www.makeuseof.com/excel-power-pivot-better-than-pivottables/ Power Pivot – Overview and Learning – Microsoft Support support.microsoft.com/en-us/office/power-pivot-overview-and-learning-f9001958-7901-4caa-ad80-028a6d2432ed Start the Power Pivot add-in for Excel – Microsoft Support support.microsoft.com/en-us/office/start-the-power-pivot-add-in-for-excel-a891a66d-36e3-43fc-81e8-fc4798f39ea8 Get started with Power Pivot in Microsoft Excel – Microsoft Support support.microsoft.com/en-us/office/get-started-with-power-pivot-in-microsoft-excel-fdfcf944-7876-424a-8437-1a6c1043a80b
Seguir leyendoMost Excel users don’t know that these features exist
Most Excel users don’t know that these features exist www.makeuseof.com/excel-features-you-didnt-know/ 7 Watch Window – Keep important cells in sight without scrolling 6 Camera Tool – Create live snapshots of your data 5 Custom Views – Instantly edit your spreadsheet for different audiences 4 Goal Seek – Work backwards to find
Seguir leyendoI make messy Excel data beautiful in minutes and it’s all thanks to these 5 tips
I make messy Excel data beautiful in minutes and it’s all thanks to these 5 tips www.makeuseof.com/make-messy-excel-data-beautiful/ 5 Clean up text with TRIM, CLEAN, and PROPER 4 Apply consistent styles with table and cell formatting 3 Highlight what matters with Conditional Formatting 2 Show trends instantly with Sparklines 1 Freeze
Seguir leyendo«I Stopped Wasting Time in Excel When I Learned These 3 Functions»
«I Stopped Wasting Time in Excel When I Learned These 3 Functions» www.makeuseof.com/excel-functions-time-saver/ FILTER SUMIFS / COUNTIFS XLOOKUP
Seguir leyendoThis Underrated PowerPoint Feature Is My Secret to Perfect Presentations
This Underrated PowerPoint Feature Is My Secret to Perfect Presentations www.makeuseof.com/powerpoint-hidden-feature-better-presentations/
Seguir leyendoI Proofread Twice as Fast With These Word Hacks
I Proofread Twice as Fast With These Word Hacks www.makeuseof.com/proofread-with-these-word-hacks/ Start With the Editor Tool (Spelling & Grammar) Make the Editor Work for You Explore the Review Tab for More Tools Compare Documents and Combine Check Readability Statistics Leverage Track Changes for Collaborative Proofreading Use Find & Replace for Rapid
Seguir leyendo