Learn 13 time saving tips to speed up data entry in Microsoft excel. Many keyboard shortcuts to make your job more efficient
Archive of posts tagged excel
Types of Excel Sheets
Learn what are four types of sheets available in Microsoft Excel: Worksheets, Chart sheets, MS Excel 4.0 macro sheets and MS Excel 5.0 dialog sheets.
What is Excel Workspace
Learn what is Excel Workspace and how it can help you to save your time from reopen the same excel files, excel windows settings again and again.
Microsoft Skip version 13th in Excel | Excel Versions History
Excel 2010 is actually Excel 14 in disguise. You may think that this name represents the 14th version of Excel. Think again. Microsoft may be a successful company, but its version-naming techniques can prove quite confusing. As you’ll see, Excel 2010 actually represents the 11th Windows version of Excel.
Enable full toolbars and menus in Excel
Stop wasting time in clicking Excel’s toolbar options button, access to options that are currently hidden by displaying all toolbars and menus.
Moving around excel spreadsheet with Ctrl, Shift and Arrow Keys
Learn to be more efficient working with Excel. Navigating and selecting cells can be so much simpler if you know the shortcuts. These tips save you from scrolling up and down, left and right. You will love it!
Show only columns and rows you interested
Tips to prevent certain information from being seen in excel. How to hide or unhide columns or rows so that it simplify the spreadsheet view area when you are working on a large worksheet. This is alternative trick if you dont have a big screen or monitor.
Split windows and freeze spreadsheet panes
Learn how to get more viewing space for Ms Excel. By easy the freeze panes and split windows help you to scrolls the rows and columns to save your time when dealing with spreadsheets.
The use of Excel template: Saving Custom Display Settings
Save your time by create an excel template to store the display settings that you find yourself manually changing over and over again such as insert additional worksheet, remove gridlines, and select new standard column width
Modify worksheet gridlines for better appearance
Avoid confusing gridlines for excel online forms and presentations with embedded charts and assign new color to gridlines for easier to read excel worksheets