Course Details
Course Outline
5 days course
Creating and modifying workbook templates
- Working with worksheets, cells and cell data
- Sorting, filtering, and managing worksheets
- Summarising data using formulas and functions
- Working with advanced formulas and functions
- Using validation rules to restrict the data entered in cells
- Creating named ranges
Analysing data and formulas
- Formatting worksheet elements
- Introduction to arithmetic operators
- Using relative and absolute cell references
- Finding data using Vlookup and Hlookup
- Auditing formulas by identifying precedents and dependants
- Managing Excel formula error indicator
Creating rule-based conditional formats
- Defining data bar, colour scale and icon set conditional format
- Working with charts
- Creating bar, column, pie, line and XY charts
- Creating stock charts
- Adding trendline to a chart
- Creating sparkline charts
Working with external data
- Importing data from CSV and txt files
- Using hyperlinks
- Linking an excel chart to another MS Office programme
- Working with objects
- Creating and formatting shapes
- Managing objects using the Selection pane
Introduction to Pivot tables
- Pivoting a pivot table report
- Managing subtotals and grand totals
- Setting AutoCorrect and automatic replace options
- Protecting a workbook
- Automating workbooks using Macros
- Recording a macro
