Latest Replies

Loading...

Latest Threads

Loading...
 

Most commonly used Excel commands, this list puts it all at your fingertips.

Discussion in 'How-To Articles, Tips and Guides' started by kuttus, Nov 4, 2012.

  1. kuttus

    kuttus Level 2

    Joined:
    Oct 5, 2012
    Messages:
    2,736
    Likes Received:
    90
    Highlighting the most commonly used and commonly looked for Excel commands, this list puts it all at your fingertips.

    Keyboard Shortcuts

    Learn how to get around Excel using only the keyboard. These cheatsheets have the keyboard shortcuts for mainpulating files, editing content, changing formatting and navigating around workbooks.

    [​IMG]
    [​IMG]
    [​IMG]
    [​IMG]
    [​IMG]
    [​IMG]

    Excel Function Cheatsheets

    The key to being efficient with Excel is knowing which functions to use. With the cheatsheets below you can find functions for working with finance, statistics and database content among others.


    [​IMG]
    [​IMG]
    [​IMG]
    [​IMG]
    [​IMG]
    [​IMG]
    [​IMG]
    [​IMG]
    [​IMG]
    [​IMG]
    [​IMG]
    [​IMG]

    Excel Formula Cheatsheets

    If you need specific calculations, this is a good place to start. Below, you’ll get a number of cheatsheets referencing the general formulas you need. Discover formulas on how to do basic math calculations, compose conditional formulas, perform complex counting and numerical conversions. Simply put in your own cell references and you’re ready to go.

    How To Read Cell References

    [​IMG]

    Simple Math Formulas From Microsoft.com

    Adding Numbers

    Calculate Percentages

    Calculate percentages

    Rounding Numbers

    [​IMG]
    [​IMG]
    [​IMG]
    [​IMG]
    [​IMG]
    [​IMG]
    [​IMG]
    [​IMG]
    [​IMG]

    Advanced Excel Tips From Microsoft.com

    Guidelines and Examples Of Array Formulas

    How to import data from Microsoft SQL Server into Microsoft Excel

    Macro to Extract Data from a Chart In Excel

    Excel Command Line Switches

    When you need specific control over Excel you need to customize and launch Excel at the highest level. Find command line switches to customize your Excel application with these Excel Command Line Switch cheatsheets.

    [​IMG]
    [​IMG]
    [​IMG]
     
    Waqas Ahmad Awan likes this.
Loading...
Other threads that you may like Forum Date
"The weirdest most commonly asked things on Google" Space Bar May 4, 2014
Virus Alert New MAC complex trojan used for cyber-espionage Latest Security News Monday at 9:19 PM
Used cCleaner and now can't access the internet (plus tons of other stuff are gone!) Malware Removal Assistance Sunday at 9:46 PM