60%
40%
Highlights
Unlock comprehensive Office skills with New Skills Academy's expert-created courses. Learn anytime, anywhere, with tutor support & verifiable qualifications.
About This Deal
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.
Fine Print
About New Skills Academy
Offering over 800 online courses, New Skills Academy allows students to get a verifiable qualification and improve career prospects. The portfolio includes courses ranging from dog grooming and pet sitting to retail banking, event management and cabin crew skills. A team of experienced and knowledgeable tutors are on hand to offer help and support. Lifetime access to the course Certificate upon completion. Courses offered by New Skills Academy have been rated 5 stars by the vast majority of customers on Trustpilot. All courses are available online, and can be accessed using a PC, MacBook, tablet or smartphone. New Skills Academy offers 24 hour customer service. Student Discount cards are also available.
Groupon Customer Reviews
100% Verified Reviews
All Groupon reviews are from people who have redeemed deals with this merchant. Review requests are sent by email to customers who purchased the deal.