If you need to list and track information collaboratively, Microsoft Lists is designed to give you the kind of lists many people manage in Excel, with more list-specific options and less complexity. SEE: Excel power user guide (TechRepublic Premium) If you want to make sure someone updating your spreadsheet can’t accidentally delete a column when they’re trying to hide it, you need to take the time to lock cells and password protect the worksheet. You can collaborate with colleagues live in Excel very effectively, but it only works if you keep that Excel file in SharePoint Online or OneDrive. Plus, managing shared Excel files can be complex. Many spreadsheets are just clever lists made by users who may find the full power of Microsoft Excel a bit more than they actually need. But that kind of shadow IT is hard to manage and support, which is why organizations are increasingly shifting to low code options like the Microsoft Power Platform to replace spreadsheets that should really be an app. Using spreadsheets as databases is ubiquitous, often combined with functions to create applications that calculate salaries, forecast sales, manage production systems and track assets. For more info, visit our Terms of Use page. This may influence how and where their products appear on our site, but vendors cannot pay to influence the content of our reviews. We may be compensated by vendors who appear on this page through methods such as affiliate links or sponsored partnerships. Also, Microsoft Lists is now available on Android. Microsoft Lists doesn’t replace Microsoft To Do or Planner, but it might edge out Excel for information management.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |