Excel Macros enable you to automate repetitive tasks – and it's not as hard as you may think. Use the Excel macro recorder to create the macro, then use the Visual Basic Editor to customize the recorded procedure. You can also create your own functions if the Function Wizard doesn't have what you need. You won't believe the time you can save!
Knowledge of Excel at the Intermediate/Advanced level is a prerequisite for this course.On Request Only - Contact DPA
Duration: Two-Day Course
Platform: Windows Only
Fee: Call for information
We recommend one to eight people for this course.
Microsoft Excel is a powerful tool to create and format spreadsheets and to analyze, evaluate, and calculate data. You can use advanced features to manage, track, and chart critical business data to create rich data visualization, PivotTable views, and professional-looking charts. If you perform a task repeatedly in Microsoft Excel, you can automate the task with a macro. A macro is a series of commands and functions that are stored in a Microsoft Visual Basic module and can be run whenever you need to perform the task. For example, if you often enter long text strings in cells, you can create a macro to format those cells so that the text wraps.
Users: IT, Database, Engineering, Finance, Legal, Marketing and Admin Professionals as well as anyone who needs create and edit spreedsheets that can be searched, sorted, analysed, reported, updated and shared with other users.