Excel Level 2
Short course
In Washington and Newcastle Upon Tyne
Description
-
Type
Short course
-
Location
-
Duration
1 Day
This course will enable delegates to streamline repetitive tasks and display spreadsheet data in more visually effective ways. Delegates will use Excel to streamline and enhance spreadsheets with templates, charts, graphics, and formulas.
Facilities
Location
Start date
Start date
Start date
About this course
We recommend that you have experience with creating, editing, formatting, saving, and printing basic spreadsheets in Excel. Students can obtain this level of skill by attending Excel Level 1.
Reviews
Course programme
This course will enable delegates to streamline repetitive tasks and display spreadsheet data in more visually effective ways. Delegates will use Excel to streamline and enhance spreadsheets with templates, charts, graphics, and formulas.
Prerequisites
- We recommend that you have experience with creating, editing, formatting, saving, and printing basic spreadsheets in Excel. Students can obtain this level of skill by attending Excel Level 1.
Objectives
- Delegates will be able to :
- Test a value in a specific cell to see if it meets a certain condition, Display a warning in a cell if the data does not meet the required criteria.
- Create a summary sheet that will calculate the total for a range of sheets, without duplicating the data(i.e. Maybe an expenses sheet that takes the monthly totals and displays them on a summary sheet)
- Filter a spreadsheet to show only the records that meet a specific criteria (i.e. All surnames beginning with A)
- Display data in various graphical formats that can be easily understood by anyone not using Excel.
- Excel Level 3
- Excel Pivot Tables
- Bespoke course (a course written to your specific needs) at your company office throughout the UK, at our training venue or at an independent location, convenient to you
- Private course at your company office throughout the UK, at our training room or at an independent location, convenient to you
- Scheduled public course at one of our training venues
- 1 delegate per computer
- 12 Months telephone and email support
- Comprehensive colour course manual and exercises
- Use of a Modern Training suite with 19 inch flat screen monitors
- Lunch (When at our training venue)
- Refreshments (When at our training venue)
- Relaxed refreshment area at our training room
Recap of Introduction Level 1
- Simple Formulae
- AutoSum
- Functions, SUM, IF, COUNT, AVERAGE, MAX, MIN etc
- Using the Sum function in referencing
- Simple Referencing in a worksheet
- 3D References
- AutoFormats
- Adding comments to cells on a worksheet
- Creating and modifying toolbars
- Using AutoFill
- Fixing column and row headings
- Protecting a Workbook/Worksheet
- Naming cells and ranges
- Using subtotals
- Filtering, sorting and finding information
- Excel as a database
- Headers and footers
- Customising a template
- Creating a template
- Changing the chart properties
- Creating a chart using the wizard
- Creating a chart in a hurry
Excel Level 2