Microsoft Office Home & Student 2021

Excel 2021 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.

With various new features and improvements, PowerPoint 2021 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 2021 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.