Advanced Excel & VBA Training

Microsoft Advanced Excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

Advanced Excel online training by Tech Skill Trainings aims on providing the candidates on the specific data by using filters and applying formulas for evaluating the data. Advanced Excel training course focuses on creating the worksheets and workbooks to display data in an effective way, use functions and formulas, use PowerPivot to access data sources, create relationships, utilize the PowerPivot DAX expressions and create format reports.

Visual Basic for Applications (VBA) is an object oriented programming language developed by Microsoft. VBA language has been integrated with Excel in order to have programming features which enables the developers to handle the data manipulation along with Excel function very easily. VBA is good for developing reporting systems in a capital markets environment and developing core business performance reporting etc.

Using a step-by-step approach, this course shows how the Visual Basic for Applications (VBA) programming language can extend the functionality of Excel. Students will learn to write macros to accept user input, read to and write from cells, and manipulate data. They will also learn to write custom functions and create user forms. Useful examples of problems and their solutions will be provided.

Basic Excel

• • Introduction to Excel
• • Simple data Entry
• • Editing and formatting data
• • Selecting Range, Cut,Copy,Paste,Format Painter,Saving Excel format
• • Changing Column and Row Width
• • Insertion,Deletion,Hiding Columns and Row
• • Find,Replace,Merge and Center
• • Add New Worksheet
• • Sorting,adding borders,simple printing,highlighting cells
• • Absolute and Relative Cell Reference
• • Doing Simple Math(Sum,subtract,division,multiplications,Average)

Advanced Excel

• • Numeric Functions
• • Text Functions
• • Lookup and Reference Functions
• • Date & time functions
• • Conditional statement and logical operators
• • Formula based formatting
• • Array Formulas
• • Named Ranges
• • Pivot Table
• • Data Validation
• • Conditional Formatting
• • Text to columns, Remove duplicate, Hyperlink
• • Preparing Charts and charts modification

VBA Macros

• • Introduction
• • Recording a Macro
• • Saving Macro Enabled Workbook
• • Moving Code Around
• • Keyboard shortcuts
• • Object ,Methods and properties
• • Range and Cell object
• • Active cell, Offset ,End, Current Region Property
• • Copy and paste data
• • Opening and closing workbook with Macros
• • Variables
• • Loops
• • Logical Testing
• • Formulas
• • Dialog Boxed and user forms
• • Array
• • User Defined functions
• • Creating folders with Macros
• • Email Automation

• • Data Analyst
• • Business Analyst
• • Fresh Graduates

• None