Course Icon Excel Training

Advanced Excel Data Analysis and Management

Designed for Excel versions 2016,2013,2010,2007

0800 1337 401

Course Objectives

Welcome to Seven Institute’s course for Microsoft Office Excel, a popular spreadsheet application designed for organising and analysing data, performing calculations, and charting information. This advanced part 3 level is intended to help regular users of Excel become even more proficient by expanding their knowledge of Excel’s power tools including powerpivot, active controls, VBA, and Power View.

Who Should Attend

Excel Advanced Part 3 is suitable for people who have attended our Excel Advanced course or who have equivalent knowledge. Some of the content is only available in Microsoft Excel versions 2010 and 2013.

Experience Required

Completed our Excel Advanced course and ideally you will have some experience using pivot tables.

Course Syllabus

WORKING WITH FORM CONTROLS AND ACTIVE X CONTROLS

  • Button Control
  • Label Control
  • Check box Control
  • Option Button Control
  • List box Control
  • Combo box Control
  • Spin Button Control
  • Scroll bar Control
  • Group box Control
  • Using Form Controls – techniques & examples
  • Other Controls in Excel
  • Data Tables
  • Creating single input tables
  • Creating double input tables
  • Projecting with data tables

GETTING THE MOST OF OUR YOUR DATA

  • Describe scenarios
  • Create a scenario
  • Save multiple scenarios
  • Merge scenarios together
  • Create a scenario summary report
  • Enable data analysis tools
  • Identify available analysis and add-in tools
  • Use a one or two input data table
  • Use Goal Seek
  • Generate reports and scenarios with Solver
  • Change Solver values and manage constraints
  • Choose a solving method
  • Use Solver as a goal seek tool
  • Insert, edit, format, and use hyperlinks

AN INTROCUTION TO POWERPIVOT

  • Download, install, and use PowerPivot
  • Integrate Access and Excel data using PowerPivot
  • Create a PivotTable from PowerPivot data

ADVANCED EXCEL TASKS

  • Understand AutoFill lists
  • Create, use, modify, and delete custom AutoFill lists
  • Link, consolidate, and combine workbooks
  • Pivot consolidated data using the PivotTable and PivotChart Wizard
  • Importing and exporting data
  • Excel Power View

INTRODUCTION TO VBA AND CREATING MACROS WITH VBA

  • VBA and Macro overview
  • Create macros using some basic VBA Code
See all of the available Seven Institute Excel Courses