Tools for your journey
Dan Rust, JD, CFE
Dan is a multifaceted innovator whose expertise spans psychological safety, military leadership, legal practice, innovation management, and technological advancement.
In case you missed it. A tool to democratize knowledge for knowledge workers.
It's good for corporate work, but here's the DoD change request.
"Vision" initiative: https://vision.il4.afwerx.dso.mil/initiatives/3870
Synopsis
I've compiled an Excel workbook based on many cheat sheets for common applications, including Office 365, Windows 10/11, etc.? It is mostly keystrokes / hotkeys, but there are other useful bits like SharePoint and Power Automate.? It has a How-to on the first worksheet.? Most importantly, it has pivot tables and slicers so you can easily search or select filters to find what you're looking for.??
?
Problem
DoD workers use Microsoft software and related programs with limited degrees of efficiency throughout their day. We pay substantial contracts for fancy new software suites like Envision (not to be confused with Vision), yet they remain under-utilized. Units and shops continue to make their dashboards and trackers using Excel, while the fancy tailor-made applications languish in their redundant silos. Imagine how much more efficient workers would be if they were using these standard office applications at 70% mastery instead of 30%.
Solution
I've already gotten the ball rolling. Here are some cheat sheets (ironically made with Excel) for how to go from zero to hero with common office applications. Users can use the "how-to" sheet to see how they can fit the tools to their needs. By using the included pivot tables and clicking on the slicer filter's drop-down, users can quickly search for keyboard commands and other useful application-specific bits. They can also simply click on sub-filters in the slicers' main fields, and automatically have the pivot tables pare down to the selected criteria. Users can change it up as needed, or add new information by "unhiding" the data table worksheets. Also included in the repositories are the many PDF cheat sheets that I've based the Excel cheat sheet workbook on.
By putting these cheat sheet worksheets and PDFs on every worker's desktop, as we do with the AF Handbook, we can instantly empower our workers to be significantly more efficient with what they do every day. In so doing, they will inevitably become more software-literate. They will become more accepting and capable with more nuanced systems such as Envision. We as a force will pave new paths and realize what we actually need to move the ball forward rather than stagnate or regress.
?
Here is my work with the PDFs and Excel pivot tables / slicers:
For office workers: Dan-OSU/Office-space-reference-sheets: Reference sheets for common office programs (github.com)
?
?
Here's what the files look like in the latter. ?I've also added some of these in the Files tab.?
?
$ tree /f
README.MD
code
??data-analysis
??????AutomateExcel-VBA-Cheatsheet.pdf
??????awesome-excel-STMCyber.pdf
??????awesome-ML.pdf
??????awesome-power_BI.pdf
??????cpearson-reference-site.pdf
??????data-science-cheat-sheet.pdf
??????discrete-math.pdf
??????Getting-Started-with-Pandas-Cheatsheet-KDnuggets.pdf
??????machine-learning-cheat-sheet.pdf
??????ML-cheat-sheet.pdf
??????Power+BI_Cheat+Sheet.pdf
??????PowerBI_Cheatsheet_Zero_To_Mastery_V1.01.pdf
??????Tips and tricks.xltx
??
??fun
??????which-programming-language-should-i-learn-first-infographic.png
??????which-programming-language-should-i-learn-first-pdf.pdf
??
??git
??????awesome-git-other.pdf
??????awesome-git.pdf
??????github-cheat-sheet.pdf
??????github-git-cheat-sheet.pdf
??
??GUI-programs-ie-365
??????power-automate-desktop-actions.pdf
??
??html-css
??????CSS Cheat Sheet??A Basic Guide to CSS??GeeksforGeeks.pdf
??????css2.pdf
??????font-awesome.pdf
??????HTML Cheat Sheet Geeks 4 Geeks.pdf
??????html5-cheat-sheet.pdf
??
??Large-language-models
A-Guide-to-Crafting-Clear-and-Effective-Prompts.md
??????Awesome-ChatGPT-Prompts.pdf
??????awesome-copilot.pdf
??????awesome-prompt-engineering.pdf
??????The Ultimate AI Tool Kit.pdf
??????Ultimate Prompt Engineering Guide.pdf
??
??python
??????awesome-data-science.pdf
??????awesome-power-bi.pdf
??????awesome-python.pdf
??????Essential Python Cheat Sheet.pdf
??????Geeks 4 Geeks Python Tutorial Learn Python Programming Last Updated?03 Apr 2024.pdf
??????jupyter-notebook.pdf
??????NumPy-Cheat-Sheet.pdf
??????numpy-geeks4geeks.pdf
??????PyCharm_ReferenceCard.pdf
??????Python Cheat Sheet.pdf
??????Python-Cheat-Sheet-by-CodeConquestDOTcom.jpg
??????Python-Cheat-Sheet-by-CodeConquestDOTcom.pdf
领英推荐
??????python-geeks4geeks.pdf
??????python-string-cheatsheet-coloured.pdf
??????Python_Basics_Cheat_Sheet-updated.pdf
??????string cheatsheet coloured.pdf
??
??rust-lang
??????Rust-Essentials.pdf
??
??txt-markdown
??????Markdown.pdf
??
??vim
??????Ideavim - NERDTree Cheat Sheet.pdf
??????vim-reference-guide.pdf
??????vimqrc.pdf
??
??visual basic
??????Awesome-VBA.pdf
??????awesome-visual-basic.pdf
??????awesome_VBA.pdf
??????vba-reference.pdf
??????VBA.pdf
??????Visual-Basic-statements-ref.pdf
??
??web
??????coffeescript.pdf
??????JavaScript.pdf
?
linux
????Linux command Cheat Sheet.pdf
????Linux Commands Cheat Sheet?Beginner to Advanced.pdf
????linux-command-line.pdf
????Shell Scripting Cheat Sheet for Linux and Unix.pdf
?
maths
????Calculus_Cheat_Sheet_All.pdf
????Common_Derivatives_Integrals_Reduced.pdf
????discrete-math.pdf
????logical_equivalences.png
?
network-security
????VLANs.pdf
?
office-work
??visual basic
??????Awesome-VBA.pdf
??????awesome-visual-basic.pdf
??????awesome_VBA.pdf
??????vba-reference.pdf
??????VBA.pdf
??????Visual-Basic-statements-ref.pdf
??
??Windows-other
??????awesome-power-platform.pdf
??????awesome-powerpoint.pdf
??????awesome-powerquery.pdf
??????power-automate-desktop-actions.pdf
??????vba-tips.pdf
????
????VBA-Tutorials
????????PowerPoint-VBA-Tutorial.pdf
????????VBA-Tutorial.pdf
????????Word-VBA-Tutorial.pdf
?
Pivot-table-ized-refs
????Coder_reference-sheets.xlsx
????Office-space-cheat-sheet.xlsx
????old-v1_Reference-sheets.xlsx
?
random
????access+vba.pdf
????awesome-excel-1.pdf
????Creative Routines??Info We Trust.pdf
????creative-routines-edit4-scaled.png
????Creative-Routines-Info-We-Trust.png
????Creative-Routines_RJ-Andrews-MOZART.png
????excel-tips-tricks.pdf
????git-cheat-sheet-education.pdf
????musictheory.pdf
????neuralnetworks.png
????the-meaning-of-life-philosophers.png
????transitioning-servicemembers.pdf
????wwysydh.gif
?
DAF members can discuss in the Innovation Teams team: https://dod.teams.microsoft.us/l/message/19:dod:[email protected]/1713196254189?tenantId=8331b18d-2d87-48ef-a35f-ac8818ebf9b4&groupId=f6b8b0a0-8a66-4719-9857-c70eb02bfe08&parentMessageId=1713196254189&teamName=DAF%20Innovation&channelName=Vision%2C%20idea%20submissions%20board&createdTime=1713196254189
Building the first AI native GOVCON BD team | Defense Innovation Base | Air Force Veteran
11 个月Yes, let's do it!