PC Applications Courses Hampshire

...up a document for a mass mailing Perform a basic mail merge to add unique addresses to a set of otherwise identical documents Perform a more complex...

...Running and recording a macro - Viewing VBA code - Function procedures All one-day IT courses are bespoke and not qualification-based. Training formats available... Learn about: Microsoft excel training, MS Excel, Microsoft Excel...

...to consistently delivering a high standard of customer service and that your customers will benefit from having a positive experience of dealing with...

...portfolio of work covered throughout this course... Learn about: MS Excel, Microsoft excel training, Microsoft Excel...

...Create and Apply Custom Number Formats Apply Conditional Formatting Create and Modify List Ranges Importing and Exporting Data Import Data from Text Files...

...Advanced Formatting - Borders and shading - Using special number formats - Working with dates - Working with styles - Other advanced formatting List Management... Learn about: Microsoft excel training, MS Excel, Microsoft Excel...

...(touch typing) and keyboard functions * understanding of the importance of accuracy and development of proof-reading skills. About the Course This is a one year course...

...been developed to enable you to add logic into your spreadsheet using more advanced formulas and functions., , , 3. Entry requirements Ideally you should... Learn about: Microsoft Excel, MS Excel, Microsoft excel training...

...Assigning Resources Specify Resources for Projects Determine Resource Working Hours Create new resource calendars Understand Effort-Driven Scheduling Modify...

...one is recorded as the relevant pass mark is achieved. The overall ITQ Level 2 (ECDL) certificate is awarded when passes for all four modules have been recorded...

...principal study units in IT and Business, includes specialist or additional study of an A level subject and incorporates throughout the skills required...

...some new skills to help you manage and extract vital information., , You will also explore the importing and exporting of data into and out of Excel finishing... Learn about: Microsoft Excel, MS Excel, Microsoft excel training...

...Understand Task Relationships Create Links Create Finish-to-Finish Relationships Create Start-to-Start Relationships Create Milestones Fine-Tuning Timelines...

...Using AVERAGE, MIN and MAX Formatting Worksheets - Formatting text - Formatting rows and columns - Number formatting - Using Format Painter and AutoFormat Printing... Learn about: Microsoft excel training, Microsoft Excel, MS Excel...

...Navigate with the Document Map Mark Text for an Index Generate Automatic Tables Applying Layout and Formatting Techniques Understanding Pagination Options...

...and Menus Create New Documents Templates Saving Documents Using the Clipboard ] Cut & Paste Text Delete Text Formatting Text Working with Fonts Adjusting...

...and columns Sort Lists Understand Filters Working With Functions Understand Inserting Functions Use the IF, OR, FV, PMT and NOW functions Formatting Worksheets...

...Delete, Merge and Split Cells Insert, Delete and Modify Columns and Rows Exploring Functions Understand and Build Functions Use AutoSum and AutoCalculate...

...Plan meetings with Attendees and Resources Propose Alternate Meeting Times Update, Accept and Canel Meeting Requests Use Calendar Colouring Save Calendars...

...Changing Appointments Setting Appointment Reminders Printing Calendars Using Tasks Entering a Task Updating Tasks Viewing and Organising Tasks Customise...