excel 2007 level 2

qa ltd.
aberdeen, birmingham, bristol, edinburgh, exeter, glasgow, leeds, london, manchester, slough, united kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' in microsoft® office excel® 2007: level 1, you created, edited, formatted, and printed basic spreadsheets. you now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. in this course, you will use microsoft office excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.



prerequisites
create basic spreadsheets
select and edit data
perform basic formatting
open, close and save files
create basic formulas �autosum
use insert function tobuilt-in functions
work with absolute references
use the autofill feature
delegates will learn how to


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

calculate with advanced formulas
organise worksheet anddata using various techniques
create and modify charts
analyse data using pivottables and pivotcharts
insert graphic objects
customise and enhance workbooks and the microsoft® office excel® environment


course outline
lesson 1: calculating data with advanced formulas
topic 1a: manage cell and range names
topic 1b: calculate data across worksheets
topic 1c: use specialized functions
topic 1d: analyze data with logical and lookup functions

lesson 2: organizing worksheet anddata
topic 2a:and modify tables
topic 2b: format tables
topic 2c: sort or filter worksheet ordata
topic 2d: calculate data in aor worksheet

lesson 3: presenting data using charts
topic 3a:a chart
topic 3b: modify charts
topic 3c: format charts

lesson 4: analyzing data using pivottables and pivotcharts
topic 4a:a pivottable report
topic 4b: analyze data using pivotcharts

lesson 5: inserting graphic objects
topic 5a: insert and modify pictures and clipart
topic 5b: draw and modify shapes
topic 5c: illustrate workflow using smartart graphics
topic 5d: layer and group graphic objects

lesson 6: customizing and enhancing workbooks and the excel environment
topic 6a: customize the excel environment
topic 6b: customize workbooks
topic 6c: manage themes
topic 6d:and use templates
...''

Elements of this syllabus are subject to change.

Phone:0844 871 2080

School Address:

tel: 0844 871 2080
e-mail us: info@qa.com

Jobs & Resumes: aberdeen, birmingham, bristol, edinburgh, exeter, glasgow, leeds, london, manchester, slough
Houses & Roommates: aberdeen, birmingham, bristol, edinburgh, exeter, glasgow, leeds, london, manchester, slough
Travel Agencies: birmingham, bristol, edinburgh, leeds, london, manchester,

Search other schools for excel 2007 level 2 training resources.

vba
publisher 2003 intro
vba programming with microsoft excel
word 2003 vba
access 2007 level 1
access 2007 level 2
access 2007 level 3
access 2007 level 4
SharePoint 2007 Advanced
excel 2007 level 1
excel 2007 level 3
infopath 2007 level 1
vista level 1
Vista Level 2
DreamWeaver MX 2004 Advanced
DreamWeaver MX 2004 Introduction

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We provide free training course catalog service since 2003, in English and Chinese. Tens of thousands of visitors search our database from our portal and partners' websites each day.