3
3
0
More than not I see Soldiers/Officers/Civilians fiddling around in Microsoft Excel (one of our most used programs in the microsoft suite outside of outlook) and wasting hours upon hours trying to accomplish simple tasks. Use this forum to post your good news stories, horror stories, or helpful hints in Microsoft Excel. I am fluent in the program an will answer all excel related questions that have me tagged in it.
**Excel Time Saver TIP of the Day** - If you have imported a list of Soldiers or any information that may have a few pieces of informaiton all in one collumn (first name, last name, SS# etc.) that you wish to seperate you can easily do this by by clicking the "Text to Collumns" button, found in the Data tab, Data Tools in your ribbon (the top bar). This tool is simple to use by may be scary at first. Try it out and if you have any questions please post below.
**Excel Time Saver TIP of the Day** - If you have imported a list of Soldiers or any information that may have a few pieces of informaiton all in one collumn (first name, last name, SS# etc.) that you wish to seperate you can easily do this by by clicking the "Text to Collumns" button, found in the Data tab, Data Tools in your ribbon (the top bar). This tool is simple to use by may be scary at first. Try it out and if you have any questions please post below.
Time Management
Army
Efficiency
Edited >1 y ago
Posted >1 y ago
Responses: 7
2
2
0
Here's a quick tip that often surprises me when someone doesn't know it: If you want to see a quick sum or average of a set of cells without creating a formula, just highlight the group of cells. There will be an average, a sum, and a count of the number of cells highlighted at the bottom right of the window.
(2)
(0)
CPT Jacob Swartout
Nice, I just tried this and never noticed this feature. Now I know and will remember to use it when needed. Thanks SGT Richard H.
(0)
(0)
SGT Richard H.
You're very welcome, Sir. I've been an Excel junkie for years and I can't tell you how long I overlooked that simple little trick!
(0)
(0)
1
1
0
**Tip of the week** - Unless you are sending an excel file to someone for them to input data export it as a PDF first. Goto File and Export to PDF to send a clean, professional, and un-editable file for others to view.
(1)
(0)
1
1
0
#1 Rule of Excel Club: You do not talk about Excel Club, unless if you want to get stuck in the S3.
#2 Rule of Excel Club: You DO NOT talk about Excel Club, unless if you want to get stuck in the God-dang S3.
#2 Rule of Excel Club: You DO NOT talk about Excel Club, unless if you want to get stuck in the God-dang S3.
(1)
(0)
SGT William B.
All kidding aside sir, it's a great thing. I've seen guys complain about the "nerds that do office-b**** stuff", and I never understood the hate. If I had to do statistical and metric analysis manually, those same guys would be stuck on a detail helping me write out and graph spreadsheets by hand so I could have them ready for the battalion commander by 1300.
(0)
(0)
Read This Next
Continue with Facebook 
Continue with Google