25,000+ Courses Nationwide
0345 4506120

Microsoft Excel - 2013 Level 2

This course builds upon the foundational Microsoft Office Excel 2013 knowledge and skills you've already acquired and sets you on the road to creating advanced workbooks and worksheets that will deepen your business intelligence.


In this course you will, create advanced formulas, analyze data with logical and lookup functions, organize worksheet data with tables, visualize data by using charts, analyze data with PivotTables, slicers, and PivotCharts, insert graphic objects and enhance workbooks.


This course is designed for individuals who already have foundational knowledge and skills in Excel 2013 and are ready to advance their data analysis skills and abilities.

Select specific date to see price, venue and full details.

Pre-Requisites

Before starting this course, delegates are recommended to take the following PTR course or have equivalent knowledge: Microsoft Office Excel 2013: Level 1.

Course Content

  •  Apply Range Names
  •  Use Specialized Functions
  •  Leverage Questions and Testing to Write Formulas
  •  Use Logical and Lookup Functions to Find Answers to Questions
  •  Create and Modify Tables
  •  Sort and Filter Data
  •  Use Summary and Database Functions to Calculate Data
  •  Create Charts
  •  Modify and Format Charts
  •  Create a Trendline
  •  Create Advanced Charts
  •  Create a PivotTable
  •  Filter Data by Using Slicers
  •  Analyze Data by Using PivotCharts
  •  Insert and Modify Graphic Objects
  •  Layer and Group Graphic Objects
  •  Incorporate SmartArt
  •  Customize Workbooks
  •  Manage Themes
  •  Create and Use Templates
  •  Protect Files

Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

We work with the best