Excel Tips
Tips on how to copy formulas acurately in excel
Learn every method to copy formula in excel either with absolute or relative references, down a column, to another column without changing references etc.
How to install Custom functions and Addins in Excel
Make your own Excel Add-in! Read and learn how user-defined custom functions in excel or macros make available to each workbook you open.
Excel Drop Down Menu - Best Practices in creating a drop down menu in Excel
Learn to add a drop down menu to select inputs to a cell from a predefined list by using data validation feature.
Keyboard Shortcuts in Excel
Learn shortcuts that will improve your excel skills and save your time
Most useful Excel Tips
Learn 15 excel tips that will improve your excel skills and save your time
Quickest ways to switch between excel sheets or tabs
Learn various strategies for fast switching between sheets in Excel starting from manual selection, to more complicated options such VBA .