a. Keyboarding: Using keyboard shortcuts to work more efficiently

b. Basic Formula skills : Efficient formulae using absolute and relative referencing.

c. Data functions: Functions for data cleaning and manipulation

d. Formatting data: Types of data, conditional formats, custom formats

a. Flat data: Tips for getting your data into a usable structure

b. Data filters: For understanding and exploring your data

c. Names: Naming fields, ranges, dynamic ranges

d. Pivot Tables: Using one of Excel's most powerful and temperamental features

a. Charts: Formatting clean and attractive charts, complex chart types,

b. Data presentation: Non-charting ways to present data such as in-cell display and using the camera tool

c. Dynamic reports: Creating dynamic reporting with D-T-P (Data-Transform-Present) methodology

"Wait! You've missed something important!" Check the Non-core Excel tips and tricks page for other valuable Excel skills