Most useful Microsoft Office skills (Excel) for the Military ?

2020-07-04T14:43:13-04:00

Response by Sgt Private RallyPoint Member made Jul 4 at 2020 3:01 PM

2020-07-04T15:01:01-04:00

CPT Private RallyPoint Member Excel is useful to know along with Word and PowerPoint for military and civilian careers.

Response by LTC Jason Mackay made Jul 4 at 2020 3:09 PM

2020-07-04T15:09:00-04:00

EXCEL: Building trackers and tools to turn exported data from Army information systems into usable information, with an eye to reduce the adjustment, reconfiguration, interpretation and other nug work.
Pivot Tables
Vertical Lookup Tables
Formatted lists and drop down menus
Count number of
Calculating "get wells" and tipping points
Structuring of data as much as possible

POWER POINT: is a display tool, but anything you can do to pipe data in with links etc so you don't spend your decision cycle nugging things into a display format.
Linking EXCEL and PPT slides
Structuring/Pre Formatting so all you have to do is cut and paste

MS WORD: how to write a standard Army memo ala AR25-50 with he sacred memo template and letterhead. How to write a white paper, info paper, FLIPL findings, staff studies, other standard Army documentswhile getting word to take the format tasks without you spending time on it.
Saving custom formats
Creating custom templates
Integrating Tables, excel output, diagrams and pictures without everything going sideways

Response by MAJ Ken Landgren made Jul 4 at 2020 7:09 PM

2020-07-04T19:09:00-04:00

I used Excel for POCs and phone numbers. That was very handy.

Response by SSG Roger Ayscue made Jul 4 at 2020 9:55 PM

2020-07-04T21:55:40-04:00

POWERPOINT....No briefing is complete without it

Response by Lt Col Jim Coe made Jul 5 at 2020 8:58 AM

2020-07-05T08:58:07-04:00

Learn how to make charts. Leaders like pictures. Charts allow you to summarize and display complicated data in an understandable form, exactly what leaders need. Also learn how to link charts to PowerPoint.