Advance Excel

Advance Excel

Price: 4,500
Offer price: 2,900
Fee(s) mode: one_time
Duration: 1 Month(s)

Course Details(What will you learn)

Excel environment
Range
Ribbon
Workbook
Format cells
Find & Select
Print
Share
Protect
count & sum
Relational operators
Logical operators
Cell References
Date & time
Text functions
Math functions
Sort
Filter
Conditional formatting
Data tables
Pivot tables
Pivot chart
Chart
Drop down list
Lookup & references(VLOOKUP, HLOOKUP, MATCH, INDEX)
Formula errors
What-if analysis
Goal seek
Data validation
Group, subgroup
Form
Sparkline's
Print area
Named range
Remove duplicates
Consolidate
Data table
Delete blank rows
Hide columns and rows
Show formulas

Learn from basic to advance

Terms & Conditions CAPSCOM TECHNOLOGY Pvt. Ltd. का बेहतर रूप से संचालन करने के लिए यहॉ कुछ नियमें और शर्ते लागू है अगर आप कैप्सकॉम टैक्नोलॉजी में पढ़ रहे है तो यह आप पर लागू होता है।