Microsoft Excel courses Middlesex

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

...This course is designed for anyone looking to work within the Accounts Department of any organisation or who wishes to manage and understand the financial costs of their own business. Before starting this course experience in basic book-keeping and Microsoft Excel is preferred. It’s... Learn about: Basic IT, Accounting and Finance, Microsoft excel training...

...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, Data Analysis Tools, Scenario manager...

...skills to work successfully within this demanding role. As a Receptionist you’ll be at the frontline of communications; ensuring information is provided in the right manner... Learn about: Communication Skills, Customer Care, Problem Solving...

...logical and date/time functions Manage Excel databases and lists Customise charts Use Excel in conjunction with other applications Manipulating Worksheets... Learn about: Hiding rows, Editing templates, Creating Templates...

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

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

...Our Office IT Diploma is designed to equip you with the essential IT skills you’ll need to be a highly valued member of any team. To stand out in today’s... Learn about: Skills and Training, Business Communication, Microsoft Excel...

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

...accounting for payroll in the accounts; preparing statements of account; paying invoices; calculating depreciation; calculating profit or loss and preparing... Learn about: Accounting records management, Team Training, Accounting and Finance...

...modifying document margin settings, adjusting document setup to fit one page, adding a header and footer, changing document orientation, page... Learn about: Font colour, Sorting Data, Microsoft excel training...

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

...sum, average, minimum, maximum, count, if Formula AutoComplete Formatting Formatting Numbers and Dates - number of decimal places, commas to indicate thousands... Learn about: Cell styles, Selecting Data, Redo buttons...

...and labels Make use of the graphic capabilities of MS Word 2003, including use of the Drawing toolbar Link and embed objects from other applications... Learn about: Microsoft Excel, Ms Word, Word Art...