Questions? 8444059688

Advanced Excel

Something0

Introduction

In this advanced course students learn how to automate information based on the skills they have developed in the basic courses. This course also provides information on how to combine multiple worksheets to handle larger, more complex sets of data. Additional coursework is spent on data analysis, importing or exporting data, and coordinating Excel documents with internet sources. This course may even give students skills to develop worksheets in XML (Extensible Mark-up Language).

Course Objectives

ADVANCED EXCEL FUNCTIONS

VARIOUS METHODS AND USES OF ADVANCE EXCEL FORMULAS:
  • VLOOKUP, HLOOKUP
  • SUMIF, SUMIFS, SUMPRODUCT, DSUM
  • COUNTIF, COUNTIFS, IF
  • IFERROR, ISERROR, ISNA, ISNUMBER, ISNONTEXT, ISBLANK, ISTEXT
  • GETPIVOTDATA
  • DCOUNT, DCOUNTA, OR, AND, SEARCH, INDEX, MATCH ETC
VARIOUS METHODS AND USES OF IF CONDITIONS:
  • When should use the "IF" Conditions?
  • Creation of Multiple IF Conditions in One Cell
  • Use the IF Conditions with the Other Advance Functions
  • How to use nested IF statements in Excel with AND, OR Functions
ADVANCED EXCEL OPTIONS:
  • Various Methods of Filter and Advance Filter options
  • Creating and Updating Subtotals
  • Various Methods of Text to Column options
  • Uses of Data Grouping and Consolidation options
  • Uses of Goal Seek and Scenarios Manager
  • Various Method of Sorting Data
  • Creating, Formatting and Modifying Chart
  • Data Validation, Creating drop down lists using different data sources
  • Linking Workbooks and Uses of Edit Link options
  • Excel Options, Customizing the Quick Access Tool Bar
PIVOT TABLES & CHARTS:
  • Various Methods and Options of Pivot Table
  • Using the Pivot Table Wizard
  • Changing the Pivot Table Layout
  • Subtotal and Grand total Options
  • Formatting
  • Grouping Items
  • Inserting Calculated Fields
  • Pivot Table Options
  • Calculation in Pivot Table
  • Display and Hide Data in Field
  • Select, Move & Clear Pivot Data
  • Creating and Modifying Pivot Chart
ADVANCE USE OF FUNCTION:
  • Mixing Function to get Various MIS Outputs
  • Creating Data Table
  • Advance Data Validation
  • Using conditional formatting with Formulas and Function
  • Using Name Manager
  • Array Formulas
MACROS:
  • What is a Macro?
  • Creating Excel Macro
  • Running Macros and Editing
  • Automating Tasks with Macro

Assignment & Portfolio Building

Reserve Your Seat

Fill in the Form below to reserve your Seat Asap!

If you Have Any Questions Call Us On +91 8444059688