FROG Software Training: Excel Advanced - Validate & Summarise


Designed for existing users of Excel who wish to progress their Excel skills and benefit from its powerful data analysis tools. It is assumed that the participant will have either attended an Excel Intermediate course or have equivalent knowledge.

Dates Thursday, November 26, 2020 - Download as vCalendar
Event Times: 09:30 to 16:30
Venue Microsoft Teams
Contact Name Rachel Crew
Email training@frog.co.uk
Contact Phone 01223841848
Website Event website

Event details:

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 Clean and Summarise, Filter, Sort, Import, Share and Protect data. You will also have gained an understanding of how to record and edit simple Macros to speed up processes. 

 

Data Validation & Protecting Cells
 

Lists

  • “Cleansing Data” with formulas, Remove Duplicates, Text to Columns
  • Filter & Advanced Filter
  • Tables & Slicers
     

Outlining

  • Grouping
  • Subtotals
     

Pivot Tables and Pivot Charts

  • Summarising with Pivot Tables
  • Creating Pivot Charts
  • Using the Slicer/Timeline
  • Quick Analysis Tool
     

Importing Data

  • Importing Data from Various Sources
  • Get & Transform
     

Templates

  • Create/Edit a Template
     

Introduction to Recording Macros

  • Recording a macro
  • Running and editing a macro
  • Assigning a macro to Objects or Buttons

For over 30 years we have improved the skillset of over 20,000 individuals with our exceptional and enjoyable courses. Our training and support started back in 1986, when our founder was working with Stephen Hawking as his PA. But you don’t have to be a world-famous theoretical physicist to take part in our training – All our courses from beginner to advanced level provide you with actionable, hands-on training that you can put into practice immediately and save you valuable time!