Introduction to MS Word, Excel, Powerpoint, Access and Publisher ... These comprehensive computer courses will take you from beginner to advanced with step-by-step, interactive learning through visual print display and online tasks.
If you have basic skills in Word and Excel can type more than 5 wpm and can create simple documents or spreadsheets but want to learn functions that cover most of everyday needs in an average office then this course is for you. You may have already completed the beginners or basic computing course which will give you those necessary basic skills. In Word we cover functions such as: using and modifying Templates to your needs different Styles Page and text Formatting automatic indexes Headers and Footers and more. In Excel we cover data entry to cells cell formatting creating Tables simple Formulas and Charts. We will also look at ways to solve problems by using the Help function to make you more independent in your work. One person per computer - certificate issued.
Spreadsheet data entry, storage, output and presentation using routine software functions and simple formulae. Formatting, adjusting, documentation and on line help for problem solving, previewed, adjusted and printed, named and stored, chart types. Features, valid representations, preview, adjust and print.
This 1 day course is designed to provide students with the skills and knowledge to use the most commonly used features of Excel 2007 including developing and enhancing your spreadsheets, using basic formulas and charting.
This course includes:- Modifying and formatting charts, various functions such as logical, maths, date and time. Also importing and exporting, macros and templates. Students must have working knowledge of Excel.
Create simple spreadsheets using basic features of Excel for keeping track of your household expenses financial records for your club or your investments. Use built in functions create simple formulas and charting. When you become a whiz at Excel you move onto creating documents like letters basic flyers and newsletters. Edit format use different fonts bullets numbers and tabs. Set margins line spacing and tables. Enhance documents by adding page borders and graphics. Pre-requisite: Prior knowledge of PCs. Course manual or notes will be provided.
Statement of Attainment from Certificate I in Information Technology ICA10105 (Unit ICAU1130B). Centrelink Approved Institution: 2P181 - Government funding may be available for eligible students. Ask us how! An ideal course for small business owners or householders who want to keep track of their budgets or set up a simple spreadsheets. Topics include creating editing and formatting spreadsheets; using built in functions; entering simple formulas and charting using Excel as a database. Course may include an out of class assessment. Pre-requisite: Prior knowledge of PCs. 32 CPD Points. Please bring pen and paper. Course manual or notes will be provided.
Statement of Attainment from Certificate I in Information Technology ICA10105 (Unit ICAU1130B) Centrelink Approved Institution: 2P181 - Government funding may be available for eligible students. Ask us how! An ideal course for small business owners or householders who want to keep track of their budgets or set up a simple spreadsheets. Topics include creating editing and formatting spreadsheets; using built in functions; entering simple formulas and charting using Excel as a database. Course may include an out of class assessment. Pre-requisite: Prior knowledge of PCs. 32 CPD Points. Please bring pen and paper. Course manual or notes will be provided.
An ideal course for small business owners or householders who want to keep track of their budgets or set up a simple spreadsheets. Topics include creating editing and formatting spreadsheets; using built in functions; entering simple formulas and charting using Excel as a database. Course may include an out of class assessment. Learn about the new features that are going to greatly increase your productivity and efficiency in using Excel 2007. Pre-requisite: Prior knowledge of PCs. 18 CPD Points Please bring pen and paper. Course manual or notes will be provided.
This course is intended for managers of small businesses and accountants who want to learn how to use Microsoft Excel in order to improve their productivity and reduce their workload. Participants will learn to create and practise useful formulas for budgets using labels and names in formulas using absolute and relative referencing in formulas logical formulas working with different functions creating simple charts selecting ranges filling a series and using Excel for record-keeping and human resources purposes such as maintaining sick and recreation leave. Some basic knowledge of Excel is required. This course is perfect for those who have already completed a basic introductory excel course and/or who use Excel daily in their work.
Use and create simple spreadsheets and charts; access the menu bar shortcuts and toolbars; create formulas work with functions and formatting techniques. Manual provided. On successful completion students will be awarded a Statement of Attainment for BSBITU202A Create and use spreadsheets from Certificate II in Business BSB20107. When you complete this course you might consider Excel Advanced and MYOB courses. Before you enrol you must be able to: create files and folders open an application program copy rename delete files save open and print a file.
For participants who want to extend their basic spreadsheet skills. Topics include naming ranges creating links between worksheets importing data and validating worksheets. Pre-requisite: A good working knowledge of Excel. 9 CPD Points. Please bring pen and paper. Course manual or notes will be provided.
Sydney Hills District Level 1, Main St, ROUSE HILL Western Sydney Cnr Kildare Rd & Lancaster St, BLACKTOWN
Pre-requisite: Must have basic computer, mouse & keyboard skills, be comfortable with windows This program aims to provide the basic skills required for the new user to understand and create, modify, save & print simple worksheets. Design formulas, produce graphical charts and develop an Excel database. Manage the Ribbon, it’s Command groups, Dialog Box Launchers, & learn useful quick shortcut keys in Microsoft Excel vers.2007.
Train with highly qualified trainers and consultants with real world experience. Raising the Bar can train students in small to large corporate groups, one on one or groups in public courses at our new training centre at North Sydney (maximum 8 students). If you are looking to upgrade your skills, refresh your previous Excel knowledge or study for Microsoft Office User Specialist exams, Raising the Bar is the company that can assist you with this. We are currently offering a 3 for 2 package. Pay for 2 courses and get the 3rd one FREE. Call us today to speak to a consultant.
Western Sydney 585 High St, PENRITH Blue Mountains & Surrounds 6 Gang Gang St, KATOOMBA Western Sydney High St, PENRITH
Using Microsoft Excel learn how to create a basicspreadsheet including graphs and charts, writing formulae and formatting options. Basic computer experience required.
Improve your decision making and business skills by learning to create your own dynamic and reliable financial models. This course is designed for business professionals who need to explore the practical usage of advanced excel functions in a financial model. By creating your own user-friendly financial model, you will learn to translate business concepts into a structured format to identify weaknesses and predict future performance. Course is a full day, running from 9am to 5pm. Fees include lunch, materials and USB on which students can take home their files.
Work with numbers? Then you need to learn Excel 2007. In this unique six-week online workshop, you'll discover dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You'll also learn the secrets behind writing powerful mathematical formulas, using the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more. You'll also learn the best ways to sort and analyze data, create custom charts and graphs, create 3-dimensional workbooks, build links between files, endow your worksheets with decision-making capabilities, and automate oft-repeated tasks with macros and buttons
Need to know a little more or take your basic Word and Excel knowledge to the next level? This course will suit those who have a basic knowledge of both applications and who are ready to learn more functionality. Topics covered: Word: Graphics headers and footers creating section breaks more table techniques and mail merge. Excel: Built In Functions creating links between Worksheets and importing data. Pre-requisite: Prior knowledge of PCs and basic Word and Excel. 7 CPD Points
NSW Central Coast & Region 1 Reliance Dr, TUGGERAH NSW Central Coast & Region 20-22 Kincumber St, KINCUMBER
BSBITU202A Create and use spreadsheets Learn to create spreadsheets for budgeting, analysing figures, creating charts, managing lists, how to introduce formulas for automatically calculating figures and perform analysis using simple functions, sorting and filtering. Basic computer skills required.
NSW Central Coast & Region 1 Reliance Dr, TUGGERAH NSW Central Coast & Region 20-22 Kincumber St, KINCUMBER
This course is for students who have Excel skills and would like to learn spreadsheet enhancements such as linking worksheets, named ranges, spreadsheet protection and advanced functions including IF and VLOOKUP. Learn to create complex spreadsheets using templates, macros and pivot tables.
NSW Central Coast & Region 1 Reliance Dr, TUGGERAH NSW Central Coast & Region 20-22 Kincumber St, KINCUMBER
This course is for students who have basic computing skills and would like to learn about creating simple spreadsheets using formulas, functions and charts. Learn how to manipulate and format cells and print existing spreadsheets.
Sydney Eastern Suburbs 98 Bondi Rd, BONDI JUNCTION
Simple, powerful and easy to customise, Excel macros can save you time and increase your productivity. Macros called loops are especially useful for working with ranges of data. Whether you’ve only heard about macros or already use them in Excel, now is the time to find out more about them. A working knowledge of Excel is a prerequisite for this course.
Sydney Eastern Suburbs 98 Bondi Rd, BONDI JUNCTION
Fridays
An accredited hands-on course designed to equip you with the expertise to create and modify spreadsheets to suit your personal requirements. Included will be: creating formulas, copying and filing, printing and manipulating worksheets, and working with functions and charting. Prerequisite: Basic keyboarding skills and PC Essentials or equivalent.
Sydney Eastern Suburbs 98 Bondi Rd, BONDI JUNCTION
Thursdays
An accredited hands-on course designed to equip you with the expertise to create and modify spreadsheets to suit your personal requirements. Included will be: creating formulas, copying and filing, printing and manipulating worksheets, and working with functions and charting. Prerequisite: Basic keyboarding skills and PC Essentials or equivalent.
An accredited hands-on course designed to equip you with the expertise to create and modify spreadsheets to suit your personal requirements. Included will be: creating formulas, copying and filing, printing and manipulating worksheets, and working with functions and charting. Prerequisite: Basic keyboarding skills and PC Essentials or equivalent.
Sydney Eastern Suburbs 98 Bondi Rd, BONDI JUNCTION
Mondays
This course is designed to cover the features required in the day-to-day use of your PCs, including but not limited to opening and closing programs; performing file management tasks; and working with Word 2007 and Excel 2007. Fulfils the requirements for ICAU2006B Operate computing packages from ICA20105 Certificate II in Information Technology.
Sydney Eastern Suburbs 98 Bondi Rd, BONDI JUNCTION
Wednesdays
This course is designed to cover the features required in the day-to-day use of your PCs, including but not limited to opening and closing programs; performing file management tasks; and working with Word 2007 and Excel 2007. Fulfils the requirements for ICAU2006B Operate computing packages from ICA20105 Certificate II in Information Technology.
Sydney Eastern Suburbs 98 Bondi Rd, BONDI JUNCTION
Fridays
This course is designed to cover the features required in the day-to-day use of your PCs, including but not limited to opening and closing programs; performing file management tasks; and working with Word 2007 and Excel 2007. Fulfils the requirements for ICAU2006B Operate computing packages from ICA20105 Certificate II in Information Technology.
Learn the basics of creating and updating spreadsheets using Microsoft Excel. Basic Windows skills required. Topics covered include concepts entering and editing data formatting using formulas and functions printing and charts. Memory stick included in course fee.
Learn the basics of creating and updating spreadsheets using Microsoft Excel. Basic Windows skills required. Topics covered include concepts entering and editing data formatting using formulas and functions printing and charts.
Learn the basics of creating and updating spreadsheets using Microsoft Excel. Basic Windows skills required. Topics covered include concepts entering and editing data formatting using formulas and functions printing and charts.
NSW Central West 227 Howick St, BATHURST NSW Central West 21-29 William St, ORANGE
If you need to learn to use Microsoft Word and Excel 2007 this course is for you. You will learn to use both software applications from an introductory level. These applications are essential to all areas of work or business and will improve your skills and knowledge.
Western Sydney Cnr Kildare Rd & Lancaster St, BLACKTOWN
BSBITU 201A - Produce simple word processed documents BSBITU 202A - Create & use spreadsheets, from Cert II in Business - BSB20107 (24 hours). Pre-requisite: MUST have basic computer, windows, mouse & keyboard proficiency. Using MS Office 2007, the elements covered in this course will provide you with beginner level skills to effectively design, create, edit, format, save and print simple documents. Modify, copy and link your Word & Excel files to prepare reports. Design a simple excel database for merging letters & envelopes. Import graphics into documents and create basic formulas for easy calculations in worksheets. Review file storage procedures, manage the Ribbon, Command groups, Dialog Box Launchers, & learn useful common shortcut keys within MS Office 2007.
If you only need the basics of word processing and spreadsheets this course is for you. This is a short comprehensive course using Office 2003 providing an introduction to both Word and Excel. Topics covered: Word: creating saving retrieving and editing a document formatting techniques using margins page layout and tabs and creating simple tables. Excel: Creating editing and formatting spreadsheets entering simple formulas and charting. Pre-requisite: Basic computer skills are required (using the mouse and keyboard). 7 CPD Points