Microsoft Excel Course: Begginers ($14.95), Intermediate or Macros ($19.95) or Advanced ($24.95) at New Skills Academy

Learn all the in and outs of spreadsheets with a comprehensive Microsoft Excel online course for beginners or advanced users

BUY NOW!

Price: $14.95
Value: $199.00
Discount: 92%
You save: $184.05

Description

The Deal

$14.95 for a Microsoft Excel for beginners certification online course (total value up to $199)

  • Introduction to Excel
  • Add
  • Multiply
  • Subtraction
  • Dividing
  • Sort
  • Percentage
  • Running Totals
  • Print
  • Paste Special
  • Merge
  • Filter
  • Average
  • AVERAGEIF
  • SUMIF Formula
  • IF Formula
  • VLOOKUP
  • HLOOKUP
  • Countif Formula
  • CountBlank
  • Counta Formula
  • Count Formula
  • Concatenate
  • Transpose
  • Date Formula
  • Month Formula
  • Pivot Tables
  • Pie Charts
  • Doughnut Charts
  • Line Charts
  • Column Charts
  • Bar Charts
  • Number Formatting
  • Create Borders
  • Conditional Formatting
  • Comments

  • Learn more

$19.95 for a Microsoft Excel intermediate certification online course (total value up to $199)

  • SumProduct Formula
  • Data Validation With Date
  • Data Validation with Whole Numbers
  • Data Validation with List Feature
  • ABS Function
  • CHAR Function
  • CLEAN Function
  • CODE Function
  • EXACT Function
  • AVERAGEA Function
  • AVERAGEIF
  • AVERAGEIFS Function
  • CELL Function With 10 Variations
  • LARGE Function
  • MAX Function
  • MEDIAN Function
  • MIN Function
  • MODE Function
  • N Function
  • RANDBETWEEN Function (Insert Random Numbers)
  • RANK Function
  • Remove Duplicate Values
  • ROUND Function Up/Down
  • Add Custom Background Image
  • Change Text To Lower Case
  • Change Text To Upper Case
  • Change Text To Proper Case
  • Insert Special Character
  • Use Autofill : A Time Saving Trick
  • Treemap Chart
  • Sunburst Chart
  • Use Tables
  • Use Templates
  • Use Themes

  • Learn more

$19.95 for a Microsoft Excel macros certification online course (total value up to $199)

  • Definitions and Background
  • Running, Naming and Saving
  • Important Tips
  • Practical Macros

  • Learn more

$24.95 for a Microsoft Excel advanced certification online course (total value up to $299)

  • Add a Password
  • AND Function
  • Auto Updating Drop-down Lists
  • CEILING Formula
  • Charts that Update Automatically
  • CHOOSE Formula
  • Compare 2 Lists with VLOOKUP Function
  • CORREL Function
  • Create an Advanced Calculator
  • Create a Combo Chart
  • Create a Custom Tab
  • Create a Pivot Chart
  • Create Visual In-cell Indicators
  • Create Visual In-cell Indicators with Icon Sets
  • Customize the Status Bar
  • DATEDIF Function
  • DATEVALUE Function
  • DAVERAGE Function
  • DCOUNT Function
  • DCOUNTA Function
  • Depreciation Formula
  • DGET Function
  • DMAX Function
  • DPRODUCT
  • DSUM Function
  • EDATE Function
  • EOMONTH Function
  • Find and Replace
  • FIND Function
  • INDEX Function
  • INDEX MATCH Function
  • INDIRECT Function
  • Insert Serial Number Automatically
  • IPMT Function
  • ISBLANK Function
  • ISERR Function
  • ISLOGICAL Function
  • ISNONTEXT Function
  • ISNUMBER Function
  • ISODD Function
  • Isolate First Name
  • ISTEXT Formula
  • LEFT Function
  • LEN Function
  • MATCH Function
  • Vlookup Multiple Results at Once
  • OR Formula
  • PMT Formula
  • Replace Formula
  • Select all Cells with Comments
  • Sparkline Charts in Excel
  • Straight Line Depreciation
  • Strikethrough
  • Sum of Years Depreciation
  • Timeline in Pivot Table
  • Vlookup with 2 Criteria
  • Vlookup with DropDown List
  • Vlookup with Max
  • Vlookup with Min
  • Watch Window In Excel

  • Learn more

$44.95 for all four courses: Excel for beginners, intermediate and advanced and Excel macros (total value up to $896)

Highlights

  • Lifetime access to the video course
  • 24/7 access to the video course
  • 24/7 customer service from New Skills Academy
  • CPD certified
  • Course completion certificate included
  • Chose one of four courses or take them all

Completion of this course does not result in a degree of accounting or qualify participants to practice professionally.



Terms and Conditions

Validity: Must redeem by 30 Jun 2022. Lifetime access to course content, starting from registration date.
Purchase: Multiple vouchers per person can be redeemed or purchased as a gift
Restrictions: Register online: https://newskillsacademy.com/redeem-a-voucher/. No refunds or cancellations once login details have been provided. Internet connection required. No additional fees required. Compatible with all major devices and browsers. CPD Certified. This course may be accredited by a private organisation and may not be formally recognised in Australia or New Zealand. Customer support available. Standard fine print for all deals

PURCHASE THIS DEAL HERE!