Master MS Excel Advanced Course
Course Details
MS Excel is one of the most important skills in today's job market. Having a solid working knowledge of Excel can improve your job performance, help you qualify for raises and promotions, or even help you land that new job that you deserve. If you're a business professional,student and employee who uses using Microsoft Excel on a daily basis, this is the course for you!
What Will You Learn?
In this course you will learn all the tab details of Excel - HOME, INSERT, PAGE LAYOUT, FORMULAS, DATA, REVIEW, VIEW etc.Master Microsoft Excel from Beginner to Advanced, Learn the most common Excel functions used in the Office, dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more.
Before Starting
Basic computer Knowledge
Instructor
Curriculum
Make Salary Sheet
0 minCreate Table
0 minPicture Option
0 minShape Option
0 minMake Hyperlink
0 minSpark Line
0 minAll Graphic Option
0 minText Option
0 minHeader & Footer
0 minColumn Chart
0 minLine Chart
0 minPie Chart
0 minTheme Option
0 minPage Setup
0 minScale To Fit
0 minArrange All
0 minTrue & False
0 minAnd Formula
0 minOR Formula
0 minIFNA Formula
0 minXOR Formula
0 minIF Formula
0 minNasted IF Formula
0 minHour Function
0 minDate Formula
0 minDate Value
0 minDay Formula
0 minDays Formula
0 minDays360 Formula
0 minE-Date formula
0 minEomonth Formula
0 minISO-WEEKNUM Formula
0 minNet-Work_days
0 minNet-Work-Day
0 minNow Formula
0 minSecond Formula
5 minTime Formula
5 minTime Value F
5 minToDay Formula
5 minWEEK-DAY Formula
5 minWEEK-NUM Formula
5 minWORK-DAY Formula
5 minWORK-DAY-INTL
5 minYEAR Formula
5 minYEAR-FRAC
5 minBAHTT TEXT
5 minChar Formula
5 minClean Formula
0 minCANCATENATE
5 minDOLAR Formula
5 minExact Formula
5 minFind Formula
5 minFixed Formula
5 minLEFT Formula
5 minLEN Formula
5 minLOWER Formula
5 minMID Formula
5 minPROPER Formula
5 minReplace Formula
5 minREPT Formula
5 minRight Formula
5 minSerach Formula
5 minSUBSTITUTE FORMULA
5 minT-Formula
5 minTrim - Formula
5 minUNI-Char
5 minUPPER Formula
5 minValue Formula
5 minFV Formula
5 minPMT Formula
5 minAddress Formula
5 minColumn Formula
5 minD-GET Formula
5 minFormula Text
5 minHyperlink Formula
5 minMatch Formula
5 minTranspose Formula
5 minV-Lookup
5 minGet External DATA
0 minSort & Filter
0 minData Tools
0 minConsolidate Option
0 minGoal Seek
0 minData Validation
0 minOutline Block
0 minCommands Option
0 minChanges Option
0 minWork Book
0 minZoom Option
0 minWindow Option
0 min
