The Complete Microsoft Excel Course (L1-3)

Looking to boost your productivity with essential office tools? Unlock your potential with Microsoft Office eLearning! Gain expert-led skills at your own pace fitting lessons seamlessly into your life. This is your chance to acquire valuable knowledge and boost your career opportunities. What We Offer The Complete Microsoft Excel Course (Level 1-3) What You ll Learn Certificate Level Topics Covered Beginner s Certificate ✔️ A basic overview of Excel ✔️ Calculating sums averages and totals ✔️ Counting cells ✔️ Learning formulas such as IF COUNTIF SUMIF VLOOKUP HLOOKUP and AVERAGEIF ✔️ Pivot tables ✔️ Inserting editing and deleting comments ✔️ Creating borders ✔️ Wrapping text ✔️ Merging cells ✔️ Pasting sorting and converting columns to rows ✔️ Creating graphs and charts ✔️ Using the dictionary Intermediate Certificate ✔️ Learning more about intermediate Excel functions including ABS AVERAGEIF AVERAGEIFS and AVERAGEA ✔️ Data validation with date list time and numbers ✔️ Functions such as RANK MIN MAX CHAR MODE MEDIAN CODE CLEAN and EXACT ✔️ How to remove duplicates in Excel ✔️ Creating random numbers ✔️ Changing text case ✔️ How to use Templates ✔️ Insert Charts ✔️ Adding custom backgrounds ✔️ How to use Tables ✔️ How to auto fill data ✔️ Adding special characters ✔️ Changing border colour and theme Advanced Certificate ✔️ How to set a password to an Excel document ✔️ 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 What s Included 24/7 Student Support End of course certification Lifetime access to your course Compatible with modern devices Why You Should Grab The Offer Imagine learning what one loves whenever one wants. New Skills Academy offers a huge variety of expert-crafted courses designed for diverse interests and career goals. Learners dive into lessons packed with easy-to-understand relevant information which can be used right away. The academy s flexible approach means you can learn at your own pace fitting studies effortlessly into the schedule. Plus you ll earn verifiable CPD-approved qualifications that employers trust boosting your career prospects. And with supportive tutors by your side the learning journey will be smooth and rewarding.