Enroll Now
Banner image

About Course

Advanced Excel skills include the ability to produce graphs and tables, use spreadsheets efficiently, and perform calculations and automation to process large volumes of data. With the rise of big data and data analytics, advanced Excel skills are a real asset both during the job hunt and everyday work tasks.

Path Ahead With Career Options

  • MIS Executive
  • Excel Data Analyst
  • Executive Assistant

Software that you will learn in this course

Course Content

Basic MS Excel

  • Clipboard operating & Paste Special
  • Font Formatting
  • Alignments
  • Merging Cells
  • Format Cells
  • Number
  • Font
  • Border
  • Fill & Protection
  • Conditional Formatting
  • Tables
  • Editing Tools
  • Sorting & Filtering
  • Find & Replace
  • Pivot tables
  • Printing option
  • Scale To Fit
  • Alignments
  • About Formulas & functions
  • Insert Functions
  • Using various Function-Financial
  • Logical text
  • Date & Time
  • Lookup & Reference
  • Mathematical Functions
  • Subtotaling
  • Comments
  • Proofing
  • Share Workbook
  • Protect Sheet
  • Workbook
  • Allow user to Edit range
  • Creating
  • Function Nesting and Advanced uses
  • Getting External Data
  • Connection
  • Advanced Sorting & Filtering
  • Flash Fill
  • Remove Duplicates
  • Validation Techniques
  • What-if-Analysis
  • Group-Ungroup

Advanced Excel Course - Data Validations

  • 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

Advanced Excel Course - Sorting and Filtering Data

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

Advanced Excel Course - 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
  • Using data consolidation feature to consolidate data
  • Show Value As (% of Row, % of Column, Running Total, Compare with Specific Field)
  • Viewing Subtotal under Pivot
  • Creating Slicers (Version 2010 & Above)

Advanced Excel Course - Working with Functions

  • Writing conditional expressions (using IF)
  • Using logical functions (AND, OR, NOT)
  • Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
  • VLOOKUP with Exact Match, Approximate Match
  • Nested VLOOKUP with Exact Match
  • VLOOKUP with Tables, Dynamic Ranges
  • Nested VLOOKUP with Exact Match
  • Using VLOOKUP to consolidate Data from Multiple Sheets

Advanced Excel Course - More Functions

  • Date and time functions
  • Text functions
  • Database functions
  • Power Functions (CountIf, CountIFS, SumIF, SumIfS)

Advanced Excel Course – Formatting

  • Using auto formatting option for worksheets
  • Using conditional formatting option for rows and columns

Advanced Excel Course – Macros

  • Relative & Absolute Macros
  • Editing Macro's

Advanced Excel Course - What If Analysis

  • Goal Seek
  • Data Tables
  • Scenario Manager

Advanced Excel Course – Charts

  • Using Charts
  • Formatting Charts
  • Using 3D Graphs
  • Using Bar and Line Chart together
  • Using Secondary Axis in Graphs
  • Sharing Charts with PowerPoint / MS Word, dynamically
  • (Data Modified in Excel, Chart would automatically get updated)

Advanced Excel Course - New Features of Excel

  • Sparklines, Inline Charts, data Charts
  • Overview of all the new features

Course Duration & Eligibility

DurationEligibility
2.5 Months You may join this course after completing your 10th class

Features & Facilities




Student Reviews

;

Recruiters Companies