FROG Software Training: Excel 2007/2010/2013/2016 Advanced - Validate & Summarise


FROG Software Training: Excel 2007/2010/2013/2016 Advanced - Validate & Summarise

The aim of this course is to assist users who need to become proficient in manipulating data within Excel. By the end of the course you will be able to Summarise, Filter, Sort, Import, and Export data at different levels. You will also have gained an understanding of how to create and edit Macros and be able to create a simple Macro.

Dates 26 Nov 2019 - Download as vCalendar
Opening times 09.30-16.30
Venue FROG, 4 Station Court, Great Shelford, Cambridgeshire CB22 5NE
Organiser name Debby O'Gorman
Telephone
01223841848
Email
Website

Event details:

Pre-requisites: It is assumed that the participant will have either attended an Excel Intermediate course or have equivalent knowledge.

Objectives
The aim of this course is to assist users who need to become proficient in manipulating data within Excel.  By the end of the course you will be able to Summarise, Filter, Sort, Import, and Export data at different levels. You will also have gained an understanding of how to create and edit Macros and be able to create a simple Macro. 

  • Lists
    • Single & Multi-level sorting
    • Auto Filter & advanced filter
    • Get external data
    • Extract data
    • Query databases
  • Data Validation
  • Pivot Tables and PivotCharts
    • Summarising With Pivot Tables
    • Using the Slicer
  • Subtotals
  • Grouping & Outlining
  • Importing and Exporting Data
  • Querying
    • Query databases
    • Extracting data
  • Templates
    • Apply/create/edit templates
  • Introduction to Macros
    • Recording a macro
    • Personal macro workbook
    • Running and editing a macro
    • Step through a macro
    • Assigning a macro to the Quick Access Toolbar
  • Using Workgroup Functions
    • Comments
    • Sharing lists
    • Tracking changes
    • Resolving conflicts
    • History of changes
    • Merging changes
    • Document Inspector
    • Mark as Final
  • Protecting Cells and Workbooks
FROG Software Training Limited

Founded in 1986 The FROG Group is recognised for the quality of its services. FROG has been providing computer and personal development training along with consultancy and room hire for over 30 years. The training centre in Cambridge offers a wide range of courses including the latest Microsoft Office, Personal Development, Adobe Creative Suite and many others, and together with partners across the UK FROG can provide all your training needs.

FROG Software Training Limited directory information