Microsoft Excel Level 1

In this course you will create and edit basic Microsoft Office Excel worksheets and workbooks.

Course Objectives

The course will cover the following elements:

• Perform calculations in an Excel worksheet
• Modify an Excel worksheet
• Modify the appearance of data within a worksheet
• Manage Excel workbooks
• Print the content of an Excel worksheet
• Create formulas in a worksheet
• Insert functions in a worksheet
• Reuse formulas
• Edit worksheet data
• Find and replace data
• Manipulate worksheet elements
• Add boards and colors to cells
• Align
• Reuse formulas
• Edit worksheet data
• Find and replace data
• Manipulate worksheet elements

Prerequisites

To be successful in this course, you should be familiar with using personal computers and you should have used the mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders. To ensure your success, we recommend you first take one of ABCO’s introductory Windows courses, such as either of the following, or have equivalent skills and knowledge:

Course Benefits

Upon successful completion of this course, students will be able to:

• Create a basic worksheet by using Microsoft Excel 2010
• Perform calculations in an Excel worksheet
• Modify and Excel worksheet
• Modify the appearance of data within a worksheet
• Manage Excel workbooks
• Print the content of an Excel worksheet
• Define the Page Layout

Course Duration

8 Hours

Microsoft Excel Level 2

In this course you will utilize 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.

Course Objectives

The course will cover the following element:

• Calculating Data with advanced formulas
• Apply cell and range names
• Calculate data across worksheets
• Use specialized functions
• Analyze data with logical and lookup functions
• Organizing worksheet and table data
• Create and modify tables
• Format tables
• Use functions to calculate data
• Presenting data using charts
• Modify charts
• Analyzing data using PivotTables, Slicers and PivotCharts
• Create a PivotTable report
• Filter data using slicers
• Inserting graphic objects
• Insert and modify pictures and clip art
• Draw and modify shapes
• Illustrate workflow using smartart graphics
• Layer and group graphic objects
• Customizing and enhancing the excel environment
• Customize the Excel environment
• Customize workbooks
• Create and use templates

Prerequisites
Before starting this course, students are recommended to take the following ABCO Technology course or have equivalent knowledge:

• Microsoft® Office Excel® :Level 1.

Course Benefits

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 PivotCharts
• Insert and modify graphic objects in a worksheet
• Customize and enhance workbooks and the Microsoft Office Excel environment

Course Duration

8 Hours

Microsoft Excel Level 3

You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets and sharer Excel data with other applications.

Course Objectives

This course will cover the following elements:

• Streamlining workflow
• Update workbook properties
• Create a macro
• Edit a macro
• Apply conditional formatting
• Add data validation criteria
• Collaborating with other users
• Protect files
• Share a workbook
• Set revision tracking
• Review tracked revisions
• Merge workbooks
• Administer digital signatures
• Restrict document access
• Auditing worksheets
• Trace cells
• Troubleshoot invalid data and formula errors
• Watch and evaluate formulas
• Create a data list outline
• Analyzing data
• Create a trendline
• Create sparklines
• Create scenarios
• Perform a What-If analysis
• Perform a statistical analysis with the analysis ToolPak
• Working with multiple workbooks
• Create a workspace
• Consolidate data
• Link cells in different workbooks
• Edit links
• Importing and exporting data
• Export excel data
• Import and delimited text file
• Integrating Excel data with the web
• Publish a worksheet to the web
• Import data from the web
• Create a web query
• Structuring workbooks with XML
• Develop XML maps
• Import and Export XML data

Prerequisites

To ensure your success, we recommend that you first take the following ABCO Technology courses or have equivalent knowledge:

• Microsoft® Office Excel® : Level 1
• Microsoft® Office Excel® : Level 2

Course Benefits

Upon successful completion of this course, students will be able to:

• Enhance productivity and efficiency by streamlining the workflow
• Collaborate with other workbook users
• Audit worksheets
• Analyze data
• Work with multiple workbooks
• Import and export data
• Integrate Excel data with the web
• Structure workbooks with XML
• Course Duration

8 Hours