Add Activex or Form Controls – Insert Controls option in Excel Quick Access Toolbar. Step-By-Step explanation on adding options to Quick Access Toolbar
Learn how to create Pivot Table in Excel & how to convert it into a Pivot Chart. This way summary report of data can be created as Pivot Table for easy ref.
Excel VBA create new workbook code is used to create, copy data & save with a name. Access newly created workbook with object. workbook.add new Excel file.
Export Outlook Calendar to Excel using VBA Code. Get this Outlook VBA code to export Calendar appointments to Excel or CSV. Step by Step explanation.
Learn how to Consolidate Data in Excel to Summarize data from different worksheet or workbooks.The build in option is more advanced to consolidate in Excel & better than Pivot Tables.
Generate Fibonacci sequence number generator using just with Excel using simple formula & VBA macro code. Enter 2 number & create Fibonacci numbers list.
Add Developer Tab to MS Excel using this option. Quick way to show Developer tab to MS Excel or Word 2010 or above. With this Record Macro & Code VBA Macro.
Compare two columns in Excel with huge volume of data. Easy tips to compare to find matching data, highlight duplicate entries using countif formula.
Get Excel VBA to count cells by color. Input range. Use this to also perform color by sum, sumbycolor or countbycolor tasks. Its all about sum by color.