• 072040 91060
  • 099456 01060
  • info@riaacademy.in
  • RT Nagar, Bangalore
Ria Academy
  • Home
  • About
  • Courses
    • Analytics
      • Advanced Excel
      • MS Excel VBA
      • MS Access
      • Power BI Training
    • Language Classes
      • Spoken English
      • German Language
      • French Language
      • Spanish Language
      • IELTS Coaching
    • Software Testing
      • Manual Testing
      • Selenium
    • Programming Language
      • C And C++
      • Data Structure
      • Dot Net
      • Python Training
    • SAP
      • SAP ABAP
      • SAP FICO
      • SAP HCM HR
      • SAP MM
      • SAP SD
    • JAVA
      • Core Java
      • Advanced Java
      • J2EE
      • Java Frameworks
    • Web Designing
      • HTML UI
      • Adobe Flash
      • Photoshop
      • Dreamweaver
    • Computer Courses
      • Computer Basic Course
      • Tally Training
    • Hardware And Networking
      • A+ Training
      • N+ Training
      • CCNA
      • CCNP
      • MCSA
    • Data Scientist
      • Data Science Certification Course
    • Cloud Computing
      • AWS Course
      • DevOps Course
    • Oracle
      • SQL Training
      • Oracle PL SQL
  • Career
  • Blog
  • Contact
Ria Academy Bangalore
  • Home
  • Courses
  • Analytics
  • Advanced Excel Course
  • Advanced Excel Course: Best Advanced Excel Training & Certification

Advanced Excel Course: Best Advanced Excel Training & Certification

  • Getting started
    • Introduction
  • Pivots Tables And Pivot Graphs
    • Introduction Video For – Pivots Tables And Pivot Graphs
    • Creating Of Pivot Table
    • Using Summary Function In Pivot Table
      1 hour
    • Pivot Table Calculations
    • Creating Own Formulas In Pivots
    • Grouping And Ungrouping In Pivot Tables
    • Creating Pivot Graph
    • Custom Filter on Pivot Table
    • Formatting Pivot table (Removing old data, grand total, subtotal …etc.)
  • Working on Objects
    • Introduction Video For – Working On Objects
    • Inserting Objects
    • Inserting Different Files Into Excel (like .doc, .pdf, .txt files)
    • Hyper Linking To Different Sheets
    • Providing Screen Tips In Hyper Link
    • Hyperlink To Send Emails
    • Inserting Symbols
    • Sending Working File To An Email
  • Data Management In Excel – Sorting
    • Introduction Video For – Data Management In Excel – Sorting
    • Rearranging Of Data
    • Sorting By Alphabets, Numbers And Time
    • Using Auto Filter Option
    • Custom Filtering With Different Options
    • Advanced Filtering
    • Find Unique Records Using Advanced Filtering
    • Filter Using Operators AND/OR
    • Filter By Color
    • Grouping And Outlining Data
    • Group And Ungroup Rows And Columns
    • Auto Outlining The Data
    • Freezing And Unfreezing
    • Use Data Validation In Excel
    • Using Input Message In Data Validation
    • Using Error Message In Data Validation
    • Remove Duplicate Records In Spread Sheet
    • Customize To Remove The Duplicate Values
    • Split Texts To Different Columns
    • Remove Special Character From String And Split The String
    • Combining Different Spreadsheet Using Data Consolidation
    • Using Summary Function In Data Consolidation
    • Use Of Conditional Formatting
    • Custom Formatting
    • Use Of Format Painter
    • Use Of Paste Special
    • Strike Through Value
    • Find And Replace
    • Arrange Multiple Windows To View In One Time
    • Split Big Sheet Into Sub Sheets For Better Analysis
    • Hide/Unhide Tab
    • Color Tab
    • Move/Copy The Tab To Another Sheet/Workbook
  • Advanced Functions
    • Introduction Video For – Advanced Functions
    • V-Lookup
    • H-Lookup
    • IF Function
    • ISERROR
    • Index Match
    • Rows
    • Columns
    • Match
    • Offset
    • Get Pivot Data
    • Date and Time Functions
    • Text Functions
    • Operators
    • Mathematical Functions
    • Calculation Options
    • Name Manager
    • Define A Name To Range
    • Use Of Name Manager
    • Using Formulas In Name Manager
    • Editing Name Range
  • Data Connection From External Data
    • Introduction Video For – Data Connection From External Data
    • From Access
    • From SQL
    • From Web
    • From ODBC
  • Customize Your Excel View
    • Introduction Video For – Customize Your Excel View
    • Customize Excel View
    • Developer Option
    • Trust Centre
    • Add-Ins
    • Save Directory Options
    • Language Setting
    • Quick Access Toolbar
  • Security Options In Excel
    • Introduction Video For – Security Options In Excel
    • Protecting The Worksheet
    • Protecting The Workbooks
    • Sharing The Workbook
    • Allow Users To Edit Ranges
This content is protected, please login and enroll course to view this content!