| 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
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