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 create, modify and reorganize a Pivot Table

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.

• Create, modify and reorganize a Pivot Table
• Analyze and aggregate data to get a good report
• Perform a VLOOKUP and HLOOKUP

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