INF1017 - Microsoft Excel 2010 Advanced

AUD$ 350
*
*
Academy IT strive to provide you with the training you need when you need it most. If you require a course and can’t attend on the dates provided or if they are not suitable to your staffing or project timelines – please call PH: (08) 7324 9800 to negotiate an alternative booking time.

About this Course

This course aims to provide skills and knowledge which will allow the attendee to create lookup functions, set Excel working options, enhance charts, protect worksheet data, perform advanced data operations using summarising, PivotTables, data consolidations, goal seeking, and Solver, and create and use macros.

Audience

This course is designed for users who need to use some of the more advanced features of Microsoft Excel 2010. At the completion of this course you should be able to:

  • Use a range of lookup and reference functions
  • Modify Excel options
  • Customise the formatting of charts in Excel
  • Create and use labels and names in a workbook
  • Protect data in worksheets and workbooks
  • Create summaries in your spreadsheets using subtotals
  • Use data linking to create more efficient workbooks
  • 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
  • Use goal seeking to determine the values required to reach a desired result
  • Group cells and use outlines to manipulate the worksheet
  • Use Solver to solve more complex and intricate problems
  • Create recorded macros in Excel
  • Use the macro recorder to create a variety of macros

 

 

 

 

 

 

 

 

 

 

 

 

 

 

To view the course outline please ensure you have Adobe Reader installed.

Get Adobe Reader

Download INF1017 - Microsoft Excel 2010 Advanced (PDF)

Location:

Related Courses
Course Name
Price
< 
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
> 
INF1015 - Microsoft Excel 2010 Introduction
AUD$ 350
 
 
18
11
13
8
5
 
 
 
 
 
 
INF1016 - Microsoft Excel 2010 Intermediate
AUD$ 350
 
 
15
18
16
17
11
 
 
 
 
 
 
| Powered by nopCommerce