admin@designated.org.uk - 0151 653 3338

Microsoft Courses

Microsoft Excel: Level Three Microsoft

2017/05/08
2017/05/08
  • 0

    day

  • :
  • 0

    hour

  • :
  • 0

    min

  • :
  • 0

    sec


Work with Excel as a real data tool. Be time efficent with Templates. Import data from other sources. Extract Data.

Overview

This one day training course aims to give intermediate users of Excel knowledge of commands and functions which will make them more proficient in spreadsheet design and development. How to apply these tools to solving their own business problems and good spreadsheet practice will also be covered.

Using Templates and Workbooks

  • Applying a Template
  • Using a Template
  • Creating a New Template
  • Editing a Template
  • Linking Between Workbooks
  • Importing Data from Text Files
  • Importing Data from Other Applications
  • Importing an HTML Table
  • Publishing Data to the Web

Working with Data

  • What is a List?
  • Validating Data Entries
  • Sorting Data
  • Subtotaling and Outlining Data
  • Extracting Data with Filters
  • Using Advanced Filters
  • Using Query
  • Querying the Web
  • Using XML to Share Data

Analysing Data

  • Using PivotTable Add info about Slicers
  • Managing PivotTable Reports
  • Creating PivotChart Reports
  • Using Charts and Trendlines
  • Working with Scenarios

Using Macros and Auditing Tools

  • What is a Macro?
  • Recording a Macro
  • Running a Macro
  • Editing a Macro
  • Auditing Workbooks
  • Tracing Errors

Sharing Workbooks

  • Creating a Shared Workbooks
  • Consolidating Data
  • Protecting Columns
  • Protecting Worksheets
  • Protecting Worksheet Content
  • Protecting Cells
  • Assigning a Password
  • Tracking Changes
  • Adding Comments
  • Preparing a Workbook