Microsoft Excel courses Middlesex

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

, 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, AAT Level 2 - Basic Costing, MS 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: SmartArt graphics, Auditing a worksheet, MS Excel...

...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 Excel, Problem Solving, Communication Skills...

...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, Microsoft excel training, 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 and Finance, MS Excel, Business Communication...

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

...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: Confidence Training, Office IT, Ms Office...

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

...accounting for payroll in the accounts; preparing statements of account; paying invoices; calculating depreciation; calculating profit or loss and preparing... Learn about: Microsoft Excel, Sage line 50, Balance Sheet...

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

...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, Columns
...

...sum, average, minimum, maximum, count, if Formula AutoComplete Formatting Formatting Numbers and Dates - number of decimal places, commas to indicate thousands... Learn about: Formulae



, MS Excel, Microsoft excel training...

...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, Borders

, Microsoft Word...