Microsoft Excel 2021 has a new look, it’s
cleaner and primed for use on tablets and phones. You can swipe and tap your
way through worksheets. You can analyses data more easily with FlashFill, use
recommend Pivot Table and Charting layouts and use Slicers now with filtered
lists. The Quick Analysis gallery allows a 1 click method to create tables, apply
conditional formatting, insert Sparkline and edit charts.
FlashFill
Excel
2021 notices patterns in the user's data entry and then auto completes the
remaining data so there’s no need to use formulas or macros to do this. Data
gets filled in automatically. Flash Fill is like a data assistant that quickly
finishes your work for you!
For example the Flash Fill feature will automatically complete a list of surnames after starting to type the second surname. It recognizes patterns and predicts what data to fill in for you. Start typing the initials and Flash Fill fills the list for you.
Flash
Fill also recognises text case. After typing a name in upper case, clicking
Flash Fill on the Data Ribbon fills all the rest of the names in upper case.
0 Comments