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

© 2016 - 2023, All Rights are Reserved.