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.

• Build advanced formulas and perform complex calculations.
• Create and use a pivot table.
• Perform VLOOKUP

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

PIVOT TABLE

field List

• Arrange fields in the right place
• In rows and/or columns
• Use the report filter
• Choose the right summary and format in Values

TOOLS tab

• Choose the right layout
• Add or remove totals and subtotals
• Choose a style to enhance the Pivot Table

Options (ANALYSIS)

• Change the source and refresh the data
• Show percentage values
• Use segments with its views
• Group selection: (Date, number)
• Insert a Pivot Table
• Create a Simple Calculated Field (Depending on the time)

NAME MANAGER

• Define a name
• Edit, delete a name

RESEARCH

• Create, use and understand VLOOKUP
  and HLOOKUP

FORMULA VERIFICATION

• Identify dependents and precedents
• View formulas

Questions & Answers