Excel 2010 – Level 2

excel level 2Part of the 21 course bundle

or £99 individually

signup

Overview

What does the course cover?

This course builds on the Excel Level 1 foundations course to teach you how to use the essential tools in Excel. You’ll learn V and H lookup, CountIf and SumIf and database functions. You’ll work with charts, graphs, filters and lists, import different file formats (like XML data) and track changes in a spreadsheet.

Aims

Why take this course?

This course provides you with solid knowledge in the most important tools in Excel. Once you have finished the course you will know more than most people who are using Excel each day. You’ll have powerful skill-set that you can use in building spreadsheets that make you even more efficient in your role.

Audience

Who should attend?

If you work with Excel on a regular basis there is a huge amount to gain by being confident at this level. There are many features to learn and this course will save you hours and hours of work as you start to start make the most of the functionality of Excel.


Course preview

Each course contains high quality, professional, Live demo’s, Downloadable exercise files and Real-world templates for you to use.


Course detail and sample lessons

Section 1: Introduction to Excel

Lesson 1: Introduction
View Demo
Lesson 2: Starting Excel
View Demo
Lesson 3: Touring Excel
Demo Not Available
Lesson 4: Entering and Editing Data
Demo Not Available
Lesson 5: Saving a Wordbook as an .XLSX
Demo Not Available
Lesson 6: Saving a Workbook in a different file format
Demo Not Available
Lesson 7: Closing a Workbook
Demo Not Available
Lesson 8: Setting Excel File Defaults
Demo Not Available

Section 2: Selecting Cells and Ranges

Lesson 1: Introduction
View Demo
Lesson 2: Selecting Cells, Rows and Columns
View Demo
Lesson 3: Moving, Copying and Deleting Cells
Demo Not Available
Lesson 4: Using Undo and Redo
Demo Not Available
Lesson 5: Finding and Replacing Values
Demo Not Available
Lesson 6: Spell checking a spreadsheet
Demo Not Available

Section 3: Modifying a Worksheet

Lesson 1: Introduction
View Demo
Lesson 2: Inserting, Deleting and Renaming a worksheet
View Demo
Lesson 3: Worksheet Views
Demo Not Available
Lesson 4: Clearing and Deleting Cells
Demo Not Available
Lesson 5: Inserting and Deleting Rows and Columns
Demo Not Available
Lesson 6: Modifying Column and Row Size
Demo Not Available
Lesson 7: Freezing and Unfreezing Rows and Columns
Demo Not Available

Section 4: Formatting Cells and their Contents

Lesson 1: Introduction
View Demo
Lesson 2: Formatting cells using the font group
View Demo
Lesson 3: Changing cell alignments
Demo Not Available
Lesson 4: Formatting numbers and dates
Demo Not Available
Lesson 5: Cell Borders and Patterns
Demo Not Available
Lesson 6: The Format Painter
Demo Not Available

Section 5: Building Simple Formula

Lesson 1: Introduction
View Demo
Lesson 2: Basic Operators
View Demo
Lesson 3: Using the SUM function
Demo Not Available
Lesson 4: Using AutoSUM
Demo Not Available
Lesson 5: Using the AVERAGE function
Demo Not Available
Lesson 6: Using the COUNT function
Demo Not Available
Lesson 7: Using the MAX function
Demo Not Available
Lesson 8: Using the MIN function
Demo Not Available
Lesson 9: Using the ROUND function
Demo Not Available
Lesson 10: Using the IF function
Demo Not Available
Lesson 11: Common formula errors
Demo Not Available

Section 6: Absolute and Relative Referencing

Lesson 1: Introduction
View Demo
Lesson 2: Using the AutoFill Tool
View Demo
Lesson 3: Relative Referencing
Demo Not Available
Lesson 4: Absolute Referencing
Demo Not Available

Section 7: Sorting Data

Lesson 1: Introduction
View Demo
Lesson 2: Sorting Data
Demo Not Available

Section 8: Charts and Graphs

Lesson 1: Introduction
View Demo
Lesson 2: Inserting and Deleting a chart
View Demo
Lesson 3: Moving and Resizing a Chart
Demo Not Available
Lesson 4: Editing the Chart type
Demo Not Available
Lesson 5: Chart Layouts and Labels
Demo Not Available
Lesson 6: Editing the Axes and Gridlines
Demo Not Available
Lesson 7: Formatting Selected Items in a chart
Demo Not Available
Lesson 8: Printing a Chart
Demo Not Available
Lesson 9: Special Features for Pie Charts
Demo Not Available

Section 9: Importing Text and Graphics

Lesson 1: Introduction
View Demo
Lesson 2: Inserting Images onto an Excel Sheet
Demo Not Available
Lesson 3: Importing Text Files (*.TXT)
Demo Not Available

Skills you’ll learn

What you’ll be able to do after the course

  • Save and export Excel into different formats
  • Protect workbooks and worksheets
  • Import and export XML and CSV files
  • Work with Vlookup and Hlookup functions
  • Filter and subtotal lists
  • Work with named cells and ranges
  • Use validation in a spreadsheet

How you can apply these skills

What you’ll be able to use these skills for

  • Perform data analysis
  • Lookup prices or products based on IDs or dates
  • Create advanced charts
  • Create charts with trend lines
  • Understand more complex spreadsheets
  • Use conditional formatting to highlight key data
  • Share workbooks with other users

Certification

When you pass the exam you will receive an internationally recognised accreditation certificate like this:

Excel_Core_Certificate


Careers that require these skills at this level?

Excel is used in practically every business and in nearly all departments in those businesses – ranging from sales to accounting and administration. Any office role will require you to be proficient to this level.