Instructor Led Cells Training Classes in United Kingdom
From Mullan Training
Microsoft Publisher



...Object
Tables
- Adding a Table
- Selecting & Modifying Cells
- Formatting Table Data
The Design Gallery
- Inserting a Design Gallery Object
- Replacing Selected Objects
- Applying Attributes from a Design Gallery Object
- Customising the Design Gallery
LOCATIONS
Courses can be delivered at our offices in Belfast city centre (opposite the Europa Hotel) or in your own workplace (where we
more...
Introduction To Business Objects



...ns
- Adding Page Breaks
- Formatting Charts
- Aligning Cells
- Aligning Blocks
Creating & Editing Queries
- Using the Query Panel
- Editing a Query
- Building a Query
- Running a Query
- Saving Queries
Using Functions
- Filtering Data
- Ranking Data
- Using Alerters
- Inserting Simple Calculations
Creating Variables
- Resetting Calculations across Breaks
- If..Then Else
more...
VB Excel


...Printing a Visual Basic Module
The Range Object
The Cells Property
The Range Property
Flexible Ranges
Range Contents
Workbooks and Sheets
Activating a Workbook
Activating a Worksheet
ThisWorkBook
Objects, Properties and Methods
Controlling Objects with their Properties
Performing Actions with Methods
Performing Multiple Actions on an Object
Variables and
more...
Introduction To MS Frontpage



...Be Carried Out Using Them
- Insert/ Delete/ Merge/ Split Cells
- Resize Rows & Columns (With Mouse, Distribute & Autofit)
- Cell Padding, Alignment, Background Picture/ Colour
Frames
- Outline Use Of Frames
- Create, Resize, Delete, Split Frames
- Set Frame Properties (Resizable, Scroll Bars)
Hyperlinks
- What Are Links? ALT Tagging Of Images To Benefit Users
- Relative & Absolute
more...
From Computer Training Solutions UK
Excel training courses (1 day) Introduction in Bristol, Bracknell or Solihull

...ooks
Working with workbooks and worksheets
Working with cells
Navigating within a worksheet
Spreadsheet Data
Entering data
Using time saving features
Formatting and Customising Data
Selecting in Excel
Formatting text
Formatting numbers
Formatting columns and rows
Formatting cells with borders and shading
Editing Spreadsheets
Cutting, copying and pasting
Inserting and deleting
more...
From 2e2
Microsoft Excel Intermediate
..., apply, and modify styles; and change the orientation of cells. Sort lists by columns; and filter lists based on complex criteria. Format data points; create combination charts and trend lines; and add and format graphic elements. Embed and link objects in a worksheet; and allow several users to work with the same data by sharing, merging, and tracking changes. Use auditing features; add
more...
Microsoft Excel Advanced
...ll know how to: Use names to assign descriptive labels to cells; use financial functions to calculate values based on conditions. Use data tables to view the effects of multiple input values on a formula. Use the Subtotal command, the Subtotal function and database functions to summarise list data; and use data forms and validation to facilitate data entry in lists; and use data tables to
more...
