Minitab Tips and Tricks: Top 10 Countdown Finale
The countdown on my favorite Minitab tips and tricks continues. If you missed tips #6-#10, check out my previous blog.
Coming in at #5, the answer to last blog's trivia quiz:
Export a Minitab graph to PowerPoint
You won't believe how easy this is. Right-click any graph you've created in Minitab and choose Send Graph to Microsoft PowerPoint. You don't even need to open PowerPoint. Minitab does it all for you--like magic. (You can send it to Word, too!)
Clear a dialog box
If you got burned, it’s time to wipe the slate clean. Press F3 to clear a Minitab dialog box and return it to default settings.
Customize Minitab menus and toolbars
Choose Tools > Customize to modify the Minitab interface to suit your needs. Add, delete, move, or edit menu or toolbar items. Create or edit menus or toolbars. Add items that link to executable or macro files. Set new keystrokes for commands.
Go to the dialog box you last used
Press Ctrl+E to return to the dialog box you used most recently. This is a quick and easy way to rerun your most recent analysis if you want to modify the settings and try it again.
And, without further adieu, my number 1 tip, which is appropriately paired with a hit from one of the top recording artists of all time.
Open Excel files in Minitab
If you’ve been copying and pasting your data, or worse yet, manually re-entering your data, from Excel into Minitab, this tip might make you cry. Over the years, Minitab and Excel have come to understand each other better and better. And their relationship promises to only get deeper and more harmonious as time goes on.
To directly open Excel files in Minitab, File > Open Worksheet. From Files of Type choose Excel (*.xls; *.xlsx).
The worksheet above opened in Minitab exactly as shown on the right, with no adjustments needed. Depending how your data are formatted in Excel, you might have to tweak the data after you open the worksheet in Minitab. You can also click Options or Preview to specify how to import and format the imported data correctly.
I’ll sign off now. I hope these tips have been helpful, and that the associated hit tunes weren’t too painful to recall. Just remember, as you use Minitab, to “Keep your feet on the ground and keep reaching for the stars…”
Note: There are many more tips and tricks you can use with Minitab Statistical Software. Check out this larger list of advanced tips compiled by Minitab’s Technical Support Specialists.