Excel 2007/2010/2013/2016 Advanced - Validate & Summaries
Short course
In Cambridge
Description
-
Type
Short course
-
Level
Advanced
-
Location
Cambridge
-
Duration
1 Day
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. Suitable for: Designed for existing users of Excel who wish to progress their Excel skills and benefit from it's powerful data analysis tools.
Facilities
Location
Start date
Start date
About this course
It is assumed that the participant will have either attended an Excel Intermediate course or have equivalent knowledge.
Reviews
Subjects
- Manipulating data
- Summarise Filter Sort Import and Export data
- Excel
- MS Excel
- Exel 2007
- Excel 2010
- Excel 2013
- Excel 2016
- Microsoft Excel
- Accounts
Teachers and trainers (1)
TBA TBA
Trainer
Course programme
Excel Advanced Validate, summarise, analyse and manipulate your data with Excel
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
Additional information
Excel 2007/2010/2013/2016 Advanced - Validate & Summaries