Tools for your journey
Hugh Jackman nerding out in Swordfish

Tools for your journey

In case you missed it. A tool to democratize knowledge for knowledge workers.

https://github.com/Dan-OSU/Office-space-reference-sheets/blob/main/Office-space-cheat-sheet.xlsx


https://github.com/Dan-OSU/office-desk-reference-sheets


https://github.com/Dan-OSU/Coder-reference-sheets/


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)

?

For coders: Dan-OSU/Coder-reference-sheets: How to do the things (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

Bruce Olson

Building the first AI native GOVCON BD team | Defense Innovation Base | Air Force Veteran

11 个月

Yes, let's do it!

要查看或添加评论,请登录

Dan Rust, JD, CFE的更多文章

  • The Chewbacca Defense to War

    The Chewbacca Defense to War

    President Trump has made it clear he wants to take over Greenland. In recent days, this has expanded to wanting to…

  • The Missing Guardians

    The Missing Guardians

    Where is your fighting spirit, America? You have fought your fair share of wars, and for your unfair share of reasons…

  • Changing the Air Force for dummies

    Changing the Air Force for dummies

    Change is hard, but let's get right to it. If you're not on AFNET, you'll need middleware.

  • Call with 9-HI platform

    Call with 9-HI platform

    I had a really cool call with David Mroczka of AI Strategy Corporation last week. In a nutshell, they optimize your…

  • More comfortable uniforms needed for great power competition

    More comfortable uniforms needed for great power competition

    What, yall thought I was done? https://vision.il4.

    1 条评论
  • PS Script for your office

    PS Script for your office

    You're going to want this. It works.

  • Desk sheets for you to reference in your office space.

    Desk sheets for you to reference in your office space.

    Do you ever wake up and wish you were a badass hacker like Hugh Jackman in Swordfish? Me too. I can't make you that…

  • Petition to kill cable news in DoD workcenters and common areas

    Petition to kill cable news in DoD workcenters and common areas

    Synopsis Cable news channels are ubiquitous in DoD work centers and common areas. They are exceedingly biased.

    16 条评论
  • King Claude

    King Claude

    I've been using Claude by Anthropic for about a year. Just superb.

  • Overwatch: the Masters of Time

    Overwatch: the Masters of Time

    DAF, view and contribute on Vision here. Synopsis A centralized unit that kills all the loose ends (old broken…

社区洞察

其他会员也浏览了