How to use dynamic array formulas in Microsoft Excel
Learn to master dynamic array formulas in Excel: overflow, key functions, and advanced examples explained step by step.
Office
How to adjust font smoothing in PowerPoint for crisp exports
Learn how to adjust fonts and PDF/A in PowerPoint to export crisp PDFs, without typography changes or loss of quality.
How to include watermarks when generating PDFs from Office
Learn how to add watermarks in Word and keep them when generating PDFs from Office, with basic, advanced and online options.
How to change image compression quality in Word
Learn how to adjust image compression in Word to reduce file size without losing quality. Complete guide, tips, and key settings.
How to adjust the maximum number of decimal places in Excel
Learn how to limit and control decimals in Excel: formats, rounding, TRUNCATION, and tricks for accurate and error-free calculations.
How to change and set the default slide size in PowerPoint
Learn how to change and set the default slide size in PowerPoint, avoid black bars, and maintain a professional design.
Microsoft 365 vs Google Workspace and migration in companies
Compare Microsoft 365 and Google Workspace and discover how to migrate email and files step by step for your business.
PDF with embedded fonts: a complete guide to printing without surprises
Learn how to create PDFs with embedded fonts in Word, Adobe, and other programs for printing without typos or surprise substitutions.
How to password-protect and encrypt documents in LibreOffice Writer
Learn how to password-protect and encrypt documents in LibreOffice Writer step by step and protect your most sensitive files.
Configure LibreOffice as the default suite in Windows
Learn how to set LibreOffice as the default suite on Windows, use .docx, .xlsx and .pptx files, and make it look similar to Microsoft Office.
Word now allows you to add hyperlinks simply by pasting the URL
Discover how Word allows you to add hyperlinks by pasting the URL onto the text and all the advanced options for internal and external links.
How to create an automatic document generator in Word using Excel as a database
Learn how to use Excel as a database to create automatic Word documents with mail merge, without data errors.
How to create a smart slide system in PowerPoint
Learn how to create smart PowerPoint slides that change based on parameters using AI, templates, placeholders, and APIs like FlashDocs.
How to build a mini ERP in Excel step by step
Learn how to create a mini ERP in Excel to manage sales, stock, collections and finances of your business in a single file, with clear reports and automation.
Tables and ranges in Excel: a complete guide to mastering your data
Learn to master cells, ranges, and tables in Excel with clear examples and practical tricks to analyze and manage your data like an expert.
OLE and DDE dynamic links between Excel and PowerPoint
Learn how to create and maintain error-free OLE/DDE dynamic links between Excel and PowerPoint with always up-to-date data.
What is an Excel PivotChart and how to get the most out of it
Discover what an Excel PivotChart is, how it relates to pivot tables, and how to use it to analyze and present data clearly.
Excel with maps, sparklines, and traffic light KPIs for powerful dashboards
Learn to create dashboards in Excel with maps, sparklines, and clear, visual, and decision-making-ready traffic light KPIs.
How to create a Master Procedure Book in Word
Learn how to create a clear, complete, and useful Master Procedures Book for your company in Word, step by step.
How to design handouts and workbooks with PowerPoint
Learn how to design attractive handouts and workbooks with PowerPoint, with a notebook style and ready to print or export to PDF.
Word forms with controlled content and validations
Learn how to create forms in Word with controlled fields and validations, protected templates, and professional content controls.
Automate charts with named ranges and dynamic series in Excel
Learn how to automate charts in Excel with named ranges and dynamic series for clear, flexible, and easy-to-maintain reports.
Accessible tables in Word with labeling and keyboard navigation
Learn how to create accessible tables in Word with correct labeling and keyboard navigation, ready for PDFs and screen readers.
How to integrate OneNote as a knowledge repository linked to Office
Discover how to use OneNote as a knowledge repository linked to Office and Teams, with class notebooks, linked notes, and educational integration.
Tips for creating responsive PowerPoint presentations in ultra-wide and 4:3 without distortion
Adjust your PowerPoint presentations to 16:9, 4:3, and ultrawide without black bars or distortion. Practical tips and key advice.
Presentations with smart placeholders: a complete guide
Discover how to create presentations with smart placeholders using AI, native templates, and data to effortlessly achieve professional slides.
What are Building Blocks and Quick Parts in Office and how to take advantage of them
Discover what Building Blocks and Quick Parts are in Office, how they work, and how to use them to create faster, more consistent, and professional documents.
OLE and DDE dynamic links between Excel and PowerPoint
Learn how to create and maintain dynamic OLE/DDE links between Excel and PowerPoint and avoid errors when updating data in your presentations.
How to remove backgrounds from images in PowerPoint step by step
Learn how to remove backgrounds from images in PowerPoint using all the techniques and instantly improve the design of your slides.
Flash Fill in Excel: A Complete Guide and Practical Uses
Learn to master Flash Fill in Excel: activate the function, use it step by step, and transform your data without complicated formulas.
Embedding fonts in a PowerPoint file: a complete guide
Learn how to embed fonts in PowerPoint on Windows and Mac to avoid formatting errors and keep your design intact when sharing.
How to create drop-down lists with fixed options in Google Sheets
Learn how to create drop-down lists in Google Sheets with fixed options to avoid errors and have consistent data in your sheets.
How to change the page number in Word
Learn how to change, start, and format page numbering in Word and other suites with clear examples and essential tips.
What are Proton Docs, Proton Drive, and Proton Sheets, and how do they work?
Discover how Proton Docs, Drive, and Sheets offer encrypted and private cloud-based office suites to replace Google Workspace without losing key features.
Excel with Python: A complete guide to leveraging the integration
Discover how to use Python in Excel, its real advantages, and the best alternative libraries to connect both worlds and get the most out of your data.
Office Scripts in Excel Web: A Complete Guide to Automating Your Workbooks
Discover how to use Office Scripts in Excel web to automate tasks, share scripts with your team, and connect them to Power Automate.
How to add or remove the ruler in Word and get the most out of it
Learn how to activate or deactivate the Word ruler, change its units, and use indents and tabs to format documents like a professional.
How to use emojis in Office: a complete guide for Word and Outlook
Learn how to use emojis in Office: shortcuts, the emoji pane, Outlook, and Word. A practical guide to communicating more effectively without sacrificing professionalism.
How to add a stamp and signature in Word step by step
Learn how to add a stamp and signature in Word: from scanned images to secure digital signatures, step by step and with practical tips.
How to delete all blank cells in Excel step by step
Learn how to delete blank rows, columns, and cells in Excel with several quick and safe step-by-step methods.
How to show hidden rows in Excel step by step
Learn all the ways to show hidden rows in Excel, including row 1 or column A. Clear guide with useful tips and shortcuts.
How to add the dollar symbol to Excel and get the most out of it
Learn how to use the dollar symbol in Excel as currency and in formulas, with shortcuts, Currency/Accounting formats, and tricks to lock cells.
How to draw in a Word document step by step
Learn to draw in Word: shapes, lines, digital ink, SmartArt and more to create clear and professional diagrams without leaving the document.
How to print a large image across multiple Word pages
Learn how to print a large image on multiple sheets using Word and other programs to create easy, high-quality homemade posters.
Types of pasting cells and content in Word tables
Master the different types of cell and content pasting in Word and Excel tables: lists, formulas, special paste, and advanced table properties.
How to merge and separate cells in Excel: a complete guide
Learn how to merge and separate cells in Excel, use Text in Columns and formulas with & to manage your data like a pro.
How to cite and reference in APA format
Learn how to cite and reference in APA 7 format easily, with clear examples of texts, books, websites, articles and more.
How to calculate mean, mode, and median in Excel step by step
Learn how to calculate mean, mode, and median in Excel with AVERAGE, MEDIAN, MODE.ONE and MODE.SEVERAL explained step by step with clear examples.
Formulas with arrays in Excel: a complete guide and practical examples
Master array and dynamic formulas in Excel with clear examples, tips, and advanced step-by-step uses.
Goal Seek function in Excel: complete guide and examples
Learn how to use Goal Seek in Excel with clear examples of loans, notes, and investments. Get the most out of What-If analysis, step by step.