![]() Previously I had looked at Excel’s pivotable feature but I didn’t think it would be able to create an outline to match MM’s requirements without a lot of work, given its primary focus on statistical analysis. In effect the methods I proposed in my previous post suggested two ways around this problem – edit the spreadsheet to look more like an outline, or alternatively import it first to Word, adjust the table and apply Word heading styles. These tables are sometimes “flat” with no hierarchical information or alternatively they involve repetition of the higher-order elements mostly in the first column or two for example, a set of entries for an organisation’s workforce will involve the department and/or section name being repeated for each person in that section, usually in the first column or two.įaced with tables like this, MM has no way of knowing when each section begins or ends it needs some sort of outline structure, Word heading styles or a combination of both for the import process to be able to work out which items are main topics, sub-topics, sub-subtopics etc. Part of the problem with importing directory listings, catalogues and similar spreadsheets into MindManager (MM) is actually at the Excel end. Subsequently I developed an alternative approach using Excel pivotables which I first outlined on the Mindjet website forum, but I thought I would post an updated version outlining both methods. In an earlier post I described a method using Word heading styles to import spreadsheets and tables such as directory listings and catalogues via a Word table to create hierarchical MindManager (MM) maps with multiple levels. Part A looks at the import of standard (non-table based) Word documents, Part B specifically covers the topic discussed below – the import of non-task tables (and Excel spreadsheets) – while Part C describes how to import tables and spreadsheets containing task lists. Update: Recently I published a series of articles covering the import of a range of material from Word, outlining some techniques which update the methods discussed below.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |