Mini Spy

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 Active Member

    Reputation:
    0
    Joined:
    Oct 5, 2012
    Messages:
    2,767
    Likes Received:
    81
    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]
     

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads: commonly used
Forum Title Date
Space Bar "The weirdest most commonly asked things on Google" May 4, 2014
News Section Keylogging Framework Used by Multiple Actors in Watering-Hole Attacks Tuesday at 8:51 AM
Malware Removal Assistance Removing Edeals (multiple malware removal tools used) Oct 17, 2014
News Section Botnets Used in “Wolf of Wall Street” Spam Campaign Oct 16, 2014
All Software Discussions B1 Free Archiver - anyone used it? Oct 7, 2014

MalwareTips.com is an independent website.All trademarks mentioned on this page are the property of their respective owners.