Microsoft Excel courses Middlesex

...AVERAGEIF, AVERAGEIFS Using text functions: PROPER, UPPER, LOWER, CONCATENATE Converting text to columns Using financial functions: FV... Learn about: Mathematical Functions, 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 MBA, Cost Accounting, Basic IT 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: MS Excel, 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: Microsoft Access, Problem Solving, Microsoft Excel...

...logical and date/time functions Manage Excel databases and lists Customise charts Use Excel in conjunction with other applications Manipulating Worksheets... Learn about: Financial functions, Manipulating Worksheets, Filtering 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: MS Excel, Accounting software, IT Management...

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

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

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

...accounting for payroll in the accounts; preparing statements of account; paying invoices; calculating depreciation; calculating profit or loss and preparing... Learn about: Microsoft Excel, Communication Skills, MS Excel...

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

...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: Envelopes and Labels, Microsoft Excel, Word Art...