In this course, we shall provide to you the followings contents thru live sessions
Basic formatting
30 Shortcuts -Accelerate your speed 3 times
Sum If, Count If, Sum Ifs &Count Ifs
Offset
Vlookup, Hlookup, Index& Match, Xlookup and Lookup
Circular references
Conditional Formatting
Data Validation
Table
Hyperlinks , Dynamic Hyperlinks
Pivot Table and slicer
Printing Tools
Auditing Tools
Name manager
Flash Fill
Consolidation
IF, IFS, And, Or & Not functions
SUM Product
Macro the beginning
The session would go around 10-12 hours, We take live sessions only on Saturday and Sunday (For Dubai and Saudi Arabia its Friday). The session would held one hour on Saturday and One Hour on Sunday. Live Softwares - Google Hangout/Zoom/Skype For further information regarding the course please email on info@vikominstitute.com or WhatsApp on +91-9213331108