Tag: excel
-
Excel Keyboard Shortcuts
Action Shortcut Bold the selection Ctrl+B Italicize the selection Ctrl+I Underline the selection Ctrl+U Strike through the selection Ctrl+5 Open the Style dialog box Alt+’ Open the Format Cells dialog box Ctrl+1 Apply the General format Ctrl+Shift+~ Apply the Currency format Ctrl+Shift+$ Apply the Percentage format Ctrl+Shift+% Apply the Date format Ctrl+Shift+# Apply…
-
Using VLookup for Excel
Credit – gcflearnfree.org How to use Excel’s VLOOKUP function Many of our learners have told us they want to learn how to use Excel’s VLOOKUP function. VLOOKUP is an extremely useful tool, and learning how to use it is easier than you think! Before you start, you should understand the basics of functions. Check out our…
-
Microsoft Excel Spreadsheet Tips
Excel Tips How to Add Characters to the Beginning of a Cell Entry: =”#”&A1 *A1 is the cell location * Adding a # symbol in front of the cell entry ________________________________________ How to Add Characters to the End of a Cell Entry: =A1&”-LTX” *A1 is the cell location *Adding -LTX to the end of…