Excel Advanced

  1. Home
  2. Events
  3. Excel Advanced

DATES: Wednesday 11th November 2015

LOCATION: New Horizions

COST: €€100.00 per participant…… funding applied

DURATION: 1 Day

TIME: 9.30am to 5.00pm

 

Overview

In this course students will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.

Objective

Upon successful completion of this course, students will be able to: – enhance productivity and efficiency by streamlining your workflow. – collaborate with others using workbooks. – audit worksheets. – analyze data. – work with multiple workbooks. – import and export data. – use Excel with the web. – structure workbooks with XML.

 

Outline

 

Lesson 1: Streamlining WorkflowUpdate Workbook PropertiesCreate a MacroEdit a MacroApply Conditional FormattingAdd Data Validation Criteria Lesson 2: Collaborating with OthersProtect FilesShare a WorkbookSet Revision TrackingReview Tracked RevisionsMerge WorkbooksAdminister Digital SignaturesRestrict Document Access Lesson 3: Auditing WorksheetsTrace CellsTroubleshoot Errors in FormulasWatch and Evaluate FormulasCreate a Data List Outline
Lesson 4: Analyzing DataCreate a TrendlineCreate SparklinesCreate ScenariosPerform What-If AnalysisPerform Statistical Analysis with the Analysis ToolPak Lesson 5: Working with Multiple WorkbooksCreate a WorkspaceConsolidate DataLink Cells in Different WorkbooksEdit Links Lesson 6: Importing and Exporting DataExport Excel DataImport a Delimited Text File
Lesson 7: Using Excel with the WebPublish a Worksheet to the WebImport Data from the WebCreate a Web Query Lesson 8: Structuring Workbooks with XMLDevelop XML MapsImport and Export XML Data

 

Who Should Attend

This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.

 Trainer

New Horizons Dublin

http://www.newhorizonsireland.ie

Menu