PC Applications training 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...pc applications training

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...pc applications training

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...pc applications training

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...pc applications training

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...pc applications training

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...pc applications training

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...pc applications training

Dreamweaver training delivered in your workplace for up to 8 delegates Quality, professional training guaranteed. pc applications training

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...pc applications training

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...pc applications training

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...pc applications training

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 &...pc applications training

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...pc applications training

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...pc applications training

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...pc applications training

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...pc applications training

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...pc applications training

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...pc applications training

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...pc applications training

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...pc applications training