FOSVA Training

Identify the Elements of the Excel Interface Navigate and Select Cells in Worksheets Customise the Excel Interface Create a Basic Worksheet Performing Calculations in an Excel Worksheet Create Formulas in a Worksheet Insert Functions in a Worksheet Reuse Formulas Modifying a Worksheet ...

Calculating Data with Advanced Formulas Apply Cell and Range Names Calculate Data Across Worksheets Use Specialised Functions Analyse Data with Logical and Lookup Functions Organising Worksheet and Table Data Create and Modify Tables Format Tables Sort or Filter Data Use Functions to...

Streamlining Workflow Update Workbook Properties Create a Macro Edit a Macro Apply Conditional Formatting Add Data Validation Criteria Collaborating with Other Users Protect Files Share a Workbook Set Revision Tracking Review Tracked Revisions Merge Workbooks Administer Digital Signatures Restrict Document Access Auditing Worksheets ...

Getting Started The Opening Screen Creating a New Document Saving a document Setting up the Workspace Preferences Using Palettes (toolbars) Creating basic Shapes Rectangle Tool Ellipse Tool Polygon, Star and Spiral Tools Creating Paths (lines) Introduction to the Pen Tool Creating Paths Adding/deleting Anchor points Manipulating Anchor Points on Paths Editing a...

Review of Level 1 Knowledge Working with Artboards Creating, re-sizing and deleting Artboards Renaming Artboards Moving Between Artboards Artboard options Freehand tools Pencil Tool Smooth and Eraser Tools Paintbrush Tool Advanced Text Techniques Selecting and Altering Text Character Palette Paragraph Palette OpenType Palette Type on a Path Tool Area Type Tool Vertical...

Review of Level 1 and Level 2 Knowledge Advanced Object Manipulation Creating a Clipping Mask Creating a Graph Creating a Gradient Mesh Free Transform tool Perspective Grids Expanding Objects Advanced Text Techniques Creating a Type Mask Outlining text Linking Text Boxes Moving Text on a Path Advanced Type options Working with Effects ...

Getting Started with Microsoft Project Explore the Microsoft Project 2010 Environment Display an Existing Project Plan in Different Views Creating a Project Plan Create a Project Plan Assign a Project Calendar Add Tasks to a Project Plan Enter the Task Duration Estimates Add Resources to a Project Plan Managing Tasks in...

Exchanging Project Plan Data with Other Applications Import Project Information Export Project Plan Cost Data to an Excel Workbook Copy a Picture of the Project Plan Information Updating a Project Plan Enter Task Progress Enter Overtime Work Edit Tasks Reschedule a Task Filter Tasks Set an Interim Plan Create a Custom...

Introduction •What Can Photoshop do? •Using the Exercises Adobe Bridge •What is Adobe Bridge? •Importing photos •Workspaces in Adobe Bridge •Customising How Thumbnails are Displayed •Renaming multiple files (Batch) •Full Screen Preview Camera Raw Essentials •Raw and JPEG Files •Why you should start in Camera Raw instead of Photoshop •The Camera Raw Interface •Previewing Files •Toggling Onscreen Shadow/Highlight Clipping Warnings •Output Settings •Saving a Copy Without Going...

Creating a Basic Worksheet •Explore the User Interface and the Ribbon •Navigate and Select in Excel •Obtain Help •Enter Data and Save a Workbook •Customize the Quick Access Toolbar Performing Calculations •Create Basic Formulas •Calculate with Functions •Copy Formulas and Functions Modifying a Worksheet •Manipulate Data •Insert and Delete Cells, Columns, and Rows •Search for Data...