I have been trying to use Mac's numbers as replacement to traditional Microsoft office Excel applications. However, I feel few restrictions while using the applications and Excel application was comparatively eased to use. Let me list down the constraints I faced while using Numbers in MAC system and how Apple can address these concerns to help users like me to migrate completely from Excel application to Numbers.
- Lack of Sort & Filter options: For most times, I feel frustrated, without filter and sort options and most times I export file as Excel to sort or filter rows to make informed decision. I understand Numbers support sort & filter options, but those options are mostly complicated and hard to use to extract insights from the data.
- Copy/paste with Transpose option: Excel has unique possibility to convert rows into columns and vice versa, while copy & transforming the data into the Sheets. However, Numbers lack this feature and often I import the data into rows or columns from Excel into Numbers to make business insights
- Customizing Toolbar: While working in Excel, the ribbon includes all-most complete set of functions are available with touch of a button. However, in Numbers it usually takes a while to get used to the functions and few functions are little bit complicated to get used to it.
Above are all my observations while using Numbers on my Mac and Excel applications with similar requirements and on same data sheets. Hope, Apple produces a unique solution to address above constraints and enable users like me to completely port to Numbers. For more such articles, please feel free to check out the G R Team Sites.