Microsoft Excel 2007 Level 4

Level
Total time

Microsoft Excel 2007 Level 4

Indicia Training
Logo Indicia Training

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

Microsoft Excel 2007 Level 4


Course Duration

1 day


Target Audience

This course is aimed at users who have attended Level 1, 2 and 3 Microsoft Excel Course, or for experienced users wishing to clarify existing knowledge using various methods and techniques.


Course Objectives

This course will provide delegates with the necessary skills and knowledge required to perform the following tasks:

· Naming Ranges and Protecting Workbooks
· Working With Lists
· Using Templates
· Recording Macros
· Vertical Lookup and Horizontal Lookup
· Data Validation


Course Contents

Naming Ranges and Protecting Workbooks
Naming Ranges
Working with Named Ranges
Name Manager
Cell Comments
Change the default name that is disp…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Microsoft Excel 2007 Level 4


Course Duration

1 day


Target Audience

This course is aimed at users who have attended Level 1, 2 and 3 Microsoft Excel Course, or for experienced users wishing to clarify existing knowledge using various methods and techniques.


Course Objectives

This course will provide delegates with the necessary skills and knowledge required to perform the following tasks:

· Naming Ranges and Protecting Workbooks
· Working With Lists
· Using Templates
· Recording Macros
· Vertical Lookup and Horizontal Lookup
· Data Validation


Course Contents

Naming Ranges and Protecting Workbooks
Naming Ranges
Working with Named Ranges
Name Manager
Cell Comments
Change the default name that is displayed in new comments
Adding and Working with Cell Comments Error! Bookmark not defined.
Format Cell Comments
Adding Notes with Text Boxes
Contextual Format Ribbon
Protecting Workbook Information
Share and Protection
Allow Users to Edit Ranges
Allow Users to Edit Ranges, Protect Sheet
Modify, Delete, Permissions and Paste Options Edit Ranges

Working With Lists
What Is a List?
Quick Access Toolbar – Data Form
Using a Form within a List
Sorting Your Data
Filtering Data in a List
Filtering Data in a List
Using an Advanced Filter
Using an Advanced Filter
Summarising Data in A List
Sub Total Function
Group and Ungroup
Text to Columns
Concatenate Function
Group and Ungroup

Using Templates
Creating Templates
Create a Workbook Template
Inserting Template Sheets into Workbooks
Saving a Workspace File and Arrange All
Viewing Multiple Worksheets in Same Workbook

Macro
Recording Macro
Running a Macro
View Macros
Use Relative References
Add the Developer Ribbon Tab
Assigning Macro to Shortcut Keys or Buttons
Assigning Macro to Shortcut
Assigning Macro to A Button

Vertical and Horizontal Lookup
Lookup Functions
Lookup Horizontal and Vertical Functions
Horizontal Table Array
Row/Index Number - Horizontal
Vertical Table Array
Row/Index Number - Vertical
Range Lookup – Horizontal and Vertical
Insert Function Tool – Formula Bar - Hlookup
Insert Function Tool – Formula Bar - Vlookup
Additional Functions

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.