What is Data Analysis
Introduction of Microsoft Excel
Data Analysis with Excel
Concatenate
Len ()
Days ()
Networkdays
Sumifs()
Averageifs()
Countsifs()
Counta()
Vlookup()
Hlookup()
If ()
Iferror()
Find/Search
Left/Right
Rank()
Advanced Analysis:
Ranges and Tables
Data Cleaning: Text Functions, Dates and Times
Conditional Formatting
Sorting and Filtering
Subtotals with Ranges
PivotTables
Data Visualization
Data Validation
Working with Multiple Worksheets
Formula Auditing
What-if Analysis
Duration : 2 Months
Fees : ₹ 5,999
Join Now
Data Analysis with Advanced Excel at MicroTech Computer Education in Tiruvannamalai is a 2-month course with a fee of ₹5,999. You will learn Excel formulas, VLOOKUP, SUMIFS, PivotTables, data cleaning, data validation and visualization. Classes are on Polur Road, near the Tiruvannamalai bus stand; call +91 99945 68168 to join.
Students from Polur, Chengam, Arani, Vandavasi, Vettavalam, Kilpennathur and Thandarampattu can join.
Address: #22A, 10th New Street, Near Bus Stand, Polur Road, Tiruvannamalai - 606601, Tamil Nadu
Call / WhatsApp: +91 99945 68168
Tiruvannamalai, Polur, Chengam, Arani, Cheyyar, Vandavasi, Vettavalam, Kilpennathur, Thandarampattu, Kalasapakkam, Chetpet, Thurinjapuram, Jamunamarathur, Peranamallur, Gingee, Thirukovilur.
Explore more courses at MicroTech: Digital Marketing · DWDP · DTP · DCA · COA · DCHE · DCN · CCA