Excel 2010 Level 2
You can also contact us by phone at 250-727-2266 or by email at firstname.lastname@example.org to register for a course date.
Click here to request a specific date, 1-1 training, or course customization.
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.
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
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.