Advance Excel Training Course

The Advanced Excel Training Program Course covering the basic and advanced modules of Microsoft Excel. In this training program, you will learn how to use Microsoft Excel and the advanced concepts of Excel. These advanced Excel functions can be combined to create some very advanced and complex formulas to use.

What to Learn

Students will be presented with interesting real-life scenarios and have to use the Excel tools, functions and data visualization techniques learned to solve problems, make inferences and present data in a meaningful and effective manner using Excel.

Advance Excel Syllabus

  • Spreadsheet Basics
  • Creating, Editing, saving and Printing spreadsheets
  • Data Formatting in Excel like colors, fonts, Bullets etc
  • Basic Sorting and Filtering
  • Basic Formulae like SUM,AVERAGE,COUNT,MAX,MIN etc
  • Basic Shortcut
  • Advance Shortcut
  • Sorting Data by values, colors
  • Filtering by numbers, text, values, colors etc.
  • Using Filters to Sort Data
  • Creating a custom AutoFilter
  • Advance Filtering Options
  • Creating a custom format
  • Create a custom number, percentage, fraction etc. format
  • Conditional Formatting
  • Creating Conditional Formatting
  • Editing Conditional Formatting
  • Adding Conditional Formatting
  • Deleting Conditional Formatting from the selected range
  • Specifying a valid range of value of a cell
  • Validation Criteria
  • Invalid Data Identification
  • Using Define names
  • Creating define names
  • Using define names in formulas
  • Name Manager
  • Deleting, Editing names
  • Index Function
  • Simple if function
  • If combined with AND/OR
  • Simple Offset function
  • Offset combined with SUM or AVERAGE
  • Choose function
  • XNPV and XIRR function
  • Sum, sum if and count if function
  • PMT FV and IPMT function
  • LEN and TRIM function
  • Concatenate function
  • Cell, Left, Right and Mid function
  • LOOKUP (V-Lookup & H-Lookup) function
  • MAX & MIN function
  • AND & OR Function
  • Round Function
  • Now & Date function
  • Change case function
  • TRIM function
  • REPT function
  • TYPE Function
  • RANDBETWEEN function
  • Convert function
  • PV function
  • Time Function (Weeknum, Workday, Networkday, Yearfrac & Edate function)
  • Relative cell reference
  • Absolute cell reference
  • Trace precedents
  • Trace dependents
  • Remove arrows
  • Error Checking
  • Freeze of windows
  • Splitting of Windows
  • Paste Special            
  • Spark lines
  • Text to columns
  • Consolidate
  • Watch Window
  • Remove duplicates
  • Go to function tab
  • Creating Tables
  • Naming the Tables
  • Changing the Table style
  • Summarize with PivotTable
  • Using Filtering in Table
  • Removing the duplicate record
  • Creating Pivot tables
  • Adding Pivot table Report Fields
  • Refreshing Pivot table Reports
  • Changing the summary functions
  • Creating report filter
  • Creating Subtotals
  • Multiple Level subtotals
  • Creating Pivot tables
  • Formatting and customizing Pivot tables
  • Using advanced options of pivot table
  • Pivot charts
  • Using external data source
  • Fields, Items and Sets in Pivot Table
  • Viewing subtotal under pivot
  • Creating Slicers
  • Creating subtotal
  • Using Automatically Outline
  • Grouping Data Manually
  • Creating a chart
  • Formatting a chart
  • Adding Labels
  • Changing the chart type, Data source
  • Protecting your work sheet
  • Protecting range with password
  • Protecting your Workbook and Excel Files
  • Goal Seek
  • Data Tables
  • Scenario Manager