Microsoft Excel courses Middlesex

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

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

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

...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: Microsoft Access, Communication Skills, Microsoft Word...

...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, Hiding rows, MS 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: Accounting and Finance, Business Communication, Skills and Training...

...AVERAGEIF, AVERAGEIFS Using text functions: PROPER, UPPER, LOWER, CONCATENATE Converting text to columns Using financial functions: FV... Learn about: Financial functions, Table quick styles, Lookup 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, Ms Office, Business Communication...

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

...accounting for payroll in the accounts; preparing statements of account; paying invoices; calculating depreciation; calculating profit or loss and preparing... Learn about: Microsoft excel training, Microsoft Excel, Sales Training...

...modifying document margin settings, adjusting document setup to fit one page, adding a header and footer, changing document orientation, page... Learn about: Selecting Data, MS Excel, 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: Sorting Data, Font colour, Microsoft Excel...

...sum, average, minimum, maximum, count, if Formula AutoComplete Formatting Formatting Numbers and Dates - number of decimal places, commas to indicate thousands... Learn about: Page size, Header and footer, 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: Embedding Objects, Borders

, Ms Word...