Microsoft Excel 2007 Level 4
Starting dates and places
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…
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
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.