Excel is one of best essential tool in a every office, It have lot of advantages and futures. It reduce work burden. Help to keep in work 100% accurate.
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of the Microsoft Office suite of software.
Go end to Download PDF file - Excel
Advantages :
- Easy to handle bulk data.
- 100% accurate result.
- Easy to prepare any kind of chart and table.
Buy
Microsoft Excel is have lot of shortcut key code, when ever you learn it you're successes in your filed. No need to learn entire code, only learn basic codes, like
General Program Shortcuts
First, let’s take a look at some general keyboard shortcuts for manipulating workbooks, getting help, and a few other interface-related actions.
- Ctrl+N: Create a new workbook
- Ctrl+O: Open an existing workbook
- Ctrl+S: Save a workbook
- F12: Open the Save As dialog box
- Ctrl+W: Close a workbook
- Ctrl+F4: Close Excel
- F4: Repeat the last command or action. For example, if the last thing you typed in a cell is “hello,” or if you change the font color, clicking another cell and pressing F4 repeats that action in the new cell.
- Shift+F11: Insert a new worksheet
- Ctrl+Z: Undo an action
- Ctrl+Y: Redo an action
- Ctrl+F2: Switch to Print Preview
- F1: Open the Help pane
- Alt+Q: Go to the “Tell me what you want to do” box
- F7: Check spelling
- F9: Calculate all worksheets in all open workbooks
- Shift+F9: Calculate active worksheets
- Alt or F10: Turn key tips on or off
- Ctrl+F1: Show or hide the ribbon
- Ctrl+Shift+U: Expand or collapse the formula bar
- Ctrl+F9: Minimize the workbook window
- F11: Create a bar chart based on selected data (on a separate sheet)
- Alt+F1: Create an embedded bar chart based on select data (same sheet)
- Ctrl+F: Search in a spreadsheet, or use Find and Replace
- Alt+F: Open the File tab menu
- Alt+H: Go to the Home tab
- Alt+N: Open the Insert tab
- Alt+P: Go to the Page Layout tab
- Alt+M: Go to the Formulas tab
- Alt+A: Go to the Data tab
- Alt+R: Go to the Review tab
- Alt+W: Go to the View tab
- Alt+X: Go to the Add-ins tab
- Alt+Y: Go to the Help tab
- Ctrl+Tab: Switch between open workbooks
- Shift+F3: Insert a function
- Alt+F8: Create, run, edit, or delete a macro
- Alt+F11: Open the Microsoft Visual Basic For Applications Editor
இங்கு பதிவிடப்படும் புத்தகங்கள் குறித்த தங்களின் கருத்துக்கள் அந்த புத்தகத்தினை பலருக்கு அறிமுகப்படுத்துவதோடு படிக்கும் ஆர்வத்தினையும் தூண்டும்...