How to Copy Excel Chart in PowerPoint Slides using VBA Macro – Step by Step Tutorial Requirement: We need to copy several charts from Excel in Powerpoint slides. And you want to skip the manual part ? Yes, you are in right place and this simple vba macro automation will do the task… [Continue Reading]
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.
Get sample code to add Excel Hyperlink using formula or using the VBA Code. Get VBA code to add, remove hyperlinks from any Excel worksheet.
Compare two columns in Excel with huge volume of data. Easy tips to compare to find matching data, highlight duplicate entries using countif formula.
