Advanced Excel with Macro

Advanced Excel with Macro              -etechguys />
<p class=Office Package

Advanced Excel with Macro

Advanced Excel with Macro                             

 In Excelmacros are written in Visual Basic for Applications (VBA). For those who cannot write VBA code, Excel allows you to record a series of steps – using keyboard and mouse – that Excel then converts into a macro.

Course Duration: 35 Hrs.                                                Timings: Weekends/Custom/Flexible

Mode of Training:  Regular/Fast Track                                 Class Duration: 4hrs weekly

More Functions and Formulas

 Formulas with Multiple Operators

 Inserting and Editing a Function

 Auto Calculate and Manual Calculation

 Defining Names

 Using and Managing Defined Names

 Displaying and Tracing Formulas

 Understanding Formula Errors

 Using Logical Functions (IF)

 Using Financial Functions (PMT)

 Using Database Functions (DSUM)

 Using Lookup Functions (VLOOKUP)

 User Defined and Compatibility Functions

 Financial Functions

 Date & Time Functions

 Math & Trig Functions

 Statistical Functions

 Lookup & Reference Functions

 Database Functions

 Text Functions

 Logical Functions

 Information Functions

 Engineering and Cube Functions

Working with Data Ranges

Sorting by One Column

 Sorting by Colours or Icons

 Sorting by Multiple Columns

 Sorting by a Custom List

 Filtering Data

 Creating a Custom AutoFilter

 Using an Advanced Filter

Working with PivotTables

 Creating a PivotTable

 Specifying PivotTable Data

 Changing a PivotTable’s Calculation

 Filtering and Sorting a PivotTable

 Working with PivotTable Layout

 Grouping PivotTable Items

 Updating a PivotTable

 Formatting a PivotTable

 Creating a PivotChart

 Using Slicers

 Sharing Slicers Between PivotTables

Analysing and Organizing Data

Creating Scenarios

 Creating a Scenario Report

 Working with Data Tables

 Using Goal Seek

 Using Solver

 Using Text to Columns

 Grouping and Outlining Data

 Using Subtotals

 Consolidating Data by Position or Category

 Consolidating Data Using Formulas

Working with the Web and External Data

 Inserting a Hyperlink

 Importing Data from an Access Database or Text File

 Importing Data from the Web and Other Sources

 Working with Existing Data Connections

Working with Macros

 Recording a Macro

 Playing and Deleting a Macro

 Adding a Macro to the Quick Access Toolbar

 Editing a Macro’s Visual Basic Code

 Inserting Copied Code in a Macro

 Declaring Variables and Adding Remarks to VBA Code

 Prompting for User Input

 Using the If…Then…Else Statement

 

Customizing Excel

 

 Customizing the Ribbon

 Customizing the Quick Access Toolbar

 Using and Customizing AutoCorrect

 Changing Excel’s Default Options

 Creating a Custom AutoFill List

 Creating a Custom Number Format


Back to Top
Content