Excel 2010 Level 2

Upcoming Courses

You can also contact us by phone at 250-727-2266 or by email at info@sectorlearning.com to register for a course date.

Click here to request a specific date, 1-1 training, or course customization.

Summary

What is Excel?

Microsoft Excel 2010 is a powerful spreadsheet software program that allows you to make quick and accurate numerical calculations. Entering data onto a spreadsheet (or a "worksheet," as it is called in Excel) is quick and easy. Once data has been entered in a worksheet, Excel can instantly perform any type of calculation on it. Excel can also make your information look sharp and professional.

The uses for Excel are limitless: businesses use Excel for creating financial reports, scientists use Excel for statistical analysis, and families use Excel to help manage their investment portfolios. Microsoft Excel is by far the most widely used and, according to most reviews, the most powerful and user friendly spreadsheet program available.

Course Outline

Working with Ranges
Defining Range Names
Protecting Cells, Worksheets and Workbooks
Creating a Template
Working with Microsoft Templates

More Functions and Formulas
Using Logical Functions (IF)
Using Financial Functions (PMT)
Using Lookup Functions (VLOOKUP)
Understanding Formula Errors
Displaying and Tracing Formulas

Working with Multiple Workbooks and Worksheets
Viewing Multiple Workbooks
Viewing Multiple Worksheets
Linking Cells, Worksheets and Workbooks
Editing and Re-establishing a Link

Additional Viewing Options
Splitting and Freezing Worksheets
Creating Headers and Footers
Grouping and Outlining Data

Working with Data Ranges
Sorting and Filtering Data
Custom Sorting and Filtering
Using Text to Columns
Using Advanced Filters

Working with Tables
Creating a Table
Adding and Removing Data
Working with the Total Row
Removing Duplicate Rows of Data
Formatting the Table
Summarizing a table with a PivotTable
Coverting to a Range

Prerequisites

This course is designed for intermediate Microsoft Excel users. To ensure your success, we recommend you first take the following courses or have equivalent knowledge: Excel 2010 - Level 1 (Beginner).

Basic computer skills are necessary to complete this course. These skills include: a basic understanding of a computer's operating system, the ability to navigate the environment using a mouse and keyboard, an understanding of computer file storage, launching an application, and creating and saving files. It is also recommended that students are also familiar with using the internet.