Microsoft Office 2019 Home & Business PC

Excel 2019 offers powerful data analysis features. It includes new text and array functions, dynamic arrays for flexible charting, and faster, more stable workbooks. You can use the new LAMBDA function to create custom functions for commonly used formulas and the IMAGE function to insert pictures without changing the formatting. There are also 14 new functions to extract and split text strings, combine, reshape, resize, and select arrays. The Dynamic Arrays in charts allow you to visualise datasets of variable length. The charts automatically update when the array recalculates. Enhanced security, such as blocking XLL add-ins, helps protect against malware.

In Office 2019, you can easily recover your document to the latest changes if the app unexpectedly closes, allowing you to pick up right where you left off. Collaboration is even easier with modern comment features, the ability to delete all resolved comments with one click, and convenient mode switching. Word now supports OpenDocument format (ODF) 1.4, enabling multiple new features such as tables in shapes, lists from zero, non-overlapping images and shapes, decorative objects, and more.

With various new features and improvements, PowerPoint 2019 is more compelling than ever. It now supports inserting a live camera feed using cameo directly on the slide and applying the same effects to it as for the other objects. You can record your presentation, including voice, ink movements, and presenter’s presence, and export it as a video file. You can add MS Stream videos and benefit from the numerous PDF accessibility improvements. Working with others has never been easier, thanks to the modern commenting features enhancing the user experience.

The personal digital notebook, OneNote, allows you to type, write, or draw notes and insert images, audio, or video clips from the web. Now, OneNote 2019 offers better navigation through your notes, enhanced Quick Notes features, a pen-focused view to minimise distraction, improved inking features and a Draw tab experience. Users can also enjoy more options for their drawing tools and better organisation of the instruments.