ABC Dee Training
London, United Kingdom
http://www.office-it-training.co.uk/

Outlook Introduction

Getting started with Outlook Overview of Outlook Overview of Outlook Today Manage email Create and send messages Reply and forward messages Attach files to messages Open file attachments Format text in messages Use hyperlinks in messages Create an AutoSignature Overview of the address books View sent messages Resend a message Save draft versions of messages Flag messages f......
 

Overview of Outlook Manage email Attach files to messages Create an AutoSignature Schedule a new appointment Edit, copy and delete appointments Manage contacts Change contact views Work with tasks Add, edit and delete tasks Mark a task as complete Sort and reorder tasks The Out Of Office assistant Create an auto reply message Overview of Excel Enter and edit data Navigat......
 

Introduction to FrontPage Viewing a completed web Overview of the FrontPage environment Navigate FrontPage Screen Elements & Understand Use of Folders Create New Web Folder Creating a New Web Page Create Web Pages within Web Fold Save & Close Web Pages Working with Text & Formatting Applying Basic Styles Web Design Do’s & Don’ts Designing & Building a Web Site Design......
 

Running a macro Recording a macro Examining module design Assigning macros Specifying the location of recorded macros Assigning shortcut keys to macros Assigning macros to menus Assigning a macro to a button on a sheet Assigning a macro to a button on a toolbar Creating decision-making code The If...Then decision structure The If...Then...Else decision structure The Select Case ......
 

Insert and edit graphic objects to enhance worksheets and charts Format graphic objects Advanced techniques for filtering data Multiple-condition criteria Manage a filtered list Create name ranges Use name ranges in formula Manage name ranges LOOKUP functions VLOOKUP, HLOOKUP functions IS, ERROR functions Create Pivot tables Edit pivot tables Group and summarise data ......
 

Absolute references Work with multiple worksheets Work with multiple workbooks Link cells in different workbooks Create workspaces Formula construction Logic functions: IF, nested IF functionAND, OR function SUMIF, COUNTIF functions Create, edit and delete comments Use the auditing toolbar Use data validation Sort data Single-level and multiple-level sorting Sorting opt......
 

Introduction to Excel basics The workbook environment Enter and edit data Navigate in a worksheet Correcting data Edit cell contents Use AutoComplete Save a file Open a second and third file Navigation and movement techniques Modifying a workbook Work with ranges Create formulae Move and copy data Cut and paste data Drag and drop data Insert rows and columns Use the cl......
 

The visual basic programming environment in Access When to use VBA rather than macros The object browser The Visual Basic editor Visual Basic modules Editor options Editor views The concepts of object-oriented programming Visual Basic syntax The structure of procedures The declaration section Comments Keywords Indenting code Navigating code using the keyboard Bookmark ......
 

Structuring Existing Data Use the Table Analyzer Wizard for Help Decide on Your Own Design Create a Junction Table Modify the Original Tables and Completing the Design Compact and Repair a Database Summarizing Data Group and Summarize Records in Different Ways Summarize with a Crosstab Query Pivot Query Results Display a Graphical Summary on a Form Simplifying Tasks with Macros......
 

Managing a Database and Data Import Data Maintain Record Integrity Export Data Document Table Relationships Controlling Data Entry Make Data Entry More Accurate Make Data Entry More Efficient Facilitate Data Entry Finding and Joining Data Find Data with Filters Get the Correct Data with Query Joins Build Bridges Between the Data Relate Data Within a Table Creating Flexible Q......
 

Working with a Relational Database Identify Uses of a Relational Database Define Database Terminology Create a New Database Based on a Template Examine the New Database Planningng Database Identify Database Purpose Review Existing Data Determine Fields Group Fields into Tables Normalize the Data Designate Primary and Foreign Keys Identify Table Relationships Building the ......
 

Module 1: Basic Concepts of Information Technology Knowledge of main parts of a computer and network. Also includes storage, software, working environment, health and safety, viruses, copywrite and data protection. Module 2: Using the Computer and managing files Using the Windows screen (such as changing screen savers, background settings, icons, folders, waste basket, minimise, maximi......
 

Pages:- 1 2 3 4 5 6 7 8

School Index A~Z: A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z

Tips: Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting.