Home

Intelligent Search for Fact Repository - Help please!

%3CLINGO-SUB%20id%3D%22lingo-sub-786162%22%20slang%3D%22en-US%22%3EIntelligent%20Search%20for%20Fact%20Repository%20-%20Help%20please!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-786162%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%20First%20post%20here%2C%20I%20recently%20started%20a%20new%20job%20and%20am%20tasked%20with%20building%20a%20%22fact%20repository%22%20of%20key%20messages%2C%20stats%2C%20facts%2C%20and%20any%20other%20relevant%20information%20when%20requested%20by%20others%20within%20the%20company.%20Its%20purpose%20is%20so%20anyone%20can%20open%20it%2C%20search%20for%20a%20very%20specific%20piece%20of%20information%20and%20see%20what%20document%20it%20is%20from%2C%20when%20it%20was%20approved%2C%20and%20more%20information%20if%20they%20want%20to.%20Essentially%20a%20google%20but%20I%20only%20have%20about%2050-75%20pages%20worth%20of%20information%20extracted%20from%20dozens%20of%20documents%20that%20is%20relevant.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPreviously%20we%20have%20used%20a%20word%20document%2C%20but%20it%20is%20getting%20to%20be%20~30%20pages%20long%2C%20and%20I%20thought%20I%20could%20put%20this%20information%20into%20excel%2C%20sorting%20it%20in%20a%20way%20that%20would%20make%20it%20easier%20to%20find%20information.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20essentially%20looking%20for%20a%20%22google%20function.%22%20I%20thought%20of%20adding%20key%20words%20under%20a%20heading%20attached%20to%20the%20paragraph%20describing%20what%20is%20actually%20in%20the%20paragraph%20which%20would%20enable%20a%20higher%20calibre%20of%20searching%20than%20simply%20searching%20for%20exact%20terms.%20It%20has%20to%20be%20smart%20because%20some%20people%20may%20put%20in%20synonyms%20or%20slightly%20different%20words%20which%20have%20the%20same%20meaning%20but%20would%20confuse%20the%20current%20search%20ability%20of%20excel.%20(Some%20older%20less%20technical%20people%20work%20here)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20realise%20it%20is%20somewhat%20confusing%2C%20but%20it%20is%20not%20a%20typical%20excel%20type%20document.%20I%20am%20not%20sure%20if%20Excel%20is%20even%20the%20best%20software%20for%20this%2C%20but%20if%26nbsp%3B%20someone%20thinks%20Word%20may%20be%20better%2C%20or%20another%20software%2C%20please%20let%20me%20know!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20really%20appreciate%20anyone's%20help%2C%20I%20want%20to%20learn%20and%20knock%20this%20out%20of%20the%20park!%20If%20you%20need%20any%20further%20details%20please%20comment.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-786162%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EIntelligent%20Search%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EQuery%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Esearch%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-787726%22%20slang%3D%22en-US%22%3ERe%3A%20Intelligent%20Search%20for%20Fact%20Repository%20-%20Help%20please!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-787726%22%20slang%3D%22en-US%22%3EPerhaps%20this%20blog%20post%20gives%20you%20some%20ideas%3F%20%3CA%20href%3D%22https%3A%2F%2Fblog.cometdocs.com%2Fbest-free-software-for-searching-through-multiple-word-excel-pdf-and-other-textual-files%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fblog.cometdocs.com%2Fbest-free-software-for-searching-through-multiple-word-excel-pdf-and-other-textual-files%3C%2FA%3E%3C%2FLINGO-BODY%3E
camthe1man
Occasional Visitor

Hello! First post here, I recently started a new job and am tasked with building a "fact repository" of key messages, stats, facts, and any other relevant information when requested by others within the company. Its purpose is so anyone can open it, search for a very specific piece of information and see what document it is from, when it was approved, and more information if they want to. Essentially a google but I only have about 50-75 pages worth of information extracted from dozens of documents that is relevant.

 

Previously we have used a word document, but it is getting to be ~30 pages long, and I thought I could put this information into excel, sorting it in a way that would make it easier to find information.

 

I am essentially looking for a "google function." I thought of adding key words under a heading attached to the paragraph describing what is actually in the paragraph which would enable a higher calibre of searching than simply searching for exact terms. It has to be smart because some people may put in synonyms or slightly different words which have the same meaning but would confuse the current search ability of excel. (Some older less technical people work here)

 

I realise it is somewhat confusing, but it is not a typical excel type document. I am not sure if Excel is even the best software for this, but if  someone thinks Word may be better, or another software, please let me know!

 

I would really appreciate anyone's help, I want to learn and knock this out of the park! If you need any further details please comment.

1 Reply
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies