Microsoft Excel for Beginners

This Nationally Recognised online training course aims to provide new users with the essential skills needed to create simple spreadsheets and charts, navigate through Excel quickly and easily, use formulas, autofill, format text, sort, adjust column and row, merge cells, insert headers and footers and more.

Upon successful completion of this course, participants should be able to:

1. Create, modify and format a spreadsheet

2. Use basic formulas and functions

3. Create a chart

4. Preview, adjust and print a spreadsheet

  • Flexible study options
  • Student support by fully qualified Trainers
  • Study when you want! Access your course content anytime, anywhere, from the comfort of your own home or workplace.

Start planning your future in Medical Administration today

WHO SHOULD DO THIS COURSE?

This Nationally Recognised online training course aims to provide new users with the essential skills needed to create simple spreadsheets and charts, navigate through Excel quickly and easily, use formulas, autofill, format text, sort, adjust column and row, merge cells, insert headers and footers and more.

COURSE CONTENT

BSBITU304 Produce Spreadsheets

Select and prepare resources

Adhere to ergonomic, work organisation and occupational health and safety requirements
Use energy and resource conservation techniques to minimise wastage
Identify spreadsheet task requirements in relation to data entry, storage, output and presentation

Plan spreadsheet design

Ensure spreadsheet design suits purpose, audience and information requirements of task
Ensure spreadsheet design enhances readability and appearance, and meets organisational and task requirements for style and layout
Use style sheets and automatic functions to ensure consistency of design and layout

Create spreadsheet

Ensure data is entered, checked and amended to maintain consistency of design and layout, in accordance with organisational and task requirements
Format spreadsheet using software functions to adjust page and cell layout to meet information requirements, in accordance with organisational style and presentation requirements
Ensure formulae are tested and used to confirm output meets task requirements, in consultation with appropriate personnel as required
Use manuals, user documentation and online help to overcome problems with spreadsheet design and production

Produce simple charts

Select chart type and design that enables valid representation of numerical data, and meets organisational and task requirements
Create charts using appropriate data range in spreadsheet
Modify chart type and layout using formatting features

Finalise spreadsheets

Preview, adjust and print spreadsheet and any accompanying charts, in accordance with task requirements
Ensure data input meets designated timelines and organisational requirements for speed and accuracy
Name and store spreadsheet in accordance with organisational requirements and exit application without data loss/damage

COURSE FEE AND PAYMENT OPTIONS

The total fee for this course is $250.

Payment can be made via credit card or EFT

COURSE DURATION

All students are allocated up to 8 weeks to complete their course, however as this is a self-paced course you can complete in much less time should you wish.

CAN I CONTINUE MY STUDIES WITH MEDICAL ADMINISTRATION TRAINING?

Absolutely! Medical Administration Training delivers fully accredited training in Certificate III up to Diploma level qualifications in Health Administration.

We also have a number of industry specific short courses on offer.   All our successful students are offered further discounts on our courses (not applicable for funded courses).


READY TO ENROL

Become job ready with Medical Administration Training  and our nationally recognised qualifications and short courses.

We are “the specialist in health related training” and have been delivering Medical Reception and Health Administration courses around Australia since 2004.

Get job ready upon the completion of our course, enrol today and unleash your future!

Ready to Enrol

Ready for new career opportunities?