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: Business Strategy, Business Account, Microsoft excel training...

...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: Merging workbooks, Recording 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 Leader, Microsoft Excel, HR Practices...

...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: MS Excel, Auditing a worksheet, Scenario manager...

... Development Effective Business Communication OR Business Document Production Successful Meetings & Minutes Microsoft Word Microsoft Word Expert Microsoft Excel Microsoft Excel Expert... Learn about: Microsoft Excel, Skills and Training, Microsoft Office...

...AVERAGEIF, AVERAGEIFS Using text functions: PROPER, UPPER, LOWER, CONCATENATE Converting text to columns Using financial functions: FV... Learn about: Microsoft Excel, Nested functions, Lookup 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: Basic IT training, Microsoft Excel, Accounting MBA...

...AVERAGEIF, AVERAGEIFS Using text functions: PROPER, UPPER, LOWER, CONCATENATE Converting text to columns Using financial functions: FV... Learn about: Lookup functions, Financial functions, Mathematical Functions...

...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 Word, Skills and Training, MS Excel...

...logical and date/time functions Manage Excel databases and lists Customise charts Use Excel in conjunction with other applications Manipulating Worksheets... Learn about: Data validation, Editing templates, 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 PowerPoint, Microsoft Office, Legal Secretary...

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

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

...sum, average, minimum, maximum, count, if •Formula AutoComplete Formatting •Formatting Numbers and Dates - number of decimal places, commas to indicate thousands... Learn about: Font colour, Selecting Data, Microsoft Excel...

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

...sum, average, minimum, maximum, count, if Formula AutoComplete Formatting Formatting Numbers and Dates - number of decimal places, commas to indicate thousands... Learn about: Redo buttons, Page size, Header and footer...

...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: Communication Training, Microsoft excel training, Business Communication...

...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 Word, Excel workbooks, Referencing


...

... 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 Excel, Ms PowerPoint, Skills and Training...

...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: Compressing images, Ms Word, Protecting a form...