Microsoft Office courses available in Sydney’s Northern Beaches and Mosman area.
Find the Microsoft Office training you need. Improve your skills with a short course in Word, Excel, Outlook or PowerPoint and explore the newest MS Office features and how to use them to their fullest potential, in your home office or job. The most popular software used in workplace it is a must for any job.
Course Outline Intermediate Microsoft Office Excel one day course focusing on more advanced features of Excel. This is a great follow on course from the Excel 2019 Introduction. Learn data setup, formula techniques, functions, formatting and linking, sorting and filtering data. This course would suit those who have basic day to day excel skills but want to learn more advanced techniques and functions of the software. Topics include Page Setup Filling Data Worksheet Techniques Page...
[More]
This course has no current classes. Please
the waiting list.
Course Outline Advanced Microsoft Office Excel course focusing on more advanced features of Excel. This is a great follow on course from the Excel 2019 Intermediate. Learn functions, labels and names, data consoildation, pivot tables and macros. This course would suit those who have intermediate excel skills but want to learn more advanced techniques and functions of the software. Topics include Lookup functions Labels and Names Protecting Data Data Consolidation PivotTables Solver...
[More]
This course has no current classes. Please
the waiting list.
Course Outline This course aims to give the learner a very good basic grounding in the use of Microsoft Word 2019 to create everyday documents required either at work or at home. The course begins by showing the user how to navigate around Microsoft Word 2019. It quickly gets the user to create a new document before getting into features such as formatting and printing. This course provides training to meet the requirements of BSBWRT311 Write simple documents from Certificate II in...
[More]
Assessments are made against units of competency from the Certificate III in Business BSB30120.
Excel is one of the most commonly used software applications especially in the workplace. You can use Excel to enter all sorts of data and perform financial, mathematical or statistical calculations. This comprehensive course covers the essentials of working with Excel 2019. This course covers creating simple spreadsheets and charts using MS Excel. You will learn how to create, edit and save spreadsheets, format data and worksheets, perform calculations using formulae and simple...
[More]
Assessments are made against units of competency from the Certificate III in Business BSB30120.
Learn advanced formatting, tables, styles, headers and footers, mail merge and graphics. This course would suit those who have basic day to day word skills but want to learn more advanced techniques and functions of the software. Course Outline Paragraph & document formatting techniques Columns Styles Headers and footers Mail Merge Table revision and advanced techniques Text boxes Enhancing pictures Prerequisites Either Word 2019 Introduction- (BSBWRT311 Write simple documents) or...
[More]
This course has no current classes. Please
the waiting list.
Essential Computer Skills (Certificate I in Skills for Vocational Pathways) is an entry level course providing core computer skills. It will introduce students to a range of Windows and other software skills including file management, MS Word, MS Excel, Internet, Email and Zoom to give the student essential IT skills to use in the workplace or in further study. The skills included will support a wide range of industry occupations. (Please note this course is not suitable for Apple...
[More]
Assessments are made against units of competency from the Certificate I in Skills for Vocational Pathways FSK10219.
Use digital technology for non-routine workplace tasks (FSKDIG003)
Use digital technology for short and basic workplace tasks (FSKDIG001)
Construct simple tables and graphs for work (FSKNUM013)
Course Outline Microsoft Power BI is the fastest growing business intelligence software in the market today. It is a business analytics tool designed for business people, to easily prepare and analyse data, and present the analysis in interactive reports and dashboards. In this Masterclass our Microsoft Certified Power BI trainer will guide you from data to dashboard, helping your business to make data driven decisions. Pre-requisites Confident keyboarding skills and Excel...
[More]
This course has no current classes. Please
the waiting list.
Course Outline Learn Microsoft Excel 2019 in one day. Excel is one of the most commonly used software applications especially in the workplace. You can use Excel to enter all sorts of data and perform financial, mathematical or statistical calculations. This one day course covers the essentials of working with Excel 2019. Topics include Excel Overview Creating a new Workbook Working with workbooks Editing workbooks Using/Understanding Formulas and Functions Selecting Range How to...
[More]
This course has no current classes. Please
the waiting list.
Course Outline An introduction to the internet including topics such as How the internet works What you need to use the internet Navigating the internet Search Engines Online security Email- using Microsoft Outlook How email works, understanding the inbox Sending and receiving emails Adding attachments Forwarding, deleting emails Junk and spam emails Please Bring Notepad and pen USB Flash drive How to enrol You can enrol online and over the phone using a credit card or come...
[More]
This course has no current classes. Please
the waiting list.
Course Outline The skills and knowledge acquired are sufficient to be able to create real-world presentations. You will learn how to add themes, run a slide show, print, publish presentations. Topics will include the following Getting to know PowerPoint: Starting Powerpoint; The Powerpoint screen; Using the ribbon; Using keytip badges; Minimising the ribbon; Shortcut menus; Using shortcut menus; Understanding dialog boxes; Launching dialog boxes; The quick access toolbar;...
[More]
Assessments are made against units of competency from the Certificate III in Business BSB30120.