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, Microsoft Excel, Business Law...

...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: Running macros, Microsoft excel training, Tracking changes...

...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: MS Excel, Team Leader, Office IT...

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

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

...AVERAGEIF, AVERAGEIFS Using text functions: PROPER, UPPER, LOWER, CONCATENATE Converting text to columns Using financial functions: FV... Learn about: Formula AutoComplete, Database functions, Structured references...

... 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: Accounting MBA, Cost Accounting, Microsoft Excel...

...AVERAGEIF, AVERAGEIFS Using text functions: PROPER, UPPER, LOWER, CONCATENATE Converting text to columns Using financial functions: FV... Learn about: Excel table, Lookup functions, Statistical 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: Skills and Training, Ms Word, Minute Taking...

...logical and date/time functions Manage Excel databases and lists Customise charts Use Excel in conjunction with other applications Manipulating Worksheets... Learn about: Microsoft excel training, Financial functions, Hiding rows...

... 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 Excel, Executive Assistant, Skills and Training...

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

...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, Inserting Data, Text orientation...

...Processing invoices and credit notes Generating reports customer/supplier invoices Generating customer/supplier statements and reconciling them Generating... Learn about: Standard VAT Scheme, MS Excel, 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: Header and footer, Inserting Data, Redo buttons...

...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: Skills and Training, Accounting and Finance, Time management...

...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: Excel workbooks, Microsoft Word, Protecting a form...

... 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 Office, Ms Word, Microsoft Office...

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