011-26235343

Advance Excel

Beginners and advanced training

Advance Excel

Most of us are familiar with Microsoft Excel as an electronic spreadsheet. It is widely used for organizing and analyzing various types of data ranging from preparing family budgets to maintaining complex financial ledgers. Excel spreadsheets are used by all the professionals at every step for statistical calculations and it’s in depth knowledge is of great added advantage to everyone. The Advanced MS Excel Course is specially designed to build proficiency in latest Excel tools. Being pro in Excel will help you coordinate better in teams, thoroughly protect your work and to smoothly control the flow of your assignments. Get trained in all the functions of this powerful tool to confidently prepare Pivot Charts, Pivot Tables, Macros and DSUMs etc.

Advanced Excel Syllabus
More Functions and Formulas
  • Formulas with Multiple Operators
  • Inserting and Editing a Function
  • AutoCalculate 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
Analyzing 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 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
More Functions and Formulas
  • Sorting by One Column
  • Sorting by Colors 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
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
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

Training Schedule: Daily, Evening & Weekend Training Available
Training Location: Govindpuri, Kalkaji, New Delhi
Training Duration: 1 Month
Registration Fees: Rs. 250/-
Have a Question? Call: 011-26235343, 9540009504

Back to top