Deepen your skills with our Microsoft Office Excel certified training. This tool allows you to specify your numbers and data through multiple possibilities according to your needs. Master the most complex features of Excel software and impress your team and employer with name management, data protection, and validation!

In this advanced-level course, you will have the necessary knowledge to use various date, mathematical, logical, statistical formulas, etc.

See an overview of the lesson details by referring to the course outline.

With this advanced knowledge of Excel software, take your business to the next level with more in-depth analysis and more relevant data.

Advanced

Basic knowledge of Excel’s functions.

Read and build advanced formulas and perform complex calculations.

FUNCTIONS

Statistics

• Refresh on simple formulas
• Understand absolute,
  relative and mixed references
• Statistic: AVERAGE, COUNT, COUNTA, MAX, MIN, COUNTIF, AVERAGEIF

Maths & trigonometry

• SUMIF
• Age calculation: INT or DATEDIF

Text

• UPPER, LOWER, PROPER
• CONCATENATE
• TRIM, SUBSTITUTE
• LEFT, RIGHT
• CONCAT

Date

• TODAY, NOW
• YEARFRAC
• YEAR, MONTH, DAY, NETWORKDAYS

Logic and information

• simple IF nested
• complex IF nested (with multiple logics)
• IF, AND, OR
• ISBLANK

OTHER

PASTE SPECIAL

• Transpose
• Paste formula, value

CONVERT DATA

• Separate data to spread across multiple columns
• Convert data to number, text, or date

Questions & Answers