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

...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, 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: Office IT, MS 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: Data Analysis Tools, Auditing a worksheet, Goal seek...

... 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, Ms Word, Business Communication...

...AVERAGEIF, AVERAGEIFS Using text functions: PROPER, UPPER, LOWER, CONCATENATE Converting text to columns Using financial functions: FV... Learn about: Formula AutoComplete, Microsoft Excel, 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 and Finance, Cost Accounting, Microsoft excel training...

...AVERAGEIF, AVERAGEIFS Using text functions: PROPER, UPPER, LOWER, CONCATENATE Converting text to columns Using financial functions: FV... Learn about: Microsoft Excel, Mathematical Functions, Lookup 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: Minute Taking, MS Excel, Ms Word...

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

... 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, Ms Office, MS Excel...

...modifying document margin settings, adjusting document setup to fit one page, adding a header and footer, changing document orientation, page... Learn about: MS Excel, Text orientation, 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, Costing and Pricing, Payroll Software...

...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, Font colour, Microsoft Excel...

...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, Selecting Data...

...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: Accounting software, Microsoft Excel, 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: Excel workbooks, Referencing


, MS Excel...

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