Intermediate Microsoft Excel

Course Overview
On this course you will be taught some of the more specific functions of MS Excel. This course will equip you with the knowledge you need to create functional spreadsheets such as budgets, customer lists, holiday entitlements or price lists. You will learn how to automate your spreadsheets saving you time as well as how to create charts and link to progress reports.

Course Content

Viewing Worksheets

· Display and Customise Worksheets &Toolbars

· Freeze Panes

· Hiding Workbooks and Worksheets

Formatting Techniques

· Using Styles

· Conditional Formatting

· Format Painter

Formulas and Functions

· Using the Series Command

· Find, insert and use appropriate Functions: Paste, HLookup, VLookup, If, Choose,

· Data Validation

· Formula Error Checker and Auditing Toolbar

Database & List Management

· Sorting a Database

· Creating Subtotals & Data Forms

· Using AutoFilters & Advanced Filters

· Add, edit and navigate between records in a Data Form

Charts

· Create a chart and change: data series, axis, gridlines, legend and chart area

· Formatting Charts

Drawing and Picture Objects

· Drawing Toolbar: Auto-shapes and Text Boxes

· Grouping and ungrouping objects

Linking to other Applications

· Embedding and Linking Objects

· Hyperlinks

· Managing Links