### Transcription

DURATIONLOCATIONCOMPATIBILITYSUPPORT10 hoursOnlineAll major devicesand browsersWe are here to help ifyou have any problemsMicrosoft Excel AdvancedThe MS Excel Advanced Course is the longest and the most comprehensive of the three Excel coursespresented here. However, if you have successfully passed the beginner and the intermediate courses,you should consider yourself fully prepared to begin the advanced course.Formulas, or functions, are what advanced users of Excel want from this tool. When one uses formulas,not only can they see the data they require for their work, they can also analyse it and get answers tovery complex questions. Though any person with a small amount of Excel knowledge can use formulas,such as SUM, a user who has advanced Excel skills will use other formulas, both alone and combined,such as MATCH, INDEX, DSUM and VLOOKUP. In addition to knowing these formulas, those who areadvanced users of Excel know how to debug these formulas, how to audit them, and how to choose theperfect formula for the occasion.“All of our online courses have been checkedand approved by IVCAS and / or CPD for yourpeace of mind.”Approved By

What You Will LearnSome of the concepts that you will learn in the MS Excel Advance Course include the following:VLOOKUP Advanced formula options and manipulations.Other advanced functions including OR, AND, CHOOSE, INDIRECT, REPLACE, LEN, LEFT, FIND.Functions including CEILING, CORREL, DATEDIF, DATEVALUE, DAVERAGE and EDATE.Colouring a column and row with a formula.Highlighting a cell with a formula.Functions including ISODD, ISNUMBER, ISTEXT, ISLOGICAL, ISNONTEXT, ISERR and ISBLANK.Functions including DGET, DMAX, DPRODUCT, DCOUNTA, DCOUNT and DSUM.How to calculate depreciation in Excel, including SLN depreciation and SYD depreciation.Calculating loan IPMT and EMI.Functions including DATEDIF, DATEVALUE, EDATE, EOMONTH, MATCH and INDEX.Full explanation of the INDEX and MATCH functions, covering several modules.Looking up data.Selecting only cells containing comments.Hiding formulas.Automatically inserting serial numbers.“Every course comes with easy to understand,yet detailed lessons created by experts.”