Advanced Excel Training Syllabus Introduction to MS Excel and Understanding Basic Working with it.
Introduction to MS Excel, Quick Review on MS Excel Options , Ribbon, Worksheets and Tools. i!erent "etween Excel #$$%, #$$&, #$'$ and #$'%. Savin( Excel )ile as *S+, Macro Enable Sheet, ) and Older +ersions. -sin( Excel Shortcuts with )ull ist o/ Excel Shortcuts *op0, *ut, aste, 1ide, -nhide, elete and ink the ata in Rows, *olu2ns and Sheets. -sin( aste Special Options. )or2attin( *ells, Rows, *olu2ns and sheets. rotectin( 3 -nprotectin( *ells, Rows, *olu2ns and Sheets with or without wi thout password a(e a0out, The2es, "ack(round and rinter roperties. Insertin( ictures, 10perlinks, 1eader4)ooters, shapes and other ob5ects in worksheets.
Advanced Excel Course - Working with Functions ~ Writing conditional expressions (using IF) ~ Using logical functions (AND, OR, NOT) ~ Using looup and reference functions (!"OO#U$, %"OO#U$, &AT'%, IND) ~ !looU$ *it+ xact &atc+, Approxiate Approxiate &atc+ ~ Nested !looU$ *it+ xact &atc+ ~ !looU$ *it+ Ta-les, D.naic Ranges ~ Nested !looU$ *it+ xact &atc+ ~ Using !"ooU$ to consolidate Data fro &ultiple /+eets Advanced Excel Course - Data Validations ~ /pecif.ing a 0alid range of 0alues for a cell ~ /pecif.ing a list of 0alid 0alues for a cell ~ /pecif.ing custo 0alidations -ased on forula for a cell Advanced Excel Course - Working with Templates ~ Designing t+e structure of a teplate ~ Using teplates for standardi1ation of *ors+eets Advanced Excel Course - Sorting and Filtering Data ~ /orting ta-les ~ Using ultiple2l ultiple2le0el e0el sorting ~ Using custo sorting ~ Filtering data for selected 0ie* (AutoFilter) ~ Using ad0anced filter options Advanced Excel Course - Working with eports ~ 'reating su-totals ~ &ultiple2le0el su-totals ~ 'reating $i0ot ta-les ~ Foratting and custoi1ing $i0ot ta-les ~ Using ad0anced options of $i0ot ta-les
~ $i0ot c+arts ~ 'onsolidating data fro ultiple s+eets and f iles using $i0ot ta-les ~ Using external data sources ~ Using data consolidation feature to consolidate data ~ /+o* !alue As ( 3 of Ro*, 3 of 'olun, Running Total, 'opare *it+ /pecific Field) ~ !ie*ing /u-total under $i0ot ~ 'reating /licers ( !ersion 4565 7 A-o0e) Advanced Excel Course - !ore Functions ~ Date and tie functions ~ Text functions ~ Data-ase functions ~ $o*er Functions ('ountIf, 'ountIF/, /uIF, /uIf/) Advanced Excel Course - Formatting ~ Using auto foratting option for *ors+eets ~ Using conditional foratting option for ro*s, coluns and cells Advanced Excel Course - !acros ~ Relati0e 7 A-solute &acros ~ diting &acro8s Advanced Excel Course - What"# Anal$sis ~ 9oal /ee ~ Data Ta-les ~ /cenario &anager Advanced Excel Course - Charts ~ Using '+arts ~ Foratting '+arts ~ Using :D 9rap+s ~ Using ;ar and "ine '+art toget+er ~ Using /econdar. Axis in 9rap+s ~ /+aring '+arts *it+ $o*er$oint < &/ Word, D.naicall. ~ (Data &odified in xcel, '+art *ould autoaticall. get updated) Advanced Excel Course - %ew Features Excel ~ /parlines, Inline '+arts, data '+arts ~ O0er0ie* of all t+e ne* features Advanced Excel Course - Final Assignment ~ T+e Final Assignent *ould test contains =uestions to -e sol0ed at t+e end of t+e 'ourse