Microsoft Office Excel – Advanced
1 Day Duration
Overview
This advanced course is aimed at users who have a number of year’s experience creating and working with complex data sets within Microsoft Office Excel. This course will introduce the security features of Excel, as well as its automating capabilities using Macros.
Data Analysis Tools
Goal seek Scenarios Data Tables
Spreadsheet Auditing
Precedents Dependants Formula error checking Watch window
Protecting Spreadsheets
Preparing spreadsheets for protection Locking cells Hiding formulae Protecting worksheets Protecting workbooks Password protection
Data Imports and Exports
Importing data into Excel Exporting data from Excel Saving data source files Refreshing data within Excel
Further Excel Features
Text to columns Remove duplicates Customising the Ribbon Customising the Quick Access Bar Using Flash Fill
Advanced Functions
Nesting functions within functions PMT CONCAT (CONCATENATE) FORECAST IFS / SUMIFS / COUNTIFS CHOOSE EDATE EOMONTH NETWORKDAYS CONVERT