Office Systems courses

What is Financial Modelling Basic Financial Statements Income Statement Balance Sheet Cash Flow Statement Compounding Capitalization Importing Data Converting Files from Other Applications Copying Data from another Application Importing Data from External Sources Using Microsoft Query Adding a Data Source Creating a Query Named Ranges Navigating Workbooks using cells or Range names Creating named Ranges based on Cell...office systems courses

Excel training delivered in your workplace for up to 8 delegates Quality, professional training guaranteed by Microsoft qualified trainer All in price £295 a day (no VAT on top!) Course Objectives: Create, open and save documents Use the mouse and keyboard shortcuts Enter and edit data Use Autofil...office systems courses

Microsoft Word Training delivered in your workplace for up to 8 delegates. From Introduction to advanced level or customised to meet your training requirement. Price: £295 per day (includes instructor-led training, workbooks, reference guide, certificates and unlimited after course support for each...office systems courses

PowerPoint training delivered in your workplace for up to 8 delegates From Introduction to Advanced level or I can provide a custom course tailored to your needs. Create effective presenttions - from master slides, formatting, annimation, transitions and delivery tips! Quality, professional training guaranteed...office systems courses

Outlook training delivered in your workplace for up to 8 delegates From Introduction to Advanced level or I can provide a custom course tailored to your needs. Quality, professional training guaranteed. Price: £250 per day (includes workbooks, reference guide, certificates and unlimited after course...office systems courses

Microsoft Project training delivered in your workplace for up to 8 delegates A fast tracked detailed course covering calendars, durations, phases, linking, constraints, critical path, costs, resourcing, tracking, reporting and exporting. Quality, professional training guaranteed and delivered by friendly, professional trainer with over...office systems courses

Microsoft FrontPage and effective Web Design training delivered in your workplace for up to 8 delegates From design to publishing - learn how to design, build and host your website. Quality, professional training guaranteed. Price: £295 per day (includes instructor-led training, workbooks, reference...office systems courses

Dreamweaver training delivered in your workplace for up to 8 delegates Quality, professional training guaranteed. office systems courses

Microsoft Access instructor-led training delivered in your workplace for up to 8 delegates by local, friendly and highly qualified IT professional. Detailed 2-day Introduction course which includes tables, forms, queries and reporting. Understand and build relational databases. Learn how to export data...office systems courses

Visio training delivered in your workplace for up to 8 delegates Quality, professional training guaranteed. Price: £295 per day (includes instructor-led training, workbooks, reference guide, certificates and unlimited after course support) Objectives covered: Identify Visio drawings and work with stencils Create, save and open drawing files Set...office systems courses

Crystal Reports instructor-led training delivered in your workplace for up to 8 delegates Quality, professional training guaranteed by local, friendly and qualified IT trainer. Price: £295 per day (includes instructor-led training, workbooks, reference guide, certificates and unlimited after course support for each delegate) Course...office systems courses

Introducing Microsoft Excel An overview of the benefits of spreadsheets. Basic spreadsheet structure. Tour of the Microsoft Excel screen. Getting HELP! Workbook Basics Moving around and selecting data. Entering data. Adjusting row and column widths. Using the Autofill facility. Saving &...office systems courses

Revision of the Basics Revision of the topics from the Introduction Course. Conditional formatting. Relative v's Absolute Cell Addressing Relative cell addressing explained. Working with absolute cell references. Working with Multiple Sheets Renaming, duplicating and moving sheets. Entering and consolidating data...office systems courses

Using Excel as a Database Setting data validation. Sorting data in a list. Using the AutoFilter and Advanced Filter. Producing summary statistics. Introduction to PivotTables. Database Functions Using the database functions - e.g DSUM, DMIN, DMAX. Other Useful Functions Information functions...office systems courses

Introducing Macros Explaining the purpose and potential of Excel macros. VBA (Macro) Basics Recording simple macros to automate routines such as document formatting. Using convenient ways of running macros - menus, toolbars, buttons within documents, and shortcut keys. Cell Referencing Using...office systems courses

Introducing Word Windows & Word terminology. The screen layout. Basic text entry. Getting HELP! Saving & Retrieving Work Saving and re-opening a document. Working with more than one document. Formatting Using formatting shortcuts and tools. Character formatting. Paragraph and Document (or Section) formatting. Tabs and indents Setting and using tabs and indents. Creating basic tables. Useful...office systems courses

Revision of the Basics Revision of the topics from the Introduction Course. Using AutoText, AutoCorrect and AutoComplete. Spelling & Grammar checking. Using the Find & Replace feature. More Formatting Recapping font, paragraph and section formatting menus. Working with the ruler to control tabs and indents. Applying borders and shading. Managing...office systems courses

Understanding and Applying Styles Introduction to styles. Applying styles. Modifying and creating your own styles. Templates Using standard templates. Creating, editing and managing templates. Inserting and updating document information and date fields. Tracking Changes Setting up a document for review. Viewing a document with changes. Accepting and rejecting changes. Working with Graphics Inserting Clip...office systems courses

Word Templates Overview of the uses of document templates and the features that are stored within them. Creating and editing templates, and copying features from one template to another. Creating Forms An introduction to creating and editing forms as a means of controlling the positioning...office systems courses

Introducing PowerPoint The benefits of presentation software. An overview of the graphic capabilities of PowerPoint. Tour of the screen. Menus and tools. Text Choosing text layout. Entering and editing text. Formatting and re-sizing text. Cut, copy and paste. Spelling checks. Changing case. Bullet points and numbered lists. Graphics Creating and editing different types of graphic...office systems courses