My favorite keyboard shortcuts to teach: Excel Shortcut to build Excel Charts: Highlight the data for the chart Then press function key “F11”. Windows Shortcut to Minimize All Windows: Hold the Windows Key then press the “M” key. Internet Explorer Shortcut to put in the “www.” And “.com”: Click in the Address bar, Type name, […]
You can now expand the formula bar to read more of your complex calculations. To expand, hover your mouse on the border of the formula bar. When you see the double sided arrow, left click + hold and drag it down. When you’re done, double click your border to fit it back. See image example […]
Sometime we get a data list that contains a combined name, i.e. Cooper, Robin. We want to split that long list as easily as possible. (image example below) Excel 2007 Highlight the range, go to the Data tab, and click the “Text to Columns” button, and follow the prompts. It is delimited by a comma. […]
Recent Comments