Browse 1,200+ courses with a wide range of study options from online courses to diploma qualifications, training and full-time education. Learn more
A variety of scholarship opportunities are available for different areas of study, across the state. Learn more
View our news, press releases, videos, announcements and publications about TAFE NSW. Learn more
Statement of Attainment in Spreadsheet functions
Learn how to use spreadsheet software to complete business tasks and produce complex documents.
This is an entry level course for people in the workforce who want to increase their skills. You will learn to design and develop spreadsheets through the use of spreadsheet, text documents using advanced word processing applications.
This short course provides training to team leaders wanting to advance their administration skills. Whilst studying this course, learners will be trained in the design and production of text documents and spreadsheets and organisation of business travel and meetings.
This short course provides training in underpinning computer skills for spreadsheet and word processing use. Whilst studying this course, learners will be trained in the design and production of text documents and WHS for the workplace.
Microsoft Excel is perhaps the most important computer software program used in the workplace today. Employers across many industries and fields expect job seekers to have Microsoft Excel skills. Itâs probably the most universally utilized software in businesses around the globe. That's why so many workers and prospective employees are required to learn Excel to enter or remain in the workplace. From the viewpoint of the employer, particularly those in the field of information systems, the use of Excel as an end-user computing tool is essential. Not only are many business professionals using Excel to perform everyday functional tasks in the workplace, an increasing number of employers rely on Excel for decision support. If you want to get a better understanding of the industry standard spreadsheet application, and learn how to create professional looking reports, budgets and forms then this is the course for you. This practical short course will teach you how to use Microsoft Excel, how to analyse and present your data, create and format spreadsheets and charts, sorting and filtering, advanced excel formulas and functions, macros and pivot tables. You will undertake two units of study:BSBITU304 Produce spreadsheets, andBSBITU402 Develop and use complex spreadsheets.
This course provides the skills and knowledge required to create a range of spreadsheets to meet organisational requirements, use online help, calculations and functions, create and modify simple charts and follow designated timelines.
Do you wonder if there is more to word processing than meets the eye? Do you use a spreadsheet only for shopping and ToDo lists? Well maybe this is the course for you!
Showing 1 to 8 of 8 for spreadsheet
It's easy to see how our short courses can give your business a boost - and it's also easy to find the right one for you. If you can't see a course that suits your needs below, give us a call and we'll help you find the perfect one for your small business. Business Get down to business with our huge range of short courses Leadership Skills Learn how to motivate your staff to perform at their best for your business with a Leadership Skills course. Small Business Gain some savvy skills to help launch or build your small business Website Building Learn how to build your business a website that works. Spreadsheet Functions Excel your business's productivity by taking a short course in Spreadsheet Functions. Basic Bookkeeping Act like a big business by managing your small business's bookkeeping like a pro. Budget Building and Management Crunch those numbers with a short course in budget building or management. Microsoft Office Essentials Increase your business's productivity by unlocking the secrets of office software with a range of short courses Photography Learn how to capture your business's good side with ta short course in photography. Skills for Business Initiative Fee-free short courses in digital and financial literacy to help you grow your small business.
A new skill is a great way to make you invaluable in your current career or employable in a new one. Luckily, TAFE NSW has a huge selection of short courses to help you stay up-to-date in our fast-moving world. There's always room to improve, and we'll help you find a short course to help you be your best. Have a look at some of our short courses below or give us a call to find something perfect to further your credentials. Early Childhood Develop knowledge and skills in working with children within an early childhood setting. Business skills Get down to business with our huge range of short courses Medical Administration Skills Learn the skills required to work in administrative and clerical positions in a medical office environment. Food Handling & Food Safety Smell success and serve yourself up a healthy career with short courses in food safety and food handling. Property Services Renovate your skills in real estate with a short course in Property Services Computer Skills Advance your career by learning the basics of computers. Spreadsheet Functions Return to the workplace with the essential computer skills you need to perform at your best. Tax Documentation The non-taxing way to become a tax agent. Skills for Business Initiative Fee-free short courses in digital and financial literacy to help you grow your small business Hospitality Essentials Gain the skills and knowledge to excel in the Hospitality industry Hair and Beauty Unleash your inner goddess with one of our Hair & Beauty short courses
Build a training program that completely suits your needs. Just select from the units on offer in either Financial Skills or Digital Literacy Skills, or choose the complete Certificate IV in New Small Business. The choice is yours. Check your eligibility - or call 1300 601 727 to speak with a small business consultant. Financial Literacy Skills for small business Choose one, multiple or all online units in Financial Literacy. Skill Plan finances Unit code BSBSMB402 Unit name Plan small business finance Gain financial knowledge needed to run your business including identifying profit targets, cash flow projections, production costs, margins, pricing strategies and more. Skill Budget Unit code FNSACC412 Unit name Prepare operational budgets Gain the skills and knowledge needed to prepare and document operational budgets for a variety of organisations. Skill Taxation Unit code FNSACC411 Unit name Process business tax requirements Learn to keep business tax accounting records, process lodgments and returns to ATO requirements, excluding income tax. BAS statements must be authorised by a registered agent. Skill Monitoring finances Unit code FNSACC311 Unit name Process financial transactions and extract interim reports Gain the skills and knowledge to process routine financial documents and financial transactions, prepare and reconcile financial receipts, and extract interim reports. Skill Small business risk management Unit code BSBSMB401 Unit name Establish legal and risk management requirements of small business Learn about regulations, legal structures, legislation and compliance, as well as how to negotiate contracts and identify and mitigate risks that affect your business. Skill Accounting software Unit code FNSACC416 Unit name Set up and operate a computerised accounting system* Learn how to modify, operate and ensure the integrity of an integrated computerised accounting system that processes transactions and produces reports. Skill Legal decisions Unit code FNSACC413 Unit name Make decisions in a legal context Get the knowledge to make decisions to compliance issues, in a legal context. Covering Australian legal systems and processes, this can be an introduction to commercial law. Skill Financial reporting Unit code FNSACC414 Unit name Prepare financial statements for non-reporting entities Learn to compile financial reports for entities with no statutory duty to file with government agencies and regulators, such as sole traders, partnerships and not-for-profits. (*) Industry-relevant software packages such as MYOB / Reckon Digital Literacy Skills for small business Choose one, multiple or all online units in Digital Literacy. Skill Using technology Unit code BSBWOR204 Unit name Use business technology Gain the skills to operate your business equipment, including computer software. Specifically you will: Select and use technology Process/organise data Maintain technology Skill Microsoft Word Unit code BSBITU201 Unit name Produce simple word processing documents Operate word processing applications and produce workplace documents. Specifically, you will: Produce word processed documents Edit word processed documents Finalise documents Skill Microsoft Excel Unit code BSBITU202 Unit name Create and use spreadsheets Create spreadsheets and charts using spreadsheet software. Specifically, you will: Create simple spreadsheets Produce simple charts Finalise spreadsheets Skill Calendar and contact management Unit code ICTICT107 Unit name Use personal productivity tools Learn to use personal productivity tools like calendars and contact lists to engage with your customers, schedule events, appointments and tasks necessary to run your business. Skill Using digital devices Unit code ICTICT104 Unit name Use digital devices Learn how to use digital devices safely to store and retrieve data, play multimedia files, edit files, print documents and backup important data. Skill Professional conduct and confidential information management Unit code ICTICT418 Unit name Contribute to copyright, ethics and privacy in an ICT environment Create, maintain and formalise a Code of Ethics to use to ensure your business remains on the right side of copyright and privacy legislation. Skill Using social media Unit code ICTWEB201 Unit name Use social media tools for collaboration and engagement Learn how to compare different types of social media tools such as Facebook, Twitter and Instagram, and select and use those appropriate to promote your business. Skill Using social media Unit code SIRXMKT002 Unit name Use Social media to engage customers Learn to use social media platforms to interact with customers and promote products and services. Skill Website building Unit code SITXEBS003 Unit name Build and launch a small business website Learn the technical skills needed to build a basic business website including hosting, web development, plan the site structure and site construction and maintenance. Skill Creating an e-business roadmap Unit code BSBSMB413 Unit name Design a digital action plan for small business Develop a plan for using digital technologies to achieve goals including a review of digital readiness, opportunities and developing digital initiatives for small business. Skill Small office set up Unit code ICTSAS307 Unit name Install, configure and secure a small office or home office network Learn how to gather requirements to design, install, configure and test a small secure network that is able to meet the needs of your small business. Skill Cybersecurity Unit code VU21990 Unit name Recognise the need for cyber security in an organization Gain introductory skills to combat cyber threats, risks and vulnerabilities. Learn how to protect against common cyber security attack mechanisms that threaten your business. Skill Cybersecurity Unit code VU21989 Unit name Test concepts and procedures for cyber security Learn crucial skills that allow you to test cyber threats, risks and vulnerabilities that can threaten your business. Skill Website improvement or maintenance Unit code BSBEBU401 Unit name Review and maintain a website Learn how to do basic updates of your website, monitor feedback, complete a data analysis, carry out non-technical maintenance and review cost implications of proposed changes. Certificate IV in New Small Business (BSB42615) This qualification is suitable for those establishing a small business. It helps build skills to solve a range of business challenges, as well as develop the ability to analyse and evaluate information and data to grow your business. This qualification is superseded by and equivalent to BSB42618 - Certificate IV in New Small Business. Unit code BSBCUS401 Unit name Coordinate implementation of customer service strategies Unit code BSBSMB404 Unit name Undertake small business planning Unit code BSBSMB403 Unit name Market the small business Unit code BSBRES401 Unit name Analyse and present research information Unit code BSBSUS401 Unit name Implement and monitor environmentally sustainable work practices Unit code BSBSMB401 Unit name Establish legal and risk management requirements of small business Unit code BSBWHS401 Unit name Implement and monitor WHS policies, procedures and programs to meet legislative requirements Unit code BSBSMB402 Unit name Plan small business finances Unit code BSBEBU401 Unit name Review and maintain a website Unit code BSBSMB407 Unit name Manage a small team
The internet is revolutionising the way people around the world learn. Here are four of the most exciting new learning tools. The days of a teacher lecturing students while navigating a stick of chalk across a blackboard will soon seem as outdated as writing with a feather dipped in a pot of ink. Here's how the tech savvy are now educating themselves and teaching others. 1. Online videos Whether you want learn how to create an Excel spreadsheet or weld sheet metal, there's now almost certainly an online video that will guide you through the process. Some of the big players in this field are: YouTube, which has video tutorials on just about everything; TED, which has short talks from a diverse range of world-leading experts; and MIT Video, which is a library of over 11,000 talks given at the prestigious Massachusetts Institute of Technology. There's also iTunes U, which claims to be the world's largest source of educational audio and video with over 200,000 titles available. 2. Flexbooks A ‘flexible textbook', the Flexbook is a free open-source textbook platform that can be used to build and edit collaborative textbooks. Textbooks look set to become relic of the past, with students of the future requiring nothing more than a tablet computer to download all the information they require. 3. E-portfolios An electronic portfolio is a collection of created and/or found digital resources. E-portfolios can contain text, images, blog entries, video and audio, multimedia files and links to online resources. They're in the process of replacing the real-world portfolios that creative types used to have to lug around, and students are increasingly learning by checking out others' e-portfolios. 4. Interactive whiteboards The blackboard may be on the way out, but teachers (and sometimes students) still need to display text, diagrams and other material. Increasingly, this is being done with an interactive whiteboard, a large interactive display that connects to a computer and projector. The projector projects the computer's desktop onto the board's surface where users control the computer using a pen, finger or stylus. There are so many new technologies helping students succeed at university, TAFE and beyond. And while they might seem pretty old school nowadays, don't forget that there's always the option of downloading apps to your smartphone that will help you achieve anything, from understanding French grammar to learning the periodic table.