DATES: Monday 10th October 2015
LOCATION: New Horizions
COST: €100.00 per participant…… funding applied
DURATION: 1 Day
TIME: 9.30am to 5.00pm
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.
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.
|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.
New Horizons Dublin