Excel: Polishing your skills

Let's polish up your Excel skills, while revising (or learning) formula and database functionality.

The Fundamentals

• Checking out what's on the Excel screen
• Using AutoFill

Working with Formula

• Entering a Formula
• Operators
• Copying a Formula
• Working with AutoSum
• Relative and Absolute Cell Addresses
• Other Functions - IF and CONCAT

Improving the visual effect of the data

• Conditional Formatting
• Charts

Database Functions

• Working with Tables
• Using Sort and Filters