Excel Tips
Keyboard Shortcuts in Excel
Learn shortcuts that will improve your excel skills and save your time
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.
Most useful Excel Tips
Learn 15 excel tips that will improve your excel skills and save your time
How to Check the Encoding of a CSV File (Free Online Checker)
Find out if a CSV file is UTF-8, UTF-8 with BOM, UTF-16 or Windows-1252 in seconds, then open it in Excel without garbled characters. Free checker that runs in your browser.
Switch Between Sheets in Excel: Shortcuts for Windows, Mac & Web
Ctrl+PgDn and Ctrl+PgUp switch sheets in Excel. Get the Mac, laptop and Excel for the web shortcuts, plus faster ways to jump between dozens of tabs.