Microsoft Excel Advanced

This course is already delivered, please contact us for the next available session tel:+357 22 44 14 92
Course Outline in PDF


You will use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.Your training in and use of Microsoft Office Excel 2010 has provided you with a solid foundation in the basic and intermediate skills for working in Excel. You have used Excel to perform tasks such as running calculations on data and sorting and filtering numeric data. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.

Who should Attend:

This course is meant for those desiring to gain advanced skill sets necessary for calculating data using functions and formulas, sorting and filtering data, using PivotTables and PivotCharts for analyzing data, and customizing workbooks

At course Completion:

Upon successful completion of this course, students will be able to:
•Use advanced formulas.
•Organize worksheet and table data using various techniques.
•Create and modify charts.
•Analyze data using PivotTables, Slicers, and Pivot Charts.
•Insert and modify graphic objects in a worksheet.
•Customize and enhance workbooks and the Microsoft Office Excel environment
•Increase productivity and improve 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: Calculating Data with Advanced Formulas

•Topic 1A: Apply Cell and Range Names
•Topic 1B: Calculate Data Across Worksheets
•Topic 1C: Use Specialized Functions
•Topic 1D: Analyze Data with Logical and Lookup Functions

Lesson 2: Organizing Worksheet and Table Data

•Topic 2A: Create and Modify Tables
•Topic 2B: Format Tables
•Topic 2C: Sort or Filter Data
•Topic 2D: Use Functions to Calculate Data

Lesson 3: Presenting Data Using Charts

•Topic 3A: Create a Chart
•Topic 3B: Modify Charts
•Topic 3C: Format Charts

Lesson 4: Analyzing Data Using PivotTables, Slicers, and Pivot Charts

•Topic 4A: Create a PivotTable Report
•Topic 4B: Filter Data Using Slicers
•Topic 4C: Analyze Data Using Pivot Charts

Lesson 5: Inserting Graphic Objects

•Topic 5A: Insert and Modify Pictures and ClipArt
•Topic 5B: Draw and Modify Shapes
•Topic 5C: Illustrate Workflow Using SmartArt Graphics
•Topic 5D: Layer and Group Graphic Objects

Lesson 6: Customizing and Enhancing the Excel Environment

•Topic 6A: Customize the Excel Environment
•Topic 6B: Customize Workbooks
•Topic 6C: Manage Themes
•Topic 6D: Create and Use Templates

Lesson 7: Streamlining Workflow

•Topic 7A: Create a Macro
•Topic 7B: Edit a Macro
•Topic 7C: Apply Conditional Formatting
•Topic 7D: Add Data Validation Criteria
•Topic 7E: Update a Workbook’s Properties
•Topic 7F: Modify Excel’s Default Settings

Lesson 8: Collaborating with Others

•Topic 8A: Protect Files
•Topic 8B: Share a Workbook
•Topic 8C: Set Revision Tracking
•Topic 8D: Review Tracked Revisions
•Topic 8E: Merge Workbooks
•Topic 8F: Administer Digital Signatures
•Topic 8G: Restrict Document Access

Lesson 9: Auditing Worksheets

•Topic 9A: Trace Cells
•Topic 9B: Troubleshoot Errors in Formulas
•Topic 9C: Troubleshoot Invalid Data and Formulas
•Topic 9D: Watch and Evaluate Formulas
•Topic 9E: Create a Data List Outline

Lesson 10: Analyzing Data

•Topic 10A: Create a Trendline
•Topic 10B: Create Scenarios
•Topic 10C: Perform What-If Analysis
•Topic 10D: Perform Statistical Analysis with the Analysis ToolPak

Lesson 11: Working with Multiple Workbooks

•Topic 11A: Create a Workspace
•Topic 11B: Consolidate Data
•Topic 11C: Link Cells in Different Workbooks
•Topic 11D: Edit Links

Lesson 12: Importing and Exporting Data

•Topic 12A: Export Excel Data
•Topic 12B: Import a Delimited Text File

Lesson 13: Using Excel with the Web

•Topic 13A: Publish a Worksheet to the Web
•Topic 13B: Import Data from the Web
•Topic 13C: Create a Web Query

Lesson 14: Structuring Workbooks with XML

•Topic 14A: Develop XML Maps
•Topic 14B: Import and Export XML Data
sd sd sd sd sd sd sd sd sd sd sd sd