Guide | How To Most commonly used Excel commands, this list puts it all at your fingertips.

[kuttus]

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.

http://123pcworld.com/MalwareTips/01.png
http://123pcworld.com/MalwareTips/02.png
http://123pcworld.com/MalwareTips/03.png
http://123pcworld.com/MalwareTips/04.png
http://123pcworld.com/MalwareTips/05.png
http://123pcworld.com/MalwareTips/06.png

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.


http://123pcworld.com/MalwareTips/07.png
http://123pcworld.com/MalwareTips/08.png
http://123pcworld.com/MalwareTips/09.png
http://123pcworld.com/MalwareTips/10.png
http://123pcworld.com/MalwareTips/11.png
http://123pcworld.com/MalwareTips/12.png
http://123pcworld.com/MalwareTips/13.png
http://123pcworld.com/MalwareTips/14.png
http://123pcworld.com/MalwareTips/15.png
http://123pcworld.com/MalwareTips/16.png
http://123pcworld.com/MalwareTips/17.png
http://123pcworld.com/MalwareTips/18.png

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

http://123pcworld.com/MalwareTips/19.png

Simple Math Formulas From Microsoft.com

Adding Numbers

Calculate Percentages

Calculate percentages

Rounding Numbers

http://123pcworld.com/MalwareTips/20.png
http://123pcworld.com/MalwareTips/21.png
http://123pcworld.com/MalwareTips/22.png
http://123pcworld.com/MalwareTips/23.png
http://123pcworld.com/MalwareTips/24.png
http://123pcworld.com/MalwareTips/25.png
http://123pcworld.com/MalwareTips/26.png
http://123pcworld.com/MalwareTips/27.png
http://123pcworld.com/MalwareTips/28.png

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.

http://123pcworld.com/MalwareTips/29.png
http://123pcworld.com/MalwareTips/30.png
http://123pcworld.com/MalwareTips/31.png