Microsoft hid 5 Word tools behind the ribbon — here’s how to get them back https://www.makeuseof.com/hidden-word-features-not-on-ribbon/ Word can read your document out loud Turn on Speak and give your eyes a break Clean up messy documents in one click AutoFormat fixes formatting errors fast See exactly how your page will
Lees verderCategorie: Office
I typed three semicolons into Excel and found its strangest formatting trick
I typed three semicolons into Excel and found its strangest formatting trick https://www.makeuseof.com/typed-three-semicolons-into-excel-found-strangest-formatting-trick/ A custom number format has four slots Leave every one of them empty, and Excel draws nothing Formulas still read the hidden value Blanking the display never touches the data underneath This beats hiding columns or turning
Lees verder4 ridiculously useful Excel tools Microsoft barely tells you exist
4 ridiculously useful Excel tools Microsoft barely tells you exist https://www.makeuseof.com/4-useful-excel-tools-microsoft-barely-tells-you-exist/ Camera Tool Not on the ribbon, but three clicks from your toolbar Flash Fill Ctrl+E does what a formula would take five minutes to write Analysis ToolPak It just isn’t turned on by default Watch Window One floating panel
Lees verderYour spreadsheet crossed into database territory if it does these 5 things
Your spreadsheet crossed into database territory if it does these 5 things https://www.makeuseof.com/spreadsheet-crossed-into-database-territory-if-these-things/
Lees verderI use Excel every day and these are the shortcuts I can’t live without
I use Excel every day and these are the shortcuts I can’t live without https://www.makeuseof.com/mastered-excel-shortcuts-cant-live-without/
Lees verderI stopped maintaining lookup formulas after finding Excel’s hidden relational database
I stopped maintaining lookup formulas after finding Excel’s hidden relational database https://www.makeuseof.com/excels-data-model-is-fantastic-database-tool-most-people-dont-know-about/
Lees verderI turned a plain Excel pivot table into an interactive dashboard in five minutes
I turned a plain Excel pivot table into an interactive dashboard in five minutes https://www.makeuseof.com/turn-plain-excel-pivot-table-into-interactive-dashboard-in-five-minutes/ How to build a dashboard using PivotTables Not everything is about fancy charts Building an interactive sales dashboard from a 1,000-row dataset It took me all of five minutes
Lees verderSUM is good, SUBTOTAL is great, but this Excel function beats them both: AGGREGATE
SUM is good, SUBTOTAL is great, but this Excel function beats them both https://www.makeuseof.com/sum-is-good-subtotal-is-great-but-this-excel-function-beats-them-both/ AGGREGATE function | Microsoft Support https://support.microsoft.com/en-us/excel/functions/aggregate-function
Lees verderI added two dots to my Excel references and my slow workbook came back to life
I added two dots to my Excel references and my slow workbook came back to life https://www.makeuseof.com/trimrange-and-trim-references-in-excel/ TRIMRANGE and Trim References The dots that tell Excel to stop wasting time on empty cells How A.:.A (or A:.A) fixes whole-column lag Speed up whole-column formulas, LAMBDAs, and dynamic arrays
Lees verderLAMBDA: I built my own Excel function without touching VBA, and now I use it daily
I built my own Excel function without touching VBA, and now I use it daily https://www.makeuseof.com/built-my-own-excel-function-without-touching-vba/ I kept rebuilding the same formula until Excel let me name it LAMBDA turns a formula you lean on into a function you can call by name I built my custom function inside the
Lees verderI stopped rebuilding the same Excel pivot every week after learning this one trick: getpivotdata
I stopped rebuilding the same Excel pivot every week after learning this one trick https://www.makeuseof.com/stopped-rebuilding-same-excel-pivot-one-trick/ The hidden Pivot Table function Why GETPIVOTDATA is more useful than its intimidating name suggests One formula changed my entire workflow Separating presentation from the Pivot Table without losing live updates Reports that update themselves
Lees verderVSTACK: I used to manually merge two spreadsheets every week — this Excel function completely replaced it
I used to manually merge two spreadsheets every week — this Excel function completely replaced it https://www.makeuseof.com/merge-spreadsheets-with-the-vstack-excel-function/ How VSTACK replaced my weekly spreadsheet merge One formula instead of copy-pasting every week What you should know before using VSTACK What works, what doesn’t, and when another tool makes more sense VSTACK
Lees verder“I tried these 6 new Excel functions and they saved me a ton of time”
I tried these 6 new Excel functions and they saved me a ton of time https://www.makeuseof.com/new-excel-functions-worth-learning-this-year/ Regular expression (regex) functions Find, extract, and clean data without endless text formulas regexreplace REGEXREPLACE Function | Microsoft Support https://support.microsoft.com/en-us/excel/regexreplace-function regextest REGEXTEST Function | Microsoft Support https://support.microsoft.com/en-us/excel/regextest-function regexextract REGEXEXTRACT Function | Microsoft Support https://support.microsoft.com/en-us/excel/regexextract-function
Lees verderONLYOFFICE DocSpace 3.7
ONLYOFFICE DocSpace 3.7: genera DOCX, PPTX y PDF desde el chat de IA y añade DeepSeek, Google AI y xAI como proveedores https://wwwhatsnew.com/2026/06/11/onlyoffice-docspace-3-7-ia-docx-pptx-pdf-deepseek-2026/
Lees verder“I never knew what those double brackets in Excel meant — now I use them in almost every formula”
I never knew what those double brackets in Excel meant — now I use them in almost every formula https://www.makeuseof.com/double-brackets-in-excel/
Lees verderOnlyOffice Docs Developer edition
ONLYOFFICE Docs Developer Edition: la suite ofimática que se mete dentro de tu SaaS sin pagar el peaje de Microsoft o Google https://wwwhatsnew.com/2026/06/05/onlyoffice-docs-developer-edition-la-suite-ofimatica-que-se-mete-dentro-de-tu-saas-sin-pagar-el-peaje-de-microsoft-o-google/ Suite bureautique en ligne pour développeurs https://www.onlyoffice.com/fr/developer-edition Comparez les éditions | ONLYOFFICE Docs https://www.onlyoffice.com/fr/compare-editions ONLYOFFICE pour les développeurs | ONLYOFFICE https://www.onlyoffice.com/fr/for-developers
Lees verderModern Excel finally made sense to me after I learned how arrays and ranges are different
Modern Excel finally made sense to me after I learned how arrays and ranges are different https://www.makeuseof.com/how-arrays-and-ranges-in-excel-are-different/
Lees verderOffice EU – Europe’s Open-Source Productivity Suite
La suite open source Euro-Office disponible le 9 juin – Le Monde Informatique https://www.lemondeinformatique.fr/actualites/lire-la-suite-open-source-euro-office-disponible-le-9-juin-100316.html Office EU – Europe’s Open-Source Productivity Suite All-in-One Office Suite, 100% European Office EU is a complete cloud-based office suite (like Microsoft 365 or Google Workspace) that is 100% European-owned and runs entirely on European infrastructure.
Lees verderIFNA: The Excel formula I use whenever #N/A takes over a sheet
The Excel formula I use whenever #N/A takes over a sheet https://www.makeuseof.com/the-ifna-function-in-excel/ IFNA function – Microsoft Support https://support.microsoft.com/en-us/office/ifna-function-6626c961-a569-42fc-a49d-79b4951fd461 ALS.NB, functie – Microsoft Ondersteuning https://support.microsoft.com/nl-nl/office/als-nb-functie-6626c961-a569-42fc-a49d-79b4951fd461
Lees verderAlmacenamiento en la nube cifrado: alternativas privadas a Google Drive y Dropbox
Almacenamiento en la nube cifrado: alternativas privadas a Google Drive y Dropbox https://wwwhatsnew.com/2026/05/03/almacenamiento-nube-cifrado-alternativas-privadas-google-drive-dropbox/
Lees verder