Once you have created a macro, you can activate it in one click by adding it to the Quick Access Toolbar Click on the arrow at the end of the Quick Access toolbar and choose More Commands. This will open
Adding Macros to the Quick Access Toolbar in Excel Read Post »
You can quickly sum a block of data (both Rows and Columns) in Excel with just one click. Start by selecting the data including the cells that will contain the SUM Formulas. (in our example Column E and Row 11)
Microsoft Excel: Quick Sum a Data Range Read Post »
Filling down an Excel Formula in a column can be quickly achieved by positioning the cursor on the lower right corner of the cell and Double Clicking. The formula will repeat to the end of the data. For more ways
Double Click to Fill Down a Microsoft Excel Formula Read Post »
Hiding certain rows or columns in Excel can make viewing complex, detailed information easier to read. Grouping Rows in Excel allows you to quickly collapse and expand similar data to create more useful views. Select the rows with similar data
Grouping Rows in Excel Read Post »
Have you ever imported data that was in all caps, or all lower case? There is a quick trick for capitalizing the first letter of each word in Excel. =Proper(Cell) formula in Excel In this example, I copy and pasted
Capitalizing the first letter of each word in Excel with the Proper function Read Post »
Want to see what your Word document would look like on the web? It’s simple: Click the “Web Layout” command on the “View” tab, in the “Views” group. To create polished Documents, take a Word training course from AETC!
Word: “Web Layout” Read Post »
Applying Conditional Formatting to your data allows you to identify variances in a range of data with a quick glance, by highlighting the differences or trends that you specify. You can customize the process by creating your own rules to
Microsoft Excel: Conditional Formatting for Understanding Data Read Post »
You can easily and quickly add captions to a picture, table or equation. Once you have created the caption you can cross reference it anywhere in the document. The ‘Insert Caption’ command is located in the Reference tab, in the
Word: Quickly Adding Captions Read Post »
You can use the Status Bar to display useful information. Right click the bottom bar of your document to make the Status Bar settings pane appear. Select the options you want shown. Then click outside the Status Bar setting pane.
Use the Status Bar to Display Useful Information Read Post »
Word allows you to write out equations right in the text field, as well as find out what the equation’s total is. You only need to set up Calculator. To do this, go to File Options Quick Access toolbar. Select
Bring Calculator right into Word Read Post »
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
