Tata Steel
Tata Steel Logo

ADVANCED EXCEL 

  • Offered byTata Steel

ADVANCED EXCEL
 at 
Tata Steel 
Overview

Gain a comprehensive overview of the excel principles and concepts

Duration

4 hours

Total fee

490

Mode of learning

Online

Credential

Certificate

ADVANCED EXCEL
 at 
Tata Steel 
Highlights

  • Earn a certificate upon completion
Details Icon

ADVANCED EXCEL
 at 
Tata Steel 
Course details

More about this course
  • Microsoft Excel is one of the most valuable tools to perform the calculation, analysis, and visualization of data
  • Advanced Excel is a comprehensive tutorial that provides a good insight into the latest and advanced features available in MS Excel 2013
  • This tutorial has been designed for all those readers who depend heavily on MS-Excel to prepare charts, tables, and professional reports that involve handling and analysis of complex data
  • In this course you will learn the most useful shortcuts, tricks, and advanced features of Microsoft Excel that will help you handle huge amounts of data more quickly and effectively, making you more efficient and setting yourself up for greater advancement
  • By the end of the course, you will learn Auto Filter & Advanced Filter, Sorting, D-functions, Charts, Conditional Formatting, and many more functions
Read more

ADVANCED EXCEL
 at 
Tata Steel 
Curriculum

Advanced Filter

Sorting & Subtotal

D-Functions

Naming Concepts

SumIf & CountIf

Charts and IF-IS

Conditional Formatting

Data Validation

Series in Excel & Macro

Pivot Table & Freeze Panes

Goal Seek & Scenario, Solver

Errors in Excel

V-Lookup

Password Protecting Excel File

Other courses offered by Tata Steel

300
4 hours
Beginner
300
2 hours
Beginner
325
2 months
– / –
410
2 hours
– / –
View Other 3 CoursesRight Arrow Icon

ADVANCED EXCEL
 at 
Tata Steel 
Students Ratings & Reviews

5/5
Verified Icon1 Rating
A
Adnan Deshmukh
ADVANCED EXCEL
Offered by Tata Steel
5
Learning Experience: Advance Functions of Excel
Faculty: It was pre recorded video Curriculum is same. It was new to me so i like it
Course Support: No career support provided
Reviewed on 13 Mar 2022Read More
Thumbs Up IconThumbs Down Icon
View 1 ReviewRight Arrow Icon
qna

ADVANCED EXCEL
 at 
Tata Steel 

Student Forum

chatAnything you would want to ask experts?
Write here...