For the love of Excel !!!

I love spreadsheets though sometimes they make me feel bore but i think if you keep learning it you won’t get bored of it. There are many tricks and cheats besides the regular functions of this program.I download some of these tuts in my phone and read them whenever i got time it helped me a lot in office so i think these tuts are¬†quite good so instead of killing time playing stupid games on phone i think it will be better for you to at-least give them a try.

 

A must read guide for understanding the functions in excel. How the different types of cell references work and how to apply range name in a formula, How to name a formula.This one was quite helpful for me as i was looking for a  tutorial on cell referencing from another worksheet and much more.

 

 

Simply for beginners : This cheat-sheet is for beginners

cheatsheet excel

You can find plenty of other’s

There are plenty of them :

  1. Access 2013
  2. Access 2010
  3. Access 2007
  4. Excel 2013
  5. Excel 2010
  6. Excel 2007
  7. IE 11
  8. Lync 2013
  9. Office 365
  10. Office 2013
  11. Office 2010
  12. Office 2007
  13. OneDrive For Business
  14. Outlook 2013
  15. Outlook 2010
  16. Outlook 2007
  17. PowerPoint 2013
  18. PowerPoint 2010
  19. PowerPoint 2007
  20. Project 2013
  21. Project 2010
  22. Project 2007
  23. SharePoint 2013
  24. SharePoint 2010
  25. SharePoint 2007
  26. Word 2013
  27. Word 2010
  28. Word 2007
  29. Windows 8
  30. Windows 7
  31. Windows XP
  32. iPad
  33. Mac OSX
  34. Excel 2011
  35. Outlook 2011
  36. PowerPoint 2011
  37. Word 2011
  38. Lotus Notes 8

Excel formulas and functions

 

We all know the famous chandoo.org site for excel here is a tips sheet from that site along with links to very useful tutorials, good pick for any excel learner.

Excel cheating tricks
Every now and then when i download a excel worksheet from internet gives me a feeling as if i am downloading a virus. SO this cheat sheet will allow you to access whether your downloaded document is containing any bad macro or virus. This sheet shows you how to locate malicious code and remove it. A must have i would say.

Excel macro virus removal

You have to click on the image to view and download the specific pdf cheat sheets

Here is another sheet that i think can prove really useful. Some new tricks along with some old ones.Like highlighting the whole row instead of a single cell.Another cool trick of moving the cells with mouse, Selecting a Range of Cells,Keep Column Names Visible as you scroll that means freezing panes,creating multi-lines in a cell,Unique List of Values in cell and more..

Learn to make macro a button

 

Does this one counts too ?