MS Excel courses Middlesex

...individuals who may be considering setting up their own business. On completing the course, you will have earned a highly regarded Pitman Training Award – a ‘mini-diploma’... Learn about: MS Excel, Microsoft Excel, Business Strategy...

...workbooks Printing and previewing multiple worksheets Using the Report Manager Named ranges Add a named range Delete a named range Use a named range... Learn about: Report Manager, Running macros, Microsoft excel training...

...well paid manager or team leader. The Management Diploma is one of a range of diplomas developed for the sole purpose of equipping newly appointed managers... Learn about: Team Training, Team Leader, Time management...

...They will be able to: Create a workspace Print workbooks Audit a worksheet Create and use PivotTables and reports Use Solver, Scenario Manager and... Learn about: Microsoft excel training, Auditing a worksheet, SmartArt graphics...

... Development Effective Business Communication OR Business Document Production Successful Meetings & Minutes Microsoft Word Microsoft Word Expert Microsoft Excel Microsoft Excel Expert... Learn about: MS Excel, Office IT, Ms Word...

...AVERAGEIF, AVERAGEIFS Using text functions: PROPER, UPPER, LOWER, CONCATENATE Converting text to columns Using financial functions: FV... Learn about: Mathematical Functions, Table quick styles, Nested functions...

... more specifically aimed at anyone looking to go on and attain an AAT Level 2 Certificate in Accounting qualification. Pre-requisites: Experience of Microsoft Excel... Learn about: Microsoft excel training, Basic IT training, Basic IT...

...AVERAGEIF, AVERAGEIFS Using text functions: PROPER, UPPER, LOWER, CONCATENATE Converting text to columns Using financial functions: FV... Learn about: Microsoft Excel, Statistical functions, Excel table...

...Using video and practical exercises the format of this course makes it quick to work through, and easy for you to adapt to include new working practices... Learn about: MS Excel, Ms Word, Skills and Training...

...logical and date/time functions Manage Excel databases and lists Customise charts Use Excel in conjunction with other applications Manipulating Worksheets... Learn about: Applying templates, Freezing panes, Financial functions...

... and Secretarial skills. The Secretarial Diploma consists of nine Core Courses: - Typing (choose from selection) Typing Speed Development Effective Business Communication OR Business Document Production Audio Transcription Successful Meetings & Minutes Microsoft Word OR Word Expert Microsoft Excel OR Excel Expert... Learn about: Ms Office, Office IT, Executive Assistant...

...modifying document margin settings, adjusting document setup to fit one page, adding a header and footer, changing document orientation, page... Learn about: Inserting Data, Text orientation, Text size...

...ways to market and sell products, defining direct costs and indirect costs, recovering costs. Lesson Two : Examples of a service business, identifying... Learn about: Payroll Software, Costing and Pricing, MS Excel...

...sum, average, minimum, maximum, count, if •Formula AutoComplete Formatting •Formatting Numbers and Dates - number of decimal places, commas to indicate thousands... Learn about: Text size, Microsoft excel training, Inserting Data...

...Processing invoices and credit notes Generating reports customer/supplier invoices Generating customer/supplier statements and reconciling them Generating... Learn about: Standard VAT Scheme, VAT scheme, MS Excel...

...sum, average, minimum, maximum, count, if Formula AutoComplete Formatting Formatting Numbers and Dates - number of decimal places, commas to indicate thousands... Learn about: Formulae



, Sorting Data, Microsoft Excel...

...diploma not only will you gain a respected Pitman Training certification, you’ll be in the best position to go on and gain the full AAT Level 2* Diploma... Learn about: Microsoft excel training, Skills and Training, Microsoft Excel...

...table or worksheet Applying a numbered caption to an image, figure, table or worksheet Using automatic caption options Creating a table of figures Advanced... Learn about: MS Excel, Referencing


, Ms Word...

... with essential skills to enable you to excel in the above role, using not only the traditional secretarial skills, including shorthand and typing, but also learning the latest Microsoft Office 2013 applications and undertaking specific professional training... Learn about: Ms PowerPoint, MS Excel, Office IT...

...table or worksheet Applying a numbered caption to an image, figure, table or worksheet Using automatic caption options Creating a table of figures Advanced... Learn about: Advanced image techniques, Stained Glass, Protecting a form...