Excel college courses

...spreadsheets and database. Practical skills in word processing, spreadsheets and database. How will I be assessed? You will be assessed by your tutor...

...Full-Time Content Students will be able to choose two different vocational pathways to study out of: hair & beauty, arts & media, land-based studies...

...unit is designed to accredit basic competancies in using spreadsheets and graphs sortware to enter, edit and present numerical data using formulae...

...Ongoing Next Intake will be January 2010 DAY(S)/TIME(S) OFFERED Monday & Tuesday from 6.00pm to 9.15pm NUMBER OF TEACHING HOURS 7 hours TOTAL FEE Call for details...

...grouping data in a Pivot table and renaming groups Manually grouping data in a Pivot table and renaming groups The session will teach the skills above... Learn about: Excel for Accounting, Excel Sheet, Excel Advanced...

...Full-Time Content Students will be able to choose two different vocational pathways to study out of: hair & beauty, arts & media, land-based studies...

...Borders, formatting, formulas, absolute referencing 3D referencing, wrapping text, adding comments Sum, count, average, max & min functions Now and if functions...

...In an era of increasing population, decreasing energy sources and increasing poverty, it is but imperative that appropriate technology, with an aim towards... Learn about: Food Technology, Food Science, Food Nutrition...

...Min and Max Formatting worksheets- formatting text, rows and columns Creating Charts- modifying and printing charts Assessment Methods: Price includes... Learn about: Excel for Accounting, Mathematics Series, Excel Sheet...

...Certificate in ICT Level 2 Time Full-Time Content This course is for anyone with a genuine interest in computing wishing to enter a career in Information Technology...

...naming ranges, finding trends in data Create macros, set security levels for macros, add macros to toolbars Apply data validation rules, add input messages...

...an Edexcel Life Skills qualification through a chosen pathway which will include independent living skills, travel and community and citizenship students...

...Develop techniques from the formatting and editing menu's that help to produce professional looking documents Assessment Methods: Assessment is based... Learn about: Excel Intermediate, Printing spreadsheets, MS Excel...

...adjusting column widths, editing cells, navigating a workbook and worksheets, using AutoSum, saving, naming and closing a workbook, adding a button to the Quick Access Toolbar...

...showing/hiding gridlines and headings, creating and working with tables, converting text to columns, removing duplicates, consolidating...

...applying a background colour and inserting a movie, using the research task pane to search the web, inserting and using a hyperlink, web page preview...

...adjusting column widths, using the SUM function in a formula, using the AutoSum feature, editing text and numbers, navigating a workbook and worksheets... Learn about: Microsoft Office...

...creating and working with tables, converting text to columns, removing duplicates, consolidating data, hiding/unhiding worksheets, using paste special... Learn about: Microsoft Office...

...general calculations The Function Wizard Using Functions in Excel: The 5 Popular functions If- function Working with Names and Ranges Copying formulae Lookups... Learn about: Excel Tables, Pivot tables, Excel for Data Management...

...and hopefully won't distract too much from your working day. Included: Teas/Coffee, Notes, Example-files, After-course support, Attendance certificate... Learn about: Business Intelligence, Microsoft excel training, Additional formulas...