Excel Shortcut Keys

Ctrl + Shift + ;    Enter the current time.
Ctrl + ;        Enter the current date.
Alt + Shift + F1    Insert New Worksheet.
Alt + Enter    While typing text in a cell, pressing Alt + Enter will move to the next line, allowing for multiple lines of text in one cell.
Shift + F3    Open the Excel formula window.
Shift + F5    Bring up search box.
Ctrl + 1        Open the Format Cells window.
Ctrl + A        Select all contents of the worksheet.
Ctrl + B        Bold highlighted selection.
Ctrl + I        Italic highlighted selection.
Ctrl + K        Insert link.
Ctrl + Z        Undo last action.
Ctrl + F3    Open Excel Name Manager.
Ctrl + F9    Minimize current window.
Ctrl + F10    Maximize currently selected window.
Ctrl + F6    Switch between open workbooks or windows.
Ctrl + Page up    Move between work sheets in the same document.
Ctrl + Page down    Move between work sheets in the same document.

Ctrl + Tab    Move between Two or more open Excel files.
Alt + =        Create a formula to sum all of the above cells.
Ctrl + '        Insert the value of the above cell into the cell currently selected.
Ctrl + Shift + 1    Format number in comma format.
Ctrl + Shift + 4    Format number in currency format.
Ctrl + Shift + 3    Format number in date format.
Ctrl + Shift + 5    Format number in percentage format.
Ctrl + Shift + 6    Format number in scientific format.
Ctrl + Shift + 2    Format number in time format.
Ctrl + Arrow key     Move to next section of text.
Ctrl + Space    Select entire column.
Shift + Space    Select entire row.
Ctrl + -     Delete the selected column or row.
Ctrl + Shift + =    Insert a new column or row.
Ctrl + Home    Move to cell A1.
Ctrl + ~    Switch between showing Excel formulas or their values in cells.
Ctrl + S        Save the open worksheet.
Ctrl + U        Underline highlighted selection.
Ctrl + 1        Change the format of selected cells.
Ctrl + 5        Strikethrough highlighted selection.
Ctrl + P        Bring up the print dialog box to begin the printing process.
F2        Edit the selected cell.
F3        After a name has been created, F3 will paste names.
F4    Repeat last action. For example, if you changed the color of text in another cell, pressing F4 will change the text in cell to the same color.
F5        Go to a specific cell. For example, C6.
F7        Spell check selected text or document.
F11        Create chart from selected data.

 

MS-Word Shortcut Keys

Ctrl + A    Select all contents of the page.

Ctrl + B    Bold highlighted selection.
Ctrl + C    Copy selected text.
Ctrl + D    Open the font preferences window.
Ctrl + E    Aligns the line or selected text to the center of the screen.
Ctrl + F    Open find box.
Ctrl + I     Italic highlighted selection.
Ctrl + J     Aligns the selected text or line to justify the screen.
Ctrl + K    Insert a hyperlink.
Ctrl + L    Aligns the line or selected text to the left of the screen.
Ctrl + M   Indent the paragraph.
Ctrl + N    Opens new, blank document window.
Ctrl + O    Opens the dialog box or page for selecting a file to open.
Ctrl + P     Open the print window.

Ctrl + R    Aligns the line or selected text to the right of the screen.
Ctrl + S     Save the open document. Just like Shift + F12.
Ctrl + T     Create a hanging indent.
Ctrl + U    Underline the selected text.
Ctrl + V    Paste.
Ctrl + W   Close the currently open document.
Ctrl + X    Cut selected text.
Ctrl + Y    Redo the last action performed.
Ctrl + Z    Undo last action.
Ctrl + 1    Single-space lines.
Ctrl + 2    Double-space lines.
Ctrl + 5    1.5-line spacing.

Ctrl + F1  Open the Task Pane.

Ctrl + F2    Display the print preview. 

Ctrl + Shift + L   Quickly create a bullet point.
Ctrl + Alt + 1      Changes text to heading 1.
Ctrl + Alt + 2      Changes text to heading 2.
Ctrl + Alt + 3      Changes text to heading 3.
Alt + Ctrl + F2    Open new document.
Ctrl + Shift + >    Increases the selected text size by one.
Ctrl + Shift + <    Decreases the selected text size by one.
Ctrl + Shift + F6   Switches to another open Microsoft Word document.

Ctrl + Shift + F12    Prints the document.
F1        Open Help.
F4        Repeat the last action performed (Word 2000+)
F5        Open the Find, Replace, and Go To window in Microsoft Word.
F7        Spellcheck and grammar check selected text or document.
F12      Save As.

 

 

Linux Shortcut Keys

Keyboard shortcut keys

CTRL+B    Moves the cursor backward one character.

CTRL+C    Cancels the currently running command.

CTRL+D    Logs out of the current session.

CTRL+F     Moves the cursor forward one character.

CTRL+H    Erase one character. Similar to pressing backspace.

CTRL+P     Paste previous line(s).

CTRL+S      Stops all output on screen (XOFF).

CTRL+Q    Turns all output stopped on screen back on (XON).

CTRL+U    Erases the complete line.

CTRL+W    Deletes the last word typed. For example, if you typed 'mv file1 file2' this     shortcut would delete file2.

CTRL+Z        Cancels current operation

Command line shortcuts

~        Moves to the user's home directory.

!!    Repeats the line last entered at the shell. See history command for previous   commands.           

!$        Repeats the last argument for the command last used. See history command      for previous commands.

 

Mac Shortcut Keys

Document shortcuts

Command-B    Boldface the selected text, or turn boldfacing on or off.

Command-I    Italicize the selected text, or turn italics on or off.

Command-U    Underline the selected text, or turn underlining on or off.

Command-T    Show or hide the Fonts window.

Command-D    Select the Desktop folder from within an Open dialog or Save dialog.

Control-Command-D    Show or hide the definition of the selected word.

Option-Delete    Delete the word to the left of the insertion point.

Control-H    Delete the character to the left of the insertion point. Or use Delete.

Control-D    Delete the character to the right of the insertion point. Or use Fn-Delete.

Control-K    Delete the text between the insertion point and the end of the line or paragraph.

Command-Delete    Select Delete or Don't Save in a dialog that contains a Delete or Don't Save button.

Command–Up Arrow    Move the insertion point to the beginning of the document.

Command–Down Arrow    Move the insertion point to the end of the document.

Command–Left Arrow    Move the insertion point to the beginning of the current line.

Command–Right Arrow    Move the insertion point to the end of the current line.

Option–Left Arrow    Move the insertion point to the beginning of the previous word.

Option–Right Arrow    Move the insertion point to the end of the next word.

Shift–Command–Up Arrow    Select the text between the insertion point and the beginning of the document.

Fn-Delete    Forward delete on keyboards that don't have a Forward Delete   key. Or use     Control-D.

Fn–Up Arrow    Page Up: Scroll up one page.

Fn–Down Arrow    Page Down: Scroll down one page.

Fn–Left Arrow    Home: Scroll to the beginning of a document.

Fn–Right Arrow    End: Scroll to the end of a document

Option–Shift–Up Arrow    Extend text selection to the beginning of the current paragraph, then to the beginning of the following paragraph if pressed again.

Option–Shift–Down Arrow    Extend text selection to the end of the current paragraph, then to the end of the following paragraph if pressed again.

Option–Shift–Left Arrow    Extend text selection to the beginning of the current word, then to the beginning of the following word if pressed again.

Option–Shift–Right Arrow    Extend text selection to the end of the current word, then to the end of the following word if pressed again.

Shift–Command–Down Arrow    Select the text between the insertion point and the end of the document.

Shift–Command–Left Arrow    Select the text between the insertion point and the beginning of the current line.

Shift–Command–Right Arrow    Select the text between the insertion point and the end of the current line.

Shift–Up Arrow    Extend text selection to the nearest character at the same horizontal location on the line above.

Shift–Down Arrow    Extend text selection to the nearest character at the same horizontal location on the line below.

Shift–Left Arrow    Extend text selection one character to the left.

Shift–Right Arrow    Extend text selection one character to the right.

Finder shortcuts

Shift-Command-C    Open the Computer window.

Shift-Command-D    Open the desktop folder.

Shift-Command-F    Open the All My Files window.

Shift-Command-G    Open a Go to Folder window.

Shift-Command-H    Open the Home folder of the current macOS user account.

Shift-Command-I    Open iCloud Drive.

Shift-Command-K    Open the Network window.

Option-Command-L    Open the Downloads folder.

Shift-Command-O    Open the Documents folder.

Shift-Command-R    Open the AirDrop window.

Shift-Command-T    Add Selected Finder item to the Dock (OS X Mountain Lion or earlier)

Command-D    Duplicate the selected files.

Command-E    Eject the selected disk or volume.

Command-F    Start a Spotlight search in the Finder window.

Command-I    Show the Get Info window for a selected file.

Command-Y    Use Quick Look to preview the selected files.

Command-1    View the items in the Finder window as icons.

Command-2    View the items in a Finder window as a list.

Command-3    View the items in a Finder window in columns.

Command-4    View the items in a Finder window with Cover Flow.

Command–Left Bracket ([)    Go to the previous folder.

Right Arrow     Open the selected folder. This works only when in list view.

Left Arrow    Close the selected folder. This works only when in list view.

Option–double-click    Open a folder in a separate window and close the current window.

Command–double-click    Open a folder in a separate tab or window.

Command-Delete    Move the selected item to the Trash.

Shift-Command-Delete    Empty the Trash.

Option-Shift-Command-Delete    Empty the Trash without confirmation dialog.

 

 

Microsoft Windows Keyboard Shortcuts

Windows system key combinations

    CTRL+ESC: Open Start menu

    ALT+TAB: Switch between open programs

    ALT+F4: Quit program

    F1: Help

    Windows Logo +L: Lock the computer (without using CTRL+ALT+DELETE)

    SHIFT+DELETE: Delete item permanently

Windows program key combinations

    CTRL+B: Bold

    CTRL+U: Underline

    CTRL+I: Italic

    CTRL+C: Copy

    CTRL+X: Cut

    CTRL+V: Paste

General keyboard-only commands

  SHIFT+F10 Opens a shortcut menu for the selected item (this is the same as right-clicking an    object

    CTRL+ESC: Opens the Start menu (use the ARROW keys to select an item)

    CTRL+ESC or ESC: Selects the Start button (press TAB to select the taskbar, or press SHIFT+F10 for a context menu)

  F1: Starts Windows Help

 F10: Activates menu bar options

 CTRL+TAB: Switch to the next child window of a Multiple Document Interface (MDI) program

    ALT+ underlined letter in menu: Opens the menu

   ALT+F4: Closes the current window

  CTRL+F4: Closes the current Multiple Document Interface (MDI) window

General folder/shortcut control

   F4: Selects the Go to A Different Folder box and moves down the entries in the box (if the toolbar is active in Windows Explorer)

   F5: Refreshes the current window.

    F6: Moves among panes in Windows Explorer

    CTRL+G: Opens the Go to Folder tool (in Windows 95 Windows Explorer only)

    CTRL+A: Select all the items in the current window

    BACKSPACE: Switch to the parent folder

    SHIFT + Click + Close button: For folders, close the current folder plus all parent folders

Microsoft Natural Keyboard keys

    Windows Logo+F1: Help

   Windows Logo+E: Windows Explorer

    Windows Logo+F: Find files or folders

    Windows Logo+D: Minimizes all open windows and displays the desktop

    CTRL+Windows Logo+F: Find computer

   Windows Logo: Start menu

    Windows Logo+R: Run dialog box

    Windows Logo+M: Minimize all

    SHIFT+Windows Logo+M: Undo minimize all

    CTRL+Z: Undo

 

How to Improve Wi-Fi Performance

 

The evolution to delivering carrier Wi-Fi is about more than technology and standards—it’s about deploying carrier-grade service assurance processes. Many enterprises depend on Wi-Fi as a critical delivery mechanism for business applications and financial transactions.

It’s quite possible to boost your Wi-Fi speed yourself, although the solution could be as simple as moving your router or as persnickety as switching Wi-Fi frequencies.
“The distance between the router and connecting devices, as well as the number of walls and floors in between, make a big difference.


Here is ways to improve Wi-Fi Performance.

• Latest Router Firmware

Firmware functions as the OS for your router. It is somewhat permanent, because it cannot be changed until a new firmware update becomes available. Consider updating the firmware to improve performance, fix bugs and upgrade security options. However, be cautious: A firmware update can be a bit dangerous because if the update is interrupted, your router could become useless. Connecting the router to the computer with a cable during the updating process greatly reduces that risk

• WiFi Range Extender

WiFi Range Extender plugs into a main socket to boost Wi-Fi signals, and it can help the signal get to a building's hard-to-reach places. All Wi-Fi routers can work reliably up to a certain distance, but past that, the signal gets poor. Wireless range extenders—also called wireless repeaters or Wi-Fi expanders—will boost signal strength. Although it is not a router, it should be located using the same protocols. Place it near the router so it gets a good signal, but also close enough to the edge of coverage so it can revive the weak points. 

• Quality of Service Tools

The QoS settings are usually found under advanced settings in the network's administrator interface. Limits can be placed on the bandwidth certain applications use, and downloads may be scheduled to run more slowly during times of increased network traffic. In addition, measuring real-time performance and analyzing that data can provide insights regarding how Wi-Fi is being used. Information that can be collected includes: the connection rates of wireless APs and third-party devices; the distribution of 802.11g, 802.11n or 802.11ac clients; the speed capability and distribution of various wireless devices and 5GHz versus 2.4 GHz connection rates.

• Authentication and Encryption

 Defiantly wireless network should be password protected. But even with a password, the latest wireless technology (802.11ac) and two or three radio access points that support speeds up to 1.3 Gbps, performance could be slow. That is because wireless networks with the faster speed technology do not support older types of authentication and encryption. Check that security on the network is WPA-2 or better.

• Environment Disturbance or Interference 

Other electronic devices—including other Wi-Fi routers—cell towers, microwaves, Bluetooth devices  can cause trouble which cause lot of disturbance in Wifi which lead to network disturbance. Generally Wi-Fi is on a different frequency than such devices, but the sheer amount of "radio noise" can cause interference. Android users can check out Wi-Fi Analyzer to find the perfect channel.