Forums
New posts
Search forums
News
Security News
Technology News
Giveaways
Giveaways, Promotions and Contests
Discounts & Deals
Reviews
Users Reviews
Video Reviews
Support
Windows Malware Removal Help & Support
Mac Malware Removal Help & Support
Mobile Malware Removal Help & Support
Blog
Log in
Register
What's new
Search
Search titles only
By:
Search titles only
By:
Reply to thread
Menu
Install the app
Install
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Forums
Security
Guides - Privacy & Security Tips
Most commonly used Excel commands, this list puts it all at your fingertips.
Message
<blockquote data-quote="kuttus" data-source="post: 81514" data-attributes="member: 2676"><p>Highlighting the most commonly used and commonly looked for Excel commands, this list puts it all at your fingertips.</p><p></p><p><u><strong><em>Keyboard Shortcuts</em></strong></u></p><p></p><p>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.</p><p></p><p><img src="http://123pcworld.com/MalwareTips/01.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p><img src="http://123pcworld.com/MalwareTips/02.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p><img src="http://123pcworld.com/MalwareTips/03.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p><img src="http://123pcworld.com/MalwareTips/04.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p><img src="http://123pcworld.com/MalwareTips/05.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p><img src="http://123pcworld.com/MalwareTips/06.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p></p><p><em><u><strong>Excel Function Cheatsheets</strong></u></em></p><p></p><p>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.</p><p></p><p></p><p><img src="http://123pcworld.com/MalwareTips/07.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p><img src="http://123pcworld.com/MalwareTips/08.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p><img src="http://123pcworld.com/MalwareTips/09.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p><img src="http://123pcworld.com/MalwareTips/10.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p><img src="http://123pcworld.com/MalwareTips/11.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p><img src="http://123pcworld.com/MalwareTips/12.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p><img src="http://123pcworld.com/MalwareTips/13.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p><img src="http://123pcworld.com/MalwareTips/14.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p><img src="http://123pcworld.com/MalwareTips/15.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p><img src="http://123pcworld.com/MalwareTips/16.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p><img src="http://123pcworld.com/MalwareTips/17.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p><img src="http://123pcworld.com/MalwareTips/18.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p></p><p><u><em><strong>Excel Formula Cheatsheets</strong></em></u></p><p></p><p>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.</p><p></p><p><u><em><strong>How To Read Cell References</strong></em></u></p><p></p><p><img src="http://123pcworld.com/MalwareTips/19.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p></p><p>Simple Math Formulas From Microsoft.com</p><p></p><p><a href="http://office.microsoft.com/en-us/excel-help/add-numbers-HP010070491.aspx" target="_blank">Adding Numbers</a></p><p></p><p><a href="http://office.microsoft.com/en-us/excel-help/calculate-percentages-HP010070493.aspx" target="_blank">Calculate Percentages</a></p><p></p><p><a href="http://office.microsoft.com/en-us/excel-help/calculate-percentages-HP010070493.aspx" target="_blank">Calculate percentages</a></p><p></p><p><a href="http://office.microsoft.com/en-us/excel-help/round-a-number-HP010070518.aspx" target="_blank">Rounding Numbers</a></p><p></p><p><img src="http://123pcworld.com/MalwareTips/20.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p><img src="http://123pcworld.com/MalwareTips/21.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p><img src="http://123pcworld.com/MalwareTips/22.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p><img src="http://123pcworld.com/MalwareTips/23.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p><img src="http://123pcworld.com/MalwareTips/24.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p><img src="http://123pcworld.com/MalwareTips/25.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p><img src="http://123pcworld.com/MalwareTips/26.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p><img src="http://123pcworld.com/MalwareTips/27.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p><img src="http://123pcworld.com/MalwareTips/28.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p></p><p><u><em><strong>Advanced Excel Tips From Microsoft.com</strong></em></u></p><p></p><p><a href="http://office.microsoft.com/en-us/excel-help/guidelines-and-examples-of-array-formulas-HA010228458.aspx?pid=CH100648411033" target="_blank">Guidelines and Examples Of Array Formulas</a></p><p></p><p><a href="http://support.microsoft.com/kb/306125" target="_blank">How to import data from Microsoft SQL Server into Microsoft Excel</a></p><p></p><p><a href="http://support.microsoft.com/kb/300643" target="_blank">Macro to Extract Data from a Chart In Excel</a></p><p></p><p><u><em><strong>Excel Command Line Switches</strong></em></u></p><p></p><p>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.</p><p></p><p><img src="http://123pcworld.com/MalwareTips/29.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p><img src="http://123pcworld.com/MalwareTips/30.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p><img src="http://123pcworld.com/MalwareTips/31.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p></blockquote><p></p>
[QUOTE="kuttus, post: 81514, member: 2676"] Highlighting the most commonly used and commonly looked for Excel commands, this list puts it all at your fingertips. [u][b][i]Keyboard Shortcuts[/i][/b][/u] 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]http://123pcworld.com/MalwareTips/01.png[/img] [img]http://123pcworld.com/MalwareTips/02.png[/img] [img]http://123pcworld.com/MalwareTips/03.png[/img] [img]http://123pcworld.com/MalwareTips/04.png[/img] [img]http://123pcworld.com/MalwareTips/05.png[/img] [img]http://123pcworld.com/MalwareTips/06.png[/img] [i][u][b]Excel Function Cheatsheets[/b][/u][/i] 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]http://123pcworld.com/MalwareTips/07.png[/img] [img]http://123pcworld.com/MalwareTips/08.png[/img] [img]http://123pcworld.com/MalwareTips/09.png[/img] [img]http://123pcworld.com/MalwareTips/10.png[/img] [img]http://123pcworld.com/MalwareTips/11.png[/img] [img]http://123pcworld.com/MalwareTips/12.png[/img] [img]http://123pcworld.com/MalwareTips/13.png[/img] [img]http://123pcworld.com/MalwareTips/14.png[/img] [img]http://123pcworld.com/MalwareTips/15.png[/img] [img]http://123pcworld.com/MalwareTips/16.png[/img] [img]http://123pcworld.com/MalwareTips/17.png[/img] [img]http://123pcworld.com/MalwareTips/18.png[/img] [u][i][b]Excel Formula Cheatsheets[/b][/i][/u] 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. [u][i][b]How To Read Cell References[/b][/i][/u] [img]http://123pcworld.com/MalwareTips/19.png[/img] Simple Math Formulas From Microsoft.com [url=http://office.microsoft.com/en-us/excel-help/add-numbers-HP010070491.aspx]Adding Numbers[/url] [url=http://office.microsoft.com/en-us/excel-help/calculate-percentages-HP010070493.aspx]Calculate Percentages[/url] [url=http://office.microsoft.com/en-us/excel-help/calculate-percentages-HP010070493.aspx]Calculate percentages[/url] [url=http://office.microsoft.com/en-us/excel-help/round-a-number-HP010070518.aspx]Rounding Numbers[/url] [img]http://123pcworld.com/MalwareTips/20.png[/img] [img]http://123pcworld.com/MalwareTips/21.png[/img] [img]http://123pcworld.com/MalwareTips/22.png[/img] [img]http://123pcworld.com/MalwareTips/23.png[/img] [img]http://123pcworld.com/MalwareTips/24.png[/img] [img]http://123pcworld.com/MalwareTips/25.png[/img] [img]http://123pcworld.com/MalwareTips/26.png[/img] [img]http://123pcworld.com/MalwareTips/27.png[/img] [img]http://123pcworld.com/MalwareTips/28.png[/img] [u][i][b]Advanced Excel Tips From Microsoft.com[/b][/i][/u] [url=http://office.microsoft.com/en-us/excel-help/guidelines-and-examples-of-array-formulas-HA010228458.aspx?pid=CH100648411033]Guidelines and Examples Of Array Formulas[/url] [url=http://support.microsoft.com/kb/306125]How to import data from Microsoft SQL Server into Microsoft Excel[/url] [url=http://support.microsoft.com/kb/300643]Macro to Extract Data from a Chart In Excel[/url] [u][i][b]Excel Command Line Switches[/b][/i][/u] 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]http://123pcworld.com/MalwareTips/29.png[/img] [img]http://123pcworld.com/MalwareTips/30.png[/img] [img]http://123pcworld.com/MalwareTips/31.png[/img] [/QUOTE]
Insert quotes…
Verification
Post reply
Top