Computers : Excel Level 3 For Business

This course provides the skills and knowledge to create lookup functions, set Excel working options, enhance charts, protect worksheet data, perform advanced data operations, use pivot tables, consolidate data, set goals, use Solver and learn about the functions of macros. This course is run in partnership with Rel Pattison Business Consulting. BSBITU402 Develop and use complex spreadsheets

Westfield Penrith on Tuesday Mornings

Beginning 26/3/2019 from 9:30:00 to 17:30:00

for 1 Day


Topics Covered include:

Use a range of lookup and reference functions and modify Excel options Customise the formatting of charts in Excel Create and use labels and names in a workbook and protect data in worksheets and workbooks Create summaries in your spreadsheets using subtotals Use data linking to create more efficient workbooks and use the Data Consolidation feature to combine data from several workbooks into one Understand and create simple PivotTable reports Construct and operate PivotTables using some of the more advanced techniques Create and edit a PivotChart Group cells and use outlines to manipulate the worksheet, use Solver to solve more complex and intricate problems and create recorded macros in Excel Use the macro recorder to create a variety of macros

Course Outcome

You will obtain a thorough grounding in the basics of spreadsheeting and using Microsoft Excel 2010.

On the first session bring

Notebook and pen. Please wear warm clothing in Autumn and Winter as the air conditioning can be cold.

and purchase during the course

Special Issues To Note

Workshop, no concession




Home | Courses | Enrolment | About Us | RTO Number 1223