Microsoft Excel courses Middlesex

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

, Lookup functions...

...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: Cost Accounting, Microsoft Excel, AAT Level 2 - Basic Costing...

...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, Auditing a worksheet, Data Analysis Tools...

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

...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, Data validation, Applying 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: Accounting MBA, Skills and Training, Accounting software...

...AVERAGEIF, AVERAGEIFS Using text functions: PROPER, UPPER, LOWER, CONCATENATE Converting text to columns Using financial functions: FV... Learn about: Microsoft Excel, Nested functions, Table quick styles...

...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: Microsoft Office, Confidence Training, Business Communication...

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

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

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

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

...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, Sorting Data, Editing Data...

...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: Creating data sources, Embedding Objects, Microsoft Excel...