MS Excel 2010 - Spreadsheet advanced
MS Advanced Excel is for those looking to take their Excel skills to the next level. This course will suit data driven professionals using complex level spreadsheets in their daily work, and looking to become an advanced level user.
Entry Requirements
Students must have a solid base of experience in using MS Excel either in 2007 or 2010 versions, and should be able to create new spreadsheets from scratch, apply high level formatting and intermediate functions and features of excel.
Student Instructions
Please bring a blue or black pen, pencil and writing paper, highlighter pen, A Memory stick/USB flash drive for saving your work and taking your files home.
Topics
Lesson 1:
Tables
- Apply table styles
- Create calculations
- Insert, delete rows
- Resize a table
- Convert to a range
- Sort
AutoFilter
- Apply a filter
- Customise a filter
Advanced Filter
- Criteria range
- Use autofilter
Database Functions
- Sum, max, min, count
Lesson 2:
VLookup
- Vlookup
- Exact vs closest match lookup
PivotTables
- Create a PivotTable
- Arrange information
- Filter
- Calculated fields
- PivotTable options
- PivotChart
Lesson 3:
Protection
- Protect worksheet
- Unlock cells
- Protect workbook
Decision making tools
- What If Tables
- Scenarios
- Goal seek
- Solver
- Comments
Lesson 4:
Sharing workbooks
Macros
- Recording macros
- Assigning macros
- Running macros
- Where to edit code
- Relative macro
Exporting, importing data
Career Prospects
help gain employment in an office situation
Delivery Style
An easy to follow manual with appropriate activities for each topic is used, together with Excel computer software. This course is information based and designed to cater to a wide range of learner needs. It is predominately self-paced with facilitator assistance.
Outcomes
At the completion of this course you will know about the more advanced features and techniques of Excel
the waiting list.
