072040 91060
099456 01060
info@riaacademy.in
RT Nagar, Bangalore
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
X
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!
Modal title
Main Content
←
Contact Us
Contact Form
Phone
WhatsApp
