157 Office Skills & Productivity courses in Warlingham

This MS Access Advanced Course mostly covers creating advanced MS Access reports, forms, and macros. Create and amend Advanced Forms and Advanced Reports. Macro buttons. This assists you to build user-friendly forms to facilitate effective navigation, effective data capture and effective viewing and querying data This course will help you to structure MS Access tables, import, and manage your data effectively.

This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database. This workshop will help participants: Ensure the integrity of their databases Manage field properties Use the query functions effectively Save time with the query expression builder Create different types of query more quickly Design better forms Link expressions in forms Create better and more useful reports Import and export tables more easily 1 Table relationship integrity Identifying relationships Identifying criteria for data integrity Applying referential integrity Managing relationship join types 2 Table field properties Field properties overview Using input mask field Using default value fields Using field validation rules 3 Query functions Running aggregate function calculations Running sum, average, count, max and min functions Grouping calculated data 4 Query calculations Using query operators and expressions Adding calculated fields to a query Using the query expression builder 5 Action queries Creating make table queries Creating append queries Creating update queries Creating delete queries 6 Designing forms Adding form controls Aligning and arranging form controls Adding pictures and labels to forms Adding new fields to a form Controlling tab order Adding command buttons Adding a combo box control Formatting data using conditional formatting 7 Form expressions (calculations) Using the form expression builder Working with a property sheet within a form Linking expressions within a form 8 Working with reports Creating reports with the report wizard Inserting report fields Formatting fields Inserting report headers and footers Working with a property sheet within a report 9 Grouped reports Creating groups with the report wizard Sorting grouped data Grouping alphabetically Grouping on date intervals Creating sub reports Adding calculations to groups 10 Importing and exporting tables Importing tables into Access Exporting tables from Access Importing and linking data in Access

Publisher Courses. With MS Publisher, combine text and photos illustrations to make professional newsletters publications. At our MS Publisher course, learn how to.

Time Management and Productivity (In-Person) Effective time management reduces stress and helps you better adhere to commitments. This course is designed to help you identify personal and organizational priorities and gain better control of where you focus your attention. You will explore the importance of planning and organizing, and you will practice sorting through and setting priorities. You will also learn how to set better time boundaries and manage the demands of others. Working with a time management framework, you will use a set of practical techniques to organize and manage your work to better deliver on your commitments. Techniques for overcoming procrastination will be addressed, as well as strategies for dealing with information overload. What You Will Learn You'll learn how to: Plan and prioritize each day's activities in a more efficient, productive manner Establish strategies to execute priorities and overcome procrastination Understand how to make trade-offs when faced with fire drills How to set and communicate boundary conditions Getting Started Introductions Course orientation Participants' expectations Foundation Concepts Exercise: A day in your life Resources to implement change o Mind-set o Tool-set o Skill-set What is your time really worth? The dynamics of procrastination The myth of multi-tasking Brain Rules - how to optimize your efficiency Organization and Prioritization Time management best practices Goal setting Exercise: Identifying your priorities The importance of organization Time management framework Prioritizing time Time Management Techniques Tips for managing time Nine ways to overcome procrastination The STING technique Managing your time o Handling unplanned urgencies o Dealing with information overload Delegation and managing others' time Creating your personal action plan

Time Management and Productivity Effective time management reduces stress and helps you better adhere to commitments. This course is designed to help you identify personal and organizational priorities and gain better control of where you focus your attention. You will explore the importance of planning and organizing, and you will practice sorting through and setting priorities. You will also learn how to set better time boundaries and manage the demands of others. Working with a time management framework, you will use a set of practical techniques to organize and manage your work to better deliver on your commitments. Techniques for overcoming procrastination will be addressed, as well as strategies for dealing with information overload. What you Will Learn Plan and prioritize each day's activities in a more efficient, productive manner Establish strategies to execute priorities and overcome procrastination Understand how to make trade-offs when faced with fire drills How to set and communicate boundary conditions Getting Started Introductions Course orientation Participants' expectations Foundation Concepts Exercise: A day in your life Resources to implement change Mind-set Tool-set Skill-set What is your time really worth? The dynamics of procrastination The myth of multi-tasking Brain Rules - how to optimize your efficiency Organization and Prioritization Time management best practices Goal setting Exercise: Identifying your priorities The importance of organization Time management framework Prioritizing time Time Management Techniques Tips for managing time Nine ways to overcome procrastination The STING technique Managing your time o Handling unplanned urgencies o Dealing with information overload Delegation and managing others' time Creating your personal action plan Summary Course summary and next steps Applying what you have learned

This one-day workshop is designed to give participants an understanding of the fundamentals of Microsoft Word and its commands, with quick ways to enter text, control formatting and edit paragraphs. This course will help participants: Create, manage and save documents, files and folders Create paragraph lists, bulleted and numbered paragraphs Edit, modify and format paragraphs Create and format tables Use shortcuts to navigate documents Format the layout of documents Manage page headers and footers Insert and managing pictures and diagrams within a document Learn time saving tips and tricks to obtain a professional finish to documents Use printing options 1 Creating documents Getting help Creating and saving documents Accessing recently used documents Managing files and folders 2 Entering and editing text Inserting and editing paragraph text Cutting, copying and pasting text Using tool tips to manage content Applying and removing text formatting Correcting spelling and grammar 3 Creating paragraph lists Creating bulleted paragraphs Creating numbered paragraphs Managing bulleted and numbered lists 4 Modifying paragraphs Changing paragraph alignment Indenting a paragraph Adding borders and shading to paragraphs Formatting paragraphs using styles 5 Navigating documents Using shortcuts for navigating documents Using 'Go To' to navigate documents Finding and replacing text Changing to read view 6 Document layout Inserting page breaks Changing page orientation Adjusting page margins Adding borders to pages 7 Page headers and footers Inserting page headers and footers Using header and footer commands Inserting page numbers Using different first page 8 Inserting pictures and diagrams Inserting pictures from your computer Inserting online pictures Flowing text around a picture Changing a picture Inserting SmartArt diagrams Entering text into SmartArt 9 Inserting tables Using tabs to create tables Resizing and repositioning tables Inserting and deleting rows and columns Using a table's commands Changing a tables text direction Formatting tables 10 Printing documents Previewing and printing documents Using the printing tools Printing parts of a document

This one-day workshop is designed to build upon skills already acquired using Microsoft Word, whether participants are self-taught or have previously attended a course. It gives participants a good understanding of managing different types of paragraph indents, and managing automated numbered paragraph lists. This course will help participants: Create and manage the layout of paragraphs Create and manage multi-level numbered paragraphs Effectively insert, use and manage section breaks Create and manage columns Find, create and apply styles Create and update a table of contents from styles Work with styles to manage formatting Work with sums in tables and use table headings Input and edit text using AutoText Work with SmartArt graphics Link to other files using paste special 1 Managing paragraph layout Controlling paragraph layouts with indents Creating and managing paragraph hanging indents 2 Numbering paragraphs Creating a new multi-level numbered paragraph Managing existing multi-level numbered paragraphs 3 Inserting columns Creating columns from existing paragraphs Setting up columns Managing columns 4 Document section breaks Controlling document layout using section breaks Managing page orientation using section breaks Managing page numbering using section breaks 5 Using styles Applying quick styles Finding existing styles Creating and saving styles Modifying styles Creating a table of contents from styles Updating a table of contents 6 Using quick parts Saving content to quick parts Modifying saved quick parts Inserting content using AutoText Editing AutoText entries Inputting text using AutoCorrect 7 Advanced table features Sorting table columns Running sums in tables Repeating table headings at top of page Importing Excel content in tables Using table properties 8 Creating a mail merge Creating letters, labels and emails Merging addresses from external files Using Outlook's address book to merge Merging to email 9 SmartArt graphic Visually communicate content with SmartArt Choosing a SmartArt graphic Inputting into SmartArt Modifying and formatting SmartArt graphics 10 Linking to other files Linking to files using paste special Linking an Excel chart to a document Managing linked content from Word

Writing Clear Business Communication: In-House Training This program is about learning about the writing process and covers the full spectrum of documents used when corresponding in the workplace. The ability to write effectively comes naturally to some people, but for the vast majority, it is a task often approached with a mixture of trepidation and dread. Effective writing seldom, if ever, 'magically materializes' on the spot. In reality, it is most often the product of planning, writing, and rewriting. This is why writing is called a process; it must go through a series of steps before it is clear and complete. This program is about learning about the writing process and covers the full spectrum of documents used when corresponding in the workplace. The ability to write effectively comes naturally to some people, but for the vast majority, it is a task often approached with a mixture of trepidation and dread. However, the ability to communicate in the written word, for whatever purpose, is an important part of our working and personal lives and can have a direct impact on our ability to persuade, gain commitment or agreement and enhance understanding. Good writing sounds like talking on paper, which is why this program is focused on getting the message across and achieving the desired results using the 'keep it simple and direct' approach. What you Will Learn At the end of this program, you will be able to: Write effective e-mails, letters, memos, and reports Clearly articulate the message Achieve desired results from correspondence Organize content for maximum impact Format for enhanced understanding Choose the appropriate communication medium for each document Revise documents to increase clarity and impact Foundations Concepts Business writing as a form of professional communication How business writing compares to other forms of writing Characteristics of good business writing Challenges with business writing The Project Environment Business writing in the project environment The concept of art, science, and optics of business writing Art Economy Precision Action Music Personality Science Purpose, simple, compound, and complex sentence structures Techniques to engage the reader Point of view: tone, attitude, and humor Organization: opening, body, and closing Support and coherence Optics Visual optics Sound optics Feel optics Effective optics Efficient optics Email Formal vs. informal emails Suggestions for improving email communication Instant and text messaging Reports Common types of reports created Formatting of reports Guidelines for meeting minutes Contracts Types of contracts Common agreements Procurement documents Templates, Forms, and Checklists Templates Forms Checklists Other Formatting Good Documentation Practices Good documentation practices Data integrity in business communication

Writing Clear Business Communication This program is about learning about the writing process and covers the full spectrum of documents used when corresponding in the workplace. The ability to write effectively comes naturally to some people, but for the vast majority, it is a task often approached with a mixture of trepidation and dread. Effective writing seldom, if ever, 'magically materializes' on the spot. In reality, it is most often the product of planning, writing, and rewriting. This is why writing is called a process; it must go through a series of steps before it is clear and complete. This program is about learning about the writing process and covers the full spectrum of documents used when corresponding in the workplace. The ability to write effectively comes naturally to some people, but for the vast majority, it is a task often approached with a mixture of trepidation and dread. However, the ability to communicate in the written word, for whatever purpose, is an important part of our working and personal lives and can have a direct impact on our ability to persuade, gain commitment or agreement and enhance understanding. Good writing sounds like talking on paper, which is why this program is focused on getting the message across and achieving the desired results using the 'keep it simple and direct' approach. What you Will Learn At the end of this program, you will be able to: Write effective e-mails, letters, memos, and reports Clearly articulate the message Achieve desired results from correspondence Organize content for maximum impact Format for enhanced understanding Choose the appropriate communication medium for each document Revise documents to increase clarity and impact Foundations Concepts Business writing as a form of professional communication How business writing compares to other forms of writing Characteristics of good business writing Challenges with business writing The Project Environment Business writing in the project environment The concept of art, science, and optics of business writing Art Economy Precision Action Music Personality Science Purpose, simple, compound, and complex sentence structures Techniques to engage the reader Point of view: tone, attitude, and humor Organization: opening, body, and closing Support and coherence Optics Visual optics Sound optics Feel optics Effective optics Efficient optics Email Formal vs. informal emails Suggestions for improving email communication Instant and text messaging Reports Common types of reports created Formatting of reports Guidelines for meeting minutes Contracts Types of contracts Common agreements Procurement documents Templates, Forms, and Checklists Templates Forms Checklists Other Formatting Good Documentation Practices Good documentation practices Data integrity in business communication

Enhancing Performance with Productive Conflict: In-House Training Most organizations have typically held the belief that workplace conflict is something that needs to be prevented, resolved, and/or mitigated. After all, conflict creates stress and leads to a variety of performance problems and very real costs. However, what savvy organizations have come to embrace is the understanding that when conflict is truly understood and harnessed, it can be utilized to not only add value to teams, but also enhance workplace performance. Conflict can be productive and make organizations better! Learners will explore the results of a formal, personalized, conflict-related assessment, uncovering targeted nuances of their conflict responses in action. Participants will learn to use basic strategies which allow them to transform destructive conflict responses into more productive ones, especially in the moment when they are happening. What you will Learn At the end of this program, you will be able to: Apply different models for understanding the lifecycle and dynamics of conflict Describe a physiological response to conflict and its impact on communication Recognize the correlation between a person's conflict style and how they respond to conflict Identify your own default responses to conflict and catch them in action Reframe automatic negative thoughts to create more positive interpersonal outcomes Utilize various tactics and strategies to transform destructive conflict responses into productive ones Getting Started Introductions and social agreements Course goal and objectives Opening activities Module 1: The Dynamics and Anatomy of Conflict Conflict basics Dynamics of conflict The anatomy of conflict Module 2: Conflict Styles and Conflict Conflict through the conflict style lens Exploring your style in conflict Destructive responses to conflict Module 3: Changing Your Response to Conflict Changing your conflict response Three steps to productive conflict Choosing a productive conflict response