Give us missed call for free demo: 7038384365 | Email your cv on: careers@yessinfotech.com



        






Advance Excel Syllabus

VBA

Advance Excel

Getting started Excel 2010

  • Introduction of Language
  • Customize the Quick Access Toolbar
  • Customizing common options in Excel
  • Absolute and relative cells
  • Customize the Excel Environment
  • Customize an Excel Worksheet

  • Working with Routine Functions

  • Writing conditional expressions (using IF)
  • Using logical functions (AND, OR, NOT)
  • Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
  • Security & Sharing Features

  • Protecting and un-protecting worksheets and cells
  • Hiding formulas
  • Saving files with passwords

    Dynamic Formatting

  • Sorting tables
  • Using multiple-level sorting
  • Using custom sorting
  • Filtering data for selected view (AutoFilter)
  • Using advanced filter options

  • Specialized Functions

  • Using conditional Aggregate Functions like Dsum, Dmax, Dminetc….


  • Working with Reports

  • Creating subtotals
  • Multiple-level subtotals
  • Creating Pivot tables
  • Formatting and customizing Pivot tables
  • Using advanced options of Pivot tables
  • Pivot charts
  • Consolidating data from multiple sheets and files using Pivot tables
  • Using external data sources
  • Slicing Pivots

  • Presenting Data Using Charts

  • Create a Chart
  • Modify Charts
  • Format Charts
  • Create a Chart Template
  • Share Excel Charts
  • Sparklines

  • Overview of Macros

  • Recording and executing macros
  • Understanding different types of references in macros
  • Assigning macros to toolbars or menu items

  • More Functions

  • Date and time functions
  • Text functions

  • Data Validation

  • Specifying a valid range of values for a cell
  • Specifying a list of valid values for a cell
  • Specifying custom validations based on formula for a cell


  • Send a message

    Kindly share your any queries here.









    Note:
    This is generalized syllabus.Don't consider this as final syllabus.

    Copyright 2017, Yess InfoTech All rights reserved.
    Designed and Developed by Yess InfoTech Team |            

    Follow us on      

    Click here to know our courses!!! |