Advance Excel Course

Course Detail
ADVANCED EXCEL COURSE
(2400 Review)

Advanced Excel Course Content

Our Advanced Excel Course content is structured to cover all the modules within Advanced Excel. From basic to advance, we give Advanced Excel training in Delhi in a manner that is easy to understand.

Below is the detailed course content for Advanced Excel Training

Pivots and Pivot Graphs:
  • Lecture 1.1:
    Creating of Pivot Table
    30 Minute
  • Lecture 1.2:
    Using Summary function in Pivot Table
    30 Minute
  • Lecture 1.3:
    Pivot Table Calculations
    30 Minute
  • Lecture 1.4:
    Creating own formulas in Pivots
    30 Minute
  • Lecture 1.5:
    Grouping and Ungrouping in Pivot Tables
    30 Minute
Working on Objects:
  • Lecture 2.1:
    Inserting Objects
    30 Minute
  • Lecture 2.2:
    Inserting different files into Excel (like .doc, .pdf, .txt files)
    30 Minute
  • Lecture 2.3:
    Hyper linking to different sheets
    30 Minute
  • Lecture 2.4:
    Providing screen tips in hyper link
    30 Minute
  • Lecture 2.5:
    Hyperlink to send emails
    30 Minute
  • Lecture 2.6:
    Inserting symbols
    30 Minute
  • Lecture 2.7:
    Sending working file to an email
    30 Minute
Data Management in Excel – Sorting:
  • Lecture 3.1:
    Rearranging of Data
    30 Minute
  • Lecture 3.2:
    Sorting by alphabets, numbers and time
    30 Minute
  • Lecture 3.3:
    Filtering Data
    30 Minute
  • Lecture 3.4:
    Grouping and Outlining Data
    30 Minute
  • Lecture 3.5:
    Data Validation
    30 Minute
  • Lecture 3.6:
    Removing duplicate records
    30 Minute
  • Lecture 3.7:
    Split Texts
    30 Minute
  • Lecture 3.8:
    Data Consolidation
    30 Minute
  • Lecture 3.9:
    Conditional Formatting
    30 Minute
  • Lecture 3.10:
    Series
    30 Minute
  • Lecture 3.11:
    Macros in excel
    30 Minute
  • Lecture 3.12:
    Copy Data
    30 Minute
  • Lecture 3.13:
    View Multiple Files
    30 Minute
  • Lecture 3.14:
    Working on Tab
    30 Minute
Advanced Functions:
  • Lecture 4.1:
    V-Lookup
    30 Minute
  • Lecture 4.2:
    H-Lookup
    30 Minute
  • Lecture 4.3:
    IF
    30 Minute
  • Lecture 4.4:
    NESTEDIF
    30 Minute
  • Lecture 4.5:
    IFERROR
    30 Minute
  • Lecture 4.6:
    ISBLANK
    30 Minute
  • Lecture 4.7:
    Index Match
    30 Minute
  • Lecture 4.8:
    Rows
    30 Minute
  • Lecture 4.9:
    Columns
    30 Minute
  • Lecture 4.10:
    Match
    30 Minute
  • Lecture 4.11:
    Offset
    30 Minute
  • Lecture 4.12:
    Get Pivot Data
    30 Minute
  • Lecture 4.13:
    Date and Time Functions
    30 Minute
  • Lecture 4.14:
    Text Functions
    30 Minute
  • Lecture 4.15:
    Operators
    30 Minute
  • Lecture 4.16:
    Mathematical functions
    30 Minute
  • Lecture 4.17:
    Calculation options
    30 Minute
  • Lecture 4.18:
    Name Manager
    30 Minute
Data Connection from External Data
  • Lecture 5.1:
    From access
    30 Minute
  • Lecture 5.2:
    From SQL
    30 Minute
  • Lecture 5.3:
    From Web
    30 Minute
  • Lecture 5.4:
    From ODBC
    30 Minute
Customize your Excel view:
  • Lecture 6.1:
    Customize Excel view
    30 Minute
  • Lecture 6.2:
    Developer Option
    30 Minute
  • Lecture 6.3:
    Trust Centre
    30 Minute
  • Lecture 6.4:
    Add-Ins
    30 Minute
  • Lecture 6.5:
    Save directory options
    30 Minute
  • Lecture 6.6:
    Language Setting
    30 Minute
  • Lecture 6.7:
    Quick access toolbar
    30 Minute
Security options in excel:
  • Lecture 7.1:
    Protecting the worksheet
    30 Minute
  • Lecture 7.2:
    Protecting the workbooks
    30 Minute
  • Lecture 7.3:
    Sharing the workbook
    30 Minute
  • Lecture 7.3:
    Allow users to edit ranges
    30 Minute